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

Questions 6–10

1. 6application · medium

   A gaming company uses Azure Cosmos DB for their player profile service. They want to enable analytics on player behavior data in Microsoft Fabric. The analytics team needs to run SQL queries against the data in Fabric, and they want the data to be continuously synchronized with minimal latency. The company already has a Fabric capacity. What should they configure?

   • AUse the change feed to write data to an Event Hub, then use a Fabric event stream to ingest it into a Lakehouse.
   • BEnable the analytical store on the container and use the Spark connector to load data into a Fabric Lakehouse on a schedule.
   • CConfigure Azure Cosmos DB Mirroring to replicate the container to a Fabric mirrored database.
   • DExport the Cosmos DB data to Azure Blob Storage and then use Fabric data pipeline to load it into a Warehouse.
   Reveal Solution Discussion Select an answer first
2. 7foundation · easy

   Which Azure service can be used to query the Azure Cosmos DB analytical store using Spark?

   • AAzure Databricks
   • BAzure Data Factory
   • CAzure SQL Database
   • DAzure Synapse Analytics (Spark pool)
   Reveal Solution Discussion Select an answer first
4. 8application · medium

   A marketing analytics team wants to run queries on customer interaction data stored in Azure Cosmos DB. They plan to use Azure Synapse SQL serverless for querying. The team wants to ensure that the analytical queries do not consume request units (RUs) from the transactional store. What should they do?

   • AEnable the analytical store on the container and configure Synapse SQL serverless to query the analytical store endpoint.
   • BConfigure a dedicated throughput container for analytical queries and use that for Synapse.
   • CUse the change feed to copy data to a separate container and query that container from Synapse.
   • DCreate a read-only replica of the Cosmos DB account and point Synapse SQL serverless to that replica.
   Reveal Solution Discussion Select an answer first
5. 9foundation · easy

   What is the purpose of Change Data Capture (CDC) in the Azure Cosmos DB analytical store?

   • ATo create a backup of the container
   • BTo enable real-time analytics on the transactional store
   • CTo track changes made to items in the container over time
   • DTo replicate data to a secondary region for disaster recovery
   Reveal Solution Discussion Select an answer first
6. 10application · medium

   A retail company runs a mission-critical order-processing application on Azure Cosmos DB. The data team needs to run complex analytical queries that join order data with product catalog data, and they expect the analytical workload to run continuously throughout the day. They want to avoid impacting the operational workload's performance and want the analytical queries to see near-real-time data. The team is already using Microsoft Fabric for other analytics workloads. What should the data team configure?

   • AEnable the analytical store and connect to it from Azure Synapse SQL serverless to run the joins, then load results into Fabric.
   • BUse the Azure Cosmos DB change feed to write data into a Fabric Lakehouse, then use Spark SQL to query the Lakehouse tables.
   • CEnable Azure Cosmos DB Mirroring for the database to create a mirrored database in Microsoft Fabric, then query the mirrored data using Fabric SQL analytics endpoints.
   • DEnable the analytical store on the containers and use the Azure Cosmos DB Spark connector to read from the analytical store in a Fabric notebook.
   Reveal Solution Discussion Select an answer first