Free Practice Questions for Microsoft Certified: Azure Data Fundamentals (DP-900) Certification
Study with 362 exam-style practice questions designed to help you prepare for the Microsoft Certified: Azure Data Fundamentals (DP-900). All questions are aligned with the latest exam guide and include detailed explanations to help you master the material.
Exam experiencesNew
Pass and fail outcomes from candidates who prepared here — advice, scores, and prep time.
Start Practicing
All Domains
Practice with randomly mixed questions from all topics
Domain Mode
Practice questions from a specific topic area
Quiz History
Exam Details
Key information about Microsoft Certified: Azure Data Fundamentals (DP-900)
- Multiple choice
- Ordering
- Matching
- True/False
associate (intermediate)
Familiarity with Exam DP-900's self-paced or instructor-led learning material.
Candidates beginning to work with data in the cloud, familiar with relational and non-relational data concepts, and different types of data workloads.
November 1, 2024
Exam Topics & Skills Assessed
Skills measured (from the official study guide)
Domain 1: Describe core data concepts
Subdomain 1.1: Describe ways to represent data
- Describe the features of structured data - Describe the features of semi-structured data - Describe the features of unstructured data
Subdomain 1.2: Identify options for data storage
- Describe common formats for data files - Describe features of common data stores including databases - Identify Azure datastores for common use cases
Subdomain 1.3: Describe common data workloads
- Describe features of transactional workloads - Describe features of analytical workloads
Subdomain 1.4: Identify roles and responsibilities for data workloads
- Describe responsibilities for database administrators - Describe responsibilities for data engineers - Describe responsibilities for data analysts
Domain 2: Identify considerations for relational data on Azure
Subdomain 2.1: Describe relational concepts
- Identify features of relational data - Describe normalization and why it is used - Identify common structured query language (SQL) statements - Identify common database objects
Subdomain 2.2: Describe relational Azure data services
- Describe the Azure SQL family of products, including Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines - Identify Azure database services for open-source database systems
Domain 3: Describe considerations for working with non-relational data on Azure
Subdomain 3.1: Describe the capabilities of Azure storage
- Describe features of Azure Blob storage - Describe features of Azure Files - Describe features of Azure Table storage
Subdomain 3.2: Describe the capabilities and features of Azure Cosmos DB
- Identify use cases for Azure Cosmos DB - Describe Azure Cosmos DB APIs
Domain 4: Describe an analytics workload
Subdomain 4.1: Describe common elements of large-scale analytics
- Describe considerations for data ingestion and processing - Describe options for analytical data stores - Describe Microsoft cloud services for large-scale analytics, including Azure Databricks and Microsoft Fabric
Subdomain 4.2: Describe considerations for real-time data analytics
- Describe the difference between batch and streaming data - Identify Microsoft cloud services for real-time analytics
Subdomain 4.3: Describe data visualization in Microsoft Power BI
- Identify the capabilities of Power BI - Describe features of data models in Power BI - Identify appropriate visualizations for data
Techniques & products