DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE · Question #40
DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE Question #40: Real Exam Question with Answer & Explanation
Sign in or unlock DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE to reveal the answer and full explanation for question #40. The question stem and answer options stay visible for context.
Question
A data engineer has joined an existing project and they see 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'; Which of the following describes why the STREAM function is included in the query?
Options
- AThe STREAM function is not needed and will cause an error.
- BThe table being created is a live table.
- CThe customers table is a streaming live table.
- DThe customers table is a reference to a Structured Streaming query on a PySpark DataFrame.
- EThe data in the customers table has been updated since its last run.
Unlock DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE to see the answer
You've previewed enough free DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE questions. Unlock DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.