[Feb-2025] COF-R02 Exam Questions and Valid COF-R02 Dumps PDF [Q112-Q130]

admin
February 16, 2025

[Feb-2025] COF-R02 Exam Questions and Valid COF-R02 Dumps PDF [Q112-Q130]

Rate this post

[Feb-2025] COF-R02 Exam Questions and Valid COF-R02 Dumps PDF

COF-R02 Brain Dump: A Study Guide with Tips & Tricks for passing Exam

Snowflake COF-R02 (SnowPro Core Recertification) Certification Exam is an advanced certification exam that measures your knowledge and expertise in Snowflake’s data cloud. COF-R02 exam is designed for individuals who have already obtained the SnowPro Core Certification and are looking to recertify their knowledge and skills. The SnowPro Core Recertification Exam is an important step in advancing your career and demonstrating your proficiency in Snowflake’s technologies.

NO.112 Which is true of Snowflake network policies? A Snowflake network policy: (Choose two.)

Is available to all Snowflake Editions

Is only available to customers with Business Critical Edition

Restricts or enables access to specific IP addresses

Is activated using an “ALTER DATABASE” command

Reference: https://docs.snowflake.com/en/sql-reference/sql/create-network-policy.html

NO.113 A user needs to create a materialized view in the schema MYDB.MYSCHEMA.
Which statements will provide this access?

GRANT ROLE MYROLE TO USER USER1;
CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO ROLE MYROLE;

GRANT ROLE MYROLE TO USER USER1;
CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1;

GRANT ROLE MYROLE TO USER USER1;
CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER1;

GRANT ROLE MYROLE TO USER USER1;
CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE;

NO.114 What is a best practice after creating a custom role?

Create the custom role using the SYSADMIN role.

Assign the custom role to the SYSADMIN role

Assign the custom role to the PUBLIC role

Add__CUSTOM to all custom role names

Explanation
When creating roles that will serve as the owners of securable objects in the system, Snowflake recommends creating a hierarchy of custom roles, with the top-most custom role assigned to the system role SYSADMIN.
This role structure allows system administrators to manage all objects in the account, such as warehouses and database objects, while restricting management of users and roles to the USERADMIN role.

NO.115 Which of the following statements are true about Schemas in Snowflake? (Choose two.)

A Schema may contain one or more Databases

A Database may contain one or more Schemas

A Schema is a logical grouping of Database Objects

Each Schema is contained within a Warehouse

Reference: https://docs.snowflake.com/en/user-guide/data-sharing-mutiple-db.html

NO.116 Which of the following are considerations when using a directory table when working with unstructured data?
(Choose two.)

A directory table is a separate database object.

Directory tables store data file metadata.

A directory table will be automatically added to a stage.

Directory tables do not have their own grantable privileges.

Directory table data can not be refreshed manually.

NO.117 Which of the following are best practices for loading data into Snowflake? (Choose three.)

Aim to produce data files that are between 100 MB and 250 MB in size, compressed.

Load data from files in a cloud storage service in a different region or cloud platform from the service or region containing the Snowflake account, to save on cost.

Enclose fields that contain delimiter characters in single or double quotes.

Split large files into a greater number of smaller files to distribute the load among the compute resources in an active warehouse.

When planning which warehouse(s) to use for data loading, start with the largest warehouse possible.

Partition the staged data into large folders with random paths, allowing Snowflake to determine the best way to load each file.

NO.118 What is the MOST performant file format for loading data in Snowflake?

CSV (Unzipped)

Parquet

CSV (Gzipped)

ORC

NO.119 True or False: Snowflake’s data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.

True

False

Reference: https://docs.snowflake.com/en/user-guide/intro-key-concepts.html

NO.120 Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)

Customer-managed encryption keys through Tri-Secret Secure

Automatic encryption of all data

Up to 90 days of data recovery through Time Travel

Object-level access control

Column-level security to apply data masking policies to tables and views

Explanation
https://docs.snowflake.com/en/user-guide/intro-editions.html

NO.121 A sales table FCT_SALES has 100 million records.
The following Query was executed
SELECT COUNT (1) FROM FCT__SALES;
How did Snowflake fulfill this query?

Query against the result set cache

Query against a virtual warehouse cache

Query against the most-recently created micro-partition

Query against the metadata excite

NO.122 Which Snowflake feature allows a user to substitute a randomly generated identifier for sensitive data, in order to prevent unauthorized users access to the data, before loading it into Snowflake?

External Tokenization

External Tables

Materialized Views

User-Defined Table Functions (UDTF)

NO.123 Which of the following objects can be cloned? (Choose four.)

Tables

Named File Formats

Schemas

Databases

Users

Explanation
Which Objects Can Be Cloned?
Data Containment Objects. Databases. Schemas. Tables. Streams.
Data Configuration and Transformation Objects. Stages. File Formats. Sequences. Tasks

NO.124 Which of the following describes external functions in Snowflake?

They are a type of User-defined Function (UDF).

They contain their own SQL code.

They call code that is stored inside of Snowflake.

They can return multiple rows for each row received

Explanation
External functions are user-defined functions that are stored and executed outside of Snowflake.
External functions make it easier to access external API services such as geocoders, machine learning models, and other custom code running outside of Snowflake. This feature eliminates the need to export and reimport data when using third-party services, significantly simplifying your data pipelines.
https://docs.snowflake.com/en/sql-reference/external-functions.html#:~:text=External%20functions%20are%20u

NO.125 Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?

Pipes

Streams

Tasks

Procedures

Explanation
https://dataterrain.com/how-to-change-tracking-using-table-streams-in-snowflake/#:~:text=A%20stream%20is%

NO.126 A single user of a virtual warehouse has set the warehouse to auto-resume and auto-suspend after 10 minutes.
The warehouse is currently suspended and the user performs the following actions:
1. Runs a query that takes 3 minutes to complete
2. Leaves for 15 minutes
3. Returns and runs a query that takes 10 seconds to complete
4. Manually suspends the warehouse as soon as the last query was completed When the user returns, how much billable compute time will have been consumed?

4 minutes

10 minutes

14 minutes

24 minutes

NO.127 True or False: It is possible to load data into Snowflake without creating a named File Format object.

True

False

Reference: https://docs.snowflake.com/en/user-guide/data-load-external-tutorial-create-file-format.html

NO.128 True or False: You can query the files in an External Stage directly without having to load the data into a table.

True

False

Reference: https://docs.snowflake.com/en/user-guide/tables-external-intro.html External tables are read-only, therefore no DML operations can be performed on them; however, external tables can be used for query and join operations. Views can be created against external tables.

NO.129 Which data type can store more than one type of data structure?

JSON

BINARY

VARCHAR

VARIANT

NO.130 How a Snowpipe charges calculated?

Per-second/per Warehouse size

Per-second/per-core granularity

Number of Pipes in account

Total storage bucket size

Reference: https://docs.snowflake.com/en/user-guide/data-load-snowpipe-billing.html

Loading …