ciply.io

Microsoft · Fundamentals · DP-900

DP-900 Practice Exams & Study Guide

131 original practice questions across all four DP-900 domains — every answer explained and backed by official Microsoft documentation. No dumps, no recycled braindumps: the link to that documentation sits under every answer, so you can check any of it yourself.

Prepares you for Microsoft Azure Data Fundamentals Exam (DP-900)Matches Microsoft's current DP-900 objectives (21 July 2026)Microsoft's outline →
131
original questions
30
drag-and-drop & hotspot items
100%
questions with an official source link

Everything in this pack

  • 131 original questions, written from official Microsoft documentation
  • All four question formatssingle answer, multi-select, drag-and-drop, hotspot
  • 3 practice modesExam, Review, Domain practice
  • A weak-area report after every session, scored by official domain
  • The designed DP-900 Study Guide and Quick Recap card deck (PDF, in the bundle)
  • Every answer linked to the exact official page behind it
  • 15 free to try right now — no card needed
  • 12 months of access, including every content update we publish in that time
  • Runs in your browser — nothing to install, no player to configure

Coverage follows the official DP-900 blueprint

Official domainExam weightOur questions
Describe core data concepts2530%37
Identify considerations for relational data on Azure2025%30
Describe considerations for working with non-relational data on Azure1520%25
Describe an analytics workload on Azure2530%39

Weights from Microsoft's current Skills Measured outline for DP-900, dated 21 July 2026. Question counts follow the blueprint — never padded to hit a number.

What you'll be able to do

  • Work through every domain of the DP-900 blueprint, in the official weighting
  • Find your weak domains before the exam does — every session scores you by domain and unit
  • Handle all four question formats under time, including drag-and-drop and hotspot
  • Explain why an answer is right, not just which one it is — and check it against the official page

Judge the quality yourself

Sample question 1

Which description best fits a transactional (OLTP) workload?

  • a.A read-mostly system that stores years of history for reporting
  • b.A high-volume system that quickly creates, reads, updates, and deletes records, with storage tuned for both reads and writes✓ correct
  • c.A model that preaggregates numbers so that summaries return fast
  • d.A format for compressing files to save storage space
Why B: (B) An OLTP workload handles many small transactions and keeps them fast. Its storage is tuned for both reading and writing as records are created, read, updated, and deleted (CRUD operations). (A) describes an analytical (OLAP) workload. (C) describes an OLAP/semantic model, not a transactional system. (D) describes an optimized file format, not a workload at all.
Sample question 2

Relational data is organized into tables. In this model, what does a single row represent?

  • a.The complete set of entities stored in the database
  • b.A single instance of an entity, such as one customer or one order✓ correct
  • c.A column definition that is shared by the whole table
  • d.A virtual result assembled from other tables
Why B: (B) In a relational table, each row records one instance of an entity — a single customer, product, or order. (A) a row is one entity instance, not the entire collection of entities. (C) columns, not rows, define the shape of the table, so a row is not a column definition. (D) a result assembled from other tables describes a view, not a base-table row.

Every explanation names why the right answer is right and what each wrong option actually refers to — that's the standard across all 131 questions. Try 15 of them free →

Look inside the DP-900 Study Guide

The real opening of Chapter 1 — how the whole guide teaches. The full guide continues like this, chapter by chapter, with original diagrams and verified questions woven in.

Chapter 1 · free excerpt

Representing and Storing Data

Every data solution starts with two plain questions. What shape is the data in? And where should it sit? This opening chapter answers both. You will meet the three shapes data takes: structured, semi-structured, and unstructured. Then come the file formats that write it down, and the two kinds of place it can live — a file store or a database. Get this groundwork right and the rest of the guide has somewhere to stand. Every Azure service in later chapters is, underneath, a way to store or work with one of these shapes.

Start with what data even is. Data is a set of facts — numbers, text, observations — that records something worth keeping. Most data describes entities a business cares about, such as customers, products, or orders. Each entity carries attributes: a customer, for one, has a name, a phone number, and a mailing address. Before you can store data well, you sort it into one of three shapes.
Structured data follows one fixed schema. Every record holds the same named fields, so the data drops neatly into a table. Rows hold one record each; columns hold the attributes. A products list where every item shows the same fields — code, name, price — is structured. This shape sits most naturally in a relational database, which Part II of the guide covers in full.

Mental model

Picture three ways an office keeps paper. Structured data is a printed form: every copy has the same boxes in the same places, so a machine can read a thousand of them without pausing. Semi-structured data is a stack of index cards — they follow a loose house style, but one card carries an extra note and another skips a line. Unstructured data is the shoebox of photos and voice memos: no labels, no grid, just contents someone has to open to make sense of. Same information, three levels of order.
THREE SHAPES OF DATA MORE ORDER → LESS Structured One fixed schema Every record has the same fields. so it fits a table Semi-structured A loose, shared shape record 1 name phone record 2 name phone noteRecords share a rough layout; fields vary. often written as JSON Unstructured No set schema at all document image audio videoDocuments, images, audio, video. a program must open it
Figure 1.1 — Three shapes of data. Structured data has one fixed schema, semi-structured keeps a loose shape whose fields vary, and unstructured data has no schema at all.

Worked example

Worked example. A hospital runs one system holding three kinds of data. Patient records carry the same fields for everyone — so they are structured — and sit in tables in a relational database, queried with SQL. Intake notes arrive as JSON, where one patient lists three allergies and another lists none; that variation makes them semi-structured. X-ray images and recorded consultations have no schema at all — unstructured — so they are kept as BLOBs in a file store. One hospital, three shapes, each one landing in the store that fits it. Force all three into a single store and something always fits badly.

Excerpt ends here — the full chapter continues with the five workloads in depth, exam traps, and verified practice questions.

Quick Recap — two of the DP-900 cards

A landscape card deck for last-mile review, ending in a Cram Sheet. One chapter card and one of the four Cram Sheet cards:

Chapter card

Three shapes of data

THREE SHAPES OF DATA MORE ORDER → LESS Structured One fixed schema Every record has the same fields. so it fits a table Semi-structured A loose, shared shape record 1 name phone record 2 name phone noteRecords share a rough layout; fields vary. often written as JSON Unstructured No set schema at all document image audio videoDocuments, images, audio, video. a program must open it
Structured data has one fixed schema and fits a table. Semi-structured keeps a loose shape whose fields vary (often JSON). Unstructured has no schema at all — documents, images, audio, video.

Cram sheet · 1 of 4

Must-memorize facts

3
data shapes — structured / semi-structured / unstructured (Ch 1)
4
ACID guarantees — atomicity, consistency, isolation, durability (Ch 2)
3
SQL statement groups — DDL, DML, DCL (Ch 4)
3
Azure SQL family members — VM, Managed Instance, SQL Database (Ch 5)
4
blob access tiers — Hot / Cool / Cold / Archive (Ch 6)
5
Cosmos DB APIs — NoSQL, MongoDB, Cassandra, Table, Gremlin (Ch 7)
4
analytics stages — ingestion, store, model, visualization (Ch 8)
4
stream stages — event, source, perpetual query, sink (Ch 9)

What the designed PDFs look like

Real pages from the files you download — the polish is part of what you're paying for.

DP-900 Study Guide — real pageDP-900 Quick Recap — real card

Simple pricing, 12 months of access

Practice Exams

$10.90launch price · 12-month access
  • 131 original questions across all 4 official domains
  • All four question formats: single, multi-select, drag-and-drop, hotspot
  • Exam, Review and Section modes with a weak-area report
  • Every answer explained and linked to the official Microsoft page behind it
Best value — save $3.90

Complete Bundle

$13.90launch price · 12-month access
  • Everything in Practice Exams
  • The designed DP-900 Study Guide (PDF), taught in learning order
  • The Quick Recap card deck for last-mile review
  • One purchase, complete preparation
  • See what's inside ↓

Study Guide + Quick Recap

$6.90launch price · 12-month access
  • Designed DP-900 Study Guide (PDF) with original diagrams
  • Quick Recap card deck ending in a cram sheet
  • Plain-English teaching around precise exam terms
  • See what's inside ↓

Secure checkout by Stripe · VAT handled · instant access

Introductory launch pricing. The regular price applies after our launch window. Prices shown in USD; local currency and tax shown at checkout.

Who this is for

  • Anyone sitting DP-900 for the first time and wanting the blueprint covered, not sampled
  • Retakers who need to find the gap that cost them, rather than re-reading everything
  • People new to Microsoft cloud, from any background — the guide teaches, it doesn't just quiz
  • Anyone who wants to check an answer against the official documentation instead of trusting it

Who it isn't for

  • Anyone looking for the live exam's actual questions. We don't have them, and nobody should be selling them to you — using them puts your certification at risk and teaches you nothing.
  • Anyone who wants to pass without understanding the material. Every answer here comes with the reasoning and the source, which is slower than memorising and the entire point.

Questions people ask before buying

Are these DP-900 exam dumps?
No. Every question is original — built on the official exam blueprint and backed by free, public, official Microsoft documentation, with every answer linked to the exact official page behind it. We never use braindumps, leaked questions, or paywalled material. If you are looking for the live exam's actual questions, we do not have them, and we would not sell them.
How long do I have access?
12 months from purchase, including all content updates during that time — certification content changes, so we keep it current rather than promising a hollow 'lifetime'. PDFs you download during that period stay yours to keep.
Can I try before buying?
Yes — 15 questions from this bank are free with a free account, in the same player you would use after purchase. Full sample questions with their explanations are also printed on this page.
What kinds of questions are included?
The bank has 131 questions across all four formats: single answer, multi-select, drag-and-drop, hotspot.
What happens when Microsoft updates the DP-900 exam?
We re-check the bank against the new Skills Measured outline and update the questions that need it, then republish. Updates during your 12 months are included at no extra cost. We date our claim against Microsoft's published outline rather than simply saying the pack was "recently updated", so you can check the correspondence yourself.
Can I get a refund?
Yes, before you access what you bought. Because these are digital products delivered immediately, opening a paid question bank or downloading a purchased PDF ends the statutory 14-day withdrawal right — until you do, it is intact. We also refund genuine cases such as a technical failure we cannot fix. The full detail, including exactly what counts as access, is in our Refund Policy.

Full detail: Refund Policy · Terms · How we build content

The no-dumps promise

Braindump sites recycle stolen exam content — using them risks your certification and teaches you nothing. Every ciply.io question is original: built on the official exam blueprint, backed by official Microsoft documentation, and every answer links the exact page behind it — so you learn why it's right. How we build content →

Every question in this pack maps to Microsoft's published Skills Measured outline for DP-900 — the current outline, dated 21 July 2026. When Microsoft revises it, we re-diff the bank against the new outline. Read Microsoft's outline →

ciply.io is an independent study resource and is not affiliated with, authorized, sponsored, or endorsed by Microsoft. Microsoft Azure Data Fundamentals Exam, DP-900, and related names are trademarks of their respective owners.