Black Friday Mega Drop - Up to 75% Off Best Sellers - Ends in 0d 00h 00m 00s - Coupon code: certbig75

DP-900 Exam Dumps - Microsoft Certified: Azure Data Fundamentals Questions and Answers

Question # 14

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

Options:

A.

sqlcmd

B.

bcp

C.

azdata

D.

Azure CLI

Buy Now
Question # 15

You have data saved in the following format:

Which format was used?

Options:

A.

YAML

B.

HTML

C.

XML

D.

JSON

Buy Now
Question # 16

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

Buy Now
Question # 17

In an analytical data model, which type of table contains entities that are used to aggregate numeric values, where each entity is represented by a row with a unique key value?

Options:

A.

bridge

B.

dimension

C.

fact

Buy Now
Question # 18

You have an Azure subscription that contains an Azure Data Lake Storage Gen2 account named accounts account1 stores raw sales transaction data from multiple regions.

You need to create an analytical data store that will ingest and analyze the data.

What should you use?

Options:

A.

account1

B.

a relational data warehouse

C.

a NoSQL database

D.

a semantic model

Buy Now
Question # 19

Select the answer that correctly completes the sentence.

Options:

Buy Now
Question # 20

Which three actions are used when performing diagnostic analytics?

Options:

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.

Buy Now
Question # 21

Which type of non-relational data store supports a flexible schema, stores data as JSON files, and stores the all the data for an entity in the same document?

Options:

A.

document

B.

columnar

C.

graph

D.

time series

Buy Now
Question # 22

What is the responsibility of a database administrator?

Options:

A.

applying data cleaning routines

B.

creating data visualizations

C.

managing data integration processes

D.

storing backup copies of data

Buy Now
Question # 23

Match the Azure Cosmos DB APIs to the appropriate data structures.

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

NOTE: Each correct match is worth one point.

Options:

Buy Now
Exam Code: DP-900
Exam Name: Microsoft Azure Data Fundamentals
Last Update: Nov 18, 2026
Questions: 341
DP-900 pdf

DP-900 PDF

$25  $99.99
DP-900 Engine

DP-900 Testing Engine

$28.75  $114.99
DP-900 PDF + Engine

DP-900 PDF + Testing Engine

$37.5  $149.99