Question 1

Which command-line tool can you use to query Azure SQL databases?

Options :

A : sqlcmd

B : bcp

C : azdata

D : Azure CLI

Answer: A

Question 2

What is required to provision Azure Data Lake Storage in an Azure Storage account?

Options :

A : Versioning must be enabled.

B : Hierarchical namespace must be enabled

C : Hierarchical namespace must be disabled

D : Versioning must be disabled

Answer: B

Question 3

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 4

What can you use to create data ingestion pipelines?

Options :

A : Azure HDInsight

B : Azure SQL Database

C : Azure Data Factory

D : Azure Cosmos DB

Answer: C

Question 5

Which two Azure services can be used to provision Spark clusters? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

Options :

A : Azure Databricks

B : Azure Log Analytics

C : Azure Time Series Insights

D : Azure HDinsight

Answer: A,D

Free DP-900 Mock Exam – Practice Online Confidently

Buying Options: