Free Snowflake (COF-R02) Certification Sample Questions with Online Practice Test [Q127-Q145]

Rate this post

Free Snowflake (COF-R02) Certification Sample Questions with Online Practice Test

COF-R02 Certification Study Guide Pass COF-R02 Fast

NO.127 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.128 Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)

ROLES

POLICY_REFERENCES

QUERY_HISTORY

RESOURCE_MONIT ORS

ACCESS_HISTORY

Explanation
https://docs.snowflake.com/en/user-guide/security-column-ddm-intro.html#:~:text=DESCRIBE%20MASKING%

NO.129 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.130 Which statement describes pruning?

The filtering or disregarding of micro-partitions that are not needed to return a query.

The return of micro-partitions values that overlap with each other to reduce a query’s runtime.

A service that is handled by the Snowflake Cloud Services layer to optimize caching.

The ability to allow the result of a query to be accessed as if it were a table.

NO.131 Which copy INTO command outputs the data into one file?

SINGLE=TRUE

MAX_FILE_NUMBER=1

FILE_NUMBER=1

MULTIPLE=FAISE

NO.132 Which cache type is used to cache data output from SQL queries?

Metadata cache

Result cache

Remote cache

Local file cache

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

NO.133 What is cached during a query on a virtual warehouse?

All columns in a micro-partition

Any columns accessed during the query

The columns in the result set of the query

All rows accessed during the query

NO.134 What type of query benefits the MOST from search optimization?

A query that uses only disjunction (i.e., OR) predicates

A query that includes analytical expressions

A query that uses equality predicates or predicates that use IN

A query that filters on semi-structured data types

Reference: https://community.snowflake.com/s/article/Search-Optimization-When-How-To-Use

NO.135 Which interfaces can be used to create and/or manage Virtual Warehouses?

The Snowflake Web Interface (UI)

SQL commands

Data integration tools

All of the above

Reference: https://docs.snowflake.com/en/user-guide/warehouses.html

NO.136 What are value types that a VARIANT column can store? (Select TWO)

STRUCT

OBJECT

BINARY

ARRAY

CLOB

Explanation
Characteristics of a VARIANT
A VARIANT can store a value of any other type, including OBJECT and ARRAY. The maximum length of a VARIANT is 16 MB.
https://docs.snowflake.com/en/sql-reference/data-types-semistructured.html#:~:text=VARIANT-,Characteristics

NO.137 Which of the following features, associated with Continuous Data Protection (CDP), require additional Snowflake-provided data storage? (Choose two.)

Tri-Secret Secure

Time Travel

Fail-safe

Data encryption

External stages

NO.138 Which of the following are true of multi-cluster Warehouses? Select all that apply below.

A multi-cluster Warehouse can add clusters automatically based on query activity

A multi-cluster Warehouse can automatically turn itself off after a period of inactivity

A multi-cluster Warehouse can scale down when query activity slows

A multi-cluster Warehouse can automatically turn itself on when a query is executed against it

NO.139 If a Snowflake user decides a table should be clustered, what should be used as the cluster key?

The columns that are queried in the select clause.

The columns with very high cardinality.

The columns with many different values.

The columns most actively used in the select filters.

NO.140 What are best practice recommendations for using the ACCOUNTADMIN system-defined role in Snowflake?
(Choose two.)

Ensure all ACCOUNTADMIN roles use Multi-factor Authentication (MFA).

All users granted ACCOUNTADMIN role must be owned by the ACCOUNTADMIN role.

The ACCOUNTADMIN role must be granted to only one user.

Assign the ACCOUNTADMIN role to at least two users, but as few as possible.

All users granted ACCOUNTADMIN role must also be granted SECURITYADMIN role.

NO.141 Which of the following describes a Snowflake stored procedure?

They can be created as secure and hide the underlying metadata from the user.

They can only access tables from a single database.

They can contain only a single SQL statement.

They can be created to run with a caller’s rights or an owner’s rights.

Reference: https://docs.snowflake.com/en/sql-reference/stored-procedures-overview.html

NO.142 A user is preparing to load data from an external stage
Which practice will provide the MOST efficient loading performance?

Organize files into logical paths

Store the files on the external stage to ensure caching is maintained

Use pattern matching for regular expression execution

Load the data in one large file

NO.143 When a Pipe is recreated using the CREATE OR REPLACE PIPE command:

The Pipe load history is reset to empty

The REFRESH parameter is set to TRUE

Previously loaded files will be ignored

All of the above

Explanation
https://docs.snowflake.com/en/user-guide/data-load-snowpipe-manage.html#load-history
“When a pipe is recreated, the load history is dropped.”

NO.144 A marketing co-worker has requested the ability to change a warehouse size on their medium virtual warehouse called mktg__WH.
Which of the following statements will accommodate this request?

ALLOW RESIZE ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;

GRANT MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING;

GRANT MODIFY ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;

GRANT OPERATE ON WAREHOUSE MKTG WH TO ROLE MARKETING;

NO.145 What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?

The warehouse size does not change until all queries currently running in the warehouse have completed.

The warehouse size does not change until all queries currently in the warehouse queue have completed.

The warehouse size does not change until the warehouse is suspended and restarted.

It does not return from the command until the warehouse has finished changing its size.

Loading …

Get Perfect Results with Premium COF-R02 Dumps Updated 332 Questions: https://www.prepawaytest.com/Snowflake/COF-R02-practice-exam-dumps.html

Leave a Reply Cancel reply