Apr-2026 Snowflake COF-C02 Certification Real 2026 Mock Exam
COF-C02 Exam Questions and Valid PMP Dumps PDF
NEW QUESTION # 404
Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?
- A. Pipe
- B. Stream
- C. External stage
- D. Task
Answer: A
Explanation:
Snowpipe enables loading data from files as soon as they're available in a stage. This means you can load data from files in micro-batches, making it available to users within minutes, rather than manually executing COPY statements on a schedule to load larger batches.
https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html
NEW QUESTION # 405
Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)
- A. Up to 90 days of data recovery through Time Travel
- B. Object-level access control
- C. Customer-managed encryption keys through Tri-Secret Secure
- D. Automatic encryption of all data
- E. Column-level security to apply data masking policies to tables and views
Answer: B,D
NEW QUESTION # 406
What are the responsibilities of Snowflake's Cloud Service layer? (Choose three.)
- A. Query parsing and optimization
- B. Virtual warehouse caching
- C. Authentication
- D. Resource management
- E. Query execution
- F. Physical storage of micro-partitions
Answer: A,C,D
Explanation:
The responsibilities of Snowflake's Cloud Service layer include authentication (A), which ensures secure access to the platform; resource management (B), which involves allocating and managing compute resources; and query parsing and optimization (D), which improves the efficiency and performance of SQL query execution3.
NEW QUESTION # 407
What compute resource is used when loading data using Snowpipe?
- A. Snowpipe uses an Apache Kafka server for its compute resources.
- B. Snowpipe uses cloud platform compute resources provided by the user.
- C. Snowpipe uses compute resources provided by Snowflake.
- D. Snowpipe uses virtual warehouses provided by the user.
Answer: C
NEW QUESTION # 408
What is the recommended way to change the existing file format type in my format from CSV to JSON?
- A. ALTER FILE FORMAT my format SWAP TYPE WITH JSON;
- B. CREATE OR REPLACE FILE FORMAT my format TYPE-JSON;
- C. REPLACE FILE FORMAT my format TYPE-JSON;
- D. ALTER FILE FORMAT my_format SET TYPE=JSON;
Answer: D
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 # 409
What affects whether the query results cache can be used?
- A. If the referenced data in the table has changed
- B. If multiple users are using the same virtual warehouse
- C. If the query contains a deterministic function
- D. If the virtual warehouse has been suspended
Answer: D
NEW QUESTION # 410
What are characteristics of transient tables in Snowflake? (Select TWO).
- A. Transient tables can be cloned to permanent tables.
- B. Transient tables can be altered to make them permanent tables.
- C. Transient tables persist until they are explicitly dropped.
- D. Transient tables have a Fail-safe period of 7 days.
- E. Transient tables have Time Travel retention periods of 0 or 1 day.
Answer: A,C
NEW QUESTION # 411
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?
- A. Query acceleration service
- B. Search optimization service
- C. Data classification
- D. Tagging
Answer: B
NEW QUESTION # 412
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. Compress the file and load the compressed file.
- B. Split the file into multiple files in the recommended size range (100 MB - 250 MB).
- C. Use a larger-sized warehouse.
- D. Set STRIP_OUTER_ARRAY=TRUE in the COPY INTO command.
Answer: B
Explanation:
The error "Max LOB size (16777216) exceeded" indicates that the size of the parsed column exceeds the maximum size allowed for a single column value in Snowflake, which is 16 MB. To resolve this issue, the file should be split into multiple smaller files that are within the recommended size range of 100 MB to 250 MB. This will ensure that each JSON document within the files is smaller than the maximum LOB size allowed. Compressing the file, using a larger-sized warehouse, or setting STRIP_OUTER_ARRAY=TRUE will not resolve the issue of the column size exceeding the maximum allowed. Reference: COPY INTO Error during Structured Data Load: "Max LOB size (16777216) exceeded..."
NEW QUESTION # 413
Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?
- A. Streams
- B. Pipes
- C. Tasks
- D. Procedures
Answer: A
Explanation:
https://dataterrain.com/how-to-change-tracking-using-table-streams-in-snowflake/#:~:text=A%20stream%20is%20a%20Snowflake,as%20metadata%20about%20each%20change.
NEW QUESTION # 414
True or False: It is possible to unload structured data to semi-structured formats such as JSON and parquet.
- A. True
- B. False
Answer: A
NEW QUESTION # 415
Snowflake's hierarchical key mode includes which keys? (Select TWO).
- A. File keys
- B. Schema master keys
- C. Secure view keys
- D. Account master keys
- E. Database master keys
Answer: A,D
Explanation:
Snowflake's hierarchical key model includes several levels of keys, where Account master keys and File keys are part of this hierarchy. Account master keys are used to encrypt all the data within an account, while File keys are used to encrypt individual files within the database2.
NEW QUESTION # 416
What is the MINIMUM Snowflake edition required to use the periodic rekeying of micro-partitions?
- A. Virtual Private Snowflake
- B. Business Critical
- C. Enterprise
- D. Standard
Answer: C
Explanation:
Periodic rekeying of micro-partitions is a feature that requires the Enterprise Edition of Snowflake or higher. This feature is part of Snowflake's comprehensive approach to encryption key management, ensuring data security through regular rekeying1. Reference: [COF-C02] SnowPro Core Certification Exam Study Guide
NEW QUESTION # 417
Which activities are included in the Cloud Services layer? {Select TWO).
- A. Dynamic data masking
- B. Infrastructure management
- C. Data storage
- D. User authentication
- E. Partition scanning
Answer: B,D
NEW QUESTION # 418
What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....) statement? (Select TWO.)
- A. Incoming data can be joined with other tables
- B. Data can be filtered by an optional where clause
- C. Row level access can be defined
- D. Columns can be omitted
- E. Columns can be reordered
Answer: B,D
Explanation:
In a CREATE PIPE ... AS COPY ... FROM (....) statement, the supported transformations include filtering data using an optional WHERE clause and omitting columns. The WHERE clause allows for the specification of conditions to filter the data that is being loaded, ensuring only relevant data is inserted into the table. Omitting columns enables the exclusion of certain columns from the data load, which can be useful when the incoming data contains more columns than are needed for the target table.
Reference:
[COF-C02] SnowPro Core Certification Exam Study Guide
Simple Transformations During a Load1
NEW QUESTION # 419
Which data types can be used in a Snowflake table that holds semi-structured data? (Select TWO).
- A. TEXT
- B. BINARY
- C. VARCHAK
- D. VARIANT
- E. ARRAY
Answer: D,E
Explanation:
Snowflake supports semi-structured data types that can store complex data structures within a single column.
The VARIANT data type can hold structured and semi-structured data formats such as JSON, Avro, ORC, Parquet, and XML. The ARRAY data type is also used for semi-structured data and can store an ordered list of elements. These data types enable users to work with semi-structured data directly in Snowflake without needing to flatten the data into a relational schema first.References: Snowflake Documentation on Semi-Structured Data Types
NEW QUESTION # 420
What is the MINIMUM Snowflake edition required to use object tagging?
- A. Business Critical
- B. Virtual Private Snowflake (VPS)
- C. Enterprise
- D. Standard
Answer: C
NEW QUESTION # 421
What happens when a database is cloned?
- A. It replicates all granted privileges on the corresponding child schema objects.
- B. It replicates all granted privileges on the corresponding child objects.
- C. It does not retain any privileges granted on the source object.
- D. It replicates all granted privileges on the corresponding source objects.
Answer: C
Explanation:
When a database is cloned in Snowflake, it does not retain any privileges that were granted on the source object. The clone will need to have privileges reassigned as necessary for users to access it. References: [COF- C02] SnowPro Core Certification Exam Study Guide
NEW QUESTION # 422
Which object can be used to query the data loading history for the last 365 days for a Snowflake account?
- A.
- B.
- C.
- D.
Answer: C
NEW QUESTION # 423
Which Snowflake layer is associated with virtual warehouses?
- A. Elastic memory
- B. Cloud services
- C. Database storage
- D. Query processing
Answer: D
Explanation:
The layer of Snowflake's architecture associated with virtual warehouses is the Query Processing layer. Virtual warehouses in Snowflake are dedicated compute clusters that execute SQL queries against the stored data. This layer is responsible for the entire query execution process, including parsing, optimization, and the actual computation. It operates independently of the storage layer, enabling Snowflake to scale compute and storage resources separately for efficiency and cost-effectiveness.
Reference:
Snowflake Documentation: Snowflake Architecture
NEW QUESTION # 424
The VALIDATE table function has which parameter as an input argument for a Snowflake user?
- A. Last_QUERY_ID
- B. CURRENT_STATEMENT
- C. JOB_ID
- D. UUID_STRING
Answer: D
Explanation:
The VALIDATE table function in Snowflake would typically use a unique identifier, such as a UUID_STRING, as an input argument. This function is designed to validate the data within a table against a set of constraints or conditions, often requiring a specific identifier to reference the particular data or job being validated.
References:
* There is no direct reference to a VALIDATE table function with these specific parameters in Snowflake documentation. It seems like a theoretical example for understanding function arguments. Snowflake documentation on UDFs and system functions can provide guidance on how to create and use custom functions for similar purposes.
NEW QUESTION # 425
......
COF-C02 Question Bank: Free PDF Download Recently Updated Questions: https://www.vcedumps.com/COF-C02-examcollection.html
COF-C02 Brain Dump: A Study Guide with Tips & Tricks for passing Exam: https://drive.google.com/open?id=13mZ-8_2Xt7GjRMJD2jaT2jdlCmlW_kXG
