Exam Certified Data Engineer Associate topic 1 question 75 discussion

Actual exam question from Databricks's Certified Data Engineer Associate

Question #: 75
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 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.

Show Suggested Answer

Suggested Answer: C 🗳️

by meow_akk at Oct. 22, 2023, 5:35 a.m.

Comments

Submit Cancel

meow_akk

Highly Voted 1 year, 8 months ago

Ans C is correct : https://docs.databricks.com/en/sql/load-data-streaming-table.html Load data into a streaming table To create a streaming table from data in cloud object storage, paste the following into the query editor, and then click Run: SQL Copy to clipboardCopy /* Load data from a volume */ CREATE OR REFRESH STREAMING TABLE <table-name> AS SELECT * FROM STREAM read_files('/Volumes/<catalog>/<schema>/<volume>/<path>/<folder>') /* Load data from an external location */ CREATE OR REFRESH STREAMING TABLE <table-name> AS SELECT * FROM STREAM read_files('s3://<bucket>/<path>/<folder>')

upvoted 8 times

...

80370eb

Most Recent 10 months, 1 week ago

Selected Answer: C

The STREAM function is used to indicate that LIVE.customers is a streaming live table. This allows the query to process real-time streaming data.

upvoted 1 times

...

benni_ale

1 year, 1 month ago

c is correct . about D: it can be correct but it is not given the fact it comes from pyspark ; sql supports (at least in databricks) the creation of streaming live table as well so it is not necessasarily from pyspark

upvoted 1 times

...

benni_ale

1 year, 1 month ago

Selected Answer: C

c is ok

upvoted 1 times

...

[Removed]

1 year, 1 month ago

Selected Answer: D

Option E, specifying "at least one notebook library to be executed," is not a requirement for setting up a Delta Live Tables pipeline. Delta Live Tables are built on top of Databricks and use notebooks to define the pipeline's logic, but the actual requirement when setting up the pipeline is typically the location where the data will be written to, like a target database or a path to cloud storage. While notebooks may contain the business logic for the transformations and actions within the pipeline, the fundamental requirement for setting up a pipeline is knowing where the data will reside after processing, hence why the location of the target database for the written data is crucial.

upvoted 1 times