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

Questions 11–15

1. 11foundation · easy

   What is the primary purpose of using the Azure Cosmos DB Spark connector to read from the transactional store?

   • ATo enable change feed processing on the transactional store
   • BTo perform real-time, low-latency reads on the transactional store from a Spark job
   • CTo create a snapshot of the transactional store for backup purposes
   • DTo offload analytical queries from the transactional store to a separate storage
   Reveal Solution Discussion Select an answer first
2. 12application · medium

   A Fabric warehouse contains mirrored Cosmos DB data. An analyst needs to view the state of the data as it existed at a specific point in time last week to generate a historical report. Which Fabric feature should they use?

   • ATime travel in the Fabric warehouse using the TIMETRAVEL clause.
   • BA snapshot of the analytical store taken last week.
   • CA Spark job that replays the change feed to reconstruct the historical state.
   • DThe change feed from the Cosmos DB transactional store.
   Reveal Solution Discussion Select an answer first
4. 13application · medium

   A manufacturing company uses Microsoft Fabric to analyze production data. They have set up Azure Cosmos DB Mirroring to replicate their IoT sensor data into a Fabric Warehouse. The quality team needs to compare the current sensor readings with the readings from exactly one week ago to identify drift. What should they use in the Fabric Warehouse to access the historical state?

   • ACreate a snapshot of the mirrored table every day and store it in a separate Fabric Lakehouse.
   • BUse the Cosmos DB change feed to replay the changes from one week ago.
   • CUse the T-SQL 'FOR SYSTEM_TIME AS OF' clause to query the mirrored table as of the desired timestamp.
   • DQuery the Cosmos DB analytical store directly from Fabric to get the historical data.
   Reveal Solution Discussion Select an answer first
5. 14application · medium

   A finance team wants to run large, read-only analytical queries on Cosmos DB transaction data without impacting the performance of the operational workload. They plan to use Azure Synapse SQL serverless. What must be configured first?

   • ASet the container's indexing policy to include all fields for faster scans.
   • BCreate a dedicated SQL pool in Synapse and load the data using PolyBase.
   • CConfigure a private endpoint for the Cosmos DB account.
   • DEnable the analytical store on the Cosmos DB container.
   Reveal Solution Discussion Select an answer first
6. 15application · medium

   A data pipeline uses Spark to transform data and needs to write the output to a Cosmos DB container. The container has a partition key of /customerId. The Spark DataFrame has a column named customerId. Which Spark write configuration should they use?

   • ASpecify the container and partition key in the write options, and ensure the DataFrame has the customerId column.
   • BUse the change feed to write the data to the container.
   • CSpecify only the container name; the partition key is inferred from the DataFrame schema.
   • DWrite to the analytical store instead, which does not require a partition key.
   Reveal Solution Discussion Select an answer first