Databricks Data Engineer Associate exam dumps

Databricks Data Engineer Associate practice question 417 of 532

Databricks Certified Data Engineer Associate. Associate level, Databricks. Free question with the correct answer and a full explanation.

Databricks Data Engineer Associate Question 417

Single answer

You are managing a Delta Live Tables (DLT) pipeline, and one of the tables is failing to load with the error: 'LIVE keyword is required in CREATE statement.' You inspect the pipeline and notice the following in the notebook for the table creation: CREATE TABLE sales_data AS SELECT * FROM STREAM(input_data). What needs to be corrected to resolve this error?

  1. A

    Replace CREATE TABLE with CREATE LIVE TABLE.

  2. B

    Remove the STREAM keyword from the FROM clause.

  3. C

    Use LIVE.input_data in the FROM clause instead of input_data.

  4. D

    Change the statement to CREATE STREAM TABLE sales_data.

Show answer and explanation

Correct answer: A

Explanation

In Delta Live Tables, all table creation statements must use the CREATE LIVE TABLE syntax to define the table as part of the DLT pipeline. The error message clearly states that the LIVE keyword is required in the CREATE statement. The STREAM keyword in the FROM clause is valid when working with streaming data, so no changes are needed there.

  • A. Correct.

    Correct. In a Delta Live Tables pipeline, the CREATE LIVE TABLE syntax is required to define a table in the pipeline. Omitting the LIVE keyword results in the observed error.

  • B. Incorrect.

    Incorrect. The STREAM keyword is valid in the FROM clause when reading streaming data, and removing it would result in an error if streaming data is used.

  • C. Incorrect.

    Incorrect. While LIVE.input_data is required when referencing other DLT tables, this is not the source of the error in this case. The error specifically pertains to the missing LIVE keyword in the CREATE statement.

  • D. Incorrect.

    Incorrect. The CREATE STREAM TABLE syntax is not valid in Delta Live Tables. DLT uses CREATE LIVE TABLE for both batch and streaming tables.

Timed practice exam

Take a Databricks Data Engineer Associate practice test under exam conditions

45 questions in 90 minutes, drawn from this bank, with a score report and a per-question review when you finish.

Start timed exam

More Databricks Data Engineer Associate practice questions

  1. 418.You are tasked with implementing a production data pipeline in Databricks that processes streaming...
  2. 419.A data engineering team is tasked with setting up a production pipeline in Databricks to process...
  3. 420.You are tasked with building a production data pipeline in Databricks that ingests data from a...
  4. 421.You are designing a production pipeline in Databricks to process large volumes of streaming data...
  5. 422.You are designing a production pipeline in Databricks to process streaming data from a Kafka...
Back to the Databricks Data Engineer Associate exam dumps