A data engineer is working on a Delta Live Tables (DLT) pipeline and encounters an error with the following query, preventing the pipeline from starting: `CREATE LIVE TABLE aggregated_sales AS SELECT store_id, sum(total) FROM cleaned_sales GROUP BY store_id`. What change should be made to this query to successfully start the DLT pipeline?

Real Exam

CREATE STREAMING TABLE aggregated_sales AS SELECT store_id, sum(total) FROM LIVE.cleaned_sales GROUP BY store_id

39.1%

CREATE TABLE aggregated_sales AS SELECT store_id, sum(total) FROM LIVE.cleaned_sales GROUP BY store_id

13.2%

CREATE LIVE TABLE aggregated_sales AS SELECT store_id, sum(total) FROM cleaned_sales GROUP BY store_id

10.6%

CREATE STREAMING LIVE TABLE aggregated_sales AS SELECT store_id, sum(total) FROM STREAM(cleaned_sales) GROUP BY store_id

22.9%

CREATE STREAMING LIVE TABLE aggregated_sales AS SELECT store_id, sum(total) FROM cleaned_sales GROUP BY store_id

14.1%

Databricks Certified Data Engineer - Associate