Spring Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = getmirror

Home
Snowflake
SnowPro Core Certification
COF-R02
SnowPro Core Recertification Exam Questions and Answers

Pass the Snowflake SnowPro Core Certification COF-R02 Questions and answers with ExamsMirror

Practice at least 50% of the questions to maximize your chances of passing.

Exam COF-R02 Premium Access

View all detail and faqs for the COF-R02 exam

Go to Exam

715 Students Passed

91% Average Score

92% Same Questions

Viewing page 6 out of 10 pages

Viewing questions 51-60 out of questions

Questions # 51:

What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?

Options:

Data is hashed by the cluster key to facilitate fast searches for common data values

Larger micro-partitions are created for common data values to reduce the number of partitions that must be scanned

Smaller micro-partitions are created for common data values to allow for more parallelism

Data may be colocated by the cluster key within the micro-partitions to improve pruning performance

Answer

Questions # 52:

Which of the following describes external functions in Snowflake?

Options:

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

Answer

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%20user%2Ddefined,code%20running%20outside%20of%20Snowflake .

Questions # 53:

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?

Options:

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;

Answer

Questions # 54:

Which stage type can be altered and dropped?

Options:

Database stage

External stage

Table stage

User stage

Answer

Explanation

https://docs.snowflake.com/en/user-guide/data-load-local-file-system-create-stage.html#table-stages

Questions # 55:

A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip__outer_array file format option

What does the STRIP_OUTER_ARRAY file format do?

Options:

It removes the last element of the outer array.

It removes the outer array structure and loads the records into separate table rows,

It removes the trailing spaces in the last element of the outer array and loads the records into separate table columns

It removes the NULL elements from the JSON object eliminating invalid data and enables the ability to load the records

Answer

Explanation

Data Size Limitations

The VARIANT data type imposes a 16 MB size limit on individual rows.

For some semi-structured data formats (e.g. JSON), data sets are frequently a simple concatenation of multiple documents. The JSON output from some software is composed of a single huge array containing multiple records. There is no need to separate the documents with line breaks or commas, though both are supported.

If the data exceeds 16 MB, enable the STRIP_OUTER_ARRAY file format option for the COPY INTO <title> command to remove the outer array structure and load the records into separate table rows:

copy into <title>

from @~/.json

file_format = (type = 'JSON' strip_outer_array = true);

https://docs.snowflake.com/en/user-guide/semistructured-considerations.html

Questions # 56:

Which of the following objects can be shared through secure data sharing?

Options:

Masking policy

Stored procedure

Task

External table

Answer

Explanation

Secure Data Sharing enables sharing selected objects in a database in your account with other Snowflake accounts. The following Snowflake database objects can be shared:

Tables

External tables

Secure views

Secure materialized views

Secure UDFs

Snowflake enables the sharing of databases through shares, which are created by data providers and “imported” by data consumers.

https://docs.snowflake.com/en/user-guide/data-sharing-intro.html#:~:text=Secure%20Data%20Sharing%20enables%20sharing,External%20tables

Questions # 57:

Which semi-structured file formats are supported when unloading data from a table? (Select TWO).

Options:

ORC

XML

Avro

Parquet

JSON

Answer

D, E

Explanation

Semi-structured

JSON, Parquet

https://docs.snowflake.com/en/user-guide/data-unload-prepare.html#:~:text=Supported%20File%20Formats,-The%20following%20file &text=Delimited%20(CSV%2C%20TSV%2C%20etc.)

Questions # 58:

What are two ways to create and manage Data Shares in Snowflake? (Choose two.)