exam questions

Exam AZ-305 All Questions

View all questions & answers for the AZ-305 exam

Exam AZ-305 topic 2 question 29 discussion

Actual exam question from Microsoft's AZ-305
Question #: 29
Topic #: 2
[All AZ-305 Questions]

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 Hide Answer
Suggested Answer: C 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
NotMeAnyWay
Highly Voted 1 year, 4 months 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 20 times
...
Elecktrus
Highly Voted 1 year, 2 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
...
SeMo0o0o0o
Most Recent 3 weeks, 1 day ago
Selected Answer: C
C is correct
upvoted 1 times
...
c_h_r_i_s_
1 month, 3 weeks ago
C is correct https://learn.microsoft.com/en-us/azure/cosmos-db/synapse-link
upvoted 1 times
...
Len83
3 months, 4 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
5 months, 1 week 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
5 months, 1 week 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
...
...
kingfighers
10 months, 1 week ago
the same as topic 1st question 26.
upvoted 3 times
...
thamaster
1 year ago
Selected Answer: C
same question as before i forgot the number
upvoted 2 times
...
AdventureChick
1 year, 2 months ago
Selected Answer: C
I agree with others & their logic. Just adding my vote.
upvoted 4 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago