SnowPro Core Certification — Question 926
Which command can be used to list all the file formats for which a user has access privileges?
Answer options
- A. LIST
- B. ALTER FILE FORMAT
- C. DESCRIBE FILE FORMAT
- D. SHOW FILE FORMATS
Correct answer: D
Explanation
The correct answer is D, SHOW FILE FORMATS, which is specifically designed to list all file formats a user can access. Options A, B, and C do not serve this purpose; LIST does not provide file format information, ALTER FILE FORMAT is for modifying formats, and DESCRIBE FILE FORMAT offers details about a specific format rather than listing all accessible formats.