Microsoft Certified Data Analyst Associate Microsoft Azure Data Fundamentals 2

Question 1

Which Azure service is best suited for storing and querying large volumes of semi-structured JSON documents?

Accepted Answer

Azure Cosmos DB

Answer

Azure Cosmos DB is a globally distributed NoSQL database that natively supports JSON documents with flexible schema and low-latency queries.

Question 2

In Azure Synapse Analytics, what is a 'dedicated SQL pool' primarily used for?

Accepted Answer

Enterprise data warehousing with massively parallel processing

Answer

A dedicated SQL pool in Azure Synapse provides enterprise data warehousing capabilities using a massively parallel processing (MPP) architecture.

Question 3

What does the term 'data lakehouse' describe in modern analytics architectures?

Accepted Answer

A combination of data lake flexibility with data warehouse structure and ACID transactions

Answer

A data lakehouse combines the cost-effective storage of a data lake with the structured querying and ACID transaction support of a data warehouse.

Question 4

Which Azure service would you use to orchestrate and schedule data pipelines that move and transform data across multiple sources?

Accepted Answer

Azure Data Factory

Answer

Azure Data Factory is a cloud-based ETL and data integration service used to create and schedule data-driven workflows (pipelines).

Question 5

In Azure, what is the purpose of a 'linked service' in Azure Data Factory?

Accepted Answer

A definition that contains the connection information needed to connect to external resources

Answer

A linked service in Azure Data Factory defines the connection information (like connection strings or credentials) required to connect to an external data source or compute resource.

Microsoft Certified Data Analyst Associate Practice Test

Microsoft Certified Data Analyst Associate Practice Test

Microsoft Certified Data Analyst Associate Microsoft Azure Data Fundamentals 2