Skip to content

Describe an analytics workload on Azure Questions

Practice questions for Describe an analytics workload on Azure topic in Microsoft Certified: Azure Data Fundamentals. 54 questions covering this domain.

54 questions13 easy25 medium16 hard
Q1
medium

Which statement correctly describes a Power BI dashboard compared to a report?

Q2
medium

In Azure Data Factory, what does a linked service define?

Q3
hard

An organization wants analytics teams across multiple Fabric workloads to reuse the same data without copying it between services. Which Fabric capabi...

Q4
medium

A team wants to use Apache Spark, Delta, SQL, Python, and lakehouse patterns for ETL and large-scale analytics. Which service is the best match?

Q5
easy

What is the main difference between batch data and streaming data?

Q6
hard

A report author needs to show a large amount of hierarchical data while also highlighting how each part contributes to the whole. Which Power BI visua...

Q7
medium

Why does Microsoft recommend star schema principles for many Power BI models?

Q8
hard

A data engineer wants to build transformations visually on Spark without managing Spark clusters directly. Which Azure capability is the best fit?

Q9
easy

Which Power BI component is best suited for data modeling and report creation?

Q10
hard

A company ingests telemetry through Azure Event Hubs and wants to analyze it in motion and send results to Power BI for real-time visualization. Which...

Q11
medium

In Azure Data Factory, what is a pipeline?

Q12
medium

A data team wants a managed service to create data-driven workflows that ingest data from many sources and orchestrate movement and transformation at ...

Q13
medium

What is OneLake in Microsoft Fabric?

Q14
easy

Which Power BI component is primarily intended for sharing, collaboration, and dashboards?

Q15
easy

Which Power BI visual is generally best for showing trends and patterns over time?

Q16
medium

A team uses Azure Synapse Analytics dedicated SQL pool. What does it primarily provide?

Q17
hard

A team uses Microsoft Fabric and wants to share a Lakehouse table with another workload (e.g., a Warehouse) without copying data. Which OneLake featur...

Q18
medium

Which Power BI feature lets a creator define calculations like "Total Sales = SUM(Sales[Amount])" in the semantic model?

Q19
hard

An organization wants to react to data events (e.g., when a metric crosses a threshold) in Microsoft Fabric and trigger actions like emails or Power A...

Q20
hard

Which Power BI item stores a tabular model definition with relationships, measures, and queries that reports connect to?

Sign in to see all 54 questions

Create a free account to browse all questions — completely free during our launch phase.