nerdexam
Snowflake

COF-R02 · Question #216

Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?

The correct answer is D. Allows optimization of parallel operations. See the full explanation below for the reasoning.

Question

Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?

Options

  • AOptimizes the virtual warehouse size and multi-cluster setting to economy mode
  • BAllows a user to import the files in a sequential order
  • CIncreases the latency staging and accuracy when loading the data
  • DAllows optimization of parallel operations

How the community answered

(42 responses)
  • A
    12% (5)
  • B
    2% (1)
  • C
    5% (2)
  • D
    81% (34)

Community Discussion

No community discussion yet for this question.

Full COF-R02 Practice