Month End Sale - 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 (2025 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 2025, ensuring you have the most current resources to build confidence and succeed on your first attempt.

Page: 3 / 5
Total 313 questions

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

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.

Select the answer that correctly completes the sentence.

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.

Your company is designing a database that will contain session data for a website. The data will include

notifications, personalization attributes, and products that are added to a shopping cart.

Which type of data store will provide the lowest latency to retrieve the data?

A.

key/value

B.

graph

C.

columnar

D.

document

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.

What are two characteristics of real-time data processing? Each correct answer present a complete solution.

NOTE: Each correct selection is worth one point.

A.

Data is processed as it is created.

B.

Low latency is expected

C.

High latency acceptable

D.

Data is processed periodically

Select the answer that correctly completes the sentence.

Match the tools to the appropriate descriptions.

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

NOTE: Each correct match is worth one point.

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

Select the answer that correctly completes the sentence.

Match the security components to the appropriate scenarios.

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

NOTE: Each correct match is worth one point.

In a fully denormalized database, how is data read and written for a single entity?

A.

Data is read from a single table and written to a single table.

B.

Data is read from multiple tables and written to a single table.

C.

Data is read from a single table and written to multiple tables.

D.

Data is read from multiple tables and written to multiple tables.

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

Which scenario is an example of a streaming workload?

A.

sending transactions that are older than a month to an archive

B.

sending transactions daily from point of sale (POS) devices

C.

sending telemetry data from edge devices

D.

sending cloud infrastructure metadata every 30 minutes

Your company is designing a data store that will contain student data. The data has the following format.

Which type of data store should you use?

A.

graph

B.

key/value

C.

object

D.

columnar

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.

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

Page: 3 / 5
Total 313 questions
Copyright © 2014-2025 Solution2Pass. All Rights Reserved