Halloween Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: xmas50

Microsoft DP-900 - Microsoft Azure Data Fundamentals

Page: 7 / 10
Total 313 questions

Which Azure Cosmos DB API stores data in the BSON format and uses MQL to query the data?

A.

MongoDB

B.

PostgreSQL

C.

Apache Gremlin

D.

Table

Select the answer that correctly completes the sentence.

Which language is used to define queries in Azure Synapse Data Explorer?

A.

Bash

B.

PowerShell

C.

KQL

D.

SQL

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

Select the answer that correctly completes the sentence.

You have a SQL pool in Azure Synapse Analytics that is only used actively every night for eight hours.

You need to minimize the cost of the SQL pool during idle times. The solution must ensure that the data

remains intact.

What should you do on the SQL pool?

A.

Scale down the data warehouse units (DWUs).

B.

Pause the pool.

C.

Create a user-defined restore point.

D.

Delete the pool

Select the answer that correctly completes the sentence.

Which two activities can be performed entirely by using the Microsoft Power BI service? Each correct answer presents a complete solution. (Choose two.)

NOTE: Each correct selection is worth one point.

A.

report and dashboard creation

B.

report sharing and distribution

C.

data modeling

D.

data acquisition and preparation

Which component of Azure Data Factory enables you to define a sequence of activities including for each iterators?

A.

control flow

B.

linked services

C.

datasets

D.

the integration runtime