CertLabProMicrosoft Azure Data Fundamentals
175道练习题
最后审核：April 2026
为你的学习之旅记录个人笔记和资源链接
按认证筛选
Microsoft Azure Data Fundamentals (DP-900) is the entry-level credential for data workloads on Azure. It targets candidates beginning a data-platform career — junior data engineers, analysts, BI developers, and stakeholders who need fluency in Azure data services. The exam validates conceptual understanding of relational and non-relational data, batch and streaming analytics workloads, and the Azure portfolio that supports each (Azure SQL family, Cosmos DB, Storage, Synapse, Data Factory, Microsoft Fabric, Databricks). Expect 40–60 multiple-choice, multiple-response, and drag-and-drop questions in 45 minutes — conceptual, not hands-on, with no case studies.
Structured / semi-structured / unstructured data, OLTP vs. OLAP, batch vs. streaming, common data roles (engineer, analyst, scientist) and the modern data warehouse / lakehouse / data mesh patterns. About 28% of questions.
Azure SQL Database vs. SQL Managed Instance vs. SQL Server on VMs, Azure Database for MySQL / PostgreSQL / MariaDB, basic SQL, normalization, and managed-service tradeoffs. About 22%.
Azure Cosmos DB APIs (NoSQL, MongoDB, Cassandra, Gremlin, Table), Azure Storage (Blob, Files, Tables, Queues), document / key-value / graph / column-family data models. About 18%.
Largest domain at 32%. Azure Synapse Analytics, Microsoft Fabric, Azure Databricks, Azure Data Factory, Power BI, plus core warehouse / lakehouse architecture concepts. Heaviest growth area in recent refreshes.
$65k–$100k–$140k USD annual
DP-900 by itself does not move salaries materially — it is a literacy signal. Engineers entering the higher end pair it with DP-203 / DP-300 / DP-600 / DP-700 plus 2–4 years of hands-on data work. Non-coastal US markets trend toward the lower end.
Source: levels.fyi 2025 data analyst / engineer roles, U.S. BLS OEWS May 2024 (15-2051 data scientists, 13-2031 budget / data analysts), Glassdoor 2025. Figures are approximate; actual compensation depends on role, region, and experience.
DP-900 has had steady demand as enterprises modernize data estates onto Azure Synapse, Databricks, and increasingly Microsoft Fabric. Recruiters treat it as a baseline literacy signal for analyst and junior engineer roles, and as evidence of intent for engineers transitioning into data platform work. It pairs naturally with AZ-900 to round out an Azure-platform overview, and acts as the recommended on-ramp to the associate-level data exams (DP-300 for DBAs, DP-600 / DP-700 for Fabric, DP-100 for data science). Microsoft regularly distributes free DP-900 vouchers through Microsoft Learn data-skills challenges.
There are no formal prerequisites. DP-900 is positioned as the first data-track exam most candidates take. Microsoft's free Microsoft Learn path covers all four domains in roughly 10–15 hours of self-paced content, and the included sandboxes let you experiment with Azure SQL, Cosmos DB, and Synapse without a paid subscription.
If you already hold AZ-900 or AI-900, plan to compress study time meaningfully — only the data-specific domains are new. If you are coming from AWS Cloud Practitioner or AWS Data Engineer Associate, focus on mapping AWS service names (RDS, DynamoDB, Glue, Redshift) onto Azure equivalents (Azure SQL, Cosmos DB, Data Factory, Synapse / Fabric).
DP-900 sits in the Fundamentals tier — comparable in difficulty to AZ-900 and AI-900. Plan on 15–25 hours of study over 2–3 weeks with no prior data background; experienced data professionals often pass with 5–10 hours of focused review. The exam runs 45 minutes with 40–60 questions in mixed formats: multiple choice, multiple response, and drag-and-drop matching exercises. No case studies at the Fundamentals tier.
The most common stumbling block is service overlap — Azure has multiple ways to land a data-warehouse, lakehouse, or streaming workload (Synapse vs. Fabric vs. Databricks vs. Stream Analytics) and the exam expects you to know which is the canonical choice for each scenario. Microsoft Fabric coverage has grown significantly in the 2024 outline refresh, so older study material may underweight it.
Refreshed to add Microsoft Fabric coverage in the analytics domain and update Azure Synapse / Databricks framing. Microsoft refreshes DP-900 approximately yearly without changing the exam code.
Pre-Microsoft-Fabric outline. Heavier on Synapse and Data Factory; no Fabric or Lakehouse-by-name coverage.
DP-900 (Microsoft Azure Data Fundamentals) is a considered an entry-level exam testing breadth of conceptual understanding rather than hands-on depth Foundational-level exam. Most candidates need 30–80 hours of study spread over 3–6 weeks for foundational-level exams. Most candidates who score consistently above the passing threshold on practice exams pass on their first attempt.