[Sep-2025] Free COF-C02 Exam Questions COF-C02 Actual Free Exam Questions [Q418-Q436]

Share

[Sep-2025] Free COF-C02 Exam Questions COF-C02 Actual Free Exam Questions

Verified COF-C02 dumps and 965 unique questions

NEW QUESTION # 418
What is a non-configurable feature that provides historical data that Snowflake may recover during a 7-day period?

  • A. Account replication
  • B. Fail-safe
  • C. Cloning
  • D. Time Travel

Answer: B

Explanation:
Fail-safe is a non-configurable feature in Snowflake that provides an additional layer of data protection beyond Time Travel. Time Travel allows users to access historical data within a configurable period (up to 90 days), while Fail-safe provides an additional 7-day period during which Snowflake retains historical data to recover from significant data loss or corruption incidents. This period is not accessible by users but can be used by Snowflake support to assist in data recovery efforts.
Reference: Snowflake Documentation on Fail-safe and Time Travel


NEW QUESTION # 419
A query runs significantly slower than expected. Which Query Profile metrics will help identify the issue?
(Select TWO).

  • A. Bytes scanned
  • B. Query Plan execution steps
  • C. Partitions scanned
  • D. Resource usage
  • E. Processing

Answer: B,C


NEW QUESTION # 420
What is the MAXIMUM number of clusters that can be provisioned with a multi-cluster virtual warehouse?

  • A. 0
  • B. 1
  • C. 2
  • D. 3

Answer: B

Explanation:
In Snowflake, the maximum number of clusters that can be provisioned within a multi-cluster virtual warehouse is 10. This allows for significant scalability and performance management by enabling Snowflake to handle varying levels of query load by adjusting the number of active clusters within the warehouse.References: Snowflake documentation on virtual warehouses, particularly the scalability options available in multi-cluster configurations.


NEW QUESTION # 421
What are value types that a VARIANT column can store? (Select TWO)

  • A. OBJECT
  • B. STRUCT
  • C. CLOB
  • D. BINARY
  • E. ARRAY

Answer: A,E

Explanation:
A VARIANT column in Snowflake can store semi-structured data types. This includes:
* B. OBJECT: An object is a collection of key-value pairs in JSON, and a VARIANT column can store this type of data structure.
* D. ARRAY: An array is an ordered list of zero or more values, which can be of any variant-supported data type, including objects or other arrays.
The VARIANT data type is specifically designed to handle semi-structured data like JSON, Avro, ORC, Parquet, or XML, allowing for the storage of nested and complex data structures.
References:
Snowflake Documentation onSemi-Structured Data Types
SnowPro® Core Certification Study Guide


NEW QUESTION # 422
What is the MINIMUM Snowflake edition that supports the periodic rekeying of encrypted data?

  • A. Enterprise
  • B. Business Critical
  • C. Virtual Private Snowflake (VPS)
  • D. Standard

Answer: A


NEW QUESTION # 423
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 src.dealership from car_sales;
  • B. select src:dealership from car_sales;
  • C. select src:Dealership from car_sales;
  • D. select dealership from car_sales;

Answer: A

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 # 424
What can the Snowflake SCIM API be used to manage? (Select TWO).

  • A. Session policies
  • B. Network policies
  • C. Integrations
  • D. Roles
  • E. Users

Answer: D,E

Explanation:
The Snowflake SCIM (System for Cross-domain Identity Management) API is used for automated user and role management. It enables integration with identity providers (IdPs) for the provisioning and deprovisioning of user accounts and roles in Snowflake. This helps in managing access control and permissions systematically and aligns with identity governance practices.
References:
* Snowflake Documentation: Managing Users and Roles with SCIM API


NEW QUESTION # 425
Which parameter prevents streams on tables from becoming stale?

  • A. STALE_AFTER
  • B. MAXDATAEXTENSIONTIMEINDAYS
  • C. MTN_DATA_RETENTION_TTME_TN_DAYS
  • D. LOCK_TIMEOUT

Answer: B


NEW QUESTION # 426
Given the statement template below, which database objects can be added to a share?(Select TWO).
GRANT <privilege> ON <object> <object_name> To SHARE <share_name>;

  • A. Secure functions
  • B. Stored procedures
  • C. Tasks
  • D. Tables
  • E. Streams

Answer: D,E

Explanation:
In Snowflake, shares are used to share data across different Snowflake accounts securely. When you create a share, you can include various database objects that you want to share with consumers. According to Snowflake's documentation, the types of objects that can be shared include tables, secure views, secure materialized views, and streams. Secure functions and stored procedures are not shareable objects. Tasks also cannot be shared directly. Therefore, the correct answers are streams (C) and tables (D).
To share a stream or a table, you use the GRANT statement to grant privileges on these objects to a share. The syntax for sharing a table or stream involves specifying the type of object, the object name, and the share to which you are granting access. For example:
GRANT SELECT ON TABLE my_table TO SHARE my_share; GRANT SELECT ON STREAM my_stream TO SHARE my_share; These commands grant the SELECT privilege on a table named my_table and a stream named my_stream to a share named my_share. This enables the consumer of the share to access these objects according to the granted privileges.
Reference: Snowflake Documentation on Shares and Database Objects (https://docs.snowflake.com)


NEW QUESTION # 427
What is the purpose of an External Function?

  • A. To call code that executes outside of Snowflake
  • B. To run a function in another Snowflake database
  • C. To share data in Snowflake with external parties
  • D. To ingest data from on-premises data sources

Answer: A


NEW QUESTION # 428
What is the MINIMUM Snowflake edition required to use the periodic rekeying of micro-partitions?

  • A. Virtual Private Snowflake
  • B. Standard
  • C. Enterprise
  • D. Business Critical

Answer: D

Explanation:
Reference: https://docs.snowflake.com/en/user-guide/intro-editions.html#business-critical-edition


NEW QUESTION # 429
Which cache type is used to cache data output from SQL queries?

  • A. Local file cache
  • B. Result cache
  • C. Remote cache
  • D. Metadata cache

Answer: B

Explanation:
https://community.snowflake.com/s/article/Caching-in-Snowflake-Data-Warehouse


NEW QUESTION # 430
A user needs to create a materialized view in the schema MYDB.MYSCHEMA.
Which statements will provide this access?

  • A. GRANT ROLE MYROLE TO USER USER1;CREATE MATERIALIZED VIEW ON SCHEMA
    MYDB.MYSCHEMA TO ROLE MYROLE;
  • B. GRANT ROLE MYROLE TO USER USER1;CREATE MATERIALIZED VIEW ON SCHEMA
    MYDB.MYSCHEMA TO MYROLE;
  • C. GRANT ROLE MYROLE TO USER USER1;CREATE MATERIALIZED VIEW ON SCHEMA
    MYDB.MYSCHEMA TO USER1;
  • D. GRANT ROLE MYROLE TO USER USER1;CREATE MATERIALIZED VIEW ON SCHEMA
    MYDB.MYSCHEMA TO USER USER1;

Answer: B

Explanation:
In Snowflake, to create a materialized view, the user must have the necessary privileges on the schema where the view will be created. These privileges are granted through roles, not directly to individual users.
Therefore, the correct process is to grant the role to the user and then grant the privilege to create the materialized view to the role itself.
The statement GRANT ROLE MYROLE TO USER USER1; grants the specified role to the user, allowing them to assume that role and exercise its privileges. The subsequent statement CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE; grants the privilege to create a materialized view within the specified schema to the role MYROLE. Any user who has been granted MYROLE can then create materialized views in MYDB.MYSCHEMA.
References:
Snowflake Documentation on Roles
Snowflake Documentation on Materialized Views


NEW QUESTION # 431
Which of the following statements describe features of Snowflake data caching? (Choose two.)

  • A. The RESULT_SCAN table function can access and filter the contents of the query result cache.
  • B. A user must set USE_METADATA_CACHE to TRUE to use the metadata cache in queries.
  • C. When the data cache is full, the least-recently used data will be cleared to make room.
  • D. A user can only access their own queries from the query result cache.
  • E. When a virtual warehouse is suspended, the data cache is saved on the remote storage layer.

Answer: A,C

Explanation:
Snowflake's data caching features include the ability to clear the least-recently used data when the data cache is full to make room for new data. Additionally, the RESULT_SCAN table function can access and filter the contents of the query result cache, allowing users to retrieve and work with the results of previous queries. The other statements are incorrect: the data cache is not saved on the remote storage layer when a virtual warehouse is suspended, users can access queries from the query result cache that were run by other users, and there is no setting called USE_METADATA_CACHE in Snowflake. Reference: Caching in the Snowflake Cloud Data Platform, Optimizing the warehouse cache


NEW QUESTION # 432
Which operations are handled in the Cloud Services layer of Snowflake? (Select TWO).

  • A. Security
  • B. Query computation
  • C. Metadata management
  • D. Data visualization
  • E. Data storage

Answer: A,C

Explanation:
The Cloud Services layer in Snowflake is responsible for various services, including security (like authentication and authorization) and metadata management (like query parsing and optimization). Reference: Based on general cloud architecture knowledge as of 2021.


NEW QUESTION # 433
A user needs to create a materialized view in the schema MYDB.MYSCHEMA.
Which statements will provide this access?

  • A. GRANT ROLE MYROLE TO USER USER1;
    CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO ROLE MYROLE;
  • B. GRANT ROLE MYROLE TO USER USER1;
    CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER1;
  • C. GRANT ROLE MYROLE TO USER USER1;
    CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1;
  • D. GRANT ROLE MYROLE TO USER USER1;
    CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE;

Answer: C


NEW QUESTION # 434
In which use cases does Snowflake apply egress charges?

  • A. Query result retrieval
  • B. Loading data into Snowflake
  • C. Database replication
  • D. Data sharing within a specific region

Answer: D

Explanation:
Explanation
Cloud providers apply data egress charges in either of the following use cases:
* Data is transferred from one region to another within the same cloud platform.
* Data is transferred out of the cloud platform.
https://docs.snowflake.com/en/user-guide/billing-data-transfer.html#:~:text=Cloud%20providers%20apply%20d


NEW QUESTION # 435
Which Snowflake technique can be used to improve the performance of a query?

  • A. Fragmenting
  • B. Clustering
  • C. Using INDEX_HINTS
  • D. Indexing

Answer: B


NEW QUESTION # 436
......

Latest 100% Passing Guarantee - Brilliant COF-C02 Exam Questions PDF: https://www.actual4labs.com/Snowflake/COF-C02-actual-exam-dumps.html

COF-C02 Dumps for Pass Guaranteed - Pass COF-C02 Exam: https://drive.google.com/open?id=1y9vTNc4WjWOSKsLbB2sSMt0-8otVnI8V

Contact Us

If you have any question please leave me your email address, we will reply and send email to you in 12 hours.

Our Working Time: ( GMT 0:00-15:00 )
From Monday to Saturday

Support: Contact now