Examice

Exam SnowPro Core All QuestionsBrowse all questions from this exam

Go to Exam

Question 803

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

ALTER FILE FORMAT my_format SET TYPE=JSON;

ALTER FILE FORMAT my_format SWAP TYPE WITH JSON;

CREATE OR REPLACE FILE FORMAT my_format TYPE=JSON;

REPLACE FILE FORMAT my_format TYPE=JSON;

Correct Answer: C

To change the existing file format type in my_format from CSV to JSON, the recommended way is to recreate the file format. Therefore, you should use the command: CREATE OR REPLACE FILE FORMAT my_format TYPE=JSON. This command will replace the existing file format with the new JSON type.

Discussion

romega2Option: C

ALTER FILE FORMAT does not support the following actions: - Changing the type (CSV, JSON, etc.) for the file format. To make any of these changes, you must recreate the file format.

0e504b5Option: C

C A doesn't work, I tested: --- 803 CREATE FILE FORMAT ET_803 TYPE=CSV; DESCRIBE FILE FORMAT ET_803; ALTER FILE FORMAT ET_803 SET TYPE =JSON; ---File format type cannot be changed. CREATE OR REPLACE FILE FORMAT ET_803 TYPE=JSON; DESCRIBE FILE FORMAT ET_803; DROP FILE FORMAT ET_803;

HeetecOption: C

C correct - https://docs.snowflake.com/en/sql-reference/sql/create-file-format

Kuma007Option: C

Answer C is correct