Microsoft Certified Data Analyst Associate Microsoft Azure Data Fundamentals 3

Question 1

Which type of Azure Cosmos DB consistency level provides the strongest consistency guarantee?

Accepted Answer

Strong

Answer

Strong consistency in Cosmos DB guarantees that reads always return the most recent committed write, at the cost of higher latency and limited to a single region.

Question 2

In Power BI, what is the difference between 'Import' and 'DirectQuery' storage modes?

Accepted Answer

Import stores data in Power BI; DirectQuery queries the source live at report time

Answer

In Import mode, data is copied and stored within Power BI's in-memory engine; in DirectQuery mode, every interaction queries the original data source in real time.

Question 3

What is the role of Azure Event Hubs in a real-time data architecture?

Accepted Answer

Ingesting high-throughput event streams from multiple producers

Answer

Azure Event Hubs is a big data streaming platform and event ingestion service capable of receiving millions of events per second from producers.

Question 4

Which Azure service enables you to run Apache Spark workloads for large-scale data engineering and machine learning?

Accepted Answer

Azure Databricks

Answer

Azure Databricks is an Apache Spark-based analytics platform optimized for Azure, supporting data engineering, data science, and machine learning at scale.

Question 5

In the context of data modeling, what does 'cardinality' refer to?

Accepted Answer

The uniqueness of data values in a column relative to the total rows

Answer

Cardinality describes how unique the values in a column are — high cardinality means many unique values, while low cardinality means few distinct values.

Microsoft Certified Data Analyst Associate Practice Test

Microsoft Certified Data Analyst Associate Practice Test

Microsoft Certified Data Analyst Associate Microsoft Azure Data Fundamentals 3