Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.
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."
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
I will go for this because it required in naming the file
upvoted 1 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Lematthew31
2 weeks, 4 days agoSamuelZhang
2 months, 4 weeks ago0e504b5
3 months ago0e504b5
3 months agoRam9198
6 months, 2 weeks agoHeetec
7 months agoRam9198
6 months, 2 weeks agojAtlas7
7 months, 2 weeks agoJG1984
8 months, 2 weeks agosinghks
9 months agoMarcusbraga
9 months, 2 weeks agoHelloCosmin
9 months, 3 weeks agoMultiCloudIronMan
10 months ago