Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
Deep dive into the quiz with AI chat providers.
We prepare a focused prompt with your quiz and certificate details so each AI can offer a more tailored, in-depth explanation.
A data engineer has written the following query:
SELECT *
FROM json.`/path/to/json/file.json`;
SELECT *
FROM json.`/path/to/json/file.json`;
The data engineer asks a colleague for help to convert this query for use in a Delta Live Tables (DLT) pipeline. The query should create the first table in the DLT pipeline.
Which of the following describes the change the colleague needs to make to the query?
Exam-Like
Community
KKeng
0
A
They need to add a COMMENT line at the beginning of the query.
B
They need to add a CREATE LIVE TABLE table_name AS line at the beginning of the query.
C
They need to add a live. prefix prior to json. in the FROM line.
D
They need to add a CREATE DELTA LIVE TABLE table_name AS line at the beginning of the query.
E
They need to add the cloud_files(...) wrapper to the JSON file path.
Explanation:
Explanation
To convert a standard SQL query into a Delta Live Tables (DLT) pipeline query, the key change required is to add CREATE DELTA LIVE TABLE table_name AS at the beginning of the query. This syntax is specific to DLT pipelines and tells Databricks that this query should be executed as part of a DLT pipeline.
Let's analyze each option:
A. They need to add a COMMENT line at the beginning of the query. - ❌ Incorrect. While comments can be added for documentation, they are not required to make a query work in DLT.
B. They need to add a CREATE LIVE TABLE table_name AS line at the beginning of the query. - ❌ Incorrect. The correct syntax is CREATE DELTA LIVE TABLE, not just CREATE LIVE TABLE.
C. They need to add a live. prefix prior to json. in the FROM line. - ❌ Incorrect. This would be incorrect syntax for DLT. The live. prefix is not used in this context.
D. They need to add a CREATE DELTA LIVE TABLE table_name AS line at the beginning of the query. - ✅ CORRECT. This is the exact syntax required to define a table in a Delta Live Tables pipeline. The complete syntax would look like:
CREATE DELTA LIVE TABLE table_name
AS
SELECT * FROM json.`/path/to/file.json`
CREATE DELTA LIVE TABLE table_name
AS
SELECT * FROM json.`/path/to/file.json`
E. They need to add the cloud_files(...) wrapper to the JSON file path. - ❌ Incorrect. While cloud_files() can be used for autoloader functionality in DLT, it's not required for all JSON file reads and is not the primary change needed to convert a standard query to a DLT query.
Key Takeaway: Delta Live Tables uses specific syntax starting with CREATE DELTA LIVE TABLE to define pipeline tables, which is different from standard SQL or even Databricks SQL syntax.
Comments
Loading comments...