Pre-Winter Sale 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 332 questions

Select the answer that correctly completes the sentence.

You need to store data by using Azure Table storage.

What should you create first?

A.

an Azure Cosmos DB instance

B.

a storage account

C.

a blob container

D.

a table

You need to use Transact-SQL to query files in Azure Data Lake Storage from an Azure Synapse Analytics data warehouse.

What should you use to query the files?

A.

Azure Functions

B.

Microsoft SQL Server Integration Services (SSIS)

C.

PolyBase

D.

Azure Data Factory

Select the answer that correctly completes the sentence.

Match the types of workloads the appropriate scenario.

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

NOTE: Each correct match 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.

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

A.

sqlcmd

B.

bcp

C.

azdata

D.

Azure CLI

Which three actions are used when performing diagnostic analytics?

A.

• Identify data anomalies

• Collect anomaly-related data

• Discover relationships and trends that explain anomalies.

B.

• Identify data anomalies

• Predict when anomalies are likely to recur

• Use analytical tools such as decision trees and regression.

C.

• Apply serf-learning loops to draw inferences from anomalies.

• Predict when anomalies are likely to recur

• Use analytical tools such as decision trees and regression.

D.

• Identify data anomalies

• Use machine learning to find patterns in large datasets.

• Discover relationships and trends that explain anomalies.

You have structured data in tabular format.

What represents an individual instance of a data entity?

A.

a column

B.

a cell

C.

a row

D.

a table

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

A.

Bash

B.

PowerShell

C.

KQL

D.

SQL