Question 1

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 2

A team of developers has computers Thai run Windows 10 and Ubuntu Desktop. The developers need to connect to and query an Azure SQL database from the computers. The developers require code assistance features such as intellSense. What should the developers use ?

Options :

A : Azure Data Studio

B : sq1cmd

C : Microsoft SQL Server Management Studio (SSMS)

D : Azure Data Explorer

Answer: A

Question 3

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

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

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