Chapter 4 of 4 · Microsoft DP-900
Describe an Analytics Workload on Azure
Ingestion, processing, data stores, Microsoft Fabric, real time analytics and Power BI.
- 4topics
- 23 minfast track
- 2diagrams and exhibits
- 25–30%of the exam
Topics in this chapter
Take them in order, or jump to the one you need.
- 1Data Ingestion and ProcessingDP-900 ingestion and processing: data pipelines, batch and streaming ingestion, ETL compared with ELT, data cleansing, and Spark…5 min
- 2Analytical Data Stores and ServicesDP-900 analytical stores: data warehouse, data lake and lakehouse compared, plus Microsoft Fabric, OneLake, Azure Databricks…Diagram6 min
- 3Batch and Real Time AnalyticsDP-900 real time analytics: batch against streaming data, Event Hubs, IoT Hub, Stream Analytics windows, Spark streaming and…Diagram6 min
- 4Power BI VisualizationDP-900 Power BI: Desktop, service and mobile apps, building a report, data models with relationships and measures, and choosing…6 min
About this chapter
What this chapter covers
This chapter covers analytics at scale: how data is collected and prepared, where analytical data is stored, how streaming data is handled as it arrives, and how Power BI turns the results into visuals.
It carries about a quarter of the exam and is the chapter with the most Microsoft service names, so a clear picture of what each one does is the main goal.
How the topics fit together
Every analytics solution follows the same four steps, and the pages follow them.
- Data ingestion and processing covers pipelines, ETL and ELT, and the engines that transform data.
- Analytical data stores and services covers data warehouses, data lakes, lakehouses, Microsoft Fabric, Azure Databricks and Azure Synapse Analytics.
- Batch and real time analytics covers streaming data, Azure Event Hubs, Azure Stream Analytics and Fabric Real Time Intelligence.
- Power BI visualization covers Power BI components, data models and choosing a suitable visual.
Keep the four steps in mind and place each service on them. Most questions simply ask where in the chain a given service works.
How to use these pages
Each topic page has the same shape, so you can skim for what you need.
- What it is: the idea in plain words.
- How it works: the mechanism, with examples and tables.
- What to remember for the exam: the facts to memorise and how questions are phrased.
- Common mistakes: the classic traps.
- Check yourself: three questions to test your understanding.
Ready for more practice?
The full Microsoft DP-900 question bank has 503 questions, with timed practice exams and an explanation for every answer.
This study guide is independent and is not affiliated with, endorsed by, or sponsored by Microsoft. Vendor names, certification names and exam codes are trademarks of their respective owners and are used for identification only.