Databricks Certified Data Engineer Associate Practice Mode

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• Chose A0

  - Correct answer : A — `PATTERN = 'landing/2026/09/*.csv'` so the command matches only files under that prefix whose names end with the `.csv` extension using glob-style matching. A . This is correct. `PATTERN` accepts glob-style expressions, so restricting it to `*.csv` under the target prefix filters the source listing down to only the matching CSV files. B . This is incorrect. `FILES` expects a list of explicit file names rather than a glob expression, and it cannot be combined with wildcard matching to select a subset of files by extension. C . This is incorrect. There is no `extension` key recognized under `FORMAT_OPTIONS`; format options configure how a given file format is parsed, not which files are selected for the load. D . This is incorrect. `FILEFORMAT` tells `COPY INTO` which parser to use for the selected files; it does not filter the source listing by file extension, so non-CSV files would still be attempted.