Home / Snowflake / COF-C02

Snowflake COF-C02 Practice Test - Questions Answers, Page 18

Question list

List of questions

Question 171

(0)

What COPY INTO SQL command should be used to unload data into multiple files?

Question 172

(0)

When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?

Question 173

(0)

When loading data into Snowflake, how should the data be organized?

Question 174

(0)

Which of the following objects can be directly restored using the UNDROP command? (Choose two.)

Question 175

(0)

Which Snowflake SQL statement would be used to determine which users and roles have access to a role called MY_ROLE?

Question 176

(0)

What is the MINIMUM edition of Snowflake that is required to use a SCIM security integration?

Question 177

(0)

A user created a transient table and made several changes to it over the course of several days. Three days after the table was created, the user would like to go back to the first version of the ta

Question 178

(0)

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

Question 179

(0)

Where can a user find and review the failed logins of a specific user for the past 30 days?

Question 180

(0)

Which of the following statements apply to Snowflake in terms of security? (Choose two.)

Question 171

What COPY INTO SQL command should be used to unload data into multiple files?

SINGLE=TRUE

MULTIPLE=TRUE

MULTIPLE=FALSE

SINGLE=FALSE

Show Answer Comment (0)

Question 172

When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?

The cloned views and the stored procedures will reference the cloned tables in the cloned database.

An error will occur, as views with qualified references cannot be cloned.

An error will occur, as stored objects cannot be cloned.

The stored procedures and views will refer to tables in the source database.

Show Answer Comment (0)

Question 173

When loading data into Snowflake, how should the data be organized?

Into single files with 100-250 MB of compressed data per file

Into single files with 1-100 MB of compressed data per file

Into files of maximum size of 1 GB of compressed data per file

Into files of maximum size of 4 GB of compressed data per file

Show Answer Comment (0)

Question 174

Which of the following objects can be directly restored using the UNDROP command? (Choose two.)

Schema

View

Internal stage

Table

User

Role

Show Answer Comment (0)

Question 175

Which Snowflake SQL statement would be used to determine which users and roles have access to a role called MY_ROLE?

SHOW GRANTS OF ROLE MY_ROLE

SHOW GRANTS TO ROLE MY_ROLE

SHOW GRANTS FOR ROLE MY_ROLE

SHOW GRANTS ON ROLE MY_ROLE

Show Answer Comment (0)

Question 176

What is the MINIMUM edition of Snowflake that is required to use a SCIM security integration?

Business Critical Edition

Standard Edition

Virtual Private Snowflake (VPS)

Enterprise Edition

Show Answer Comment (0)

A user created a transient table and made several changes to it over the course of several days. Three days after the table was created, the user would like to go back to the first version of the table.

How can this be accomplished?

Use Time Travel, as long as DATA_RETENTION_TIME_IN_DAYS was set to at least 3 days.

The transient table version cannot be retrieved after 24 hours.

Contact Snowflake Support to have the data retrieved from Fail-safe storage.

Use the FAIL_SAFE parameter for Time Travel to retrieve the data from Fail-safe storage.

Show Answer Comment (0)