- (Topic 2)
What types of data listings are available in the Snowflake Data Marketplace? (Choose two.)

1. A. Reader
2. B. Consumer
3. C. Vendor
4. D. Standard
5. E. Personalized

Correct Answer: CE
In the Snowflake Data Marketplace, the types of data listings available include ??Vendor??, which refers to the providers of data, and ??Personalized??, which indicates customized data offerings tailored to specific consumer needs45.

- (Topic 3)
What is the recommended compressed file size range for continuous data loads using Snowpipe?

1. A. 8-16 MB
2. B. 16-24 MB
3. C. 10-99 MB
4. D. 100-250 MB

Correct Answer: D
For continuous data loads using Snowpipe, the recommended compressed file size range is between 100-250 MB. This size range is suggested to optimize the number of parallel operations for a load and to avoid size limitations, ensuring efficient and cost-effective data loading

- (Topic 3)
What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?

1. A. The warehouse size does not change until all queries currently running in the warehouse have completed.
2. B. The warehouse size does not change until all queries currently in the warehouse queue have completed.
3. C. The warehouse size does not change until the warehouse is suspended and restarted.
4. D. It does not return from the command until the warehouse has finished changing its size.

Correct Answer: D
The WAIT_FOR_COMPLETION = TRUE parameter in an ALTER WAREHOUSE command ensures that the command does not return until the warehouse has completed resizing. This means that the command will wait until all the necessary compute resources have been provisioned and the warehouse size has been changed. References: [COF-C02] SnowPro Core Certification Exam Study Guide

- (Topic 2)
Which statement is true about running tasks in Snowflake?

1. A. A task can be called using a CALL statement to run a set of predefined SQL commands.
2. B. A task allows a user to execute a single SQL statement/command using a predefined schedule.
3. C. A task allows a user to execute a set of SQL commands on a predefined schedule.
4. D. A task can be executed using a SELECT statement to run a predefined SQL command.

Correct Answer: B
In Snowflake, a task allows a user to execute a single SQL statement/command using a predefined schedule (B). Tasks are used to automate the execution of SQL statements at scheduled intervals.

- (Topic 3)
In which Snowflake layer does Snowflake reorganize data into its internal optimized, compressed, columnar format?

1. A. Cloud Services
2. B. Database Storage
3. C. Query Processing
4. D. Metadata Management

Correct Answer: B
Snowflake reorganizes data into its internal optimized, compressed, columnar format in the Database Storage layer. This process is part of how Snowflake manages data storage, ensuring efficient data retrieval and query performance