Microsoft Certified Data Analyst Associate Microsoft Azure Data Fundamentals 4

Question 1

In a star schema, what distinguishes a 'fact table' from a 'dimension table'?

Accepted Answer

Fact tables store numeric measurements and foreign keys; dimension tables store descriptive attributes

Answer

Fact tables contain quantitative measures (like sales amount) and foreign keys to dimension tables, while dimension tables hold descriptive attributes (like product name or customer city).

Question 2

What does OLAP stand for, and what is its primary use case?

Accepted Answer

Online Analytical Processing — analyzing large datasets for business intelligence and reporting

Answer

OLAP (Online Analytical Processing) is designed for complex analytical queries and multidimensional analysis, enabling fast aggregations and slice-and-dice operations on large historical datasets.

Question 3

Which Azure service provides a fully managed, scalable Apache Kafka service?

Accepted Answer

Azure Event Hubs with Kafka protocol support

Answer

Azure Event Hubs supports the Apache Kafka protocol, allowing existing Kafka applications to connect without changing client code.

Question 4

What is 'data lineage' in the context of data governance?

Accepted Answer

The historical record of data's origins and how it has moved and transformed over time

Answer

Data lineage tracks the journey of data from its origin through all transformations and movements, helping organizations understand data quality and impact analysis.

Question 5

In Azure SQL Database, what is the purpose of 'elastic pools'?

Accepted Answer

Sharing a fixed set of compute resources across multiple databases to optimize cost

Answer

Elastic pools allow multiple Azure SQL databases to share a pool of eDTUs or vCores, which is cost-effective when databases have unpredictable or varying usage patterns.

Microsoft Certified Data Analyst Associate Practice Test

Microsoft Certified Data Analyst Associate Practice Test

Microsoft Certified Data Analyst Associate Microsoft Azure Data Fundamentals 4