Question 1

Which statement is an example of Data Definition Language (DDL)?

Options :

A : SELECT

B : INSERT

C : DELETE

D : DROP

Answer: D

Question 2

You have data saved in the following format:

Which format was used?

Options :

A : YAML

B : HTML

C : XML

D : JSON

Answer: B

Question 3

What should you use to build a Microsoft Power BI paginated report?

Options :

A : Power BI report Builder

B : Power BI Desktop

C : Charticulator

D : the Power BI service

Answer: A

Question 4

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.

Options :

A : read-access geo-redundant storage (RA_GRS)

B : zone-redundant storage (ZRS)

C : geo-redundant storage (GRS)

D :

locally-redundant storage (LRS)Azure Storage offers two options for copying your data to a secondary region:With GRS or GZRS, the data in the secondary region isn't available for read or write access unless there is a failover to the secondary region. For read access to the secondary region, configure your storage account to use read-access georedundant storage (RA-GRS) or read-access geo-zone-redundant storage (RA-GZRS).

Answer: A,C

Question 5

You plan to deploy an app. The app requires a nonrelational data service that will provide latency guarantees of less than 10-ms for reads and writes. What should you include in the solution?

Options :

A : Azure Cosmos

B : Azure Table storage

C : Azure Files

D : Azure Blob storage

Answer: A

Free DP-900 Mock Exam – Practice Online Confidently

Buying Options: