Enable Azure Cosmos DB Analytical Workloads DP-420 Practice Questions (Page 4)

Questions 16–20

1. 16foundation · easy

   What is a key difference between writing to the transactional store and writing to the analytical store from Spark?

   • ABoth stores are read-only, and writes are done through the change feed
   • BThe transactional store supports writes, while the analytical store is read-only
   • CBoth stores support writes, but with different consistency levels
   • DThe analytical store supports writes, while the transactional store is read-only
   Reveal Solution Discussion Select an answer first
2. 17application · medium

   A team wants to run analytical queries on Cosmos DB data using Azure Synapse SQL serverless. They have already enabled the analytical store on the container. What else is required to establish the connection and execute queries?

   • ACreate a linked service in Synapse and use the Cosmos DB SQL API endpoint.
   • BConfigure a private endpoint for the Cosmos DB account.
   • CEnable the change feed on the container.
   • DCreate a dedicated SQL pool and load the data using PolyBase.
   Reveal Solution Discussion Select an answer first
4. 18foundation · easy

   Which endpoint is used to connect to the Azure Cosmos DB analytical store from Azure Synapse SQL serverless?

   • AThe analytical store endpoint, which is distinct from the transactional store endpoint
   • BThe Azure Cosmos DB account endpoint with a special query parameter
   • CThe Azure Cosmos DB account endpoint using the SQL API
   • DThe same endpoint as the transactional store, but with a different authentication method
   Reveal Solution Discussion Select an answer first
5. 19foundation · easy

   What is the primary purpose of enabling Azure Cosmos DB Mirroring for a container?

   • ATo create a writable copy of the container that can be updated from Microsoft Fabric
   • BTo enable the analytical store on the container for direct querying from Synapse
   • CTo create a backup of the container that can be restored to a point in time
   • DTo create a read-only replica of the container in Microsoft Fabric for analytical workloads
   Reveal Solution Discussion Select an answer first
6. 20application · medium

   A team is using Spark to process streaming data and needs to write the results back to a Cosmos DB container for use by an operational application. They want to ensure the writes are committed with the same consistency as the application's own writes. Which approach should they use?

   • AUse the Cosmos DB Spark connector to write to the transactional store.
   • BWrite to the analytical store using the Spark connector.
   • CWrite to a Fabric lakehouse and use a shortcut to expose the data to Cosmos DB.
   • DUse Azure Data Factory to copy the Spark output to the Cosmos DB container.
   Reveal Solution Discussion Select an answer first