Azure Data Fundamentals (DP-900) · 30% practice allocation

Azure DP-900: Describe an analytics workload on Azure Practice Questions

5 free sample questions from the Describe an analytics workload on Azure domain, with answers and explanations. The full DP-900 bank has 62 questions across 4 domains. Questions are scenario-based and written from the official Azure exam guide.

A dashboard designer must show a single key performance indicator — current quarter revenue against a target — as prominently and simply as possible. Which visual is MOST appropriate?

A. A card or KPI/gauge visual✓ Correct
B. A matrix with thousands of rows
C. A scatter plot of every transaction
D. A map

Explanation

A card (single big number) or KPI/gauge visual communicates one headline metric against a target with maximum clarity — ideal for a hero KPI. A dense matrix (B) or per-transaction scatter (C) buries the number in detail. A map (D) is for geographic data, irrelevant to a single revenue-vs-target figure.

A retail analyst wants to build interactive reports and dashboards that business users can explore, with data refreshed from multiple sources. Which Microsoft tool is designed for this?

A. Azure Key Vault
B. Azure Blob Storage
C. Power BI✓ Correct
D. SQL Server Management Studio

Explanation

Power BI is Microsoft's business-intelligence and data-visualization platform: connect to sources, model data, and build interactive reports and dashboards for business consumption. Blob Storage (B) stores files. SQL Server Management Studio (D) is a database administration tool. Azure Key Vault (A) secures secrets and keys — none of these are visualization tools.

A company reports that its overnight analytics load reprocesses the entire day's transactions at 2 AM and results are ready by 6 AM for morning dashboards. Which characteristics identify this as batch processing? (Select 2)

A. Results must be available within milliseconds of each event
B. Data is processed in a bounded set collected over a defined period✓ Correct
C. The pipeline maintains an always-open connection to react to individual events
D. Each transaction is processed the instant it occurs
E. Processing runs on a schedule rather than continuously✓ Correct

Explanation

Batch processing works on bounded datasets (the whole day's transactions) (B) on a schedule (the 2 AM run) (E). Options A, C, and D describe stream processing — per-event handling, millisecond latency, and continuous event-driven pipelines — the opposite of this nightly batch pattern.

Which sequence correctly describes a typical modern analytics pipeline in Azure/Fabric?

A. Visualize → ingest → delete → archive
B. Ingest raw data → store in a data lake → transform/process → model into a warehouse or lakehouse → visualize in Power BI✓ Correct
C. Encrypt → decrypt → email → print
D. Model → visualize → ingest → store

Explanation

Data flows from ingestion of raw source data, into lake storage, through transformation, into an analytical model (warehouse/lakehouse), and finally to visualization in a BI tool. The other options place consumption before the data exists, scramble the order, or describe unrelated operations entirely.

What is a data lakehouse, as introduced in Microsoft Fabric?

A. An architecture combining the low-cost, flexible storage of a data lake with the structured querying and management features of a data warehouse✓ Correct
B. A relational-only OLTP database
C. A physical building where servers are kept
D. A Power BI subscription tier

Explanation

A lakehouse blends the two worlds: cheap, open, flexible lake storage for any data, plus warehouse-style schema, tables, and SQL querying over it — so you get one platform for both raw and curated analytics. It is not an OLTP database (B), a datacenter (C), or a licensing tier (D).

Test yourself across every DP-900 domain

The free DP-900 practice test mixes about 20 questions weighted like the exam. The full 62-question bank adds instant grading, flashcards and a timed mock exam.

Take the free DP-900 practice test Practice the full bank

Study this domain

Describe an analytics workload on Azure study guide (DP-900) →

Other DP-900 domains

← All Azure Data Fundamentals study resources