Azure Data Fundamentals · 30% of the exam

Describe an analytics workload on Azure: free practice questions

5 sample questions from our 15-question bank for this domain — answers and explanations included. These are the same scenario-based style as the real Azure exam.

1. A factory wants to detect equipment anomalies within seconds of sensor readings arriving, continuously, 24/7. Which processing approach and Azure service fit BEST?

  • A. Real-time (stream) processing with Azure Stream Analytics or Fabric Real-Time Intelligence✓ Correct
  • B. Nightly batch processing with a scheduled pipeline
  • C. Manual monthly export to Excel
  • D. Quarterly data warehouse reload
Explanation

Reacting within seconds to a continuous event stream requires real-time stream processing — Azure Stream Analytics (or Fabric's Real-Time Intelligence) is purpose-built for it. Nightly batch (B), monthly Excel (C), and quarterly reloads (D) all introduce latency measured in hours to months, far too slow for second-level anomaly detection.

2. An analyst wants to visualize monthly revenue over three years to reveal the trend and seasonality. Which chart type is the STANDARD choice?

  • A. A line chart with time on the horizontal axis✓ Correct
  • B. A pie chart
  • C. A single-number card
  • D. A treemap
Explanation

Line charts are the canonical way to show a measure changing over a continuous time axis, making trends and seasonal patterns visible. A pie chart (B) shows composition at one moment, not change over time. A card (C) shows one value with no trend. A treemap (D) shows hierarchical proportions, not time series.

3. 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).

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

  • A. Ingest raw data → store in a data lake → transform/process → model into a warehouse or lakehouse → visualize in Power BI✓ Correct
  • B. Visualize → ingest → delete → archive
  • C. Model → visualize → ingest → store
  • D. Encrypt → decrypt → email → print
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.

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

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

10 more questions in this domain

Practice the full bank with instant grading, flashcards, and a timed mock exam.

Start practicing free
Describe an analytics workload on Azure — Free Azure Data Fundamentals Practice Questions | DataCertPrep — Certification Prep