Which SQL command is used to grant the USAGE privilege on a file format to a role?

GRANT ALL ON FILE FORMAT my_format TO ROLE analyst;

GRANT USAGE ON FILE FORMAT my_format TO ROLE analyst;

GRANT READ ON FILE FORMAT my_format TO ROLE analyst;

GRANT SELECT ON FILE FORMAT my_format TO ROLE analyst;

A data engineer needs to load a one-time CSV file from their local machine into a Snowflake table. The file is small and will not be reused. The engineer does not want to create a permanent stage. What is the most efficient way to load the file?

Use the GET command to download the file to the table stage, then use COPY INTO.

Use the PUT command to upload the file to the user stage, then use COPY INTO with the user stage.

Create a table stage and use the PUT command to upload the file directly to the table.

Create an external stage pointing to a local directory, then use COPY INTO.

SnowflakeSnowPro Advanced — Data Engineer

Domain 1Objective 2

Configure Stages, File Formats, and Connectors DEA-C02 Practice Questions (Page 5)

Part of the Data Movement domain, which accounts for 26% of the DEA-C02 exam.

25questions here

5free pages

9concepts

26%of the exam

Questions 21–25

21foundation · easy
Which SQL command is used to grant the USAGE privilege on a file format to a role?
Select an answer first
22application · easy
A data engineer created a named external stage for a team to load data from an S3 bucket. The team members have the DATA_LOADER role. The engineer wants to allow the DATA_LOADER role to use the stage but not modify or drop it. Which privilege should be granted?
Select an answer first
23application · medium
A data engineer needs to load a one-time CSV file from their local machine into a Snowflake table. The file is small and will not be reused. The engineer does not want to create a permanent stage. What is the most efficient way to load the file?
Select an answer first
24foundation · easy
Which file format option is used to specify the character that separates fields in a CSV file?
Select an answer first
25foundation · easy
Which file format type is used for semi-structured data that is stored as key-value pairs?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

No more pagesBack to DEA-C02

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Snowflake. “DEA-C02” is a trademark of its owner, used for identification only.

Configure Stages, File Formats, and Connectors DEA-C02 Practice Questions (Page 5)

Questions 21–25

Which SQL command is used to grant the USAGE privilege on a file format to a role?

A data engineer created a named external stage for a team to load data from an S3 bucket. The team members have the DATA_LOADER role. The engineer wants to allow the DATA_LOADER role to use the stage but not modify or drop it. Which privilege should be granted?

A data engineer needs to load a one-time CSV file from their local machine into a Snowflake table. The file is small and will not be reused. The engineer does not want to create a permanent stage. What is the most efficient way to load the file?

Which file format option is used to specify the character that separates fields in a CSV file?

Which file format type is used for semi-structured data that is stored as key-value pairs?

Keep studying — Data Movement