You have the following SQL query.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

When provisioning an Azure Cosmos DB account, which feature provides redundancy within an Azure
region?

A.

multi-master replication

B.

Availability Zones

C.

automatic failover

D.

the strong consistency level

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

You need to develop a solution to provide data to executives. the solution must provide an interactive graphic
interface, depict various key performance indications, and support data exploration by using drill down.
What should you use in Microsoft Power BI?

A.

a dashboard

B.

Microsoft Power Apps

C.

a dataflow

D.

a report

You have an application that runs on Windows and requires across to a mapped drive.
Which Azure service should you use?

A.

Azure Cosmos DB

B.

Azure Table storage

C.

Azure Files

D.

Azure Blob Storage

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

What is a benefit of the Azure Cosmos DB Table API as compared to Azure Table storage?

A.

supports partitioning

B.

provides resiliency if art Azure region fads

C.

provides a higher storage capacity

D.

supports a multi-master model

You need to create an Azure Storage account.
Data in the account must replica outside the Azure region automatically.
Which two types of replica can you us for the storage account? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one pint.

A.

read-access geo-redundant storage (RA_GRS)

B.

zone-redundant storage (ZRS)

C.

geo-redundant storage (GRS)

D.

locally-redundant storage (LRS)

For each of the following statements. select Yes if the statement is true. Otherwise, select No.
NOTE Each correct selection is worth one point.

Your company needs to design a database that shows how changes traffic in one area of a network affect other
components on the network.
Which type of data store should you use?

A.

Key/value

B.

Graph

C.

Document

D.

columnar

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