Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
A data engineer encounters the following code snippet in a project's codebase: CREATE STREAMING LIVE TABLE loyal_customers AS SELECT customer_id FROM STREAM(LIVE.customers) WHERE loyalty_level = 'high'; What is the purpose of the STREAM function in this query?_
A
The STREAM function indicates that the customers table is a reference to a Structured Streaming query on a PySpark DataFrame.
B
The STREAM function is unnecessary and will trigger an error in the query.
C
The STREAM function signifies that the customers table is a streaming live table, designed for continuously updating data.
D
The data within the customers table has been modified since the query was last executed.
E
The table being created is designated as a live table.