Microsoft Certified Data Analyst Associate Microsoft Azure Data Fundamentals 5

Question 1

Which Azure service would you use to apply real-time SQL-like transformations and aggregations on streaming data from Event Hubs?

Accepted Answer

Azure Stream Analytics

Answer

Azure Stream Analytics provides a real-time analytics service that uses a SQL-like query language to process and transform streaming data from sources like Event Hubs and IoT Hub.

Question 2

In Microsoft Power BI, what is a 'measure' in DAX?

Accepted Answer

A calculated aggregation formula evaluated at query time based on filter context

Answer

A DAX measure is a formula that performs an aggregation (like SUM or AVERAGE) and is calculated dynamically based on the current filter context in a report.

Question 3

What is the key difference between 'structured' and 'unstructured' data?

Accepted Answer

Structured data has a predefined schema (like rows and columns); unstructured data has no fixed format

Answer

Structured data conforms to a rigid schema (e.g., relational tables), while unstructured data like images, videos, or emails has no predefined format or model.

Question 4

Which Azure Cosmos DB API would you choose if you want to use existing MongoDB drivers and queries without modifying your application code?

Accepted Answer

API for MongoDB

Answer

The Azure Cosmos DB API for MongoDB provides wire protocol compatibility with MongoDB, allowing existing MongoDB applications to connect without code changes.

Question 5

What is the purpose of 'data masking' in Azure SQL Database?

Accepted Answer

Hiding sensitive data from non-privileged users by showing obfuscated values

Answer

Dynamic Data Masking in Azure SQL Database limits sensitive data exposure by replacing it with masked values (e.g., showing 'XXXX' instead of a credit card number) for non-privileged users.

Microsoft Certified Data Analyst Associate Practice Test

Microsoft Certified Data Analyst Associate Practice Test

Microsoft Certified Data Analyst Associate Microsoft Azure Data Fundamentals 5