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

Easiest Solution 2 Pass Your Certification Exams

DP-900 Microsoft Azure Data Fundamentals Free Practice Exam Questions (2026 Updated)

Prepare effectively for your Microsoft DP-900 Microsoft Azure Data Fundamentals certification with our extensive collection of free, high-quality practice questions. Each question is designed to mirror the actual exam format and objectives, complete with comprehensive answers and detailed explanations. Our materials are regularly updated for 2026, ensuring you have the most current resources to build confidence and succeed on your first attempt.

Page: 1 / 5
Total 316 questions

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

NOTE: Each correct selection is worth one point.

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 lo ops 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 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)

Which Azure Storage service implements the key/value model?

A.

Azure Files

B.

Azure Table

C.

Azure Blob

D.

Azure Queue

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 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

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.

Match the Azure Data Lake Storage terms to the appropriate levels in the hierarchy.

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

NOTE: Each correct match is worth one point.

Select the answer that correctly completes the sentence.

Which storage solution supports access control lists (ACLs) at the file and folder level?

A.

Azure Data Lake Storage

B.

Azure Cosmos DB

C.

Azure Queue storage

D.

Azure Blob storag e

Select the answer that correctly completes the sentence.

You are writing a set of SQL queries that administrators will use to troubleshoot an Azu re SQL database.

You need to embed documents and query results into a SQL notebook.

What should you use?

A.

Microsoft SQL Server Management Studio (SSMS)

B.

Azure Data Studio

C.

Azure CLI

D.

Azure PowerShell

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.

You have a transactional application that stem data in an Azure SQL managed instance. When should you implement a read-only database replica?

A.

You need to generate reports without affecting the transactional workload.

B.

You need to audit the transactional application.

C.

You need to implement high availability in the event of a regional outage

D.

You need to improve the recovery point objective (RPO).

You need to gather real-time telemetry data from a mobile application.

Which type of workload d escribes this scenario?

A.

Online Transaction Processing (OLTP)

B.

batch

C.

massively parallel processing (MPP)

D.

streaming

Match the processes to the appropriate scenarios.

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

NOTE: Each correct match is worth one point.

Match the types of workloads to the appropriate scenarios.

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.

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

You have data saved in the following format.

\

Which format was used?

A.

XML

B.

yaml

C.

JSON

D.

HTML

Page: 1 / 5
Total 316 questions
Copyright © 2014-2026 Solution2Pass. All Rights Reserved