Updated Aug-2023 Premium COF-R02 Exam Engine pdf – Download Free Updated 332 Questions [Q58-Q80]

QUESTION 58
The first user assigned to a new account, ACCOUNTADMIN, should create at least one additional user with which administrative privilege?

QUESTION 59
What SQL command would be used to view all roles that were granted to user.1?

QUESTION 60
A running virtual warehouse is suspended.
What is the MINIMUM amount of time that the warehouse will incur charges for when it is restarted?

QUESTION 61
Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)

QUESTION 62
What is the MOST performant file format for loading data in Snowflake?

QUESTION 63
The Snowflake cloud services layer is responsible for which tasks? (Choose two.)

QUESTION 64
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.

QUESTION 65
What is the MINIMUM Snowflake edition required to use the periodic rekeying of micro-partitions?

QUESTION 66
How a Snowpipe charges calculated?

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

QUESTION 68
Which services does the Snowflake Cloud Services layer manage? (Choose two.)

QUESTION 69
The Snowflake Search Optimization Services supports improved performance of which kind of query?

QUESTION 70
Users are responsible for data storage costs until what occurs?

QUESTION 71
What impacts the credit consumption of maintaining a materialized view? (Choose two.)

QUESTION 72
Which of the following describes the Snowflake Cloud Services layer?

QUESTION 73
Which of the following can be executed/called with Snowpipe?

QUESTION 74
Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)

QUESTION 75
What types of data listings are available in the Snowflake Data Marketplace? (Choose two.)

QUESTION 76
Which of the following practices are recommended when creating a user in Snowflake? (Choose two.)

QUESTION 77
Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?

QUESTION 78
What is a key feature of Snowflake architecture?

QUESTION 79
What tasks can be completed using the copy command? (Select TWO)

QUESTION 80
A company needs to allow some users to see Personally Identifiable Information (PII) while limiting other users from seeing the full value of the PII.
Which Snowflake feature will support this?