Exam DP-420 topic 4 question 15 discussion

Actual exam question from Microsoft's DP-420

Question #: 15
Topic #: 4

You have operational data in an Azure Cosmos DB for NoSQL database.

Database users report that the performance of the database degrades significantly when a business analytics team runs large Apache Spark-based queries against the database.

You need to reduce the impact that running the Spark-based queries has on the database users.

What should you implement?

A. Azure Synapse Link
B. a default consistency level of Consistent Prefix
C. a default consistency level of Strong
D. the Spark connector

Show Suggested Answer

Suggested Answer: A 🗳️

by bcd_6 at Nov. 16, 2023, 11:56 p.m.

Comments

Submit Cancel

[Removed]

9 months ago

Selected Answer: A

vote for A Azure Synapse Link allows you to perform near-real-time analytics on operational data stored in Azure Cosmos DB without impacting the performance of transactional workloads. It achieves this by maintaining separate analytical store for Cosmos DB data, which can be queried using Azure Synapse Analytics (formerly Azure SQL Data Warehouse) or other analytical tools.

upvoted 3 times

...

[Removed]

9 months, 1 week ago

Selected Answer: A

A Azure Synapse Link

upvoted 3 times

...

edavison

1 year ago

A Azure Synapse Link for Cosmos DB creates a tight integration between Azure Cosmos DB and Azure Synapse Analytics. It allows you to run large-scale analytics on operational data without affecting the performance of the operational workloads in Cosmos DB. Synapse Link uses a columnar store to replicate data from Cosmos DB. This replication is asynchronous and does not impact the transactional store's performance, making it ideal for scenarios where operational workloads and analytical workloads need to coexist without impacting each other.

upvoted 3 times

...

bcd_6

1 year ago

Is A the right answer?

upvoted 2 times

...