Azure DP-900 study guide
Azure DP-900 · Work through your exam, one topic at a time.
The Microsoft Certified: Azure Data Fundamentals credential is an entry-level certification - Microsoft lists its level as Beginner - that demonstrates foundational knowledge of core data concepts and the Microsoft Azure data services built around them. It sits in the Databases subject area and is associated with the Data Engineer role, but the intended audience is broader: candidates just beginning to work with data in the cloud who want a recognized starting point. It can help you prepare for role-based certifications such as Azure Database Administrator Associate or Azure Data Engineer Associate, although Microsoft states it is not a prerequisite for any of them. Exam DP-900 is a proctored assessment scheduled through Pearson VUE, or through Certiport if you are a student or educator. The Azure DP-900 study guide has 4 sections and about 1,384 words.
01Describe Core Data Concepts
Core data concepts questions are almost always vocabulary and classification questions. Learn three axes: 1.
352 words, about 2 min02Identify Considerations for Relational Data on Azure
The relational model stores data in tables of rows and columns, with a schema enforcing types and constraints. Know: primary key (unique row identifier), foreign key (enforces a relationship and referential integrity), unique , check , not null , and default constraints; views (saved queries); and indexes (clustered = physical row order; nonclustered = separate lookup structure that speeds reads but slows writes).
355 words, about 2 min03Describe Considerations for Working with Non-Relational Data on Azure
Cosmos DB is a globally distributed, multi-model NoSQL service. Know its APIs: NoSQL (document), MongoDB , Cassandra (column-family), Gremlin (graph), and Table .
308 words, about 2 min04Describe an Analytics Workload on Azure
Analytics workloads ingest data, store it at scale, transform it, and serve it to reports or models. Typical Azure components: Azure Data Lake Storage Gen2 - hierarchical namespace over Blob storage; the landing zone for raw files (often organized in a medallion pattern: bronze raw, silver cleansed, gold curated).
369 words, about 2 min