- (Topic 2)
What do the terms scale up and scale out refer to in Snowflake? (Choose two.)

1. A. Scaling out adds clusters of the same size to a virtual warehouse to handle more concurrent queries.
2. B. Scaling out adds clusters of varying sizes to a virtual warehouse.
3. C. Scaling out adds additional database servers to an existing running cluster to handle more concurrent queries.
4. D. Snowflake recommends using both scaling up and scaling out to handle more concurrent queries.
5. E. Scaling up resizes a virtual warehouse so it can handle more complex workloads.
6. F. Scaling up adds additional database servers to an existing running cluster to handle larger workloads.

Correct Answer: AE
Scaling out in Snowflake involves adding clusters of the same size to a virtual warehouse, which allows for handling more concurrent queries without affecting the performance of individual queries. Scaling up refers to resizing a virtual warehouse to increase its compute resources, enabling it to handle more complex workloads and larger queries more efficiently.

- (Topic 2)
Which of the following are best practices for loading data into Snowflake? (Choose three.)

1. A. Aim to produce data files that are between 100 MB and 250 MB in size, compressed.
2. B. Load data from files in a cloud storage service in a different region or cloud platform from the service or region containing the Snowflake account, to save on cost.
3. C. Enclose fields that contain delimiter characters in single or double quotes.
4. D. Split large files into a greater number of smaller files to distribute the load among the compute resources in an active warehouse.
5. E. When planning which warehouse(s) to use for data loading, start with the largest warehouse possible.
6. F. Partition the staged data into large folders with random paths, allowing Snowflake to determine the best way to load each file.

Correct Answer: ACD
Best practices for loading data into Snowflake include aiming for data file sizes between 100 MB and 250 MB when compressed, as this size is optimal for parallel processing and minimizes overhead. Enclosing fields with delimiter characters in quotes ensures proper field recognition during the load process. Splitting large files into smaller ones allows for better distribution of the load across compute resources, enhancing performance and efficiency.

- (Topic 1)
Query compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?

1. A. Compute layer
2. B. Storage layer
3. C. Cloud infrastructure layer
4. D. Cloud services layer

Correct Answer: D
Query compilation in Snowflake occurs in the Cloud Services layer. This layer is responsible for coordinating and managing all aspects of the Snowflake service, including authentication, infrastructure management, metadata management, query parsing and optimization, and security. By handling these tasks, the Cloud Services layer enables the Compute layer to focus on executing queries, while the Storage layer is dedicated to persistently storing data.
References:
✑ [COF-C02] SnowPro Core Certification Exam Study Guide
✑ Snowflake Documentation on Snowflake Architecture1

- (Topic 3)
Which feature allows a user the ability to control the organization of data in a micro- partition?

1. A. Range Partitioning
2. B. Search Optimization Service
3. C. Automatic Clustering
4. D. Horizontal Partitioning

Correct Answer: C
Automatic Clustering is a feature that allows users to control the organization of data within micro-partitions in Snowflake. By defining clustering keys, Snowflake can automatically reorganize the data in micro-partitions to optimize query performance1.

- (Topic 4)
Which Snowflake role can manage any object grant globally, including modifying and revoking grants?

1. A. USERADMIN
2. B. ORGADMIN
3. C. SYSADMIN
4. D. SECURITYADMIN

Correct Answer: D
The SECURITYADMIN role in Snowflake can manage any object grant globally, including modifying and revoking grants. This role has the necessary privileges to oversee and control access to all securable objects within the Snowflake environment4.