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

Microsoft DP-900 - Microsoft Azure Data Fundamentals

Microsoft DP-900 Premium Access     Download Demo    
Page: 4 / 10
Total 316 questions

You have a database that stores data in the format shown in the following table.

Of which type of database is this an example?

A.

document

B.

column family

C.

key-value

D.

relational

Which statement accurately describes data processing?

A.

Batch processing requires that data be processed immediately upon arrival.

B.

Stream processing is typically used for time-critical operations that require an instant response.

C.

Stream processing is typically used for analyzing larger datasets in less time.

D.

Batch processing is typically used for scenarios that require continuous, real-time insights from rapidly arriving data.

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

NOTE: Each correct selection is worth one point.

What is the responsibility of a database administrator?

A.

applying data cleaning routines

B.

creating data visualizations

C.

managing data integration processes

D.

storing backup copies of data

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

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

You need to mi nimize 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

What is used to define a query in a stream processing jobs in Azure Stream Analytics?

A.

XML

B.

KQL

C.

YAML

D.

SQL

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.

A.

Azure Databricks

B.

Azure Log Analytics

C.

Azure Time Series Insights

D.

Azure HDinsight

Select the answer that correctly completes the sentence.

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