Microsoft DP-900 Practice Exams

Last updated on Oct 22,2026

Exam Code: DP-900
Exam Name: Microsoft Azure Data Fundamentals
Certification Provider: Microsoft
Latest update: Oct 22,2026

Question #21

HOTSPOT

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

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Reference:

https://docs.microsoft.com/en-us/azure/data-lake-store/data-lake-store-get-started-portal

https://docs.microsoft.com/en-us/azure/storage/common/storage-account-overview

https://azure.microsoft.com/en-us/pricing/details/bandwidth/

Question #22

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.

Reveal Solution Hide Solution

Correct Answer: A

Question #23

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

Reveal Solution Hide Solution

Correct Answer: C
C

Explanation:

Reference: https://docs.microsoft.com/en-us/sql/t-sql/queries/update-transact-sql?view=sql-server-ver15

Question #24

What is the typical latency for read operations against media files stored in the Cool access tier of Azure Blob Storage?

A . a few milliseconds
B . a few seconds
C . a few minutes
D . a few hours

Reveal Solution Hide Solution

Correct Answer: A

Question #25

When can you use an Azure Resource Manager template?

A . to automate the creation of an interdependent group of Azure resources in a repeatable way
B . to automate the creation of an interdependent and develop can deploy from the Azure portal
C . To provision Azure subscriptions and apply policies for multi-tenant deployments
D . To set complex permissions automatically on existing objects in an Azure subscription

Reveal Solution Hide Solution

Correct Answer: A
A

Explanation:

You can automate deployments and use the practice of infrastructure as code. In code, you define the infrastructure that needs to be deployed

To implement infrastructure as code for your Azure solutions, use Azure Resource Manager templates (ARM templates). The template is a JavaScript Object Notation (JSON) file that defines the infrastructure and configuration for your project. The template uses declarative syntax, which lets you state what you intend to deploy without having to write the sequence of programming commands to create it. In the template, you specify the resources to deploy and the properties for those resources.

Reference: https://docs.microsoft.com/en-us/azure/azure-resource-manager/templates/overview

Question #26

HOTSPOT

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

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Descriptive, to answer the question: What’s happening?

Note: Azure Media Indexer enables you to make content of your media files searchable and to generate a full-text transcript for closed captioning and keywords. You can process one media file or multiple media files in a batch.

Reference:

https://demand-planning.com/2020/01/20/the-differences-between-descriptive-diagnostic-predictive-cognitive-analytics/

https://azure.microsoft.com/en-us/blog/answering-whats-happening-whys-happening-and-what-will-happen-with-iot-analytics/

https://docs.microsoft.com/en-us/azure/media-services/previous/media-services-index-content

Question #27

You have an Azure Cosmos DB account that uses the Core (SQL) API.

Which two settings can you configure at the container level? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point. (Choose two.)