In a COPY INTO command, how do you specify that the source files are JSON and set an option to ignore corrupt records?

FILE_FORMAT = 'JSON', FORMAT_OPTIONS ('mode' = 'PERMISSIVE')

FORMAT = JSON, OPTIONS ('mode' = 'PERMISSIVE')

FILE_FORMAT = JSON ('mode' = 'PERMISSIVE')

FILE_FORMAT = JSON, FORMAT_OPTIONS ('mode' = 'PERMISSIVE')

A data engineer is loading data from an S3 bucket that organizes files by date: s3://bucket/events/date=2024-01-01/, s3://bucket/events/date=2024-01-02/, etc. The engineer wants to load only the data for a specific date range using COPY INTO. What is the most efficient way to do this?

Run COPY INTO on the entire s3://bucket/events/ path and rely on the incremental load feature to skip already-loaded files.

Run COPY INTO on the entire s3://bucket/events/ path with a pattern that matches the date range.

Run COPY INTO with the source path pointing to the specific date partition, e.g., s3://bucket/events/date=2024-01-01/

Run COPY INTO on the entire s3://bucket/events/ path and use a WHERE clause to filter the data.

DatabricksCertified Data Engineer Associate

Domain 2Objective 2

GCS) into Unity‑Catalog–governed Tables. DATA-ENGINEER-ASSOCIATE Practice Questions (Page 1)

Part of the Data Ingestion and Loading domain, which accounts for 21% of the DATA-ENGINEER-ASSOCIATE exam. Databricks does not publish an official question count, but from its 90-minute exam (~35–60 total, ~7–13 in this domain), expect 1–2 from this objective — we provide 17 practice questions to prepare you well beyond it. (estimate)

17questions here

4free pages

7concepts

21%of the exam

Questions 1–5

1foundation · easy
In a COPY INTO command, how do you specify that the source files are JSON and set an option to ignore corrupt records?
Select an answer first
2foundation · easy
Which COPY INTO option allows you to validate files for errors without actually loading any data?
Select an answer first
3foundation · easy
Which of the following file formats is NOT supported by COPY INTO?
Select an answer first
4application · medium
A data engineer is loading data from an S3 bucket that organizes files by date: s3://bucket/events/date=2024-01-01/, s3://bucket/events/date=2024-01-02/, etc. The engineer wants to load only the data for a specific date range using COPY INTO. What is the most efficient way to do this?
Select an answer first
5foundation · easy
In a COPY INTO command, which clause is used to specify that the source files are in CSV format and to set options like header and delimiter?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DATA-ENGINEER-ASSOCIATE

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Databricks. “DATA-ENGINEER-ASSOCIATE” is a trademark of its owner, used for identification only.

Use the COPY INTO Command to Incrementally Load Files from Cloud Object Storage (ADLS/S3/GCS) into Unity‑Catalog–governed Tables. DATA-ENGINEER-ASSOCIATE Practice Questions (Page 1)

Questions 1–5

In a COPY INTO command, how do you specify that the source files are JSON and set an option to ignore corrupt records?

Which COPY INTO option allows you to validate files for errors without actually loading any data?

Which of the following file formats is NOT supported by COPY INTO?

A data engineer is loading data from an S3 bucket that organizes files by date: s3://bucket/events/date=2024-01-01/, s3://bucket/events/date=2024-01-02/, etc. The engineer wants to load only the data for a specific date range using COPY INTO. What is the most efficient way to do this?

In a COPY INTO command, which clause is used to specify that the source files are in CSV format and to set options like header and delimiter?

Keep studying — Data Ingestion and Loading