Exam Certified Data Engineer Professional topic 1 question 16 discussion

Correct answer is B. table is created and data of join will be stored on DBFS and it will be returned on query time

The question says "Which statement describes the results of querying recent_orders?" The question doesn't ask about the code snipped itself. This question is about the logic of "select * from recent_orders" after the creation of recent_orders. answer is D D is the right answer

B is correct

Only logic there is inside create statemetn and it will execute once while executing "create table" statement. Further select queries will only select any data that was inserted during create table statement , data wont by updated automatically. So B

i think B

i picked b

CTAS statements persist it results, so B

B. All logic will execute when the table is defined and store the result of joining tables to the DBFS; this stored data will be returned when the table is queried.

"Create Table" is an action so "B"

B is correct

I think B is the correct answer

B is correct. Views compute when query is executed, not when defined. And vice versa for tables.

Key here is that option D says "returned". The CTAS statement does not return results, thus option B is correct.

The correct answer is: B. All logic will execute when the table is defined and store the result of joining tables to the DBFS; this stored data will be returned when the table is queried. When the CREATE TABLE AS statement is executed, it runs the enclosed SELECT statement immediately to pull the current data from the users and orders tables where the order_date is within the last 7 days. This result is then stored as a new table called recent_orders in the Delta Lake on the DBFS (Databricks File System). Subsequent queries against recent_orders will return this stored data, and not recompute the join unless the table is updated or refreshed.

Correct is B . CTAS command

Creating a table will not display results. You need to make a select alter it is created.

Based on typical Delta Lake behavior, option D is the most accurate description. Delta Lake queries generally execute at query time and retur n results based on the state of the source tables at the time the query began. Delta Lake provides features for managing data versions and transactions, but it doesn't precompute and store results like option B or cache results like option C.