SnowPro Core Certification — Question 732

What is the recommended way to change the existing file format type in my_format from CSV to JSON?

Answer options

• A. ALTER FILE FORMAT my_format SET TYPE=JSON;
• B. ALTER FILE FORMAT my_format SWAP TYPE WITH JSON;
• C. CREATE OR REPLACE FILE FORMAT my_format TYPE=JSON;
• D. REPLACE FILE FORMAT my_format TYPE=JSON;

Correct answer: C

Explanation

The correct answer is C because 'CREATE OR REPLACE FILE FORMAT' allows you to change the file format type to JSON effectively. Options A and D are incorrect as they do not properly address the requirement to change the existing format. Option B is also invalid since 'SWAP' is not a recognized command for changing file formats.