This is the free Microsoft DP-900 practice question bank —
150 of 282 total questions, each with a full explanation, free to
read with no signup required. Updated 2026-04-24.
Every answer is verified against official Microsoft documentation —
see our methodology.
Question 1
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.
Show Answer
Correct Answer: No
No
Yes
Explanation: Azure SQL Database is a PaaS offering and does not include all features available in SQL Server running on Azure VMs.
In a PaaS model, the platform manages infrastructure, so you do not need to create a virtual machine or virtual network before deploying a relational database.
In an IaaS model, you are responsible for the infrastructure, so you must create a virtual machine and virtual network before deploying a relational database.
Question 2
Which service can be used to build extract, transform, and load (ETL) pipelines?
A. Azure Data Factory
B. Azure Pipelines
C. Azure SQL Database
D. Azure Cosmos DB
E. Azure Databricks
Show Answer
Correct Answer: A, E
Explanation: Azure Data Factory is a managed service specifically designed to build and orchestrate ETL/ELT pipelines. Azure Databricks can also be used to implement ETL pipelines using Apache Spark for large-scale data processing. The other options are not ETL pipeline services.
Question 3
HOTSPOT
-
Select the answer that correctly completes the sentence.
Show Answer
Correct Answer: In non-relational databases, data is always stored in tables: No
In non-relational databases, data is always stored by using a fixed schema: No
In non-relational databases, two entities in the same collection can have different sets of fields: Yes
Explanation: Non-relational databases are not table-based, are typically schema-flexible, and allow documents/items in the same collection to have different fields.
Question 4
HOTSPOT
-
Select the answer that correctly completes the sentence.
Show Answer
Correct Answer: Azure Databricks
Explanation: Azure Databricks is a fully managed analytics platform built on Apache Spark and offered as Azure’s implementation of Databricks, which is available across multiple cloud providers.
Question 9
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.
Show Answer
Correct Answer: No
No
Yes
Explanation: Stream processing handles data incrementally, not all at once.
Batch processing runs on collected data with higher latency, not immediate.
Stream processing supports near-real-time aggregates and calculations like rolling averages.
Question 12
What is the responsibility of a database administrator?
A. applying data cleaning routines
B. creating data visualizations
C. managing data integration processes
D. storing backup copies of data
Show Answer
Correct Answer: D
Explanation: A database administrator (DBA) is responsible for maintaining, securing, and ensuring the availability of databases, which includes performing and managing regular backups and recovery procedures. The other options relate to data analysis, visualization, or integration roles rather than core DBA duties.
Question 14
HOTSPOT
-
Select the answer that correctly completes the sentence.
Show Answer
Correct Answer: dataframe
Explanation: Structured Streaming in Apache Spark treats streaming data as an unbounded table and is implemented using the Spark DataFrame API, where each DataFrame represents a single logical table.
Question 15
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.
Show Answer
Correct Answer: Azure Databricks: No
Azure HDInsight: No
Azure SQL Database: No
Azure Synapse Analytics: Yes
Explanation: Azure Synapse Analytics includes the same pipeline engine as Azure Data Factory (Synapse Pipelines). The other listed services do not provide the ADF pipeline engine.
Question 17
You have an Azure SQL database that contains tables for customers and orders.
You need to create a query that will return the orders placed by each customer.
Which two Transact-SOL statements should you include in the query? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A. INDEX
B. EXISTS
C. JOIN
D. ORDERBY
E. SELECT
Show Answer
Correct Answer: C, E
Explanation: To return orders placed by each customer, the query must retrieve data and relate the two tables. SELECT is required to specify and return the columns in the result set, and JOIN is required to combine the Customers and Orders tables based on their relationship (such as CustomerID). ORDER BY only controls sorting, EXISTS is for filtering with subqueries, and INDEX is not part of a query’s result logic.
Question 18
How is raw data stored in a data lakehouse?
A. as tables
B. as queues
C. as files
D. as disks
Show Answer
Correct Answer: C
Explanation: In a data lakehouse, raw data is kept in its native form within a data lake layer. This means it is stored as files (e.g., CSV, JSON, Parquet, Avro) on distributed storage, rather than as database tables, queues, or disks. Structured tables are typically created later on top of these files.
$19
Get all 282 questions with detailed answers and explanations
Instant download HTML + PDF delivered the moment payment clears.
Secure Stripe checkout we never see or store your card details.
7-day refund if files are defective see our refund policy.
