You have an Azure Cosmos DB Core (SQL) API account that is used by 10 web apps.
You need to analyze the data stored in the account by using Apache Spark to create machine learning models. The solution must NOT affect the performance of the web apps.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
To analyze the data stored in the Azure Cosmos DB account using Apache Spark without affecting the performance of the web apps, you should follow these steps: First, ensure to enable Azure Synapse Link for the Cosmos DB account and also enable the Analytical store on the relevant container. This setup provides a seamless and optimized connection for data analytics. Second, in an Apache Spark pool in Azure Synapse, create a table that uses 'cosmos.olap' as the data source. This approach allows you to read from the analytical store, ensuring that the analysis does not impact the transactional workloads or the performance of the web apps using the Cosmos DB account. These actions together facilitate efficient data analysis while preserving the performance of the web apps.
Selected Answer: AD
Might be correct https://learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/how-to-query-analytical-store-spark
Why not E ?
cosmos.oltp connects to the transactional store, cosmos.olap connects to the analytical store.
Answer A and D
A. In an Apache Spark pool in Azure Synapse, create a table that uses cosmos.olap as the data source: By creating a table in an Apache Spark pool in Azure Synapse that uses the cosmos.olap data source, you can efficiently access and analyze the data stored in your Azure Cosmos DB account. This approach leverages the optimized capabilities of Apache Spark and allows you to perform machine learning tasks on the data. D. Enable Azure Synapse Link for the account and Analytical store on the container: Enabling Azure Synapse Link for your Azure Cosmos DB account and enabling the Analytical store on the container provides seamless integration between Azure Cosmos DB and Azure Synapse Analytics. It allows you to load and analyze data from Azure Cosmos DB using Apache Spark in Azure Synapse Analytics without impacting the performance of your web apps.
answer provided is correct