DP-900Microsoft Azure Data Fundamentals
What the exam covers
Study guide
From Microsoft
About DP-900
Data fundamentals on Azure: structured vs semi-structured data, transactional vs analytical workloads, Azure SQL and open-source databases, Cosmos DB and storage, and analytics with Fabric and Power BI.
Who it's for. People starting a data career or working with data teams on Azure.
How to prepare
- Know OLTP vs OLAP and batch vs streaming from short descriptions.
- Learn the Cosmos DB APIs and which data model each one serves.
- Be clear on Azure SQL Database vs SQL Managed Instance vs SQL Server on a VM.
Sample DP-900 questions
Try these with the answers on the page, then practise the full bank.
- A media company is cataloguing its data assets. Which asset below counts as unstructured data? Describe core data concepts
- Which description correctly contrasts schema-on-write with schema-on-read? Describe core data concepts
- A travel marketplace stores hotel listings whose attributes differ by property type and change often as partners add new fields. The catalog must be readable with low latency on several continents and stay available if one region fails. Which data type and store combination fits? Describe core data concepts
- A payments processor must guarantee that refunds and charges are recorded exactly once, support auditors who run cross-customer analysis over several years, and process card authorizations in real time. Which architecture best meets these needs? Describe core data concepts
- A healthcare startup has to run a SQL Server instance inside a virtual machine in Azure. It also needs administrator rights on the guest Windows operating system so it can install a third-party monitoring agent. Which option meets these requirements? Relational data on Azure
- An order-line table stores a product code that must always match a code that exists in the product catalog table. Which database construct enforces this link between the two tables? Relational data on Azure
- An HR team wants staff to query employee records without seeing salary columns. The administrator defines a saved SELECT that exposes only the permitted columns. Which object does this describe? Relational data on Azure
- An Azure SQL Database must keep serving requests if an entire datacenter fails within one region, and the team does not want to build any replicas by hand. Which configuration provides this? Relational data on Azure
- All 27 sample questions
Questions people ask
Is this DP-900 practice exam free?
Yes. All 200 questions, the timed mock exam and the explanations are free, and there's no account to create.
Are these real exam questions?
No. Real exam questions are confidential under the Azure candidate agreement. These are practice questions written to cover the same domains in the same scenario style, each with an explanation of why the answer is right.
How is the DP-900 mock exam scored?
Questions are drawn from every domain in proportion to the exam guide, and you get a raw percentage with a breakdown by domain. Azure uses scaled scoring, so treat 75% or more here as a sign you're ready rather than a predicted score.
Where is my progress saved?
In your browser, on this device. Nothing is sent to us apart from the answers you check, and clearing site data resets it.