10 exam-style questions with answers and explanations, straight from our 1,030-question bank. Tap an answer to check yourself. When you're ready, take the scored version in the free practice test.
These 10 free DP-900 questions are organized by exam domain, so you can see how each part of the Microsoft Certified: Azure Data Fundamentals (DP-900) blueprint is tested. Reveal the answer and explanation under each question.
A product catalog contains JSON documents with named fields and nested attributes. Clothing records include sizes, while camera records include sensor specifications. Product photographs are stored separately as JPEG files. How should the catalog documents and the photographs be classified, respectively?
Correct answer: D - Semi-structured data and unstructured data
Most queries against a large collection of sales files aggregate three numeric fields out of 90 available fields. The query engine supports column-oriented file reads, and people do not need to edit the files by hand. Which file format best exploits that access pattern?
Correct answer: A - Apache Parquet
A retailer's warehouse is available and its reports calculate correctly when current data arrives. The recurring problem is upstream: branch files use different formats, and scheduled loads fail intermittently. Designing and monitoring a reliable ingestion and transformation process most directly matches the responsibilities of a:
Correct answer: B - Data engineer
An order-processing application uses several databases on one SQL Server instance. Its stored procedures query across those databases, and its scheduled T-SQL jobs use SQL Server Agent. The migration must retain these features without making the company responsible for a server operating system. Where should the databases move?
Correct answer: B - Azure SQL Managed Instance, with the databases on one instance
An administrator intended to change one product's price but ran the following statements in a SQL Server session: BEGIN TRANSACTION; UPDATE dbo.Products SET Price = 0; The UPDATE has completed. The session is still connected, the transaction has not been committed, and no other statements have run in that transaction. Which immediate action undoes the mistake without discarding other transactions' committed changes?
Correct answer: B - Execute ROLLBACK TRANSACTION in the session that ran the UPDATE
Each row in a Product table stores ProductID, SupplierID, SupplierName, and SupplierPhone. A supplier serves many products. These fields are intended to show the supplier's current contact details, not a historical snapshot. After a phone-number change, different products show conflicting numbers for the same supplier. Which redesign removes the underlying update anomaly?
Correct answer: A - Store supplier details once in a Supplier table and reference SupplierID from Product
Three Windows application servers read and update documents through a shared SMB path. The application cannot be rewritten to call an object-storage API, and the infrastructure team wants to stop maintaining a file-server operating system. The replacement should be:
Correct answer: C - An SMB file share hosted by Azure Files
An Azure Table Storage import contains two orders: Order 1: PartitionKey = 'North', RowKey = '0042' Order 2: PartitionKey = 'South', RowKey = '0042' A reviewer flags the repeated RowKey as a duplicate entity. What does the key design actually imply?
Correct answer: C - The orders identify different entities because their key pairs are different
In a Power BI model, Product has one row per ProductID, while Sales has many rows for each ProductID. Every sales row has a matching product. A slicer built from Product does not change the measure Total Sales = SUM(Sales[Amount]); the tables are currently unrelated. What relationship should be added on ProductID?
Correct answer: A - Product on the one side and Sales on the many side, with Product filtering Sales
The analytics team's shortlist is being checked against three requirements: 1. One software-as-a-service platform for ingestion, Spark engineering, SQL warehousing, and reporting. 2. A shared logical data lake across those workloads. 3. Power BI included as a platform workload rather than connected as an external product. Which entry on the shortlist satisfies all three?
Correct answer: D - Microsoft Fabric
The full bank has 1,020 more DP-900 questions with explanations.
Continue in the free practice test →
View plans