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: 2 / 5
Total 316 questions

What can be used with native notebook support to query and visualize data by using a web-based interface?

A.

Azure Databricks

B.

pgAdmin

C.

Microsoft Power Bl

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

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

What should you use to automatically delete blobs from Azure Blob Storage?

A.

soft delete

B.

archive storage

C.

the change feed

D.

a lifecycle management policy

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

NOTE: Each correct selection is worth one point.

Select the answer that correctly completes the sentence.

Select the answer that correctly completes the sentence.

What is the primary purpose of a data warehou se?

A.

to provide answers to complex queries that rely on data from multiple sources

B.

to provide transformation services between source and target data stores

C.

to provide read-only storage of relational and non-relational historical data

D.

to provide storage for transactional line-of-business (LOB) applications

Select the answer that correctly completes the sentence.

Match the types of data stores to the appropriate scenarios.

To answer, drag the appropriate data store type from the column on the left to its scenario on the right. Each data store 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.

You need to recommend a data store service that meets the following requirements:

    Native SQL API access

    Configurable indexes

What should you recommend?

A.

Azure Files

B.

Azure Blob storage

C.

Azure Table storage

D.

Azure Cosmos DB

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

To complete the sente nce, select the appropriate option in the answer area.

Which clause should you use in a select statement to combine rows in one tab le with rows in another table?

A.

JOIN

B.

VALUES

C.

set

D.

KEY

You need to store event log data that is semi-structured and received as the logs occur. What should you use?

A.

Azure Table storage

B.

Azure Queue storage

C.

Azure Files

Select the answer that correctly completes the sentence.

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

• Use machine learning to find patterns in large datasets.

• Discover relationships and trends that explain anomalies.

You need to query a table named Products in an Azure SQL database.

Which three requirements must be met to query the table from the internet? Each correct answer presents part of the solution. (Choose three.)

NOTE: Each correct selection is worth one poin t.

A.

You must be assigned the Reader role for the resource group that contains the database.

B.

You must have SELECT access to the Products table.

C.

You must have a user in the database.

D.

You must be assigned the Contributor role for the resource group that contains the database.

E.

Your IP address must be allowed to connect to the database.

Match the data processing languages to the appropriate real-time analytics services.

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

NOTE: Each correct match is worth one point.

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