SnowflakeSnowflake
COF-C02 · Question #251
COF-C02 Question #251: Real Exam Question with Answer & Explanation
The correct answer is A: ALTER FILE FORMAT my_format SET TYPE=JSON;. To change the existing file format type from CSV to JSON, the recommended way is to use the ALTER FILE FORMAT command with the SET TYPE=JSON clause. This alters the file format specification to use JSON instead of CSV.
Data Loading and Unloading
Question
What is the recommended way to change the existing file format type in my format from CSV to JSON?
Options
- AALTER FILE FORMAT my_format SET TYPE=JSON;
- BALTER FILE FORMAT my format SWAP TYPE WITH JSON;
- CCREATE OR REPLACE FILE FORMAT my format TYPE-JSON;
- DREPLACE FILE FORMAT my format TYPE-JSON;
Explanation
To change the existing file format type from CSV to JSON, the recommended way is to use the ALTER FILE FORMAT command with the SET TYPE=JSON clause. This alters the file format specification to use JSON instead of CSV.
Topics
#File Formats#DDL#ALTER FILE FORMAT#Data Loading
Community Discussion
No community discussion yet for this question.