Microsoft · DP-900
Microsoft Certified: Azure Data Fundamentals (DP-900) Practice Tests
Demonstrate foundational knowledge of core data concepts related to Microsoft Azure data services, including relational and non-relational data and analytics workloads.
Exam Details
Practice Questions
381
≈ 7 practice exams
Duration
45 minutes
Passing Score
700/1000
Difficulty
FoundationalLast Updated
Oct 2026
Topics Covered
Core data conceptsRelational data on AzureNon-relational data on AzureAnalytics workloads on Azure
Microsoft DP-900 Azure Data Fundamentals Practice Exam
DP-900 is Microsoft's entry point for candidates beginning to work with cloud data. The July 21, 2026 blueprint covers core data concepts (25-30%), relational data on Azure (20-25%), non-relational data on Azure (15-20%), and analytics workloads (25-30%). It expects recognition of suitable services and workload patterns, not implementation at an administrator or engineer level.
The proctored exam allows 45 minutes and requires a scaled score of 700 or greater. Microsoft does not publish a fixed question count, and 700 is not the same as 70% correct. There is no certification prerequisite; Microsoft explicitly positions Azure Data Fundamentals as optional preparation for later role-based credentials rather than a requirement for them.
This 381-question DP-900 bank gives each current domain repeated coverage. Start with 30 free questions, then use missed answers to distinguish transactional from analytical workloads, relational from non-relational stores, and the roles of Azure SQL, Azure Storage, Cosmos DB, Microsoft Fabric, Azure Databricks, and Power BI.
Exam Domain Breakdown
Describe core data concepts28%
Identify considerations for relational data on Azure23%
Describe considerations for non-relational data on Azure18%
Describe an analytics workload on Azure28%
Exam Overview
Exam DP-900 validates foundational knowledge of data concepts and the Azure services used for relational, non-relational, and analytics workloads. The current Microsoft study guide is dated July 21, 2026 and divides the exam into four weighted skill areas.
This is a concepts exam for people beginning to work with cloud data. It asks candidates to identify appropriate workload types, data representations, roles, and services; it is not an implementation exam for database administrators or data engineers.
Who Should Take This Exam
DP-900 is aimed at students, career changers, business or technology professionals, and early-career data practitioners who want a verified foundation in cloud data. Microsoft expects familiarity with relational and non-relational data and with transactional and analytical workloads.
Prerequisites
There is no certification, education, or experience prerequisite. Microsoft says Azure Data Fundamentals can help candidates prepare for later role-based credentials, but it is not a prerequisite for them.
Exam Format
The proctored exam allows 45 minutes and may contain interactive components. Microsoft requires a scaled score of 700 or greater and does not publish a fixed question count; 700 should not be read as exactly 70% correct.
Skills Measured
- 1.Describe core data concepts (25-30%): data representations and stores, transactional and analytical workloads, and the responsibilities of data roles.
- 2.Identify considerations for relational data on Azure (20-25%): relational principles, SQL, database objects, Azure SQL products, and managed open-source databases.
- 3.Describe considerations for non-relational data on Azure (15-20%): Blob, Files, and Table storage plus Azure Cosmos DB use cases and APIs.
- 4.Describe an analytics workload on Azure (25-30%): ingestion and processing, analytical stores, Databricks, Microsoft Fabric, streaming, and Power BI.
Study Tips
- Use the July 21, 2026 Microsoft study guide as the syllabus and check it again shortly before the exam.
- Complete Microsoft's free learning paths and official Practice Assessment before using longer timed mocks.
- Practise matching a requirement to a workload or service instead of memorizing product taglines.
- Use the Exam Sandbox to learn the interface and interactive item types.
- Keep Azure SQL, Azure Storage, Cosmos DB, Microsoft Fabric, Databricks, and Power BI roles distinct.
Career Benefits
Passing DP-900 earns Microsoft Certified: Azure Data Fundamentals. It documents an entry-level understanding of cloud data vocabulary and Azure data services and can provide a structured starting point for deeper database, analytics, or data-engineering study without claiming that it alone qualifies someone for those roles.
Sample Questions
5 sample questions with answers and explanations. The full bank has 381 questions, enough for 7 full-length practice exams.
Preview — answers shown1. A data engineer is writing a SQL query to add a new employee to the Employees table. Which Data Manipulation Language (DML) command should they use?
AALTER
BSELECT
CCREATE
DINSERT
Explanation
The INSERT command is the DML statement used to add new rows of data into a table. The syntax would be INSERT INTO Employees (...) VALUES (...). CREATE and ALTER are Data Definition Language (DDL) commands used to define or modify the structure of the database itself, not the data within it. SELECT is used to retrieve data.
2. Which of the four main types of analytics answers the question, 'What is likely to happen in the future?'
ADescriptive analytics
BDiagnostic analytics
CPredictive analytics
DPrescriptive analytics
Explanation
Predictive analytics is the branch of analytics focused on making predictions about future outcomes. It uses historical data, statistical algorithms, and machine learning techniques to identify the likelihood of future results. A common example is a sales forecast. Descriptive analytics tells you what happened. Diagnostic analytics tells you why it happened. Prescriptive analytics tells you what you should do about it.
3. A developer is writing a SQL statement to remove all employee records from the Employees table where the Status column is 'Terminated'. Which DML command should be used?
ADROP
BUPDATE
CDELETE
DTRUNCATE
Explanation
The DELETE command should be used. DELETE is a DML statement used to remove one or more rows from a table based on a condition specified in a WHERE clause. It is logged for each row, so it can be slower but more precise than TRUNCATE. DROP is a DDL command that removes the entire table object. TRUNCATE is a DDL command that removes all rows from a table quickly but cannot use a WHERE clause. UPDATE modifies existing rows.
4. In Azure, which of the following is an example of Platform-as-a-Service (PaaS)?
AAn Azure Virtual Machine with Windows Server installed.
BAzure SQL Database.
CA physical server in an Azure datacenter.
DMicrosoft Office 365.
Explanation
Azure SQL Database is a classic example of PaaS. In a PaaS model, the cloud provider (Azure) manages the underlying infrastructure, including the servers, storage, networking, and operating system. The customer only manages their application and data. This allows developers to build and run applications without the complexity of building and maintaining the infrastructure. An Azure VM is IaaS (Infrastructure-as-a-Service). A physical server is part of the cloud provider's infrastructure. Office 365 is SaaS (Software-as-a-Service).
5. Which of the following database objects is created primarily to improve the performance of data retrieval operations by creating a data structure that allows for faster lookups on specific columns?
AA stored procedure
BAn index
CA view
DA trigger
Explanation
An index is the database object created specifically to improve query performance. It works much like an index in the back of a book; instead of scanning the entire table (the whole book), the database can use the index to quickly find the location of the rows that match the query's criteria. This can dramatically speed up data retrieval on large tables. A view is a stored query. A stored procedure is a block of reusable code. A trigger is code that runs automatically in response to an event.
Frequently Asked Questions
What does DP-900 cover in the current blueprint?
The July 21, 2026 blueprint covers core data concepts (25-30%), relational data on Azure (20-25%), non-relational data on Azure (15-20%), and analytics workloads (25-30%).
How long is DP-900 and what score is required?
Microsoft allows 45 minutes and requires a scaled score of 700 or greater. A score of 700 is not equivalent to exactly 70% correct.
How many questions are on DP-900?
Microsoft does not publish a fixed DP-900 question count. Its certification exams can change item count, and the exam may include interactive components.
Does DP-900 have prerequisites?
No. Microsoft targets candidates beginning to work with cloud data and expects familiarity with relational and non-relational data and transactional and analytical workloads.
Is DP-900 required before another Azure data certification?
No. Microsoft says it can help prepare for role-based credentials such as Azure Database Administrator Associate or Azure Data Engineer Associate, but it is not a prerequisite.
When was the DP-900 skills outline last updated?
Microsoft lists the current skills measured as of July 21, 2026. Candidates should use that dated study guide because cloud-service coverage changes over time.
More Microsoft Practice Exams
Microsoft Certified: Azure AI Fundamentals (AI-900)
AI-900 · 464 questions
Microsoft Azure AI Fundamentals (AI-901)
AI-901 · 600 questions
Microsoft Certified: Azure Cosmos DB Developer Specialty (DP-420)
DP-420 · 677 questions
Microsoft Certified: Azure Data Scientist Associate (DP-100)
DP-100 · 987 questions
Microsoft Certified: Azure Database Administrator Associate (DP-300)
DP-300 · 389 questions
Microsoft Certified: Azure Developer Associate (AZ-204)
AZ-204 · 640 questions
$17.99
One-time access to this exam
381 questions (7 practice exams' worth)
Unlimited timed exam simulations
Yours forever — no subscription
Detailed explanations
Free preview stays available