What Is a benefit of hosting a database on Azure SQL managed instance as compared to an Azure SQL database?

1. A. native support for cross-database queries and transactions
2. B. built-in high availability
3. C. system-Initiated automatic backups
4. D. support for encryption at rest

Correct Answer: A

Match the Azure SQL services to the appropriate use cases.
To answer, drag the appropriate service from the column on the left to its use case on the right. Each service may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.

Solution:


Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

Match the types of data to the appropriate Azure data services.
To answer, drag the appropriate data types from the column on the left to its service on the right. Each data type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.

Solution:
Box 1: Image files
Azure Blob storage is suitable for image files. Box 2:Key/value pairs
Azure CosmosDB table API is a key-value storage hosted in the cloud. Box 3: Relationship between employees
One-to-many relationships between business domain objects occur frequently: for example, one department has many employees. There are several ways to implement one-to-many relationships in the Azure Table service.

Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution. (Choose three.)
NOTE: Each correct selection is worth one point.

1. A. denormalized data
2. B. heavy writes and moderate reads
3. C. light writes and heavy reads
4. D. schema on write
5. E. schema on read
6. F. normalized data

Correct Answer: BDF

Select the answer that correctly completes the sentence.

Solution:


Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A