Apr 04, 2026 Updated COF-C02 Dumps Questions For Snowflake Exam
Best Value Available Preparation Guide for COF-C02 Exam
Snowflake COF-C02 (SnowPro Core Certification) Exam covers a wide range of topics, including Snowflake architecture, data loading and unloading techniques, security and access control, and query optimization. COF-C02 exam is divided into multiple sections, each of which focuses on a different aspect of the Snowflake platform. COF-C02 exam comprises of 70 multiple-choice questions that need to be answered within 90 minutes. COF-C02 exam is available in multiple languages, including English, Japanese, and German.
NEW QUESTION # 565
True or False: You can resize a Virtual Warehouse while queries are running.
- A. False
- B. True
Answer: B
NEW QUESTION # 566
Which property or parameter can be used to temporarily disable Multi-Factor Authentication (MFA) for a Snowflake user?
- A. EXT_AUTHN_DUO
- B. MINS_TO_BYPASS_MFA
- C. ALLOW_CLIENT_MFA_CACHING
- D. DISABLE_MFA
Answer: B
Explanation:
* The MINS_TO_BYPASS_MFA property can temporarily disable Multi-Factor Authentication (MFA) for a user, allowing them to log in without providing an MFA code for a specific duration (in minutes).
* Example:
ALTER USER my_user SET MINS_TO_BYPASS_MFA = 10;
References:
* Snowflake Documentation: Multi-Factor Authentication
NEW QUESTION # 567
What Snowflake objects can contain custom application logic written in JavaScript? (Select TWO)
- A. Stored procedures
- B. Tasks
- C. User-Defined Functions (UDFs)
- D. Stages
- E. Views
Answer: A,C
Explanation:
Snowflake allows users to write custom application logic in JavaScript for two types of objects: Stored Procedures and User-Defined Functions (UDFs).
* Stored Procedures:Snowflake stored procedures can be written in JavaScript to encapsulate complex business logic and procedural operations.
CREATE OR REPLACE PROCEDURE my_procedure()
RETURNS STRING
LANGUAGE JAVASCRIPT
EXECUTE AS CALLER
AS
$$
// JavaScript logic here
$$;
* User-Defined Functions (UDFs):Snowflake UDFs can be written in JavaScript to perform custom calculations or operations on data.
CREATE OR REPLACE FUNCTION my_function(x FLOAT)
RETURNS FLOAT
LANGUAGE JAVASCRIPT
AS
$$
return x * 2;
$$;
References:
* Snowflake Documentation: Stored Procedures
* Snowflake Documentation: User-Defined Functions (UDFs)
NEW QUESTION # 568
Which data formats are supported by Snowflake when unloading semi-structured data? (Select TWO).
- A. Binary file in Parquet
- B. Newline Delimited JSON
- C. Plain text file containing XML elements
- D. Binary file in Avro
- E. Comma-separated JSON
Answer: A,B
Explanation:
Snowflake supports a variety of file formats for unloading semi-structured data, among which Parquet and Newline Delimited JSON (NDJSON) are two widely used formats.
* B. Binary file in Parquet: Parquet is a columnar storage file format optimized for large-scale data processing and analysis. It is especially suited for complex nested data structures.
* D. Newline Delimited JSON (NDJSON): This format represents JSON records separated by newline characters, facilitating the storage and processing of multiple, separate JSON objects in a single file.
These formats are chosen for their efficiency and compatibility with data analytics tools and ecosystems, enabling seamless integration and processing of exported data.
References:
* Snowflake Documentation: Data Unloading
NEW QUESTION # 569
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. select dealership from car_sales;
- B. select src.dealership from car_sales;
- C. select src:dealership from car_sales;
- D. select src:Dealership from car_sales;
Answer: B
Explanation:
In Snowflake, to extract a specific element from a JSON stored in a VARIANT column, the correct syntax is to use the dot notation. Therefore, the query select src.dealership from car_sales; will return the dealership information contained within each JSON object in the src column.
References: For a detailed explanation, please refer to the Snowflake documentation on querying semi- structured data.
NEW QUESTION # 570
If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: A
Explanation:
Explanation
Size specifies the amount of compute resources available per cluster in a warehouse. Snowflake supports the following warehouse sizes:
https://docs.snowflake.com/en/user-guide/warehouses-overview.html
NEW QUESTION # 571
If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: A
Explanation:
In Snowflake, each size increase in virtual warehouses doubles the number of servers. Therefore, if a sizeSmall virtual warehouse is made up of two servers, a Large warehouse, which is two sizes larger, would be made up of eight servers (2 servers for Small, 4 for Medium, and 8 for Large)2.
Size specifies the amount of compute resources available per cluster in a warehouse. Snowflake supports the following warehouse sizes:
https://docs.snowflake.com/en/user-guide/warehouses-overview.html
NEW QUESTION # 572
When creating a user it is advisable sable to: Choose 2 answers
- A. Set the user to be initially disabled
- B. Force an immediate password change
- C. Set the users access to expire within a specified timeframe
- D. Set a default role for the user
- E. Set the number of minutes to unlock to 15 minutes
Answer: B,D
NEW QUESTION # 573
Which command can be used to list all the file formats for which a user has access privileges?
- A. LIST
- B. SHOW FILE FORMATS
- C. DESCRIBE FILE FORMAT
- D. ALTER FILE FORMAT
Answer: B
Explanation:
The command to list all the file formats for which a user has access privileges in Snowflake is SHOW FILE FORMATS. This command provides a list of all file formats defined in the user's current session or specified database/schema, along with details such as the name, type, and creation time of each file format. It is a valuable tool for users to understand and manage the file formats available for data loading and unloading operations.
Reference:
Snowflake Documentation: SHOW FILE FORMATS
NEW QUESTION # 574
What transformations are supported when loading data into a table using the COPY INTO <table> command?
(Select TWO).
- A. Column reordering
- B. Column omission
- C. FLATTEN function
- D. JOIN function
- E. GROUP BY function
Answer: A,B
Explanation:
The COPY INTO <table> command in Snowflake supports column reordering and column omission as part of its data transformation capabilities during the load process45.
NEW QUESTION # 575
Which Snowflake object can be used to record DML changes made to a table?
- A. Snowpipe
- B. Stream
- C. Stage
- D. Task
Answer: B
Explanation:
Snowflake Streams are used to track and record Data Manipulation Language (DML) changes made to a table.
Streams capture changes such as inserts, updates, and deletes, which can then be processed by other Snowflake objects or external applications.
* Creating a Stream:
CREATE OR REPLACE STREAM my_stream ON TABLE my_table;
* Using Streams:Streams provide a way to process changes incrementally, making it easier to build efficient data pipelines.
* Consuming Stream Data:The captured changes can be consumed using SQL queries or Snowflake tasks.
References:
* Snowflake Documentation: Using Streams
* Snowflake Documentation: Change Data Capture (CDC) with Streams
NEW QUESTION # 576
Which function should be used to insert JSON format string data inot a VARIANT field?
- A. PARSE_JSOK
- B. TO_VARIANT
- C. CHECK_JSON
- D. FLATTEN
Answer: A
NEW QUESTION # 577
What operations can be performed while loading a simple CSV file into a Snowflake table using the COPY INTO command? (Select TWO).
- A. Grouping by operations
- B. Selecting the first few rows
- C. Converting the datatypes
- D. Performing aggregate calculations
- E. Reordering the columns
Answer: C,E
NEW QUESTION # 578
The Snowflake cloud services layer is responsible for which tasks? (Choose two.)
- A. Database storage
- B. Authentication and access control
- C. Metadata management
- D. Local disk caching
- E. Query processing
Answer: C,E
NEW QUESTION # 579
Which statistics can be used to identify queries that have inefficient pruning? (Select TWO).
- A. Bytes scanned
- B. Percentage scanned from cache
- C. Partitions total
- D. Partitions scanned
- E. Bytes written to result
Answer: C,D
Explanation:
The statistics that can be used to identify queries with inefficient pruning are 'Partitions scanned' and
'Partitions total'. These statistics indicate how much of the data was actually needed and scanned versus the total available, which can highlight inefficiencies in data pruning34.
NEW QUESTION # 580
What is the MINIMUM permission needed to access a file URL from an external stage?
- A. READ
- B. MODIFY
- C. USAGE
- D. SELECT
Answer: C
Explanation:
To access a file URL from an external stage in Snowflake, the minimum permission required is USAGE on the stage object. USAGE permission allows a user to reference the stage in SQL commands, necessary for actions like listing files or loading data from the stage, but does not permit the user to alter or drop the stage.
References:
* Snowflake Documentation: Access Control
NEW QUESTION # 581
What does a table with a clustering depth of 1 mean in Snowflake?
- A. The table has no overlapping micro-partitions.
- B. The table has only 1 micro-partition.
- C. The table has no micro-partitions.
- D. The table has 1 overlapping micro-partition.
Answer: A
Explanation:
In Snowflake, a table's clustering depth indicates the degree of micro-partition overlap based on the clustering keys defined for the table. A clustering depth of 1 implies that the table has no overlapping micro-partitions.
This is an optimal scenario, indicating that the table's data is well-clustered according to the specified clustering keys. Well-clustered data can lead to more efficient query performance, as it reduces the amount of data scanned during query execution and improves the effectiveness of data pruning.
References:
* Snowflake Documentation on Clustering: Understanding Clustering Depth
NEW QUESTION # 582
What do temporary and transient tables have m common in Snowflake? (Select TWO).
- A. Both tables have data retention period maximums of one day.
- B. Both tables are visible only to a single user session.
- C. For both tables the retention period ends when the tables are dropped.
- D. For both tables, the retention period does not end when the session ends
- E. Both tables have no Fail-safe period.
Answer: C,E
Explanation:
Temporary and transient tables in Snowflake share several characteristics, notably, neither table type has a Fail-safe period. Fail-safe is a feature that provides additional data protection beyond the Time Travel period. However, this feature does not apply to temporary or transient tables. Additionally, for both types of tables, the data retention period effectively ends when the tables are dropped. This means that once these tables are deleted, their data is not recoverable, distinguishing them from permanent tables, which benefit from Snowflake's Time Travel and Fail-safe features.
Reference: Snowflake Documentation on Table Types
NEW QUESTION # 583
Which of the following statements apply to Snowflake in terms of security? (Choose two.)
- A. All data in Snowflake is encrypted.
- B. Snowflake can run within a user's own Virtual Private Cloud (VPC).
- C. Snowflake leverages a Role-Based Access Control (RBAC) model.
- D. Snowflake requires a user to configure an IAM user to connect to the database.
- E. All data in Snowflake is compressed.
Answer: A,C
Explanation:
Snowflake uses a Role-Based Access Control (RBAC) model to manage access to data and resources.
Additionally, Snowflake ensures that all data is encrypted, both at rest and in transit, to provide a high level of security for data stored within the platform. References: [COF-C02] SnowPro Core Certification Exam Study Guide
NEW QUESTION # 584
Which function returns an integer between 0 and 100 when used to calculate the similarity of two strings?
- A. MINHASH COMBINE
- B. APPROXIMATE_JACCARD_INDEX
- C. APPROXIMATE_SIMILARITY
- D. JAROWINKLER_SIMILARITY
Answer: D
Explanation:
TheJAROWINKLER_SIMILARITYfunction in Snowflake returns an integer between 0 and 100, indicating the similarity of two strings based on the Jaro-Winkler similarity algorithm. This function is useful for comparing strings and determining how closely they match each other.
Understanding JAROWINKLER_SIMILARITY:The Jaro-Winkler similarity metric is a measure of similarity between two strings. The score is a number between 0 and 100, where 100 indicates an exact match and lower scores indicate less similarity.
Usage Example:To compare two strings and get their similarity score, you can use:
SELECTJAROWINKLER_SIMILARITY('string1','string2')ASsimilarity_score;
Application Scenarios:This function is particularly useful in data cleaning, matching, and deduplication tasks where you need to identify similar but not identical strings, such as names, addresses, or product titles.
Reference:For more detailed information on theJAROWINKLER_SIMILARITYfunction and its usage, refer to the Snowflake documentation on string functions: https://docs.snowflake.com/en/sql-reference/functions
/jarowinkler_similarity.html
NEW QUESTION # 585
While unloading data into a stage, how can the user ensure that the output will be a single file?
- A. Use the GET option FILES-SINGLE.
- B. Use the copy option files=single.
- C. Use the COPY Option SINGLE=TRUE .
- D. Use the get option SINGLE-TRUE.
Answer: C
Explanation:
To ensure that the output will be a single file when unloading data into a stage, you should use the COPY option SINGLE=TRUE. This option specifies that the result of the COPY INTO command should be written to a single file, rather than multiple files.
:
Snowflake Documentation: COPY INTO <location>
NEW QUESTION # 586
Which role must be used to create resource monitors?
- A. SYSADMIN
- B. ORGADMIN
- C. SECURITYADMIN
- D. ACCOUNTADMIN
Answer: D
Explanation:
In Snowflake, the ACCOUNTADMIN role is required to create resource monitors. Resource monitors are used to manage and monitor the consumption of compute resources. The ACCOUNTADMIN role has the necessary privileges to create, configure, and manage resource monitors across the account.
References:
* Snowflake Documentation: Resource Monitors
NEW QUESTION # 587
......
Individuals can register for Snowflake COF-C02: SnowPro Core Certification Exam on the Snowflake website. COF-C02 exam is available online and can be taken from anywhere, at any time. The cost of the exam is $175 USD per attempt, and individuals must pass with a score of 80% or higher to earn the certification.
Full COF-C02 Practice Test and 975 Unique Questions, Get it Now!: https://www.practicematerial.com/COF-C02-exam-materials.html
The Best COF-C02 Exam Study Material Premium Files and Preparation Tool: https://drive.google.com/open?id=1EZoXjQ-duzoACbVJlS4miw1nlUeebIkF
