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
HOTSPOT
To complete the sentence, select the appropriate option in the answer area.
Explanation:
Note: The data warehouse workload encompasses:
✑ The entire process of loading data into the warehouse
✑ Performing data warehouse analysis and reporting
✑ Managing data in the data warehouse
✑ Exporting data from the data warehouse
Reference: https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-workload-management
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.
Which two Azure services can be used to provision Spark clusters? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
- A . Azure Databricks
- B . Azure Log Analytics
- C . Azure Time Series Insights
- D . Azure HDinsight
A, D
Explanation:
Reference: https://www.sqlshack.com/a-beginners-guide-to-azure-databricks/
You need to store data by using Azure Table storage.
What should you create first?
- A . an Azure Cosmos DB instance
- B . a storage account
- C . a blob container
- D . a table
B
Explanation:
First create an Azure storage account, then use Table service in the Azure portal to create a table.
Note: An Azure storage account contains all of your Azure Storage data objects: blobs, files, queues, and tables.
Reference:
https://docs.microsoft.com/en-us/azure/storage/tables/table-storage-quickstart-portal
https://docs.microsoft.com/en-us/azure/storage/common/storage-account-create
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:
Box 1: No
A pipeline is a logical grouping of activities that together perform a task.
Box 2: Yes
You can construct pipeline hierarchies with data factory.
Box 3: Yes
A pipeline is a logical grouping of activities that together perform a task.
Reference: https://mrpaulandrew.com/2019/09/25/azure-data-factory-pipeline-hierarchies-generation-control/
Select the answer that correctly completes the sentence.
