Analytics Workloads on Azure (25–30%)DP-900 Study Guide

Azure Synapse Analytics

Objective 3.1 · Analytics

Azure Data Factory

Objective 3.2 · Analytics

Azure Databricks

Objective 3.3 · Analytics

Power BI Fundamentals

Objective 3.4 · Analytics

Real-Time Analytics on Azure

Objective 3.5 · Analytics

Azure HDInsight

Objective 3.1 · Analytics

Azure Data Lake Storage Gen2

Objective 3.1 · Analytics

Azure Stream Analytics

Objective 3.5 · Analytics

Microsoft Fabric Overview

Objective 3.1 · Analytics

Power BI: Reports vs Dashboards vs Datasets

Objective 3.4 · Analytics

Power BI Gateway for On-Premises Data

Objective 3.4 · Analytics

Data Warehouse Concepts: Facts and Dimensions

Objective 3.1 · Analytics

Synapse Dedicated vs Serverless SQL Pools

Objective 3.1 · Analytics

Azure Synapse Spark Pools

Objective 3.1 · Analytics

Azure Synapse Link for Cosmos DB

Objective 3.1 · Analytics

Delta Lake Format in Azure

Objective 3.1 · Analytics

Bronze, Silver, Gold Medallion Architecture

Objective 3.1 · Analytics

Azure Data Factory Activities and Pipelines

Objective 3.2 · Analytics

ADF Triggers: Scheduled, Tumbling, Event-Based

Objective 3.2 · Analytics

Databricks Notebooks and Clusters

Objective 3.3 · Analytics

Databricks Delta Live Tables

Objective 3.3 · Analytics

Power BI Datasets and Dataflows

Objective 3.4 · Analytics

DAX Formulas and Measures in Power BI

Objective 3.4 · Analytics

Power BI Service vs Power BI Desktop

Objective 3.4 · Analytics

Row-Level Security in Power BI

Objective 3.4 · Analytics

Azure Event Hubs for Streaming Data

Objective 3.5 · Analytics

Stream Analytics SQL Queries and Windows

Objective 3.5 · Analytics

Lambda and Kappa Data Architectures

Objective 3.5 · Analytics

Data Lakehouse vs Data Warehouse vs Data Lake

Objective 3.1 · Analytics

Azure Data Lake Storage Gen2 Hierarchical Namespace

Objective 3.1 · Analytics

HDInsight Hadoop and MapReduce

Objective 3.1 · Analytics

Microsoft Fabric: OneLake and Workspaces

Objective 3.1 · Analytics

Azure Data Share for Sharing Datasets

Objective 3.2 · Analytics

Azure AI Search for Unstructured Data

Objective 3.5 · Analytics

Search Indexes and Full-Text Search Concepts

Objective 3.5 · Analytics

BigQuery vs Azure Synapse Analytics

Objective 3.1 · Analytics

Power BI Premium vs Pro Licensing

Objective 3.4 · Analytics

Azure Analysis Services

Objective 3.4 · Analytics

PolyBase and External Tables in Synapse

Objective 3.1 · Analytics

Azure IoT Hub and Telemetry Ingestion

Objective 3.5 · Analytics

Apache Spark Core Concepts for DP-900

Objective 3.3 · Analytics

Data Warehouse Distribution: Hash, Round-Robin, Replicated

Objective 3.1 · Analytics