DP-900: Analytics Workloads on Azure

Analytics Workloads on Azure is one of the skill areas tested on the Azure Data Fundamentals (DP-900) exam. Below are free DP-900 practice questions with worked answers and a concept diagram — each with a plain-language explanation. Practice the first 10 questions of DP-900 free, no signup.

The concept, in one picture

Concept flowData fundamentals at a glance
Data fundamentals at a glanceRelationaltables, rows, schema-on-writeSQL · Azure SQL, PostgreSQLNon-relationalkey-value, document, graphNoSQL · Cosmos DB, tablesDescriptivewhat happened?Diagnosticwhy did it happen?Predictivewhat will happen?Prescriptivewhat should we do?Analytics grows in value from describing the past to advising action

Try a real DP-900 question

Sample DP-900 question

Choose the option that correctly completes the sentence. In Azure Synapse Analytics, the massively parallel processing (MPP) engine [answer choice].

  • spreads processing work across the compute nodes.
  • spreads processing work across the control nodes.
  • routes client connections across the compute nodes.
  • routes client connections across the control nodes.
Explanation

The MPP engine spreads query processing across the compute nodes so that the workload runs in parallel.

Practice DP-900 free

The first 10 questions of every exam are free. No signup, no email wall.

Start practicing →

Get a free DP-900 study plan by email

A short plan to work through DP-900 by skill area, plus a note when we add new questions. Optional — the practice above stays free. No spam, unsubscribe anytime.

More DP-900 skill areas