A table is registered with the following code:
Both users and orders are Delta Lake tables. Which statement describes the results of querying recent_orders?
Exam Certified Data Engineer Professional All QuestionsBrowse all questions from this exam
Question 16
Correct Answer: B
When using a CREATE TABLE AS SELECT (CTAS) statement in Delta Lake, the logic executes at the time the table is defined. The result of the join operation is stored in the Databricks File System (DBFS). This means that the data resulting from the join operation at the time the table was created is stored, and this stored data will be returned whenever the table is queried. The CTAS statement does not recompute the join at query time. Instead, it queries the already stored result set.
Discussion
asmayassinegOption: B
Correct answer is B. table is created and data of join will be stored on DBFS and it will be returned on query time
BrianNguyen95Option: B
correct answer is B
BIKRAM063Option: B
Correct is B . CTAS command
lucasasterioOption: B
correct is B
robson90Option: D
Aa ok, I missed "logic will execute at query time" ignore my previous comment
Isio05Option: B
CTAS statements persist it results, so B
imatheushenriqueOption: 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.
coercionOption: B
"Create Table" is an action so "B"
PrashantTiwariOption: B
B is correct
kz_dataOption: B
I think B is the correct answer
IWantCertsOption: B
B is correct. Views compute when query is executed, not when defined. And vice versa for tables.
cryptoflamOption: B
Key here is that option D says "returned". The CTAS statement does not return results, thus option B is correct.
aragorn_bregoOption: B
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.
sturcuOption: B
Creating a table will not display results. You need to make a select alter it is created.
SantitoxicOption: D
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.
Starvosxant
No. Simple no. When you execute a create table even with a Join you DONT see the results imediatly unless you query the table. So correct answer is B. The create table statement by default creates a Managed table, which is stored in DBFS.
Naveenkm
Its create separate delta lake transaction logs for this new table. So B is the correct the answer.
robson90Option: D
Why not D? Table does not need to be stored on DBFS if using Unity Catalog. At least that's my understanding https://docs.databricks.com/en/dbfs/unity-catalog.html