FORMAT_NAME and TYPE are mutually exclusive in the COPY command.

• A. False
• B. True
• C. Not applicable
• D. Both can be used together

Answer: (B)

In Snowflake, the file format for a COPY operation can be provided in two ways: by referencing a saved, named file format (FORMAT_NAME) or by supplying an inline file format specification that includes TYPE and other options. You use only one of these methods in a single COPY command. They are mutually exclusive because a named format already defines its TYPE and settings, and mixing an inline TYPE with that predefined format would create ambiguity about which settings to apply. If you need the behavior of a particular format, you either rely on the stored file format object or specify all the needed attributes inline, but you don’t combine both. For example, you can use a named format like FORMAT_NAME = 'my_csv_fmt' (which dictates its own TYPE, such as CSV), or you can specify inline: TYPE = 'CSV', SKIP_HEADER = 1, etc. But you cannot do both in the same COPY statement.