Please enable JavaScript.
Coggle requires JavaScript to display documents.
Azure Data Fundamentals - Coggle Diagram
Azure Data Fundamentals
[DP-900: Azure Data Fundamentals]
► [Domain 1: Core Data Components]
► Data Types
Structured (Tables, Rows/Columns, Strict Schema, SQL/CSV)
Semi-Structured (Key-Value, Flexible Schema, JSON/XML/YAML)
Unstructured (No Structural Blueprint, Videos/Audio/PDFs/Images)
► Workloads
Transactional (OLTP) -> Fast, daily operations, Normalized, Low latency, ACID compliance
Analytical (OLAP) -> Complex queries, Historical analysis, Denormalized, Data Warehouses
► Analytics Pipeline
Ingestion (Pulling raw data from sources into the cloud)
Processing
Batch Processing (Large chunks at scheduled intervals, e.g., nightly)
Stream Processing (Real-time, continuous live data processing)
Visualization (Presenting data in charts/graphs for business decisions)
► [Domain 2: Relational Data on Azure]
► Azure Offerings
Azure SQL Database (Fully managed PaaS, automated patching, modern apps)
Azure SQL Managed Instance (PaaS, near-100% on-prem compatibility, SQL Agent)
Azure Database for PostgreSQL / MySQL (Fully managed open-source engines)
► Management & Querying
Provisioning & Connectivity (Firewalls, VNet access, connection strings)
Security (Azure AD/Entra ID authentication, Encryption, Data Masking)
SQL Querying (SELECT, INSERT, UPDATE, DELETE, WHERE, JOIN)
► [Domain 3: Non-Relational Data on Azure]
► Azure Cosmos DB (Globally distributed, Multi-model NoSQL, single-digit ms latency)
Core (SQL) API -> Stores JSON documents, queried with SQL syntax
MongoDB API -> For existing MongoDB app migrations
Gremlin API -> For Graph data structures (nodes and edges)
Table API -> For premium key-value performance needs
Cassandra API -> For wide-column distributed structures
► Azure Storage
Azure Blobs -> Object storage for massive unstructured data (videos, images, backups)
Azure Files -> Fully managed cloud file shares using SMB/NFS protocols
Azure Tables -> Cost-effective NoSQL key-value store for simple semi-structured data
► [Domain 4: Analytics Workloads on Azure]
► Modern Data Warehousing
Azure Synapse Analytics (Enterprise analytics combining SQL, Spark, and pipelines)
Massive Parallel Processing (MPP) (Distributes query processing across multiple compute nodes)
► Data Integration
Azure Data Factory (ADF) (Cloud orchestration and automation of data movement)
Integration Methods
ETL (Extract, Transform, Load -> Transform happens on an intermediate server)
ELT (Extract, Load, Transform -> Transform happens directly inside the target system)
► Reporting (Power BI)
Power BI Desktop -> Local Windows application used to model data and author reports
Power BI Service -> Cloud SaaS platform used to publish reports and share Dashboards