Azure Data
Fundamentals
1. Which service is managed and serverless, avoids the use of Windows Server licenses, and allows for
each workload to have its own instance of the service being used?: Azure SQL Database
2. What is fully managed and does not require changes to a database for migration?: Azure
SQL Managed Instance
3. Which data service allows you to create a single database that can scale up and down without downtime?:
SQL Azure SQL Database
4. Which open-source database is a hybrid relational-object database?: Post- greSQL
5. Which open-source database has built-in support for temporal data?: Mari- aDB
6. Which SQL engine is optimized for IoT scenarios?: Azure SQL Edge
7. Which type of Azure Storage is used for VHDs and is optimized for random read and write operations?:
page blob
8. Which type of Azure Storage is used to store key/value pairs grouped in partitions?: Azure Table storage
9. Which storage solution should you use to store unstructured documents, graph databases, and
key/value pairs?: Azure Cosmos DB
10. Which Azure Cosmos DB API should you use for data in the BSON format?-
: MongoDB
11.Which Azure Cosmos DB API should you use for data in key/value tables?-
: Table
12.You need to process many JSON files every minute, while keeping the data from the files accessible by
using native queries. Which Azure Cosmos DB API should you use?: NoSQL
13.Which Azure Cosmos DB API is queried by using a syntax based on SQL?: Apache Cassandra
14.Which type of data structure allows you to store data in a two-column format without requiring a
complex database management system?: key/value store
15.You have a folder that contains documents, images, and audio files.Which type of data do you have?:
unstructured
16.Which type of data should be sent from video cameras in a native binary format?: unstructured
17.You need to aggregate and store multiple JSON files that contain records for sales transactions.
The solution must minimize the development effort. Which storage solution should you implement?:
Azure Cosmos DB
18.Which type of database should you use to store sequential data in the fastest way possible?:
time series
1/
4
Fundamentals
1. Which service is managed and serverless, avoids the use of Windows Server licenses, and allows for
each workload to have its own instance of the service being used?: Azure SQL Database
2. What is fully managed and does not require changes to a database for migration?: Azure
SQL Managed Instance
3. Which data service allows you to create a single database that can scale up and down without downtime?:
SQL Azure SQL Database
4. Which open-source database is a hybrid relational-object database?: Post- greSQL
5. Which open-source database has built-in support for temporal data?: Mari- aDB
6. Which SQL engine is optimized for IoT scenarios?: Azure SQL Edge
7. Which type of Azure Storage is used for VHDs and is optimized for random read and write operations?:
page blob
8. Which type of Azure Storage is used to store key/value pairs grouped in partitions?: Azure Table storage
9. Which storage solution should you use to store unstructured documents, graph databases, and
key/value pairs?: Azure Cosmos DB
10. Which Azure Cosmos DB API should you use for data in the BSON format?-
: MongoDB
11.Which Azure Cosmos DB API should you use for data in key/value tables?-
: Table
12.You need to process many JSON files every minute, while keeping the data from the files accessible by
using native queries. Which Azure Cosmos DB API should you use?: NoSQL
13.Which Azure Cosmos DB API is queried by using a syntax based on SQL?: Apache Cassandra
14.Which type of data structure allows you to store data in a two-column format without requiring a
complex database management system?: key/value store
15.You have a folder that contains documents, images, and audio files.Which type of data do you have?:
unstructured
16.Which type of data should be sent from video cameras in a native binary format?: unstructured
17.You need to aggregate and store multiple JSON files that contain records for sales transactions.
The solution must minimize the development effort. Which storage solution should you implement?:
Azure Cosmos DB
18.Which type of database should you use to store sequential data in the fastest way possible?:
time series
1/
4