Exam SnowPro Core topic 1 question 751 discussion

FILE_EXTENSION = 'string' | NONE String that specifies the extension for files unloaded to a stage. Accepts any extension. The user is responsible for specifying a valid file extension that can be read by the desired software or service. Note If the SINGLE copy option is TRUE, then the COPY command unloads a file without a file extension by default. To specify a file extension, provide a file name and extension in the internal_location or external_location path. For example: copy into @stage/data.csv ...

file_extension is the option to consider. String that specifies the extension for files unloaded to a stage. Accepts any extension. The user is responsible for specifying a valid file extension that can be read by the desired software or service.

C. file_extension The file_extension option must be used to specify the exact name of the file when unloading data from a relational table into a CSV file in an external stage.

It's D

D for sure

It's either C or D. The question asks: "which file format option...". D SINGLE is not about file format option. It's a parameter for COPY INTO <location>. Also is the question asking about the table name? or a file name? It sounds like it's about the file name, but the question says "table name", which is confusing. I'd vote D, but I'm not 100% sure. https://docs.snowflake.com/en/sql-reference/sql/copy-into-location https://docs.snowflake.com/en/sql-reference/sql/create-file-format

Question - The table must be named exactly as specified by the user Note If the SINGLE copy option is TRUE, then the COPY command unloads a file without a file extension by default. To specify a file extension, provide a file name and extension in the internal_location or external_location path. For example: copy into @stage/data.csv ...

C correct - from docs: "Important If SINGLE = TRUE, then COPY ignores the FILE_EXTENSION file format option and outputs a file simply named data. To specify a file extension, provide a filename and extension in the internal or external location path."

"Extension" only allows an extension name so therefore incorrect

The file_extension file format option specifies the file extension of the output file. The default file extension for CSV files is .csv. If you want the table to be named exactly as specified by the user, you must set the file_extension option to .csv.

https://docs.snowflake.com/en/sql-reference/sql/copy-into-location Single=True and specify a single file name like this: -- S3 bucket COPY INTO 's3://mybucket/./../a.csv' FROM mytable; -- Google Cloud Storage bucket COPY INTO 'gcs://mybucket/./../a.csv' FROM mytable;

D If the SINGLE copy option is TRUE, then the COPY command unloads a file without a file extension by default. To specify a file extension, provide a file name and extension in the internal_location or external_location path (e.g. copy into @stage/data.csv). https://docs.snowflake.com/en/sql-reference/sql/create-file-format

D. Single

I will go for this because it required in naming the file