A data engineer wants to optimize query performance for a Delta table storing billions of records.
Queries frequently filter on the column transaction_date. Which Delta Lake feature should be applied to physically organize the data and reduce the amount of data scanned during query execution?

• A. Broadcast join
• B. Caching
• C. Z-Ordering
• D. VACUUM

A data engineer wants to create a relational object by pulling data from two tables. The relational object does not need to be used by other data engineers in other sessions. In order to save on storage costs, the data engineer wants to avoid copying and storing physical data.
Which of the following relational objects should the data engineer create?

• A. Delta Table
• B. Spark SQL Table
• C. Database
• D. Temporary view
• E. View

A data analyst has created a Delta table sales that is used by the entire data analysis team. They want help from the data engineering team to implement a series of tests to ensure the data is clean. However, the data engineering team uses Python for its tests rather than SQL.
Which of the following commands could the data engineering team use to access sales in PySpark?

• A. spark.sql("sales")
• B. spark.table("sales")
• C. SELECT * FROM sales
• D. spark.delta.table("sales")
• E. There is no way to share data between PySpark and SQL.

A data engineer uses COPY INTO to load CSV files from an external location into a Delta table.
The job is accidentally triggered twice within the same hour.
What is the expected outcome?

• A. The target table is overwritten with only the newest file.
• B. The second run loads only files that were not already ingested, because COPY INTO tracks loaded files idempotently.
• C. The second run fails with a duplicate-file error and rolls back the first run.
• D. Records are duplicated because COPY INTO always reloads all files in the source path.