- (Topic 2)
Snowflake supports the use of external stages with which cloud platforms? (Choose three.)

1. A. Amazon Web Services
2. B. Docker
3. C. IBM Cloud
4. D. Microsoft Azure Cloud
5. E. Google Cloud Platform
6. F. Oracle Cloud

Correct Answer: ADE
Snowflake supports the use of external stages with Amazon Web Services (AWS), Microsoft Azure Cloud, and Google Cloud Platform (GCP). These platforms allow users to stage data externally and integrate with Snowflake for data loading operations

- (Topic 4)
What is the relationship between a Query Profile and a virtual warehouse?

1. A. A Query Profile can help users right-size virtual warehouses.
2. B. A Query Profile defines the hardware specifications of the virtual warehouse.
3. C. A Query Profile can help determine the number of virtual warehouses available.
4. D. A Query Profile automatically scales the virtual warehouse based on the query complexity.

Correct Answer: A
A Query Profile provides detailed execution information for a query, which can be used to analyze the performance and behavior of queries. This information can help users optimize and right-size their virtual warehouses for better efficiency. References:
[COF-C02] SnowPro Core Certification Exam Study Guide

- (Topic 6)
What happens to the privileges granted to Snowflake system-defined roles?

1. A. The privileges cannot be revoked.
2. B. The privileges can be revoked by an ACCOUNTADMIN.
3. C. The privileges can be revoked by an orgadmin.
4. D. The privileges can be revoked by any user-defined role with appropriate privileges.

Correct Answer: A
The privileges granted to Snowflake's system-defined roles cannot be revoked. System- defined roles, such asSYSADMIN,ACCOUNTADMIN,SECURITYADMIN, and others, come with a set of predefined privileges that are essential for the roles to function correctly within the Snowflake environment. These privileges are intrinsic to the roles and ensure that users assigned these roles can perform the necessary tasks and operations relevant to their responsibilities.
The design of Snowflake's role-based access control (RBAC) model ensures that system- defined roles have a specific set of non-revocable privileges to maintain the security, integrity, and operational efficiency of the Snowflake environment. This approach prevents accidental or intentional modification of privileges that could disrupt the essential functions or compromise the security of the Snowflake account.
References:
✑ Snowflake Documentation on Access Control: Understanding Role-Based Access Control (RBAC)

- (Topic 6)
How can the Query Profile be used to troubleshoot a problematic query?

1. A. It will indicate if a virtual warehouse memory is too small to run the query
2. B. It will indicate if a user lacks the privileges needed to run the query.
3. C. It will indicate if a virtual warehouse is in auto-scale mode
4. D. It will indicate if the user has enough Snowflake credits to run the query

Correct Answer: A
The Query Profile in Snowflake provides detailed insights into the execution of a query. It helps in troubleshooting performance issues by showing the steps of the query execution and the resources consumed. One of the key aspects it reveals is whether the virtual warehouse memory was sufficient for the query.
✑ Access Query Profile:Navigate to the Query History page and select the query you
want to analyze.
✑ Examine Query Execution Steps:The Query Profile displays the different stages of the query execution, including the time taken and resources used at each step.
✑ Identify Memory Issues:Look for indicators of memory issues, such as spilling to disk or memory errors, which suggest that the virtual warehouse memory might be too small.
References:
✑ Snowflake Documentation: Query Profile
✑ Snowflake Documentation: Optimizing Queries

- (Topic 2)
When loading data into Snowflake via Snowpipe what is the compressed file size recommendation?

1. A. 10-50 MB
2. B. 100-250 MB
3. C. 300-500 MB
4. D. 1000-1500 MB

Correct Answer: B
For loading data into Snowflake via Snowpipe, the recommended compressed file size is between 100-250 MB. This size range is optimal for balancing the performance of parallel processing and minimizing the overhead associated with handling many small files2.