Home / Data Engineer Associate / Objective 2.2

Domain 2: Data Ingestion and Loading · 21% of the exam · Full exam outline

2.2 Use the COPY INTO command to incrementally load files from cloud object storage (ADLS/S3/GCS) into Unity Catalog-governed tables.

Practice questions

Question 1easy

A user runs COPY INTO from a path under /Volumes/ and is denied access to the source files. Which privilege on that volume should an admin grant?

Included in Sample: sample every domain.See plans

Choose an answer to check it. Afterward, select any option to review its explanation.

Reading source files from a Unity Catalog volume with COPY INTO requires READ VOLUME on that volume, and it applies to all nested directories under it.

CREATE TABLE concerns creating the target table, not reading the source files, so it would not clear a denial on the volume.

READ FILES is the matching privilege when the source path is a Unity Catalog external location, which is why it looks right. The source here is a volume, so the volume privilege is the one needed.

COPY INTO only reads from the source volume; writing to the volume is not what the load needs.

Question 2easy

A COPY INTO statement is scheduled nightly against the same volume folder. New files arrive every day, and files from earlier nights stay in the folder. What happens to the earlier files on each run?

Included in Master: master every domain.See plans