ExamGecko
Question list
Search
Search

Question 497 - SnowPro Core discussion

Report
Export

Which command can be used to list all the file formats for which a user has access privileges?

A.

LIST

Answers
A.

LIST

B.

ALTER FILE FORMAT

Answers
B.

ALTER FILE FORMAT

C.

DESCRIBE FILE FORMAT

Answers
C.

DESCRIBE FILE FORMAT

D.

SHOW FILE FORMATS

Answers
D.

SHOW FILE FORMATS

Suggested answer: D

Explanation:

The command to list all the file formats for which a user has access privileges in Snowflake is SHOW FILE FORMATS. This command provides a list of all file formats defined in the user's current session or specified database/schema, along with details such as the name, type, and creation time of each file format. It is a valuable tool for users to understand and manage the file formats available for data loading and unloading operations.

Snowflake Documentation: SHOW FILE FORMATS

asked 29/10/2024
Trey Contello
42 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first