DP-900 Microsoft · Fundamentals

DP-900 practice test

Microsoft Azure Data Fundamentals. Practice exam aligned to the DP-900 skills measured (July 2026): core data concepts, relational and non-relational data on Azure, and analytics workloads including Microsoft Fabric, Azure Databricks and Power BI.

  • 6 practice tests + challenge test
  • 350 questions
  • 40 questions, 45 min per test
  • Pass at 70%

Take the free DP-900 diagnostic10 questions, no card needed

Free DP-900 sample questions

3 questions from the free diagnostic, with answers and explanations.

Question 1 · Describe ways to represent data

Each order in an online store is saved as a JSON document, and different orders can have different fields. What kind of data is this?

  1. Semi-structured data
  2. Structured data
  3. Unstructured data
  4. Columnar analytical data
Show answer

Answer: A (Semi-structured data)

JSON carries its own field names, so it has some structure, but documents don't have to share a fixed schema: that makes it semi-structured.

Question 2 · Identify roles and responsibilities for data workloads

Which role builds and maintains the pipelines that move data from operational systems into an analytical data store?

  1. Data engineer
  2. Data analyst
  3. Database administrator
  4. Data scientist
Show answer

Answer: A (Data engineer)

Data engineers design and run data ingestion and transformation pipelines. Analysts explore and visualize the data; DBAs manage databases.

Question 3 · Describe common elements of large-scale analytics

Which analytical data store keeps files in open Delta format in a data lake and lets you query the same tables with both Spark and SQL?

  1. A lakehouse
  2. A data warehouse
  3. An eventhouse
  4. A data mart
Show answer

Answer: A (A lakehouse)

A lakehouse combines data lake storage with table structure (Delta Lake), so Spark and SQL engines can work on the same data.

Try the full diagnostic free

What the DP-900 practice covers

Share of practice questions per skill area.

  • Describe relational concepts14%
  • Describe common elements of large-scale analytics14%
  • Describe data visualization in Microsoft Power BI12%
  • Describe relational Azure data services10%
  • Describe the capabilities of Azure storage10%
  • Describe capabilities and features of Azure Cosmos DB8%
  • Describe considerations for real-time data analytics8%
  • Describe ways to represent data6%
  • Identify options for data storage6%
  • Describe common data workloads6%
  • Identify roles and responsibilities for data workloads6%

Question formats

  • Single choice
  • Multiple select
  • Hotspot (drop-down and yes/no)
  • Drag-and-drop matching
  • Drag-and-drop select and place
  • Case studies
  • Exhibits (screenshots, diagrams and code)

Career path: Fundamentals

Cloud, data, AI, security and Power Platform basics for anyone starting out, and for business roles working with technical teams.

  1. AZ-900
  2. DP-900
  3. AI-901
  4. SC-900
  5. PL-900

Guides

DP-900 practice test FAQ

Is there a free DP-900 practice test?

Yes. Create a free account and take the DP-900 free diagnostic: 10 questions across every skill area of the exam, with a study plan for the topics to work on. You can retake it as often as you like.

How many questions are in each ExamKite DP-900 practice test?

Each full practice test has 40 questions with a 45-minute timer, and you pass at 70%. There are 6 practice tests plus a harder challenge test, with 350 questions in total.

Which question formats does the DP-900 practice include?

Single choice, multiple select, hotspot (drop-down and yes/no), drag-and-drop matching, drag-and-drop select and place, case studies and exhibits (screenshots, diagrams and code), the same formats you meet on the real exam.

Are these real DP-900 exam questions?

No. They are original questions written for ExamKite and mapped to the Microsoft skills outline, never copied from the real exam. Using leaked exam questions breaks the certification provider's exam rules and can get your certification revoked.

More answers in the full FAQ.

Ready to practice for DP-900?

Start with the free diagnostic and get a study plan for the topics you miss.

Create a free account