To complete the sentence, select the appropriate option in the answer area.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *

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.

• A.denormalized data
• B.heavy writes and moderate reads
• C.light writes and heavy reads
• D.schema on write
• E.schema on read
• F.normalized data

Comment: *

Name: *

Email: *

Verification: *

Your company is designing a data store that will contain student data. The data has the following format.

Which type of data store should you use?

• A.object
• B.key/value
• C.graph
• D.columnar

Comment: *

Name: *

Email: *

Verification: *

You need to use Transact-SQL to query files in Azure Data Lake Storage from an Azure Synapse Analytics data warehouse.
What should you use to query the files?

• A.Azure Functions
• B.PolyBase
• C.Microsoft SQL Server Integration Services (SSIS)
• D.Azure Data Factory

Comment: *

Name: *

Email: *

Verification: *

You need to recommend a data store service that meets the following requirements:
Native SQL API access
Configurable indexes
What should you recommend?

• A.Azure Files
• B.Azure Blob storage
• C.Azure Table storage
• D.Azure Cosmos DB

Comment: *

Name: *

Email: *

Verification: *