Summer Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ecus65

Microsoft DP-900 - Microsoft Azure Data Fundamentals

Page: 3 / 10
Total 306 questions

Match the types of data to the appropriate Azure data services.

To answer, drag the appropriate data types from the column on the left to its service on the right. Each data type may be used once, more than once, or not at all.

NOTE: Each correct match is worth one point.

Which Azure SQL offering supports automatic database scaling and automatic pausing of the database during inactive periods?

A.

Azure SQL Database Hyperscale

B.

Azure SQL managed instance

C.

Azure SQL Database serveless

D.

Azure SQL Database elastic pod

Select the answer that correctly completes the sentence.

You have a banking application that transfers money in to and out of accounts.

Of which type of solution is this is an example?

A.

extract transform, and load (ETL)

B.

a data warehouse

C.

online analytical processing (OLAP)

D.

online transaction processing (OLTP)

You have the following SQL query.

NOTE: Each correct selection is worth one point.

Select the answer that correctly completes the sentence.

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

NOTE: Each correct selection is worth one point.

Which two Azure services can be used to provision Apache Spark clusters? Each correct answer presents a complete solution. (Choose two.)

NOTE: Each correct selection is worth one point.

A.

Azure Time Series Insights

B.

Azure HDInsight

C.

Azure Databricks

D.

Azure Log Analytics

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

A.

sqlcmd

B.

bcp

C.

azdata

D.

Azure CLI

Which three services support Apache Spark? Each correct answer presents a complete solution NOTE: Each correct selection is worth one point.

A.

Azure Data Explorer

B.

Azure Synapse Analytics

C.

Azure Databricks

D.

Azure Stream Analytics

E.

Azure HDInsight