SnowPro Core Certification Exam
Last Update Jun 24, 2026
Total Questions : 1085
We are offering FREE COF-C02 Snowflake exam questions. All you do is to just go and sign up. Give your details, prepare COF-C02 free exam questions and then go for complete pool of SnowPro Core Certification Exam test questions that will help you more.
What happens when a network policy includes values that appear in both the allowed and blocked IP address list?
Which function is used to convert rows in a relational table to a single VARIANT column?
Which privilege is required to use the search optimization service in Snowflake?
What should be used when creating a CSV file format where the columns are wrapped by single quotes or double quotes?
Which Snowflake edition offers the highest level of security for organizations that have the strictest requirements?
Which Snowflake mechanism is used to limit the number of micro-partitions scanned by a query?
User1, who has the SYSADMIN role, executed a query on Snowsight. User2, who is in the same Snowflake account, wants to view the result set of the query executed by User1 using the Snowsight query history.
What will happen if User2 tries to access the query history?
Which file function generates a SnowFlake-hosted URL that must be authenticated when used?
What is the Fail-safe retention period for transient and temporary tables?
A user wants to add additional privileges to the system-defined roles for their virtual warehouse. How does Snowflake recommend they accomplish this?
What is the only supported character set for loading and unloading data from all supported file formats?
The effects of query pruning can be observed by evaluating which statistics? (Select TWO).
What is the MAXIMUM number of clusters that can be provisioned with a multi-cluster virtual warehouse?
A user has semi-structured data to load into Snowflake but is not sure what types of operations will need to be performed on the data. Based on this situation, what type of column does Snowflake recommend be used?
How long is a query visible in the Query History page in the Snowflake Web Interface (Ul)?
The VALIDATE table function has which parameter as an input argument for a Snowflake user?
What does the worksheet and database explorer feature in Snowsight allow users to do?
What is the MINIMUM permission needed to access a file URL from an external stage?
How does a Snowflake stored procedure compare to a User-Defined Function (UDF)?
Which view can be used to determine if a table has frequent row updates or deletes?
Which of the following statements describe features of Snowflake data caching? (Choose two.)
Why would a Snowflake user decide to use a materialized view instead of a regular view?
What SnowFlake database object is derived from a query specification, stored for later use, and can speed up expensive aggregation on large data sets?
A Snowflake user is writing a User-Defined Function (UDF) that includes some unqualified object names.
How will those object names be resolved during execution?
What is used to denote a pre-computed data set derived from a SELECT query specification and stored for later use?
Which function will provide the proxy information needed to protect Snowsight?
What is the Fail-safe period for a transient table in the Snowflake Enterprise edition and higher?
There are two Snowflake accounts in the same cloud provider region: one is production and the other is non-production. How can data be easily transferred from the production account to the non-production account?
How does a Snowflake user extract the URL of a directory table on an external stage for further transformation?
When floating-point number columns are unloaded to CSV or JSON files, Snowflake truncates the values to approximately what?
By default, how long is the standard retention period for Time Travel across all Snowflake accounts?
For Directory tables, what stage allows for automatic refreshing of metadata?
When unloading data, which file format preserves the data values for floating-point number columns?
Which command should be used to unload all the rows from a table into one or more files in a named stage?
Which role has the ability to create a share from a shared database by default?
What is it called when a customer managed key is combined with a Snowflake managed key to create a composite key for encryption?
If a virtual warehouse runs for 61 seconds, shut down, and then restart and runs for 30 seconds, for how many seconds is it billed?
Which command can be used to list all the file formats for which a user has access privileges?
Which service or feature in Snowflake is used to improve the performance of certain types of lookup and analytical queries that use an extensive set of WHERE conditions?
Which command will identify the names of files that are in a Snowflake stage?
Which data formats are supported by Snowflake when unloading semi-structured data? (Select TWO).
A Snowflake user wants to temporarily bypass a network policy by configuring the user object property MINS_TO_BYPASS_NETWORK_POLICY.
What should they do?
Which SQL command can be used to verify the privileges that are granted to a role?
What is the following SQL command used for?
Select * from table(validate(t1, job_id = > ' _last ' ));
The following JSON is stored in a VARIANT column called src of the CAR_SALES table:
A user needs to extract the dealership information from the JSON.
How can this be accomplished?
A running virtual warehouse is suspended.
What is the MINIMUM amount of time that the warehouse will incur charges for when it is restarted?
Which command should be used to load data from a file, located in an external stage, into a table in Snowflake?
What are best practice recommendations for using the ACCOUNTADMIN system-defined role in Snowflake? (Choose two.)
Which of the following significantly improves the performance of selective point lookup queries on a table?
Which file formats are supported for unloading data from Snowflake? (Choose two.)
What is the MINIMUM edition of Snowflake that is required to use a SCIM security integration?
What COPY INTO SQL command should be used to unload data into multiple files?
A table needs to be loaded. The input data is in JSON format and is a concatenation of multiple JSON documents. The file size is 3 GB. A warehouse size small is being used. The following COPY INTO command was executed:
COPY INTO SAMPLE FROM @~/SAMPLE.JSON (TYPE=JSON)
The load failed with this error:
Max LOB size (16777216) exceeded, actual size of parsed column is 17894470.
How can this issue be resolved?
A Snowflake Administrator needs to ensure that sensitive corporate data in Snowflake tables is not visible to end users, but is partially visible to functional managers.
How can this requirement be met?
Which columns are part of the result set of the Snowflake LATERAL FLATTEN command? (Choose two.)
Which snowflake objects will incur both storage and cloud compute charges? (Select TWO)
What types of data listings are available in the Snowflake Data Marketplace? (Choose two.)
How can a row access policy be applied to a table or a view? (Choose two.)
A user created a new worksheet within the Snowsight Ul and wants to share this with teammates
How can this worksheet be shared?
True or False: Snowpipe via REST API can only reference External Stages as source.
What is the minimum Snowflake edition required to use Dynamic Data Masking?
Which services does the Snowflake Cloud Services layer manage? (Choose two.)
A company needs to allow some users to see Personally Identifiable Information (PII) while limiting other users from seeing the full value of the PII.
Which Snowflake feature will support this?
Which data types are supported by Snowflake when using semi-structured data? (Choose two.)
A user created a transient table and made several changes to it over the course of several days. Three days after the table was created, the user would like to go back to the first version of the table.
How can this be accomplished?
Which statements are correct concerning the leveraging of third-party data from the Snowflake Data Marketplace? (Choose two.)
What is the maximum total Continuous Data Protection (CDP) charges incurred for a temporary table?
What are the responsibilities of Snowflake ' s Cloud Service layer? (Choose three.)
Which of the following features are available with the Snowflake Enterprise edition? (Choose two.)
Assume there is a table consisting of five micro-partitions with values ranging from A to Z.
Which diagram indicates a well-clustered table?
A user is preparing to load data from an external stage
Which practice will provide the MOST efficient loading performance?
Which statements are true concerning Snowflake ' s underlying cloud infrastructure? (Select THREE),
A virtual warehouse is created using the following command:
Create warehouse my_WH with
warehouse_size = MEDIUM
min_cluster_count = 1
max_cluster_count = 1
auto_suspend = 60
auto_resume = true;
The image below is a graphical representation of the warehouse utilization across two days.
What action should be taken to address this situation?
Which of the following objects are contained within a schema? (Choose two.)
What is the default file size when unloading data from Snowflake using the COPY command?
The Snowflake Cloud Data Platform is described as having which of the following architectures?
What happens to historical data when the retention period for an object ends?
How should a virtual warehouse be configured if a user wants to ensure that additional multi-clusters are resumed with no delay?
Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?
Which Snowflake function will interpret an input string as a JSON document, and produce a VARIANT value?
What do the terms scale up and scale out refer to in Snowflake? (Choose two.)
Which command should be used to download files from a Snowflake stage to a local folder on a client ' s machine?
When publishing a Snowflake Data Marketplace listing into a remote region what should be taken into consideration? (Choose two.)
What action will change a customized schedule for a resource monitor back to the default schedule?
Which table function is used to perform additional processing on the results of a previously-run query?
A global company needs to share financial reports with managers who are in different regions. Managers should only see the data from their respective regions. How can these requirements be met with the least amount of operational overhead?
What action will cause the cache associated with compute resources to be dropped?
What will happen if multiple identical COPY INTO < location > statements using the default settings are executed in parallel on the same data file?
Which multi-duster virtual warehouse setting will help process queued queries as quickly as possible?
Which feature is designed to reduce security risks associated with an individual user ' s password authentication?
How can data be shared in Snowflake with another account located in the same region without the need to copy or move the data?
A clustering key was defined on a table, but It is no longer needed. How can the key be removed?
How should a Snowflake user access a third-party SaaS service to process unstructured data?
Which Snowflake feature enables loading data from cloud storage as soon as files ate available in a stage?
How many credits does a size 3X-Large virtual warehouse consume if it runs continuously for 2 hours?
When would creating and using a standard view be preferable to using a materialized view?
What is a Snowflake recommendation for the use of key pair authentication?
Which statements reflect valid commands when using secondary roles? (Select TWO).
What is the default access of a securable object until other access is granted?
Which command is used to lake away staged files from a Snowflake stage after a successful data ingestion?
Which COPY INTO < table > options can be used to load data from a staged file when the metadata in the file has expired? (Select TWO)
What are the possible values within a METADATASACTION column in a Snowflake stream? (Select TWO).
Which roles can make grant decisions to objects within a managed access schema? (Select TWO)
When unloading data from a query into a location, which VALIDATION_MODE parameter returns the query results?
By default, which role is required to change the refresh frequency for an auto-fulfilled application package?
What Multi-Factor Authentication, or MFA, service is provided by Snowflake?
This query was executed:
Assuming the weather_events table has not changed, which query would benefit from cached results?
A user has been granted the APPLY privilege on a masking policy that partially masks customer telephone numbers. Which additional privilege must be granted so that the user can apply the masking policy to the relevant columns?
Snowflake users can create a resource monitor at which levels? (Select TWO).
Which data sharing mechanism can be used to share data privately or publicly within the Snowflake Marketplace?
Which Snowflake feature supports the use of natural language queries to analyze unstructured data?
Which command should be used to load data from a local computer into Snowflake?
Why is a federated environment used for user authentication in Snowflake?
How can staged files be removed during data loading once the files have loaded successfully?
Which data sharing option allows a Snowflake user to set up and manage a group of accounts and offer a share to that group?
Queries are frequently run on very large tables and return only a few rows.
Use of which feature or service will optimize the query performance?
Taking which step will minimize the number of queries waiting to run on a virtual warehouse?
Which query types will have significant performance improvement when run using the search optimization service? (Select TWO)
A directory table that references an external stage is being refreshed manually.
What will happen to any scheduled automatic-refresh operations occurring at the same time as the manual-refresh operations?
What is the effect of using FORCE = TRUE in a COPY INTO < table > command?
A Snowflake user is trying to load a 125 GB file using SnowSQL. The file continues to load for almost an entire day. What will happen at the 2 < hour mark?
What is the relationship between a Query Profile and a virtual warehouse?
What objects in Snowflake are supported by Dynamic Data Masking? (Select TWO). '
What is the purpose of the STRIP NULL_VALUES file format option when loading semi-structured data files into Snowflake?
A column named " Data " contains VARIANT data and stores values as follows:
How will Snowflake extract the employee ' s name from the column data?
What function can be used with the recursive argument to return a list of distinct key names in all nested elements in an object?
For which use cases is running a virtual warehouse required? (Select TWO).
What is the minimum Snowflake Edition that supports secure storage of Protected Health Information (PHI) data?
Who can activate and enforce a network policy for all users in a Snowflake account? (Select TWO).
Which statistics are displayed in a Query Profile that indicate that intermediate results do not fit in memory? (Select TWO).
What happens when a Snowflake user changes the data retention period at the schema level?
Which Snowflake data types can be used to build nested hierarchical data? (Select TWO)
When using the ALLOW CLIENT_MFA_CACHING parameter, how long is a cached Multi-Factor Authentication (MFA) token valid for?
A JSON file, that contains lots of dates and arrays, needs to be processed in Snowflake. The user wants to ensure optimal performance while querying the data.
How can this be achieved?
How can performance be optimized for a query that returns a small amount of data from a very large base table?
What metadata does Snowflake store for rows in micro-partitions? (Select TWO).
What will prevent unauthorized access to a Snowflake account from an unknown source?
Which Snowflake feature allows administrators to identify unused data that may be archived or deleted?
Which Snowflake database object can be used to track data changes made to table data?
What happens to the objects in a reader account when the DROP MANAGED ACCOUNT command is executed?
What are the least privileges needed to view and modify resource monitors? (Select TWO).
What information is found within the Statistic output in the Query Profile Overview?
What tasks can an account administrator perform in the Data Exchange? (Select TWO).
Which solution improves the performance of point lookup queries that return a small number of rows from large tables using highly selective filters?
A tag object has been assigned to a table (TABLE_A) in a schema within a Snowflake database.
Which CREATE object statement will automatically assign the TABLE_A tag to a target object?
Which commands are restricted in owner ' s rights stored procedures? (Select TWO).
Which metadata table will store the storage utilization information even for dropped tables?
When working with a managed access schema, who has the OWNERSHIP privilege of any tables added to the schema?
Which Snowflake feature provides increased login security for users connecting to Snowflake that is powered by Duo Security service?
Which Snowflake command can be used to unload the result of a query to a single file?
Which command is used to unload data from a Snowflake database table into one or more files in a Snowflake stage?
A Snowflake account has activated federated authentication.
What will occur when a user with a password that was defined by Snowflake attempts to log in to Snowflake?
Which privilege must be granted by one role to another role, and cannot be revoked?
What Snowflake feature provides a data hub for secure data collaboration, with a selected group of invited members?
A permanent table and temporary table have the same name, TBL1, in a schema.
What will happen if a user executes select * from TBL1 ;?
Which statements describe benefits of Snowflake ' s separation of compute and storage? (Select TWO).
Which VALIDATION_MODE value will return the errors across the files specified in a COPY command, including files that were partially loaded during an earlier load?
Regardless of which notation is used, what are considerations for writing the column name and element names when traversing semi-structured data?
Which Snowflake edition enables data sharing only through Snowflake Support?
Two users share a virtual warehouse named wh dev 01. When one of the users loads data, the other one experiences performance issues while querying data.
How does Snowflake recommend resolving this issue?
Which SQL command can be used to see the CREATE definition of a masking policy?
Which of the following is the Snowflake Account_Usage.Metering_History view used for?
What is the purpose of using the OBJECT_CONSTRUCT function with me COPY INTO command?
How often are the Account and Table master keys automatically rotated by Snowflake?
Which kind of Snowflake table stores file-level metadata for each file in a stage?
Which Snowflake feature will allow small volumes of data to continuously load into Snowflake and will incrementally make the data available for analysis?
What is the recommended way to change the existing file format type in my format from CSV to JSON?
What type of columns does Snowflake recommend to be used as clustering keys? (Select TWO).
Which features could be used to improve the performance of queries that return a small subset of rows from a large table? (Select TWO).
What column type does a Kafka connector store formatted information in a single column?
Which operations are handled in the Cloud Services layer of Snowflake? (Select TWO).
Which feature allows a user the ability to control the organization of data in a micro-partition?
By definition, a secure view is exposed only to users with what privilege?
Which pages are included in the Activity area of Snowsight? (Select TWO).
A user has a standard multi-cluster warehouse auto-scaling policy in place.
Which condition will trigger a cluster to shut-down?
Which Snowflake objects can be shared with other Snowflake accounts? (Choose three.)
How can a Snowflake user access a JSON object, given the following table? (Select TWO).
A user needs to create a materialized view in the schema MYDB.MYSCHEMA. Which statements will provide this access?
Query parsing and compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?
Which command is used to unload files from an internal or external stage to a local file system?
Which statements reflect key functionalities of a Snowflake Data Exchange? (Choose two.)
A company needs to read multiple terabytes of data for an initial load as part of a Snowflake migration. The company can control the number and size of CSV extract files.
How does Snowflake recommend maximizing the load performance?
What is used to diagnose and troubleshoot network connections to Snowflake?
How does Snowflake allow a data provider with an Azure account in central Canada to share data with a data consumer on AWS in Australia?
How does Snowflake handle the bulk unloading of data into single or multiple files?
When should a user consider disabling auto-suspend for a virtual warehouse? (Select TWO).
Network policies can be applied to which of the following Snowflake objects? (Choose two.)
Which privilege is required for a role to be able to resume a suspended warehouse if auto-resume is not enabled?
Which statement accurately describes a characteristic of a materialized view?
If a virtual warehouse runs for 61 seconds, shuts down, and then restarts and runs for 30 seconds, for how many seconds is it billed?
What is the minimum Snowflake edition needed for database failover and fail-back between Snowflake accounts for business continuity and disaster recovery?
What privilege should a user be granted to change permissions for new objects in a managed access schema?
Which clients does Snowflake support Multi-Factor Authentication (MFA) token caching for? (Select TWO).
If a Snowflake user decides a table should be clustered, what should be used as the cluster key?
Data storage for individual tables can be monitored using which commands and/or objects? (Choose two.)
A data provider wants to share data with a consumer who does not have a Snowflake account. The provider creates a reader account for the consumer following these steps:
1. Created a user called " CONSUMER "
2. Created a database to hold the share and an extra-small warehouse to query the data
3. Granted the role PUBLIC the following privileges: Usage on the warehouse, database, and schema, and SELECT on all the objects in the share
Based on this configuration what is true of the reader account?
How can a user improve the performance of a single large complex query in Snowflake?
Which of the following are considerations when using a directory table when working with unstructured data? (Choose two.)
What is the difference between a stored procedure and a User-Defined Function (UDF)?
Where would a Snowflake user find information about query activity from 90 days ago?
Which of the following describes how multiple Snowflake accounts in a single organization relate to various cloud providers?
Which is the MINIMUM required Snowflake edition that a user must have if they want to use AWS/Azure Privatelink or Google Cloud Private Service Connect?
A user has 10 files in a stage containing new customer data. The ingest operation completes with no errors, using the following command:
COPY INTO my__table FROM @my__stage;
The next day the user adds 10 files to the stage so that now the stage contains a mixture of new customer data and updates to the previous data. The user did not remove the 10 original files.
If the user runs the same copy into command what will happen?
A marketing co-worker has requested the ability to change a warehouse size on their medium virtual warehouse called mktg__WH.
Which of the following statements will accommodate this request?
What happens when an external or an internal stage is dropped? (Select TWO).
During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?
Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)
A user has an application that writes a new Tile to a cloud storage location every 5 minutes.
What would be the MOST efficient way to get the files into Snowflake?
True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.
Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?
True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.
What is the default character set used when loading CSV files into Snowflake?
What is the default File Format used in the COPY command if one is not specified?
A company strongly encourages all Snowflake users to self-enroll in Snowflake ' s default Multi-Factor Authentication (MFA) service to provide increased login security for users connecting to Snowflake.
Which application will the Snowflake users need to install on their devices in order to connect with MFA?
What Snowflake role must be granted for a user to create and manage accounts?
User-level network policies can be created by which of the following roles? (Select TWO).
Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)
A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip__outer_array file format option
What does the STRIP_OUTER_ARRAY file format do?
What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?
Which of the following objects can be shared through secure data sharing?
Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).
When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of Queries are always queuing in the warehouse
According to recommended best practice, what should be done to reduce the Queue volume? (Select TWO).
Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).
True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.
In which scenarios would a user have to pay Cloud Services costs? (Select TWO).
Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?
Which of the following compute resources or features are managed by Snowflake? (Select TWO).
A virtual warehouse ' s auto-suspend and auto-resume settings apply to which of the following?
What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)
Which Snowflake technique can be used to improve the performance of a query?
What SQL command would be used to view all roles that were granted to user.1?
TESTED 24 Jun 2026
