Snowflake COF-R02 Exam Actual Questions

Name: SnowPro Core Recertification Exam
Brand: QA4Exam
SKU: COF-R02
Price: 30 USD
Availability: InStock
Rating: 4.9 (200 reviews)

The questions for COF-R02 were last updated on Oct 3, 2024.

Viewing page 1 out of 66 pages.
Viewing questions 1-5 out of 330 questions

Unlock Access to All 330 Questions & Answers

Question No. 1

How can a user change which columns are referenced in a view?

DMaterialize the view to perform the changes

CRecreate the view with the required changes

BUse the ALTER VIEW command to update the view

AModify the columns in the underlying table

Show Answer

Correct Answer: B

Question No. 2

Which commands should be used to grant the privilege allowing a role to select data from all current tables and any tables that will be created later in a schema? (Choose two.)

Egrant SELECT on all tables in database DB1 to role MYROLE;

Dgrant SELECT on future tables in schema DB1.SCHEMA to role MYROLE;

Cgrant SELECT on all tables in schema DB1.SCHEMA to role MYROLE;

Bgrant USAGE on future tables in schema DB1.SCHEMA to role MYROLE;

Agrant USAGE on all tables in schema DB1.SCHEMA to role MYROLE;

Fgrant SELECT on future tables in database DB1 to role MYROLE;

Show Answer

Correct Answer: D, C

Question No. 3

Using variables in Snowflake is denoted by using which SQL character?

Show Answer

Correct Answer: C

Question No. 4

What happens to the shared objects for users in a consumer account from a share, once a database has been created in that account?

DThe shared objects can be re-shared.

CThe shared objects become accessible.

BThe shared objects are copied.

AThe shared objects are transferred.

Show Answer

Correct Answer: B

Question No. 5

Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?

DVALIDATION_MODE

CREPLACE_INVALID_CHARACTERS

BSKIP_BYTE_ORDER_MARK

ASTRIP_NULL_VALUES

Show Answer

Correct Answer: D

https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html

VALIDATION_MODE=RETURN_n_ROWS|RETURN_ERRORS|RETURN_ALL_ERRORS

String (constant) that instructs the COPY command to validate the data filesinsteadof loading them into the specified table; i.e. the COPY command tests the files for errors but does not load them. The command validates the data to be loaded and returns results based on the validation option specified:

Unlock All Questions for Snowflake COF-R02 Exam

Full Exam Access, Actual Exam Questions, Validated Answers, Anytime Anywhere, No Download Limits, No Practice Limits

Get All 330 Questions & Answers