← All exams
Home · Azure Data Fundamentals (DP-900)

Azure Data Fundamentals (DP-900)

Practice for Microsoft's data fundamentals cert.

Pass mark 35/50 45 minutes Microsoft How many can I get wrong?
Little and often beats one big session. Five minutes on the bus counts.
Free practice questions
Try 3 real Azure Data Fundamentals (DP-900) questions
Have a go, then reveal the worked explanation. A taster from a bank of 273 original questions — unlock for unlimited drills and full timed mocks.
Q1. Which term describes data that is organised into rows and columns with a fixed schema, such as a table of customer orders?
  • A.  Structured data
  • B.  Semi-structured data
  • C.  Unstructured data
  • D.  Metadata
Show answer & explanation
✓ Answer: A. Structured data
Structured data follows a predefined schema of rows and columns, like a relational database table. Semi-structured data (such as JSON) has some organisation but no fixed schema, and unstructured data (such as images) has no inherent structure at all.
Q2. A retail company has many small, lightly used databases with unpredictable, spiky usage patterns and wants to share compute resources cost-effectively across them. Which Azure SQL Database feature is designed for this scenario?
  • A.  Elastic pool
  • B.  Hyperscale service tier
  • C.  Read replica
  • D.  Geo-restore
Show answer & explanation
✓ Answer: A. Elastic pool
Elastic pools let multiple Azure SQL databases share a set pool of resources (DTUs or vCores), which is cost-effective when individual databases have unpredictable or infrequent peaks. Hyperscale targets very large single databases needing fast scale-out storage, not resource sharing across many small databases.
Q3. What is the key difference between Geo-Redundant Storage (GRS) and Read-Access Geo-Redundant Storage (RA-GRS)?
  • A.  GRS replicates synchronously while RA-GRS replicates asynchronously
  • B.  RA-GRS allows read access to the secondary region's replicated data, while GRS does not
  • C.  GRS is only available for Blob storage while RA-GRS supports all storage types
  • D.  RA-GRS stores data in three availability zones instead of one region
Show answer & explanation
✓ Answer: B. RA-GRS allows read access to the secondary region's replicated data, while GRS does not
Both GRS and RA-GRS asynchronously replicate data to a secondary region, but RA-GRS additionally allows applications to read from that secondary region even when the primary is available, while plain GRS only allows read access to the secondary after Microsoft-initiated failover. Both apply across supported storage types, and availability-zone replication is a separate redundancy option (ZRS/GZRS).
Exam format (pass mark, question count, timing) verified against Microsoft Credentials. Questions are our own, not the official paper.
Start here
Ten questions to see where you stand
Two minutes, no timer, marked the moment you finish with every answer explained. Then you'll know which topics need the work before you sit a full mock.
Exam mode
Full mock exam
50 random questions, real timing, marked against the official pass mark. Different every time.
Create a free account for a full mock
No card needed. A free account unlocks a full timed mock and 3 drills on every exam.
Try it free
Topic drills
Ten quick questions on one topic, marked instantly with explanations.
1 free drill left — then a free account unlocks 3 + a full mock.
Core data concepts · 43
Relational data on Azure · 45
Non-relational data on Azure · 47
Data warehousing & analytics · 45
Data visualisation (Power BI) · 48
Governance & security · 45
Azure Data Fundamentals (DP-900) — common questions
Frequently asked
How many questions are in the Azure Data Fundamentals (DP-900)?
The exam has 50 questions. Every Revision Robin mock uses the same 50-question format so your practice matches the real thing.
What is the pass mark for the Azure Data Fundamentals (DP-900)?
You need 35 out of 50 correct to pass, which is about 70%. Our mocks mark you against this exact threshold.
How long do you get?
The test is timed at 45 minutes. Our full mock runs on the same clock so you can practise your pacing.
Are these the real exam questions?
No. Our questions are original and written to match the current syllabus, so they give realistic practice without copying the official paper. Every answer comes with a plain-English explanation. Always confirm current rules and content with Microsoft.