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
You need to perform hybrid transactional and analytical processing (HTAP) queries against Azure Cosmos DB data sources by using Azure Synapse Analytics.
What should you use?
- A . Synapse pipelines
- B . a Synapse SQL pool
- C . Synapse Link
- D . Synapse Studio
C
Explanation:
Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/synapse-link
You need to gather real-time telemetry data from a mobile application.
Which type of workload describes this scenario?
- A . Online Transaction Processing (OLTP)
- B . batch
- C . massively parallel processing (MPP)
- D . streaming
D
Explanation:
Reference: https://docs.microsoft.com/en-in/azure/azure-monitor/overview
A data engineer is responsible for which task?
- A . Design and build analytical models.
- B . Design and implement data stores for analytical workloads.
- C . Explore data to identify trends.
- D . Implement policies, tools. and processes for backup and recovery plans.
Which Azure storage solution provides native support for POSIX-compliant access control lists (ACLs)?
- A . Azure Queue storage
- B . Azure Data Lake Storage
- C . Azure table storage
- D . Azure Files
B
Explanation:
Reference: https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-access-control
Which Azure Storage service implements the key/value model?
- A . Azure Files
- B . Azure Table
- C . Azure Blob
- D . Azure Queue
DRAG DROP
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.
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.
Explanation:
Reference: https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl
Which language is used to define queries in Azure Synapse Data Explorer?
- A . Bash
- B . PowerShell
- C . KQL
- D . SQL