DP-900 Microsoft Azure Data Fundamentals Free Practice Exam Questions (2026 Updated)
Prepare effectively for your Microsoft DP-900 Microsoft Azure Data Fundamentals certification with our extensive collection of free, high-quality practice questions. Each question is designed to mirror the actual exam format and objectives, complete with comprehensive answers and detailed explanations. Our materials are regularly updated for 2026, ensuring you have the most current resources to build confidence and succeed on your first attempt.
Select the answer that correctly completes the sentence.
To complete the sentence, select the appropriate option in the answer area.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
You have the following SQL query.
NOTE: Each correct selection is worth one point.
Which statement is an example of Data Manipulation Language (DML)?
Match the terms to the appropriate descriptions.
To answer, drag the appropriate term from the column on the left to its description on the right. Each term may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
To complete the sentence, select the appropriate option in the answer area.
To complete the sentence, select the appropriate option in the answer area.
For each of the following statements, select Yes if the statement is true, Otherwise, select No.
NOTE: Each correct selection is worth one point.
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?
You need to design and model a database by using a graphical tool that supports project-oriented offline
database development.
What should you use?
Which three services support Apache Spark? Each correct answer presents a complete solution NOTE: Each correct selection is worth one point.
What is the primary purpose of a data warehouse?
You need to gather real-time telemetry data from a mobile application.
Which type of workload describes this scenario?
Select the answer the correctly completes the sentence.
Select the answer that correctly completes the sentence.
Select the answer that correctly completes the sentence.
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. (Choose two.)
NOTE: Each correct selection is worth one point.
You have a data store that has the structure shown in the following exhibit.
Which type of data store is this?
Match the types of workloads the appropriate scenario.
To answer, drag the appropriate workload type from the column on the left to its scenario on the right. Each workload type may be used once, more than once or not at all.
NOTE: Each correct match is worth one point.
