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?

Real Exam

CREATE STREAMING LIVE TABLE sales_aggregated AS SELECT order_date, sum(order_amount) as sales_per_day FROM sales_cleaned GROUP BY order_date_

12.3%

CREATE LIVE TABLE sales_aggregated AS SELECT order_date, sum(order_amount) as sales_per_day FROM STREAM(sales_cleaned) GROUP BY order_date_

12.3%

CREATE STREAMING TABLE sales_aggregated AS SELECT order_date, sum(order_amount) as sales_per_day FROM LIVE.sales_cleaned GROUP BY order_date_

16.9%

CREATE LIVE TABLE sales_aggregated AS SELECT order_date, sum(order_amount) as sales_per_day FROM LIVE.sales_cleaned GROUP BY order_date_

41.5%

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_

16.9%

Databricks Certified Data Engineer - Associate