Microsoft DP-900 Practice Exams
Last updated on Oct 23,2026- Exam Code: DP-900
- Exam Name: Microsoft Azure Data Fundamentals
- Certification Provider: Microsoft
- Latest update: Oct 23,2026
What ate three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution NOTE: Each correct selection is worth one point.
- A . normalized data
- B . schema defined in a database
- C . schema defined when reading unstructured data from a database
- D . normalized data
- E . light writes and heavy reads
- F . heavy writes and moderate reads
Select the answer that correctly completes the sentence.
When provisioning an Azure Cosmos DB account, which feature provides redundancy within an Azure region?
- A . multi-master replication
- B . Availability Zones
- C . automatic failover
- D . the strong consistency level
B
Explanation:
With Availability Zone (AZ) support, Azure Cosmos DB will ensure replicas are placed across multiple zones within a given region to provide high availability and resiliency to zonal failures.
Note: Azure Cosmos DB provides high availability in two primary ways. First, Azure Cosmos DB replicates data across regions configured within a Cosmos account. Second, Azure Cosmos DB maintains 4 replicas of data within a region.
Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/high-availability
DRAG DROP
Match the Azure services to the appropriate locations in the architecture.
To answer, drag the appropriate service from the column on the left to its location on the right. Each service may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.
Explanation:
Box Ingest: Azure Data Factory
You can build a data ingestion pipeline with Azure Data Factory (ADF).
Box Preprocess & model: Azure Synapse Analytics
Use Azure Synapse Analytics to preprocess data and deploy machine learning models.
Reference:
https://docs.microsoft.com/en-us/azure/machine-learning/how-to-data-ingest-adf
https://docs.microsoft.com/en-us/azure/machine-learning/team-data-science-process/sqldw-walkthrough
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.
Select the answer that correctly completes the sentence.
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. NOTE: Each correct selection is worth one point. (Choose three.)
- 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.
BCE
Explanation:
https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/getting-started-with-database-engine-permissions?view=sql-server-ver15
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
Which T-SQL statement should be used to instruct a database management system to use an index instead of performing a full table scan?
- A . WHERE
- B . SELECT
- C . JOIN