10 free Snowflake SnowPro Core COF-C03 practice questions with the correct answer and a full explanation for each, taken from the CertStash pack of 116 questions. Work through them, then open each answer to check your reasoning.
Get all 116 questions (US$39) · Download these 10 as a PDF
Question 1
Snowflake provides a mechanism for its customers to override its natural clustering algorithms. This method is:
Show answer and explanation
Correct answer: B. Clustering keys
Clustering keys provide the mechanism for customers to override Snowflake's natural clustering algorithms. By specifying clustering keys on a table, users can influence how micro-partitions are organized and pruned during query execution, optimizing performance for their specific access patterns.
Why the other options are wrong
- A. Micro-partitions are the result of clustering, not the mechanism to override clustering algorithms.
- C. Key partitions is not a valid Snowflake concept or feature.
- D. Clustered partitions is not the correct terminology; the feature is called clustering keys.
Question 2
Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)
Show answer and explanation
Correct answer: B, D
B. Economy D. Standard Snowflake Virtual Warehouse Scaling Policies include Standard and Economy. Standard policy scales up before scaling out (increasing warehouse size first), while Economy policy scales out before scaling up (adding more warehouses first). Custom and Optimized are not valid scaling policy options.
Why the other options are wrong
- A. Custom is not a valid Virtual Warehouse Scaling Policy in Snowflake.
- C. Optimized is not a valid Virtual Warehouse Scaling Policy in Snowflake.
Question 3
True or False: A single database can exist in more than one Snowflake account.
Show answer and explanation
Correct answer: B. False
A single database can only exist within one Snowflake account. Databases are account- scoped objects and cannot span multiple Snowflake accounts. Each account maintains its own separate set of databases and data.
Why the other options are wrong
- A. Databases are isolated to a single account and cannot exist in multiple accounts simultaneously.
Question 4
Which of the following roles is recommended to be used to create and manage users and roles?
Show answer and explanation
Correct answer: B. SECURITYADMIN
SECURITYADMIN is the recommended role for creating and managing users and roles in Snowflake. This role has the specific privileges needed for user and role administration tasks while maintaining proper separation of duties. ACCOUNTADMIN has broader privileges but is reserved for account-level administration.
Why the other options are wrong
- A. SYSADMIN is used for creating and managing database objects, not for user and role administration.
- C. PUBLIC is a default role with minimal privileges and cannot be used to manage users and roles.
- D. ACCOUNTADMIN has excessive privileges for routine user and role management tasks.
Question 5
True or False: Bulk unloading of data from Snowflake supports the use of a SELECT statement.
Show answer and explanation
Correct answer: A. True
Bulk unloading of data from Snowflake supports the use of a SELECT statement. The COPY INTO command, which handles unloading data to stages or external locations, can query data using a SELECT statement to specify which data to unload.
Why the other options are wrong
- B. SELECT statements are fully supported for unloading data from Snowflake using the COPY INTO command.
Question 6
Select the different types of Internal Stages: (Choose three.)
Show answer and explanation
Correct answer: A, B, C
A. Named Stage B. User Stage C. Table Stage The three types of Internal Stages in Snowflake are Named Stage, User Stage, and Table Stage. Named Stages are explicitly created database objects, User Stages are automatically created for each user (prefixed with @~), and Table Stages are automatically created for each table (prefixed with @%). Schema Stage is not a valid internal stage type.
Why the other options are wrong
- D. Schema Stage is not a valid type of internal stage in Snowflake.
Question 7
True or False: A customer using SnowSQL / native connectors will be unable to also use the Snowflake Web Interface (UI) unless access to the UI is explicitly granted by support.
Show answer and explanation
Correct answer: B. False
A customer using SnowSQL or native connectors can simultaneously use the Snowflake Web Interface without any special permissions or support intervention. Access to different interfaces is independent; using one method does not restrict access to another. Both are standard tools available to all users.
Why the other options are wrong
- A. No explicit grant from support is required; users can use both SnowSQL/connectors and the Web UI simultaneously without restriction.
Question 8
Account-level storage usage can be monitored via:
Show answer and explanation
Correct answer: B. The Snowflake Web Interface (UI) in the Account -> Billing & Usage section
Billing & Usage section Account-level storage usage is monitored through the Snowflake Web Interface in the Account section under Billing & Usage. This dashboard provides comprehensive views of storage consumption and billing information at the account level. The other options reference either non-existent views or incorrect locations within the interface.
Why the other options are wrong
- A. The Databases section in the Web UI shows individual database information, not account-level storage usage summary.
- C. ACCOUNT_USAGE_HISTORY is not a valid system view in Snowflake's Information Schema.
- D. ACCOUNT_USAGE_METRICS is not a valid view in the Account Usage Schema for storage monitoring.
Question 9
Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: (Choose two.)
Show answer and explanation
Correct answer: B, D
B. Warehouse size D. # of clusters for the Warehouse Snowflake credits for compute are consumed based on warehouse size and the number of clusters configured for that warehouse. Warehouse size determines the compute power per cluster (Small, Medium, Large, etc.), while the number of active clusters determines how many parallel compute resources are running. The number of users and amount of data processed do not directly determine credit consumption; rather, it is the computational resources allocated and active that consume credits.
Why the other options are wrong
- A. Number of users does not directly affect credit consumption; multiple users can share a warehouse without increasing cluster count or size.
- C. Amount of data processed does not directly determine credits; the same query on different data sizes consumes credits based on warehouse compute resources, not data volume.
Question 10
Which statement best describes `clustering`?
Show answer and explanation
Correct answer: A. Clustering represents the way data is grouped together and stored within Snowflake's micro-partitions
together and stored within Snowflake's micro-partitions Clustering represents the way data is grouped together and stored within Snowflake's micro-partitions based on column values. This is an automatic physical organization that optimizes query performance by co-locating similar data. Clustering is not something the DBA must manually define for every table; it occurs naturally based on load order and can be optimized with clustering keys. The COPY command does not require clustering specifications, and clustering cannot be disabled at the account level.
Why the other options are wrong
- B. Database administrators do not need to define clustering methodology for each table; Snowflake handles clustering automatically based on data insertion order.
- C. The COPY command does not require clustering specifications; clustering is a physical storage optimization that occurs independently of data loading.
- D. Clustering cannot be disabled within a Snowflake account; it is an inherent part of how Snowflake physically stores and organizes data in micro-partitions.
That was 10 of 116.
The full Snowflake SnowPro Core COF-C03 pack has all 116 questions, each with the answer, the explanation and why the other options are wrong, plus a questions-only copy for timed runs. US$39, paid once, with free monthly updates and a pass-or-your-money-back guarantee.