Exam Certified Data Engineer Associate topic 1 question 158 discussion

Actual exam question from Databricks's Certified Data Engineer Associate

Question #: 158
Topic #: 1

[All Certified Data Engineer Associate Questions]

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?

A. The STREAM function is not needed and will cause an error.
B. The data in the customers table has been updated since its last run.
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.

Show Suggested Answer

Suggested Answer: C 🗳️

by MultiCloudIronMan at Dec. 16, 2024, 3:55 p.m.

Comments

Submit Cancel

MultiCloudIronMan

5 days, 20 hours ago

Selected Answer: C

The correct answer is C. The customers table is a streaming live table. The STREAM function is used to indicate that the customers table is a streaming live table, which means it is continuously updated with new data. This allows the loyal_customers table to be created as a streaming live table that processes data incrementally as it arrives.

upvoted 2 times

...

Exam Certified Data Engineer Associate All Questions

View all questions & answers for the Certified Data Engineer Associate exam

Exam Certified Data Engineer Associate topic 1 question 158 discussion

Comments

MultiCloudIronMan

SY0-701