Online Access Free COF-R02 Practice Test

Which of the following DML commands isn't supported by Snowflake?

• A.TRUNCATE TABLE
• B.UPDATE
• C.MERGE
• D.UPSERT

By default, which Snowflake role is required to create a share?

• A.ORGADMIN
• B.ACCOUNTADMIN
• C.SECURITYADMIN
• D.SHAREADMIN

Which of the following connectors allow Multi-Factor Authentication (MFA) authorization when connecting?
(Choose all that apply.)

• A.SnowSQL
• B.Python
  D18912E1457D5D1DDCBD40AB3BF70D5D
• C.JDBC
• D.Snowflake Web Interface (UI)
• E.ODBC

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?

• A.10 minutes
• B.4 minutes
• C.24 minutes
• D.14 minutes

What is a responsibility of Snowflake's virtual warehouses?

• A.Infrastructure management
• B.Metadata management
• C.Query parsing and optimization
• D.Query execution
• E.Permanent storage of micro-partitions