COF-R02 Exam Dumps - SnowPro Core Recertification Exam

Go to page:

<< First
Prev
1
2
3
4
5
6
7
Next
Last >>

Question # 33

Network policies can be applied to which of the following Snowflake objects? (Choose two.)

Roles

Databases

Warehouses

Users

Accounts

Full Access

Question # 34

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

Configure the user to be initially disabled.

Force an immediate password change.

Set a default role for the user.

Set the number of minutes to unlock to 15 minutes.

Set the user's access to expire within a specified timeframe.

Full Access

Question # 35

What is the default file size when unloading data from Snowflake using the COPY command?

5 MB

8 GB

16 MB

32 MB

Full Access

Question # 36

A single user of a virtual warehouse has set the warehouse to auto-resume and auto-suspend after 10 minutes. The warehouse is currently suspended and the user performs the following actions:

1. Runs a query that takes 3 minutes to complete

2. Leaves for 15 minutes

3. Returns and runs a query that takes 10 seconds to complete

4. Manually suspends the warehouse as soon as the last query was completed

When the user returns, how much billable compute time will have been consumed?

4 minutes

10 minutes

14 minutes

24 minutes

Full Access

Question # 37

How often are the Account and Table master keys automatically rotated by Snowflake?

30 Days

60 Days

90 Days

365 Days.

Full Access

Question # 38

Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)

Use the DROP command after the load completes.

Specify the TEMPORARY option when creating the file format.

Specify the PURGE copy option in the COPY INTO

command.

Use the REMOVE command after the load completes.

Use the DELETE LOAD HISTORY command after the load completes.

Full Access

Question # 39

Which Snowflake architectural layer is responsible for a query execution plan?

Compute

Data storage

Cloud services

Cloud provider

Full Access

Question # 40

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?

Row access policies

Data masking policies

Data encryption

Role based access control

Full Access

Go to page: