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 use Transact-SQL to query files in Azure Data Lake Storage from an Azure Synapse
Analytics data warehouse.
What should you use to query the files?
- A . Azure Functions
- B . Microsoft SQL Server Integration Services (SSIS)
- C . PolyBase
- D . Azure Data Factory
C
Explanation:
Reference: https://docs.databricks.com/data/data-sources/azure/synapse-analytics.html
HOTSPOT
To complete the sentence, select the appropriate option in the answer area.
Explanation:
Reference: https://azure.microsoft.com/en-us/services/cognitive-services/speech-services/
Which statement is an example of Data Definition Language (DDL)?
- A . SELECT
- B . JOIN
- C . MERGE
- D . CREATE
D
Explanation:
Reference: https://www.geeksforgeeks.org/difference-between-ddl-and-dml-in-dbms/
Blob rehydration occurs in Azure Blob storage when a blob moves between which access tiers?
- A . Archive to Cool
- B . Hot to Cool
- C . Cool to Archive
- D . Hot to Archive
DRAG DROP
Match the types of data to the appropriate Azure data services.
To answer, drag the appropriate data types from the column on the left to its service on the right. Each data type may be used once, more than once, or not at all. NOTE: Each correct match is worth one point.
Explanation:
Box 1: Image files
Azure Blob storage is suitable for image files.
Box 2: Key/value pairs
Azure CosmosDB table API is a key-value storage hosted in the cloud.
Box 3: Relationship between employees
One-to-many relationships between business domain objects occur frequently: for example, one
department has many employees. There are several ways to implement one-to-many relationships in
the Azure Table service.
Reference: https://docs.microsoft.com/en-us/azure/storage/tables/table-storage-design-modeling
You have an application that runs on Windows and requires access to a mapped drive.
Which Azure service should you use?
- A . Azure Files
- B . Azure Blob storage
- C . Azure Cosmos DB
- D . Azure Table storage
A
Explanation:
Azure Files is Microsoft’s easy-to-use cloud file system. Azure file shares can be seamlessly used in Windows and Windows Server.
To use an Azure file share with Windows, you must either mount it, which means assigning it a drive letter or mount point path, or access it via its UNC path.
Reference: https://docs.microsoft.com/en-us/azure/storage/files/storage-how-to-use-files-windows
What is used to define a query in a stream processing jobs in Azure Stream Analytics?
- A . XML
- B . KQL
- C . YAML
- D . SQL
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
Select the answer that correctly completes the sentence.
