The Integrated Microsoft Azure Data Fundamentals (DP-900) Study Guide [85 Minute Read]

A First-Principles Approach to Data Architecture, Analytics, and Cloud Services

Welcome to 'The Integrated Microsoft Azure Data Fundamentals (DP-900) Study Guide.' This guide moves beyond simple definitions. It is designed to build a robust mental model of how data "lives" in the cloud.

We will deconstruct data concepts into their foundational truths, understanding the 'why' behind every service choice. Each topic is aligned with the official Microsoft DP-900 Exam Objectives (Nov 2024 Update), targeting the specific cognitive skills required for success.

Visual: DP-900 Exam Domain Weights

---

(Table of Contents - For Reference)

• Phase 1: First Principles of Azure Data

  • 1.1. The Three Questions Framework
    • 1.1.1. What Shape Is Your Data?
    • 1.1.2. What Is Your Intent?
    • 1.1.3. What Scale Do You Need?
  • 1.2. The Control-Convenience Spectrum
    • 1.2.1. IaaS, PaaS, and SaaS for Data
    • 1.2.2. The Responsibility Trade-off
  • 1.3. The Data Lifecycle Model
    • 1.3.1. Ingest → Store → Process → Serve
    • 1.3.2. Choosing Services by Lifecycle Stage
  • 1.4. Reflection Checkpoint: First Principles Mastery

• Phase 2: Core Data Concepts & Workloads (25-30%)

  • 2.1. Data Representation: The Physics of Data
    • 2.1.1. Structured, Semi-Structured, and Unstructured Data
    • 2.1.2. File Formats: The Containers of Analytics
  • 2.2. Workload Types: The Intent of Data
    • 2.2.1. Transactional (OLTP) vs. Analytical (OLAP)
    • 2.2.2. Batch vs. Streaming Processing
  • 2.3. Data Roles & Responsibilities
  • 2.4. Reflection Checkpoint: Core Data Concepts Mastery

• Phase 3: Relational Data on Azure (20-25%)

  • 3.1. Relational First Principles (Normalization, ACID, SQL)
    • 3.1.1. Normalization and Data Integrity
    • 3.1.2. SQL Command Categories (DDL, DML, DCL)
    • 3.1.3. Common Database Objects
  • 3.2. The Azure SQL Family: Choosing the Right Host
    • 3.2.1. SQL on VM (IaaS) vs. Managed Instance vs. SQL Database (PaaS)
    • 3.2.2. Azure SQL Database Deployment Options
  • 3.3. Security & Governance for Data Services
    • 3.3.1. Security Features (TDE, Always Encrypted, Masking)
    • 3.3.2. Data Governance with Microsoft Purview
    • 3.3.3. Azure Monitor for Data Services
  • 3.4. Open Source Databases on Azure
    • 3.4.1. PostgreSQL, MySQL, and MariaDB on Azure
  • 3.5. Reflection Checkpoint: Relational Data Mastery

• Phase 4: Non-Relational Data on Azure (15-20%)

  • 4.1. Azure Storage Accounts: The Universal Container
    • 4.1.1. Azure Blob Storage
    • 4.1.2. Azure Files
    • 4.1.3. Azure Table Storage: Simple Key-Value Store
  • 4.2. Azure Cosmos DB: The Planet-Scale Database
    • 4.2.1. Core Concepts: Global Distribution and Consistency
    • 4.2.2. Selecting the Right API (SQL, Mongo, Gremlin, etc.)
  • 4.3. Reflection Checkpoint: Non-Relational Data Mastery

• Phase 5: Modern Analytics & Visualization (25-30%)

  • 5.1. The Modern Data Warehouse Architecture
    • 5.1.1. Data Ingestion with Azure Data Factory
    • 5.1.2. Data Storage with Azure Data Lake Gen2
    • 5.1.3. Data Processing with Azure Synapse Analytics
    • 5.1.4. Data Processing with Azure Databricks
  • 5.2. Microsoft Fabric: The Unified Analytics Platform
    • 5.2.1. OneLake: The Foundation
    • 5.2.2. Fabric Workloads (Experiences)
    • 5.2.3. Lakehouse Architecture
    • 5.2.4. Fabric vs. Azure Synapse Comparison
  • 5.3. Data Visualization with Power BI
    • 5.3.1. Appropriate Visualizations
    • 5.3.2. Data Modeling Concepts (Dimensions, Facts, Hierarchy)
    • 5.3.3. Reports vs. Dashboards
  • 5.4. Reflection Checkpoint: Analytics & Visualization Mastery

• Phase 6: Exam Readiness & Strategy

  • 6.1. Exam Structure, Question Types, and Scoring
  • 6.2. Effective Time Management During the Exam
  • 6.3. Keyword Mapping & Distractor Identification
  • 6.4. Scenario-Based Sample Questions (By Domain)
    • 6.4.1. Core Data Concepts Questions
    • 6.4.2. Relational Data Questions
    • 6.4.3. Non-Relational Data Questions
    • 6.4.4. Analytics & Visualization Questions
    • 6.4.5. Security & Governance Questions

• Phase 7: Comprehensive Glossary

---