DEA-C02 Data Movement Practice Question

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

• ✗

  Add a FILE_FORMAT option of TYPE = CSV with COMPRESSION = NONE

  Why it's wrong here

  Disabling compression increases the bytes written and slows the transfer, working against the throughput objective. CSV with no compression also inflates storage cost and makes downstream reads slower. File format choice affects parseability and size, not the parallelism of the unload itself, so this option does not address the stated goals of throughput and organized output.

• ✗

  Use OVERWRITE = TRUE and leave MAX_FILE_SIZE at its default

  Why it's wrong here

  OVERWRITE = TRUE simply replaces existing objects in the prefix; it does not improve write parallelism or organize output for subset reads. Leaving MAX_FILE_SIZE at default still yields multiple files, but the scenario also wants deliberate organization, which this option ignores. Overwriting is also risky for archival because it destroys prior exports in the same location without adding any throughput benefit.

• ✗

  Set SINGLE = TRUE so the output is one large file

  Why it's wrong here

  SINGLE = TRUE forces all output into a single object, which serializes the write and removes parallelism, directly contradicting the throughput goal. It also produces a file that downstream tools must read in full, defeating subset reads. The option is useful only for small exports where one file is convenient, so it is the opposite of what this large archival scenario requires.

• ✓

  Set MAX_FILE_SIZE to a moderate value and use a partition-like folder path in the stage prefix

  Why this is correct

  Controlling MAX_FILE_SIZE splits the unload into many files, which increases parallel write throughput and keeps individual objects manageable. Writing into a structured prefix lets downstream readers prune by folder rather than scanning the whole export. Together these options satisfy both the throughput and the organization goals without requiring post-processing of the unloaded data.