A team regularly loads CSV files from multiple stages and wants to standardize the file format settings. They create a file format object named my_csv_format. Later, they need to change the field delimiter from a comma to a semicolon for all future loads. What should the team do?

Update each COPY INTO statement to use the new delimiter.

Drop the file format and create a new one with the new delimiter.

Run CREATE OR REPLACE FILE FORMAT my_csv_format SET FIELD_DELIMITER = ';';

Run ALTER FILE FORMAT my_csv_format SET FIELD_DELIMITER = ';';

A data engineering team needs to load CSV files from an existing Amazon S3 bucket into Snowflake. The S3 bucket is already configured with the necessary IAM role and trust relationship for Snowflake. The team wants to avoid duplicating the storage location configuration in every COPY INTO statement. What should the team create first?

Create an internal named stage and upload the CSV files to it before loading.

Create a table stage and load the data directly from S3 using the table stage.

Create an external stage that references the S3 bucket and use it in the COPY INTO command.

Create a file format object and reference it in the COPY INTO command.

SnowPro® Core Certification

Domain 4Objective 3

Configure Stages and File Formats COF-C03 Practice Questions (Page 1)

Part of the Data Loading, Unloading, and Connectivity domain, which accounts for 18% of the COF-C03 exam.

19questions here

4free pages

7concepts

18%of the exam

Questions 1–5

1foundation · easy
Which file format type in Snowflake is used for semi-structured data that is stored as key-value pairs and is commonly used for web APIs?
Select an answer first
2foundation · easy
Which Snowflake stage type is automatically created for each user and is used to stage files that are accessible only to that user?
Select an answer first
3application · easy
A team regularly loads CSV files from multiple stages and wants to standardize the file format settings. They create a file format object named my_csv_format. Later, they need to change the field delimiter from a comma to a semicolon for all future loads. What should the team do?
Select an answer first
4foundation · easy
Which file format option in Snowflake specifies the character that separates fields in a CSV file?
Select an answer first
5application · medium
A data engineering team needs to load CSV files from an existing Amazon S3 bucket into Snowflake. The S3 bucket is already configured with the necessary IAM role and trust relationship for Snowflake. The team wants to avoid duplicating the storage location configuration in every COPY INTO statement. What should the team create first?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to COF-C03

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. “COF-C03” is a trademark of its owner, used for identification only.

Configure Stages and File Formats COF-C03 Practice Questions (Page 1)

Questions 1–5

Which file format type in Snowflake is used for semi-structured data that is stored as key-value pairs and is commonly used for web APIs?

Which Snowflake stage type is automatically created for each user and is used to stage files that are accessible only to that user?

A team regularly loads CSV files from multiple stages and wants to standardize the file format settings. They create a file format object named my_csv_format. Later, they need to change the field delimiter from a comma to a semicolon for all future loads. What should the team do?

Which file format option in Snowflake specifies the character that separates fields in a CSV file?

Keep studying — Data Loading, Unloading, and Connectivity