Free Snowflake COF-C03 Exam 2026 Practice Materials Collection
COF-C03 Exam Info and Free Practice Test All-in-One Exam Guide Aug-2026
NEW QUESTION # 418
Which of the following conditions must be met in order to return results from the results cache? (Select TWO).
- A. Micro-partitions have been reclustered since the query was last run
- B. The query has been run within 24 hours of the previously-run query
- C. The query includes a User Defined Function (UDF)
- D. The new query is run using the same virtual warehouse as the previous query
- E. The user has the appropriate privileges on the objects associated with the query
Answer: B,E
Explanation:
To return results from the results cache in Snowflake, certain conditions must be met:
Privileges: The user must have the appropriate privileges on the objects associated with the query. This ensures that only authorized users can access cached data.
Time Frame: The query must have been run within 24 hours of the previously-run query. Snowflake's results cache is designed to store the results of queries for a short period, typically 24 hours, to improve performance for repeated queries.
NEW QUESTION # 419
What is the minimum Snowflake edition required to create a materialized view?
- A. Enterprise Edition
- B. Business Critical Edition
- C. Virtual Private Snowflake Edition
- D. Standard Edition
Answer: A
Explanation:
Materialized views in Snowflake are a feature that allows for the pre-computation and storage of query results for faster query performance. This feature is available starting from the Enterprise Edition of Snowflake. It is not available in the Standard Edition, and while it is also available in higher editions like Business Critical and Virtual Private Snowflake, the Enterprise Edition is the minimum requirement.
References:
Snowflake Documentation on CREATE MATERIALIZED VIEW1.
Snowflake Documentation on Working withMaterialized Views
https://docs.snowflake.com/en/sql-reference/sql/create-materialized-view.html#:~:text=Materialized%
20views%20require%20Enterprise%20Edition,upgrading%2C%20please%20contact%20Snowflake%
20Support.
NEW QUESTION # 420
Which roles are needed to access Document AI? Select TWO.
- A. PUBLIC
- B. ACCOUNTADMIN
- C. SYSADMIN
- D. OBJECT_VIEWER
- E. DOCUMENT_INTELLIGENCE_CREATOR
Answer: B,E
Explanation:
The correct answers are C. ACCOUNTADMIN and E. DOCUMENT_INTELLIGENCE_CREATOR .
Document AI is part of Snowflake Cortex and uses specific privileges/roles for access and administration. The ACCOUNTADMIN role is commonly required for initial setup or granting required privileges, while DOCUMENT_INTELLIGENCE_CREATOR is used to create and work with Document AI objects.
Why C is correct:
ACCOUNTADMIN has the account-level authority needed to enable or manage required access for Document AI features.
Why E is correct:
DOCUMENT_INTELLIGENCE_CREATOR is the Snowflake role associated with creating Document AI- related objects and using Document AI capabilities.
Why the other options are incorrect:
A). PUBLIC is available to all users but does not provide Document AI creation privileges.
B). SYSADMIN manages many account objects, but it is not the specific Document AI role in the answer set.
D). OBJECT_VIEWER is a Snowflake database role for object metadata visibility, not Document AI access.
Official Snowflake documentation reference:
Snowflake documentation for Document AI describes the required access model and includes the DOCUMENT_INTELLIGENCE_CREATOR role for creating Document AI objects, with account administrator involvement for setup.
Reference: Snowflake Documentation - Document AI; Snowflake Cortex; SnowPro Core Study Guide - Snowflake Architecture and Security.
==
NEW QUESTION # 421
What is the recommended way to change the existing file format type in my format from CSV to JSON?
- A. CREATE OR REPLACE FILE FORMAT my format TYPE-JSON;
- B. ALTER FILE FORMAT my_format SET TYPE=JSON;
- C. ALTER FILE FORMAT my format SWAP TYPE WITH JSON;
- D. REPLACE FILE FORMAT my format TYPE-JSON;
Answer: B
Explanation:
To change the existing file format type from CSV to JSON, the recommended way is to use the ALTER FILE FORMAT command with the SET TYPE=JSON clause. This alters the file format specification to use JSON instead of CSV.References:Based on my internal knowledge as of 2021.
NEW QUESTION # 422
Masking policies are created at what level in Snowflake?
- A. Schema
- B. Table
- C. Database
- D. Column
Answer: D
Explanation:
Masking policies in Snowflake are created and applied at the column level. These policies are used to obfuscate sensitive data by masking the values in a specific column. Masking policies can enforce data privacy and protection measures by dynamically masking the data based on the role of the user querying the data.
Snowflake Documentation: Dynamic Data Masking
NEW QUESTION # 423
Which privilege is required to use the search optimization service in Snowflake?
- A. GRANT SEARCH OPTIMIZATION ON SCHEMA < schema_name > TO ROLE < role >
- B. GRANT ADD SEARCH OPTIMIZATION ON SCHEMA < schema_name > TO ROLE < role >
- C. GRANT SEARCH OPTIMIZATION ON DATABASE < database_name > TO ROLE < role >
- D. GRANT ADD SEARCH OPTIMIZATION ON DATABASE < database name > TO ROLE < role >
Answer: B
Explanation:
To utilize the search optimization service in Snowflake, the correct syntax for granting privileges to a role involves specific commands that include adding search optimization capabilities:
Option C: GRANT ADD SEARCH OPTIMIZATION ON SCHEMA < schema_name > TO ROLE < role > .
This command grants the specified role the ability to implement search optimization at the schema level, which is essential for enhancing search capabilities within that schema.
Options A and B do not include the correct verb " ADD, " which is necessary for this specific type of grant command in Snowflake. Option D incorrectly mentions the database level, as search optimization privileges are typically configured at the schema level, not the database level.
References:Snowflake documentation on the use of GRANT statements for configuring search optimization.
NEW QUESTION # 424
What action should be taken if a large number of concurrent queries are queued in a virtual warehouse?
- A. Scale-out with a multi-cluster warehouse.
- B. Disable auto-suspend on the warehouse.
- C. Enable auto-resume on the warehouse.
- D. Scale-up by resizing the warehouse.
Answer: D
NEW QUESTION # 425
True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.
- A. False
- B. True
Answer: A
Explanation:
The ACCOUNTADMIN role is the most powerful role in Snowflake and should be limited to a select number of users within an organization. It is responsible for account-level configurations and should not be used for day-to-day object creation or management. Granting a custom role to ACCOUNTADMIN could inadvertently give broad access to users with this role, which is not a recommended security practice.
NEW QUESTION # 426
Which file formats are supported for unloading data from Snowflake? (Choose two.)
- A. JSON
- B. Avro
- C. ORC
- D. Delimited (CSV, TSV, etc.)
- E. XML
Answer: A,D
Explanation:
Snowflake supports unloading data in JSON and delimited file formats such as CSV and TSV.These formats are commonly used for data interchange and are supported by Snowflake for unloading operations
NEW QUESTION # 427
The is the minimum Fail-safe retention time period for transient tables?
- A. 7 days
- B. 0 days
- C. 12 hours
- D. 1 day
Answer: B
Explanation:
Transient tables in Snowflake have a minimum Fail-safe retention time period of 0 days.This means that once the Time Travel retention period ends, there is no additional Fail-safe period for transient tables
NEW QUESTION # 428
Where would a Snowflake user find information about query activity from 90 days ago?
- A. information__schema - query history_by_ses s i on view
- B. information__schema . cruery_history view
- C. account__usage . query history view
- D. account__usage.query__history__archive View
Answer: D
Explanation:
To find information about query activity from 90 days ago, a Snowflake user should use the account_usage.query_history_archive view. This view is designed to provide access to historical query data beyond the default 14-day retention period found in the standard query_history view. It allows users to analyze and audit past query activities for up to 365 days after the date of execution, which includes the 90-day period mentioned.
References:
[COF-C02] SnowPro Core Certification Exam Study Guide
Snowflake Documentation on Account Usage Schema1
NEW QUESTION # 429
Which virtual warehouse consideration can help lower compute resource credit consumption?
- A. Setting up a multi-cluster virtual warehouse
- B. Increasing the maximum cluster count parameter for a multi-cluster virtual warehouse
- C. Automating the virtual warehouse suspension and resumption settings
- D. Resizing the virtual warehouse to a larger size
Answer: C
Explanation:
One key strategy to lower compute resource credit consumption in Snowflake is by automating the suspension and resumption of virtual warehouses. Virtual warehouses consume credits when they are running, and managing their operational times effectively can lead to significant cost savings.
A . Setting up a multi-cluster virtual warehouse increases parallelism and throughput but does not directly lower credit consumption. It is more about performance scaling than cost efficiency.
B . Resizing the virtual warehouse to a larger size increases the compute resources available for processing queries, which increases the credit consumption rate. This option does not help in lowering costs.
C . Automating the virtual warehouse suspension and resumption settings: This is a direct method to manage credit consumption efficiently. By automatically suspending a warehouse when it is not in use and resuming it when needed, you can avoid consuming credits during periods of inactivity. Snowflake allows warehouses to be configured to automatically suspend after a specified period of inactivity and to automatically resume when a query is submitted that requires the warehouse.
D . Increasing the maximum cluster count parameter for a multi-cluster virtual warehouse would potentially increase credit consumption by allowing more clusters to run simultaneously. It is used to scale up resources for performance, not to reduce costs.
Automating the operational times of virtual warehouses ensures that you only consume compute credits when the warehouse is actively being used for queries, thereby optimizing your Snowflake credit usage.
NEW QUESTION # 430
How can an administrator check for updates (for example, SCIM API requests) sent to Snowflake by the identity provider?
- A. REST EVENT HISTORY
- B. QUERY_HISTORY
- C. ACCESS_HISTORY
- D. LOAD_HISTORY
Answer: A
Explanation:
To monitor updates, such as SCIM API requests sent to Snowflake by the identity provider, an administrator can use theREST EVENT HISTORYfeature. This feature allows administrators to query historical data about REST API calls made to Snowflake, including those related to user and role management through SCIM (System for Cross-domain Identity Management).
TheREST EVENT HISTORYtable function returns information about REST API calls made over a specified period. It is particularly useful for auditing and monitoring purposes, especially when integrating Snowflake with third-party identity providers that use SCIM for automated user provisioning and deprovisioning.
An example query to check for SCIM API requests might look like this:
SELECT*FROMTABLE(information_schema.rest_event_history(date_range_start= > dateadd( ' hours ' ,-1, current_timestamp())))WHERErequest_type = ' SCIM ' ; This query returns details on SCIM API requests made in the last hour, including the request type, the identity provider ' s details, and the outcome of each request.
Reference: Snowflake Documentation on REST EVENT HISTORY (https://docs.snowflake.com/en/sql- reference/functions/rest_event_history.html)
NEW QUESTION # 431
Which role has the ability to create a share from a shared database by default?
- A. ACCOUNTADMIN
- B. SYSADMIN
- C. SECURITYADMIN
- D. ORGADMIN
Answer: A
Explanation:
By default, the ACCOUNTADMIN role in Snowflake has the ability to create a share from a shared database. This role has the highest level of access within a Snowflake account, including the management of all aspects of the account, such as users, roles, warehouses, and databases, as well as the creation and management of shares for secure data sharing with other Snowflake accounts.
References:
Snowflake Documentation: Roles
NEW QUESTION # 432
When a column in a table is dropped, what is the impact on the table ' s micro-partitions?
- A. The table ' s micro-partitions will be updated to reflect the removal of the data in the dropped column.
- B. New micro-partitions will be created that include all remaining columns and data.
- C. A new table will be created, without the data in the dropped column, and new micro-partitions will be created.
- D. The existing micro-partitions will not be changed or impacted.
Answer: D
Explanation:
The correct answer is D. The existing micro-partitions will not be changed or impacted .
Important correction:
The provided answer B is not correct.
Snowflake stores table data in immutable micro-partitions. Because micro-partitions are immutable, Snowflake does not physically rewrite all existing micro-partitions immediately when a column is dropped.
Instead, metadata is updated so that the dropped column is no longer visible or accessible in the table definition.
Why D is correct:
Dropping a column is a metadata operation. The underlying existing micro-partitions are not immediately rewritten to remove the column data. Snowflake's immutable micro-partition design avoids expensive full- table rewrites for this type of operation.
Why the other options are incorrect:
A). Snowflake does not immediately create new micro-partitions containing only the remaining columns.
B). Existing micro-partitions are immutable and are not updated in place.
C). Snowflake does not automatically create a new table and rewrite all remaining data when a column is dropped.
Official Snowflake documentation reference:
Snowflake documentation describes micro-partitions as immutable storage units. Table metadata operations, such as dropping columns, do not immediately rewrite existing micro-partitions.
Reference: Snowflake Documentation - Micro-partitions and data clustering; Snowflake Documentation - ALTER TABLE ... DROP COLUMN; SnowPro Core Study Guide - Snowflake Architecture.
NEW QUESTION # 433
How can a Snowflake user access a JSON object, given the following table? (Select TWO).
- A. src:salesperson.name
- B. SRC:salesperson.name
- C. src:sa1esPerson. name
- D. src:salesperson.Name
- E. SRC:salesperson.Name
Answer: A,D
Explanation:
To access a JSON object in Snowflake, dot notation is used where the path to the object is specified after the column name containing the JSON data. Both lowercase and uppercase can be used for attribute names, so both "name" and "Name" are valid. References: [COF-C03] SnowPro Core Certification Exam Study Guide
NEW QUESTION # 434
A team needs to monitor and receive alerts for Snowpipe credit usage.
Why should a custom budget be used instead of a resource monitor?
- A. Resource monitors can track costs for only one virtual warehouse, whereas custom budgets monitor the entire account.
- B. Custom budgets can track costs using object tags and include serverless features.
- C. A custom budget is the only tool that can automatically send alert emails to users outside the ACCOUNTADMIN role.
- D. Custom budgets track historical spending, whereas resource monitors provide cost forecasts.
Answer: B
Explanation:
A resource monitor applies only to virtual warehouses and the cloud-services usage associated with those warehouses. It cannot monitor credit consumption from serverless features such as Snowpipe, so it is unsuitable for the stated requirement. A custom budget can monitor supported serverless features and can define its scope either by adding individual objects or by associating a tag and tag value with the budget. This makes it possible to group and track costs for a department, workload, or service without relying solely on warehouse boundaries. Budgets can also send notifications when spending is projected to exceed the configured monthly limit. Therefore, option D correctly identifies both decisive advantages: tag-based scoping and coverage of serverless credit usage, including Snowpipe.
NEW QUESTION # 435
Which of the following Snowflake objects can be shared using a secure share? (Select TWO).
- A. Sequences
- B. Materialized views
- C. Secure User Defined Functions (UDFs)
- D. Tables
- E. Procedures
Answer: C,D
Explanation:
Secure sharing in Snowflake allows users to share specific objects with other Snowflake accounts without physically copying the data, thus not consuming additional storage. Tables and Secure User Defined Functions (UDFs) are among the objects that can be shared using this feature. Materialized views, sequences, and procedures are not shareable objects in Snowflake.
References:
[COF-C02] SnowPro Core Certification Exam Study Guide
Snowflake Documentation on Secure Data Sharing1
NEW QUESTION # 436
What is the impact of removing some of the privileges granted to a role?
- A. The role will retain all privileges until a new session is started.
- B. The role will lose access to objects that are not granted to the updated role.
- C. The user will have to reinstate the role using the USE ROLE command after the change.
- D. Any users who are actively using the role will have their current session terminated.
Answer: B
Explanation:
The correct answer is B. The role will lose access to objects that are not granted to the updated role .
Snowflake access control is based on privileges granted to roles. Users receive access to objects through the active role and any inherited roles in the role hierarchy. If privileges are revoked from a role, that role no longer has those privileges unless they are still inherited through another granted role.
Why B is correct:
When privileges are removed from a role, users using that role lose the ability to perform actions that depended on the revoked privileges. Access is controlled by the current set of grants assigned to the role.
Why the other options are incorrect:
A). A role does not retain revoked privileges until a new session starts. Revoked privileges affect access according to Snowflake access control rules.
C). The user does not need to reissue USE ROLE just because privileges were revoked.
D). Snowflake does not terminate active sessions simply because a privilege is removed from a role.
Official Snowflake documentation reference:
Snowflake documentation explains that privileges are granted to roles, roles are granted to users or other roles, and revoking privileges removes the ability to perform the associated actions unless access exists through another role path.
Reference: Snowflake Documentation - Access control overview; Snowflake Documentation - GRANT privileges; Snowflake Documentation - REVOKE privileges; SnowPro Core Study Guide - Security and Access Control.
==
NEW QUESTION # 437
Which Snowflake object is supported by both database replication and replication groups?
- A. Stages
- B. Pipes
- C. Materialized views
- D. Users
Answer: B
NEW QUESTION # 438
What is it called when a customer managed key is combined with a Snowflake managed key to create a composite key for encryption?
- A. Key pair authentication
- B. Tri-secret secure encryption
- C. Hierarchical key model
- D. Client-side encryption
Answer: B
Explanation:
Tri-secret secure encryption is a security model employed by Snowflake that involves combining a customer-managed key with a Snowflake-managed key to create a composite key for encrypting data. This model enhances data security by requiring both the customer-managed key and the Snowflake-managed key to decrypt data, thus ensuring that neither party can access the data independently. It represents a balanced approach to key management, leveraging both customer control and Snowflake's managed services for robust data encryption.
References:
Snowflake Documentation: Encryption and Key Management
NEW QUESTION # 439
What should be used when creating a CSV file format where the columns are wrapped by single quotes or double quotes?
- A. SKIP BYTE ORDER MARK
- B. ESCAPE_UNENCLOSED_FIELD
- C. FIELD_OPTIONALLY_ENCLOSED_BY
- D. BINARY_FORMAT
Answer: C
Explanation:
When creating a CSV file format in Snowflake and the requirement is to wrap columns by single quotes or double quotes, the FIELD_OPTIONALLY_ENCLOSED_BY parameter should be used in the file format specification. This parameter allows you to define a character (either a single quote or a double quote) that can optionally enclose each field in the CSV file, providing flexibility in handling fields that contain special characters or delimiters as part of their data.
References:
Snowflake Documentation: CSV File Format
NEW QUESTION # 440
Which tasks will help optimize virtual warehouse costs? (Select TWO)
- A. Enabling auto-resume
- B. Limiting statement timeout seconds
- C. Limiting statement queue times
- D. Enabling multi-cluster warehouses
- E. Enabling auto-suspend
Answer: B,E
Explanation:
* Auto-suspend ensures that a warehouse automatically suspends when idle, reducing compute costs.
* Statement timeout prevents long-running queries from consuming excessive credits.
Reference:
Snowflake Docs: Managing Warehouses
Snowflake Docs: Statement Timeouts
NEW QUESTION # 441
......
Pass Snowflake COF-C03 Actual Free Exam Q&As Updated Dump: https://www.exam4tests.com/COF-C03-valid-braindumps.html
Latest COF-C03 Actual Free Exam Updated 1187 Questions: https://drive.google.com/open?id=12_1NtLbHwDA2vl11IWJxGQz11qT1nQSN