support@Free-Braindumps.com
Register Login
Cisco
CompTIA
ISC
EC-Council
EXIN
Fortinet
ITIL
Juniper
Microsoft
VMware
Avaya
SAP
Google
NVIDIA
Salesforce
Amazon
Palo Alto Networks
ISC2
CrowdStrike
Anthropic
All Vendors
  1. Home
  2. Exams
  3. Databricks
  4. Certified Data Engineer Associate

Free Certified Data Engineer Associate Exam Braindumps
Certified Data Engineer Associate Questions 105–112 (page: 15)

Updated On: 7-Apr-2026
Page 15 of 30
PDF with 280 Questions

Which of the following describes when to use the CREATE STREAMING LIVE TABLE (formerly CREATE INCREMENTAL LIVE TABLE) syntax over the CREATE LIVE TABLE syntax when creating Delta Live Tables (DLT) tables using SQL?

  1. CREATE STREAMING LIVE TABLE should be used when the subsequent step in the DLT pipeline is static.
  2. CREATE STREAMING LIVE TABLE should be used when data needs to be processed incrementally.
  3. CREATE STREAMING LIVE TABLE is redundant for DLT and it does not need to be used.
  4. CREATE STREAMING LIVE TABLE should be used when data needs to be processed through complicated aggregations.
  5. CREATE STREAMING LIVE TABLE should be used when the previous step in the DLT pipeline is static.

Answer(s): B



Which of the following describes the type of workloads that are always compatible with Auto Loader?

  1. Streaming workloads
  2. Machine learning workloads
  3. Serverless workloads
  4. Batch workloads
  5. Dashboard workloads

Answer(s): A



A data engineer is using the following code block as part of a batch ingestion pipeline to read from a composable table:



Which of the following changes needs to be made so this code block will work when the transactions table is a stream source?

  1. Replace predict with a stream-friendly prediction function
  2. Replace schema(schema) with option ("maxFilesPerTrigger", 1)
  3. Replace "transactions" with the path to the location of the Delta table
  4. Replace format("delta") with format("stream")
  5. Replace spark.read with spark.readStream

Answer(s): E



Which of the following queries is performing a streaming hop from raw data to a Bronze table?






Answer(s): E



A data engineer runs a statement every day to copy the previous day's sales into the table transactions. Each day's sales are in their own file in the location "/transactions/raw".

Today, the data engineer runs the following command to complete this task:



After running the command today, the data engineer notices that the number of records in table transactions has not changed.

What explains why the statement might not have copied any new records into the table?

  1. The format of the files to be copied were not included with the FORMAT_OPTIONS keyword.
  2. The COPY INTO statement requires the table to be refreshed to view the copied rows.
  3. The previous day's file has already been copied into the table.
  4. The PARQUET file format does not support COPY INTO.

Answer(s): C



Which command can be used to write data into a Delta table while avoiding the writing of duplicate records?

  1. DROP
  2. INSERT
  3. MERGE
  4. APPEND

Answer(s): C



A data engineer has configured a Structured Streaming job to read from a table, manipulate the data, and then perform a streaming write into a new table.

The code block used by the data engineer is below:



Which line of code should the data engineer use to fill in the blank if the data engineer only wants the query to execute a micro-batch to process data every 5 seconds?

  1. trigger("5 seconds")
  2. trigger(continuous="5 seconds")
  3. trigger(once="5 seconds")
  4. trigger(processingTime="5 seconds")

Answer(s): D



What is used by Spark to record the offset range of the data being processed in each trigger in order for Structured Streaming to reliably track the exact progress of the processing so that it can handle any kind of failure by restarting and/or reprocessing?

  1. Checkpointing and Write-ahead Logs
  2. Replayable Sources and Idempotent Sinks
  3. Write-ahead Logs and Idempotent Sinks
  4. Checkpointing and Idempotent Sinks

Answer(s): A



  PDF
Viewing page 15 of 30
Viewing questions 71 - 75 out of 280 questions


Post your Comments and Discuss Databricks Certified Data Engineer Associate exam prep with other Community members:

AI Tutor AI Tutor 👋 I’m here to help!