SnowPro Core Certification 2026 Exam
Last Update Jul 14, 2026
Total Questions : 1120
We are offering FREE COF-C03 Snowflake exam questions. All you do is to just go and sign up. Give your details, prepare COF-C03 free exam questions and then go for complete pool of SnowPro Core Certification 2026 Exam test questions that will help you more.
Which command is used to start configuring Snowflake for Single Sign-On (SSO)?
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?
Which TABLE function helps to convert semi-structured data to a relational representation?
How can a user improve the performance of a single large complex query in Snowflake?
Which of the following are handled by the cloud services layer of the Snowflake architecture? (Choose two.)
Which of the following practices are recommended when creating a user in Snowflake? (Choose 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 table objects can be shared with other accounts? (Select TWO).
Which function is used to convert rows in a relational table to a single VARIANT column?
Credit charges for Snowflake virtual warehouses are calculated based on which of the following considerations? (Choose two.)
What MINIMUM privilege is required on the external stage for any role in the GET REST API to access unstructured data files using a file URL?
A materialized view should be created when which of the following occurs? (Choose two.)
A tabular User-Defined Function (UDF) is defined by specifying a return clause that contains which keyword?
If queries start to queue in a multi-cluster virtual warehouse, an additional compute cluster starts immediately under what setting?
What is the difference between a stored procedure and a User-Defined Function (UDF)?
Which command should be used to load data incrementally based on column values that are specified in the source table or subquery?
Which of the following can be used when unloading data from Snowflake? (Choose two.)
What can a Snowflake user do with the information included in the details section of a Query Profile?
Which URL type allows users to access unstructured data without authenticating into Snowflake or passing an authorization token?
Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?
Which clients does Snowflake support Multi-Factor Authentication (MFA) token caching for? (Select TWO).
What is the MINIMUM Snowflake edition required to use the periodic rekeying of micro-partitions?
What is the minimum Snowflake edition needed for database failover and fail-back between Snowflake accounts for business continuity and disaster recovery?
What is the MINIMUM Snowflake edition that supports the periodic rekeying of encrypted data?
Which function will return the URL for an external stage by using the stage name as the input?
If a column contains float values that are greater than (15,9) and the values need to be preserved when unloading data, what data file format should be used?
Which function should be used to insert JSON format string data inot a VARIANT field?
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?
What is the recommended compressed file size range for continuous data loads using Snowpipe?
What privilege should a user be granted to change permissions for new objects in a managed access schema?
What statistical information in a Query Profile indicates that the query is too large to fit in memory? (Select TWO).
When unloading to a stage, which of the following is a recommended practice or approach?
What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)
A user unloaded a Snowflake table called mytable to an internal stage called mystage.
Which command can be used to view the list of files that has been uploaded to the staged?
What are two ways to create and manage Data Shares in Snowflake? (Choose two.)
User-level network policies can be created by which of the following roles? (Select TWO).
What is the MINIMUM edition of Snowflake that is required to use a SCIM security integration?
Which of the following are best practices for loading data into Snowflake? (Choose three.)
Which tool or service can be used to graphically explore and manage data stored within a Snowflake account, including databases, tables, and views?
Which Snowflake tool provides detailed execution statistics of a query with no cost to the user?
A Query Profile for a query that took 10 minutes shows that 2 GB of data was spilled to storage.
Why is the query taking so long, and what should be done to improve its performance?
Which data types are supported by the Search Optimization Service? Select TWO.
Dynamic Data Masking can be used with which Snowflake objects? (Select TWO)
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)
In which scenarios would a user have to pay Cloud Services costs? (Select TWO).
Which authentication method requires access to a secure file that is only stored on the user ' s local device?
A table is created with a column set to a data type of CHARACTER(25). If the table is viewed in the database section of Snowsight, what data type will be shown for the column?
What is the maximum total Continuous Data Protection (CDP) charges incurred for a temporary table?
If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?
Assume there is a table consisting of five micro-partitions with values ranging from A to Z.
Which diagram indicates a well-clustered table?
Which statements are correct concerning the leveraging of third-party data from the Snowflake Data Marketplace? (Choose two.)
Which snowflake objects will incur both storage and cloud compute charges? (Select TWO)
What are supported file formats for unloading data from Snowflake? (Choose three.)
In the Snowflake access control model, which entity owns an object by default?
In an auto-scaling multi-cluster virtual warehouse with the setting SCALING_POLICY = ECONOMY enabled, when is another cluster started?
What are the correct parameters for time travel and fail-safe in the Snowflake Enterprise Edition?
A user is preparing to load data from an external stage
Which practice will provide the MOST efficient loading performance?
Which of the following objects can be directly restored using the UNDROP command? (Choose two.)
What are the responsibilities of Snowflake ' s Cloud Service layer? (Choose three.)
A user created a new worksheet within the Snowsight Ul and wants to share this with teammates
How can this worksheet be shared?
What is the minimum Snowflake edition required to use Dynamic Data Masking?
Which of the following significantly improves the performance of selective point lookup queries on a table?
The Snowflake Cloud Data Platform is described as having which of the following architectures?
What is the minimum Snowflake edition that has column-level security enabled?
What versions of Snowflake should be used to manage compliance with Personal Identifiable Information (PII) requirements? (Choose two.)
What feature can be used to reorganize a very large table on one or more columns?
Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)
A user has unloaded data from Snowflake to a stage
Which SQL command should be used to validate which data was loaded into the stage?
In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)
What is the minimum Snowflake edition required to create a materialized view?
Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?
Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)
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 SQL command would be used to view all roles that were granted to user.1?
Which data types does Snowflake support when querying semi-structured data? (Select TWO)
What is the default character set used when loading CSV files into Snowflake?
Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).
Which semi-structured file formats are supported when unloading data from a table? (Select TWO).
A virtual warehouse ' s auto-suspend and auto-resume settings apply to which of the following?
Which command can be used to stage local files from which Snowflake interface?
What types of data listings are available in the Snowflake Data Marketplace? (Choose two.)
Which SQL commands, when committed, will consume a stream and advance the stream offset? (Choose two.)
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?
What actions will prevent leveraging of the ResultSet cache? (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?
What is the maximum Time Travel retention period for a temporary Snowflake table?
A user has unloaded data from a Snowflake table to an external stage.
Which command can be used to verify if data has been uploaded to the external stage named my_stage?
Which services does the Snowflake Cloud Services layer manage? (Choose two.)
Which of the following statements apply to Snowflake in terms of security? (Choose two.)
Which of the following are characteristics of Snowflake virtual warehouses? (Choose two.)
What is the following SQL command used for?
Select * from table(validate(t1, job_id = > ' _last ' ));
Which statements are true concerning Snowflake ' s underlying cloud infrastructure? (Select THREE),
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 Snowflake function will interpret an input string as a JSON document, and produce a VARIANT value?
How should a virtual warehouse be configured if a user wants to ensure that additional multi-clusters are resumed with no delay?
Which command should be used to load data from a file, located in an external stage, into a table in Snowflake?
What happens to the shared objects for users in a consumer account from a share, once a database has been created in that account?
If a Snowflake user decides a table should be clustered, what should be used as the cluster key?
Which Snowflake architectural layer is responsible for a query execution plan?
Which Snowflake layer is always leveraged when accessing a query from the result cache?
What occurs when a pipe is recreated using the CREATE OR REPLACE PIPE command?
When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?
True or False: Snowpipe via REST API can only reference External Stages as source.
User INQUISITIVE_PERSON has been granted the role DATA_SCIENCE. The role DATA_SCIENCE has privileges OWNERSHIP on the schema MARKETING of the database ANALYTICS_DW.
Which command will show all privileges granted to that schema?
What service is provided as an integrated Snowflake feature to enhance Multi-Factor Authentication (MFA) support?
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?
Which of the following objects can be shared through secure data sharing?
Which Snowflake objects can be shared with other Snowflake accounts? (Choose three.)
A Snowflake user has two tables that contain numeric values and is trying to find out which values are present in both tables. Which set operator should be used?
How does Snowflake handle the bulk unloading of data into single or multiple files?
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?
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?
What column type does a Kafka connector store formatted information in a single column?
Which stages are used with the Snowflake PUT command to upload files from a local file system? (Choose three.)
What is a machine learning and data science partner within the Snowflake Partner Ecosystem?
What is the default File Format used in the COPY command if one is not specified?
What Snowflake role must be granted for a user to create and manage accounts?
What are ways to create and manage data shares in Snowflake? (Select TWO)
Which metrics in the QUERY_HISTORY Account_Usage View can be used to assess the pruning efficiency of a query? (Select TWO).
What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....) statement? (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?
Which command is used to unload data from a Snowflake table into a file in a stage?
Which of the following conditions must be met in order to return results from the results cache? (Select TWO).
Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)
A user needs to create a materialized view in the schema MYDB.MYSCHEMA.
Which statements will provide this access?
A Snowflake user is creating a deployment pipeline for Snowflake objects.
What interface should be used to automate object deployment?
A Snowflake user needs to share a data set and wants it to be available to any Snowflake account that resides in the same cloud region. What is the recommended way to do this?
Which of the following Snowflake objects can be shared using a secure share? (Select TWO).
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?
Query compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?
True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.
In Snowflake ' s data security framework, how does column-level security contribute to the protection of sensitive information? (Select TWO).
Which data sharing mechanism can be used to share data privately or publicly within the Snowflake Marketplace?
Which types of values lead to slower queries and increased storage consumption when placed within a VARIANT column? Select TWO.
When regularly unloading similarly formatted semi-structured data, where should copy options be specified?
A Snowflake Practitioner manages a database called SALES_DB. This database has a PUBLIC schema and an ORDERS table that is updated frequently. The database has a data retention period of 7 days. On November 16, 2025, at 3:00 PM, the Practitioner accidentally ran a DELETE command that removed all records from the ORDERS table. Which statement will recover all deleted records?
How should a data provider securely share Snowflake objects with a data consumer who does not have a Snowflake account?
Which statement can be used to create a point-in-time, zero-copy snapshot of a table named Cable?
Which function can be used to convert semi-structured data into rows and columns?
Which Snowflake table stores file-level metadata about unstructured data files in a stage, including size, last-modified timestamp, and Snowflake file URL?
Which security feature supports the replacement of active keys to enhance key-pair authentication?
The following settings are configured:
THE MIN_DATA_RETENTION_TIME_IN_DAYS is set to 5 at the account level.
THE DATA_RETENTION_TIME_IN_DAYS is set to 2 at the object level.
For how many days will the data be retained at the object level?
A Snowflake user accidentally deleted a table. The table no longer exists, but the session is within the data retention period. How can the table be restored using the LEAST amount of operational overhead?
What type of queries will benefit from the search optimization service when using equality predicates?
What is a non-configurable feature that provides historical data that Snowflake may recover during a 7-day period?
What action should be taken if a Snowflake user wants to share a newly created object in a database with consumers?
What common query issues can be identified using the Query Profile? (Select TWO)
What is the MINIMUM Snowflake edition required to use a dedicated metadata store?
Using which feature or object will temporarily scale virtual warehouses running costly queries?
When will Snowflake charge credits for the use of the Cloud Services layer?
What is the effect of using FORCE = TRUE in a COPY INTO < table > command?
Which steps will reduce memory spillage when running a very large query? (Select TWO)
What is the default access of a securable object until other access is granted?
While preparing to unload data in Snowflake, the file format option can be specified in which commands? (Select TWO).
Which COPY INTO < table > parameter setting should be used to prevent a partial data load when an error is encountered?
How does Snowflake support the use of structured and semi-structured data? (Select TWO)
Which view in SNOWFLAKE.ACCOUNT_USAGE shows from which IP address a user connected to Snowflak?
How does an authentication policy affect security in a Snowflake account?
A user needs to automatically retrieve Iceberg column definitions using the INFER_SCHEMA function for semi-structured files stored on a stage. Which file format configuration will help them achieve this?
Which command will identify the names of files that are in a Snowflake stage?
In addition to performing all the standard steps to share data, which privilege must be granted on each database referenced by a secure view in order to be shared?
What will happen to partitions if a table is cloned and the original table type is then changed from permanent to transient?
Which Snowflake mechanism is used to limit the number of micro-partitions scanned by a query?
Which COPY INTO < location > command options impact the number of files generated? Select TWO.
Which role has the ability to create a share from a shared database by default?
What is the Fail-safe retention period for transient and temporary tables?
Regardless of which notation is used, what are considerations for writing the column name and element names when traversing semi-structured data?
Which view can be used to determine if a table has frequent row updates or deletes?
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?
For Directory tables, what stage allows for automatic refreshing of metadata?
The VALIDATE table function has which parameter as an input argument for a Snowflake user?
What will happen if a Snowflake user increases the size of a suspended virtual warehouse?
What criteria does Snowflake use to determine the current role when initiating a session? (Select TWO).
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?
What are valid sub-clauses to the OVER clause for a window function? (Select TWO).
What should be used when creating a CSV file format where the columns are wrapped by single quotes or double quotes?
Which file function generates a SnowFlake-hosted URL that must be authenticated when used?
By default, how long is the standard retention period for Time Travel across all Snowflake accounts?
A user wants to add additional privileges to the system-defined roles for their virtual warehouse. How does Snowflake recommend they accomplish this?
What does the worksheet and database explorer feature in Snowsight allow users to do?
A Snowflake user executed a query and received the results. Another user executed the same query 4 hours later. The data had not changed.
What will occur?
What is the MAXIMUM number of clusters that can be provisioned with a multi-cluster virtual warehouse?
Which privilege is required for a role to be able to resume a suspended warehouse if auto-resume is not enabled?
Which data formats are supported by Snowflake when unloading semi-structured data? (Select TWO).
How long is a query visible in the Query History page in the Snowflake Web Interface (Ul)?
Which SQL command can be used to verify the privileges that are granted to a role?
What is the only supported character set for loading and unloading data from all supported file formats?
By default, which role has access to the SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER function?
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?
Which Snowflake edition offers the highest level of security for organizations that have the strictest requirements?
When using the ALLOW_CLI£NT_MFA_CACHING parameter, how long is a cached Multi-Factor Authentication (MFA) token valid for?
What is the default value in the Snowflake Web Interface (Ul) for auto suspending a Virtual Warehouse?
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?
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?
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 function will provide the proxy information needed to protect Snowsight?
Why would a Snowflake user decide to use a materialized view instead of a regular view?
While clustering a table, columns with which data types can be used as clustering keys? (Select TWO).
When referring to User-Defined Function (UDF) names in Snowflake, what does the term overloading mean?
How does a Snowflake stored procedure compare to a User-Defined Function (UDF)?
Which table type exists only within the session it was created and is only visible to the user who created it?
How does a Snowflake user extract the URL of a directory table on an external stage for further transformation?
Which common query problems are identified by the Query Profile? (Select TWO.)
Which file format will keep floating-point numbers from being truncated when data is unloaded?
What SnowFlake database object is derived from a query specification, stored for later use, and can speed up expensive aggregation on large data sets?
Which privilege is required to use the search optimization service in Snowflake?
Which command should be used to unload all the rows from a table into one or more files in a named stage?
What information is found within the Statistic output in the Query Profile Overview?
What happens when a Snowflake user changes the data retention period at the schema level?
What feature of Snowflake Continuous Data Protection can be used for maintenance of historical data?
When using the ALLOW CLIENT_MFA_CACHING parameter, how long is a cached Multi-Factor Authentication (MFA) token valid for?
Which Snowflake command can be used to unload the result of a query to a single file?
A Snowflake user has been granted the create data EXCHANGE listing privilege with their role.
Which tasks can this user now perform on the Data Exchange? (Select TWO).
Which metadata table will store the storage utilization information even for dropped tables?
Which data types can be used in Snowflake to store semi-structured data? (Select TWO)
Which stream type can be used for tracking the records in external tables?
Which commands are restricted in owner ' s rights stored procedures? (Select TWO).
What is the minimum Snowflake Edition that supports secure storage of Protected Health Information (PHI) data?
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?
What is the relationship between a Query Profile and a virtual warehouse?
Which solution improves the performance of point lookup queries that return a small number of rows from large tables using highly selective filters?
Which Snowflake function is maintained separately from the data and helps to support features such as Time Travel, Secure Data Sharing, and pruning?
Which parameter can be set at the account level to set the minimum number of days for which Snowflake retains historical data in Time Travel?
What transformations are supported when loading data into a table using the COPY INTO < table > command? (Select TWO).
Which Snowflake feature will allow small volumes of data to continuously load into Snowflake and will incrementally make the data available for analysis?
What objects in Snowflake are supported by Dynamic Data Masking? (Select TWO). '
Which statistics are displayed in a Query Profile that indicate that intermediate results do not fit in memory? (Select TWO).
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?
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?
What tasks can an account administrator perform in the Data Exchange? (Select TWO).
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?
How can performance be optimized for a query that returns a small amount of data from a very large base table?
Which Snowflake role can manage any object grant globally, including modifying and revoking grants?
What are key characteristics of virtual warehouses in Snowflake? (Select TWO).
When enabling access to unstructured data, which URL permits temporary access to a staged file without the need to grant privileges to the stage or to issue access tokens?
Which statistics can be used to identify queries that have inefficient pruning? (Select TWO).
What is the most efficient method to share a subset of data from a table with a consumer account?
How can a Snowflake user validate data that is unloaded using the COPY INTO < location > command?
What are the least privileges needed to view and modify resource monitors? (Select TWO).
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 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?
Query parsing and compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?
How can a data provider ensure that a data consumer is going to have access to the required objects?
TESTED 14 Jul 2026
