Answer-first summary for fast verification
Answer: CREATE LIVE TABLE sales_aggregated AS SELECT order_date, sum(order_amount) as sales_per_day FROM LIVE.sales_cleaned GROUP BY order_date
In Delta Live Tables pipelines, the `CREATE LIVE TABLE` syntax is used to create a table with SQL. To reference another live table within the pipeline, the `LIVE.` keyword must be prepended to the table name. Therefore, the correct modification to the query is to use `FROM LIVE.sales_cleaned` to successfully initiate the DLT pipeline.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
A data engineer has written a query to create a Delta Live Table named sales_aggregated to calculate the total sales per day, referencing another Delta Live Table called sales_cleaned. However, the DLT pipeline fails to start due to an error in the query. Which of the following modifications should be made to the query to successfully initiate the DLT pipeline?
A
CREATE STREAMING LIVE TABLE sales_aggregated AS SELECT order_date, sum(order_amount) as sales_per_day FROM sales_cleaned GROUP BY order_date
B
CREATE LIVE TABLE sales_aggregated AS SELECT order_date, sum(order_amount) as sales_per_day FROM STREAM(sales_cleaned) GROUP BY order_date
C
CREATE STREAMING TABLE sales_aggregated AS SELECT order_date, sum(order_amount) as sales_per_day FROM LIVE.sales_cleaned GROUP BY order_date
D
CREATE LIVE TABLE sales_aggregated AS SELECT order_date, sum(order_amount) as sales_per_day FROM LIVE.sales_cleaned GROUP BY order_date
E
CREATE STREAMING LIVE TABLE sales_aggregated AS SELECT order_date, sum(order_amount) as sales_per_day FROM STREAM(sales_cleaned) GROUP BY order_date