Exam AZ-305 topic 2 question 29 discussion

Actual exam question from Microsoft's AZ-305

Question #: 29
Topic #: 2

You have the resources shown in the following table.

CDB1 hosts a container that stores continuously updated operational data.

You are designing a solution that will use AS1 to analyze the operational data daily.

You need to recommend a solution to analyze the data without affecting the performance of the operational data store.

What should you include in the recommendation?

A. Azure Data Factory with Azure Cosmos DB and Azure Synapse Analytics connectors
B. Azure Synapse Analytics with PolyBase data loading
C. Azure Synapse Link for Azure Cosmos DB
D. Azure Cosmos DB change feed

Show Suggested Answer

Suggested Answer: C 🗳️

by NotMeAnyWay at July 13, 2023, 5:35 p.m.

Comments

Submit Cancel

NotMeAnyWay

Highly Voted 2 years ago

Selected Answer: C

The correct answer is C. Azure Synapse Link for Azure Cosmos DB. Azure Synapse Link for Azure Cosmos DB creates a tight integration between Azure Cosmos DB and Azure Synapse Analytics, allowing you to run near real-time analytics over operational data in Azure Cosmos DB. It creates a "no-ETL" (Extract, Transform, Load) environment that allows you to analyze data directly without affecting the performance of the transactional workload, which is exactly what is required in this scenario. A. Azure Data Factory with Azure Cosmos DB and Azure Synapse Analytics connectors would require ETL operations which might impact the performance of the operational data store. B. Azure Synapse Analytics with PolyBase data loading is more appropriate for loading data from external data sources such as Azure Blob Storage or Azure Data Lake Storage. D. Azure Cosmos DB change feed doesn't directly address the need for analytics without affecting the performance of the operational data store.

upvoted 23 times

...

Elecktrus

Highly Voted 1 year, 10 months ago

Selected Answer: C

Azure Synapse Link for Azure Cosmos DB. Azure Synapse Link for Azure Cosmos DB is a cloud-native hybrid transactional and analytical processing (HTAP) capability that enables near real time analytics over operational data in Azure Cosmos DB. Azure Synapse Link creates a tight seamless integration between Azure Cosmos DB and Azure Synapse Analytics. It enables customers to run near real-time analytics over their operational data with full performance isolation from their transactional workloads and without an ETL pipeline https://learn.microsoft.com/en-us/azure/cosmos-db/synapse-link

upvoted 6 times

...

c_h_r_i_s_

Most Recent 9 months, 2 weeks ago

C is correct https://learn.microsoft.com/en-us/azure/cosmos-db/synapse-link

upvoted 1 times

...

Len83

11 months, 3 weeks ago

This question appeared in the exam, August 2024, I gave this same answer as listed here. I scored 870

upvoted 1 times

...

23169fd

1 year, 1 month ago

Selected Answer: C

Azure Synapse Link enables real-time analytics on operational data stored in Azure Cosmos DB without impacting the performance of the operational database. It allows seamless integration between Azure Cosmos DB and Azure Synapse Analytics, providing a hybrid transactional and analytical processing (HTAP) capability.

upvoted 1 times

23169fd

1 year, 1 month ago

A. Azure Data Factory with Azure Cosmos DB and Azure Synapse Analytics connectors Reason: While Azure Data Factory can move data from Cosmos DB to Synapse Analytics, it typically involves batch processing, which may not be real-time and could affect operational data performance during the ETL process. B. Azure Synapse Analytics with PolyBase data loading Reason: PolyBase is excellent for loading large volumes of data but is designed for structured data and batch loading, not continuous real-time analysis, and may impact the performance during large data transfers. D. Azure Cosmos DB change feed Reason: The change feed provides a continuous log of changes but requires additional processing to integrate with Synapse Analytics, which can complicate the solution and impact performance.

upvoted 1 times

...