A COPY INTO command fails with the error 'File format is not supported'. What is the most likely cause?

The file format name is misspelled or does not exist.

A data engineer is troubleshooting a COPY INTO command that fails with the error 'Failed to access remote file: access denied. Please check your credentials'. The external stage was created with an AWS IAM role. The engineer verified that the IAM role has the correct S3 permissions and that the stage URL is correct. What is the most likely cause of the access denied error?

The files in the S3 bucket are encrypted with a different KMS key.

The IAM role is not trusted by the Snowflake account, or the external ID does not match.

The stage was created with the wrong storage integration.

The S3 bucket is in a different region than the Snowflake account.

SnowflakeSnowPro Advanced — Data Engineer

Domain 1Objective 2

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

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 16–20

16foundation · easy
A COPY INTO command fails with the error 'File format is not supported'. What is the most likely cause?
Select an answer first
17foundation · easy
A data engineer needs to load a one-time CSV file from their local machine into a Snowflake table. Which type of stage is most appropriate for this task?
Select an answer first
18foundation · easy
Which configuration parameter in the Snowflake Connector for Kafka specifies the Snowflake account identifier?
Select an answer first
19expert · medium
A data engineer is troubleshooting a COPY INTO command that fails with the error 'Failed to access remote file: access denied. Please check your credentials'. The external stage was created with an AWS IAM role. The engineer verified that the IAM role has the correct S3 permissions and that the stage URL is correct. What is the most likely cause of the access denied error?
Select an answer first
20foundation · easy
Which stage type is automatically created for every table and user in Snowflake?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back 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 4)

Questions 16–20

A COPY INTO command fails with the error 'File format is not supported'. What is the most likely cause?

A data engineer needs to load a one-time CSV file from their local machine into a Snowflake table. Which type of stage is most appropriate for this task?

Which configuration parameter in the Snowflake Connector for Kafka specifies the Snowflake account identifier?

Which stage type is automatically created for every table and user in Snowflake?

Keep studying — Data Movement