Halloween Sale Special - 75% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: stp75

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 / 6
Total 341 questions

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 an inventory management database that contains the following table.

Which statement should you use in a SQL query to change the inventory quantity of Product1 to 270?

A.

INSERT

B.

MERGE

C.

UPDATE

D.

CREATE

Your company needs to implement a relational database in Azure. The solution must minimize ongoing

maintenance.

Which Azure service should you use?

A.

Azure HDInsight

B.

Azure SQL Database

C.

Azure Cosmos DB

D.

SQL Server on Azure virtual machines

Match the Azure services to appropriate requirements.

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

NOTE: Each correct match is worth one point.

What are two uses of data visualization? Each correct answer present a complete solution.

NOTE: Each correct selection is worth one point.

A.

Represent trends and patterns over time.

B.

Communicate the significance of data.

C.

implement machine learning to predict future values.

D.

Consistently implement business logic across reports

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 setting can only be configured during the creation of an Azure Cosmos DB account?

A.

geo-redundancy

B.

multi-region writes

C.

production or non-reduction account type

D.

API

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 need to store data in Azure Blob storage for seven years to meet your company ' s compliance

requirements. The retrieval time of the data is unimportant. The solution must minimize storage costs.

Which storage tier should you use?

A.

Archive

B.

Hot

C.

Cool

You have a database that stores data in the format shown in the following table.

Of which type of database is this an example?

A.

document

B.

column family

C.

key-value

D.

relational

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

NOTE: Each correct selection is worth one point.

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

For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

When you create an Azure SQL database, which account can always connect to the database ?

A.

the Azure Active director/ (Azure AO) account that created the database

B.

the Azure Active Directly Azure AD) administrator account

C.

the sa account

D.

the server admin login account of the logical server

Select the answer that correctly completes the sentence.

Select the answer that correctly completes the sentence.

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

What is an example of rehydrating a blob in an Azure Storage account?

A.

changing the access tier of a blob from Archive to Cool

B.

changing the access tier of a blob from Cool to Archive

C.

splitting a blob into multiple files

D.

appending data to a blob

tence.

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