Answer-first summary for fast verification
Answer: The customers table is a streaming live table.
The STREAM function is used to refer to a streaming live table. This means that the 'customers' table is a streaming live table, specifically designed for processing streaming data. The STREAM function enables the query to process data as it arrives, making it suitable for use in a streaming live table context.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A new data engineer is reviewing the codebase of an ongoing project and encounters the following query in the project repository:
CREATE STREAMING LIVE TABLE loyal_customers AS SELECT customer_id FROM STREAM(LIVE.customers) WHERE loyalty_level = 'high';
What is the purpose of using the STREAM function in this query?
A
The STREAM function is not needed and will cause an error.
B
The table being created is a live table.
C
The customers table is a streaming live table.
D
The customers table is a reference to a Structured Streaming query on a PySpark DataFrame.
E
The data in the customers table has been updated since its last run.
No comments yet.