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

Questions 1–5

1. 1foundation · easy

   A data engineer is evaluating Change Data Feed (CDF) for a streaming table that ingests high-frequency sensor data. Which limitation of CDF is most relevant to this scenario?

   • ACDF does not support Delta tables that are used as streaming sources.
   • BCDF only works with batch queries, not with streaming queries.
   • CCDF adds latency because changes are only available after the table is compacted.
   • DCDF introduces additional storage and processing overhead, which can increase pipeline complexity.
   Reveal Solution Discussion Select an answer first
2. 2foundation · easy

   Which table property must be set to `true` to enable Change Data Feed (CDF) on a Delta table?

   • Adelta.changeDataTracking
   • Bdelta.cdf.enabled
   • Cdelta.enableChangeDataFeed
   • Ddelta.trackChanges
   Reveal Solution Discussion Select an answer first
4. 3application · medium

   A data team is using a streaming table to ingest data from a Delta table that is updated with new records and occasional corrections. They notice that the streaming table does not reflect the corrections. What is the most likely reason?

   • AStreaming tables do not support processing updates and deletes from the source.
   • BThe streaming table requires a trigger interval of less than 1 second to process updates.
   • CThe source table needs to be optimized before the streaming table can see updates.
   • DChange Data Feed is not enabled on the streaming table.
   Reveal Solution Discussion Select an answer first
5. 4application · medium

   A data engineer needs to enable Change Data Feed on a Delta table that is used by a streaming query. The table is created by a batch job that runs daily. Which approach should be used to enable CDF?

   • AUse the OPTIMIZE command with the 'changeDataFeed' option.
   • BSet the table property 'delta.enableChangeDataFeed' to true using ALTER TABLE.
   • CRecreate the table with the CDF property and copy all data.
   • DSet the Spark configuration 'spark.databricks.delta.changeDataFeed.enabled' to true.
   Reveal Solution Discussion Select an answer first
6. 5application · medium

   A company has a Delta table that is updated every 10 minutes by a batch job. They have a downstream dashboard that needs to reflect these updates as quickly as possible. Currently, they run a batch job that reads the entire table every 10 minutes. What change would reduce the latency of the dashboard updates?

   • ACreate a materialized view that refreshes every 10 minutes.
   • BUse the OPTIMIZE command on the source table before each batch job.
   • CIncrease the frequency of the batch job to every 5 minutes.
   • DEnable Change Data Feed on the source table and use a streaming query to read only the changes.
   Reveal Solution Discussion Select an answer first