Core Data Concepts (25–30%)DP-900 Study Guide

Data Roles and Core Concepts

Objective 1.1 · Core Data Concepts

Relational Data Concepts

Objective 1.2 · Core Data Concepts

Non-Relational Data Concepts

Objective 1.3 · Core Data Concepts

Analytics and Data Warehouse Concepts

Objective 1.4 · Core Data Concepts

Data Roles: Engineer, Analyst, Scientist, DBA

Objective 1.1 · Core Data Concepts

ETL vs ELT Data Pipelines

Objective 1.1 · Core Data Concepts

Batch Processing vs Streaming Analytics

Objective 1.4 · Core Data Concepts

Data Lake vs Data Warehouse vs Lakehouse

Objective 1.4 · Core Data Concepts

Microsoft Purview Data Catalog

Objective 1.1 · Core Data Concepts

Data Governance: Quality, Lineage, Cataloguing

Objective 1.1 · Core Data Concepts

Non-Relational DB Types: Document, Key-Value, Graph, Column

Objective 1.3 · Core Data Concepts

Document Databases and JSON Storage

Objective 1.3 · Core Data Concepts

Graph Databases: Gremlin API and Relationships

Objective 1.3 · Core Data Concepts

Key-Value Stores and In-Memory Caching

Objective 1.3 · Core Data Concepts

Column-Family Databases (Cassandra API)

Objective 1.3 · Core Data Concepts

Structured vs Semi-Structured vs Unstructured Data

Objective 1.1 · Core Data Concepts

Data Formats: JSON, CSV, Parquet, and Avro

Objective 1.1 · Core Data Concepts

OLAP vs OLTP Workloads

Objective 1.4 · Core Data Concepts

Star Schema vs Snowflake Schema

Objective 1.4 · Core Data Concepts

Data Governance: Lineage, Glossary, and Classification

Objective 1.1 · Core Data Concepts

Microsoft Purview Data Map and Scanning

Objective 1.1 · Core Data Concepts

GDPR and Data Privacy on Azure

Objective 1.1 · Core Data Concepts

Data Ingestion Patterns: Batch vs Streaming

Objective 1.4 · Core Data Concepts

Schema-on-Read vs Schema-on-Write

Objective 1.1 · Core Data Concepts

Data Mesh and Domain-Oriented Data Ownership

Objective 1.1 · Core Data Concepts

Data Quality: Completeness, Accuracy, Consistency

Objective 1.1 · Core Data Concepts

Master Data Management Concepts

Objective 1.1 · Core Data Concepts