Apply Change Data Feed (CDF) to Address Specific Limitations of Streaming Tables and Enhance Latency. DATA-ENGINEER-PROFESSIONAL Practice Questions (Page 3)

Questions 11–15

1. 11foundation · easy

   A data pipeline currently performs a full refresh of a Delta table every hour. How can enabling Change Data Feed (CDF) help reduce the latency of downstream analytics?

   • ABy allowing downstream consumers to read only the rows that changed since the last refresh.
   • BBy compressing the table to reduce the amount of data read during the refresh.
   • CBy automatically scheduling the refresh to run more frequently.
   • DBy creating a materialized view that is updated in real time.
   Reveal Solution Discussion Select an answer first
2. 12application · medium

   A retail company uses a Delta table as the source for a streaming table that powers a real-time dashboard. The pipeline currently uses a streaming table with a trigger interval of 5 minutes. The data team notices that the dashboard lags behind the source updates by up to 15 minutes during peak hours. They need to reduce this latency without rewriting the entire pipeline. What should they do?

   • AReplace the streaming table with a materialized view that refreshes every hour.
   • BDisable Change Data Feed on the source table to reduce overhead and speed up the streaming table.
   • CEnable Change Data Feed on the source table and configure the streaming table to read changes using the change data feed.
   • DIncrease the trigger interval to 10 minutes to allow the streaming table to process larger micro-batches more efficiently.
   Reveal Solution Discussion Select an answer first
4. 13foundation · easy

   In a streaming query reading from a Delta table with Change Data Feed (CDF) enabled, which option is used to specify the starting version for reading changes?

   • AstartingTimestamp
   • BreadChangeData
   • CstartingVersion
   • DchangeDataVersion
   Reveal Solution Discussion Select an answer first
5. 14application · medium

   A streaming query reads from a Delta table with Change Data Feed enabled. The query needs to process only the changes that occurred after a specific point in time. Which option should be used in the streaming read?

   • Aoption('maxFilesPerTrigger', '10')
   • Boption('ignoreChanges', 'true')
   • Coption('startingVersion', 'latest')
   • Doption('startingTimestamp', '2024-01-01')
   Reveal Solution Discussion Select an answer first
6. 15foundation · easy

   Which of the following is a specific limitation of using Change Data Feed (CDF) with streaming tables?

   • ACDF cannot be enabled on tables that are used as streaming sources.
   • BCDF adds latency because changes are only visible after the next OPTIMIZE operation.
   • CCDF increases storage and processing overhead, which can complicate pipeline maintenance.
   • DCDF requires the use of a separate cluster for change data processing.
   Reveal Solution Discussion Select an answer first