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

Questions 21–25

1. 21application · medium

   A company needs to track changes to product data in Cosmos DB to feed a downstream analytics system. They want to capture both inserts and updates with the ability to query the change history. They plan to use the analytical store. What should they enable?

   • AA trigger that copies changes to a separate container.
   • BAzure Synapse Link with automatic sync.
   • CThe change feed on the transactional store.
   • DChange Data Capture (CDC) on the analytical store.
   Reveal Solution Discussion Select an answer first
2. 22foundation · easy

   Which Microsoft Fabric component directly consumes the data replicated by Azure Cosmos DB Mirroring?

   • APower BI Desktop
   • BOneLake
   • CAzure Data Factory
   • DAzure Synapse Analytics workspace
   Reveal Solution Discussion Select an answer first
4. 23application · medium

   A retail company needs to run near-real-time analytics on Cosmos DB order data. They want to use Microsoft Fabric to create Power BI reports with minimal latency and no additional data movement. The team also needs to join the order data with other Fabric tables. Which approach should they use?

   • ACreate a Fabric shortcut to the Cosmos DB transactional store and query it directly from Power BI.
   • BConfigure Azure Cosmos DB Mirroring to continuously replicate the container into Fabric OneLake.
   • CUse the Cosmos DB Spark connector to write the entire container to a Fabric lakehouse in a nightly batch.
   • DEnable the analytical store on the container and use the Azure Synapse Link to query it from Spark.
   Reveal Solution Discussion Select an answer first
5. 24foundation · easy

   What is the purpose of enabling the analytical store on an Azure Cosmos DB container?

   • ATo create a backup of the container that can be restored to a point in time
   • BTo provide a columnar, read-optimized store for large-scale analytical queries without consuming request units
   • CTo enable change feed on the container for event-driven architectures
   • DTo create a second transactional store that can handle write operations with lower latency
   Reveal Solution Discussion Select an answer first
6. 25application · medium

   A data engineering team needs to read the latest transaction data from Cosmos DB in a Spark job to perform real-time fraud detection. They require the lowest possible latency and must see the most recent writes. Which Spark configuration should they use?

   • ARead from the analytical store using the Cosmos DB Spark connector.
   • BEnable Cosmos DB Mirroring and read from the mirrored data in OneLake.
   • CUse Azure Synapse SQL serverless to query the analytical store.
   • DRead from the transactional store using the Cosmos DB Spark connector.
   Reveal Solution Discussion Select an answer first