A Data Engineer would like to define a file structure for loading and unloading data. Where can the file structure be defined? (Choose three.)

Question

Options

• ACOPY command
• BMERGE command
• CFILE FORMAT object
• DPIPE object
• ESTAGE object
• FINSERT command

• A
  78% (36)
• B
  7% (3)
• D
  2% (1)
• F
  13% (6)

Explanation

In Snowflake, file structure (format) for loading/unloading data can be defined in three places: the COPY INTO command allows inline FILE_FORMAT options directly in the statement; a FILE FORMAT object is a named, reusable schema object that encapsulates format settings (CSV delimiters, JSON strip nulls, Parquet compression, etc.); and a STAGE object can have a file format baked in at creation time, so any COPY that references that stage inherits the format automatically.

The distractors fail because MERGE (B) and INSERT (F) are standard DML statements that operate on table rows - they have no concept of external file structure. PIPE (D) is a Snowpipe automation object that references a COPY command internally, but the file structure lives in that embedded COPY, not in the PIPE definition itself.

Memory tip: Think "CSE" - COPY command, Stage object, filE format object - the three places where you tell Snowflake how a file is shaped before data ever touches a table.

No community discussion yet for this question.