Snowflake cof-r02 practice test

True or False: Micro-partition metadata enables some operations to be completed without requiring
Compute.

• A. True
• B. False

Which of the following are options when creating a Virtual Warehouse?

• A. Auto-suspend
• B. Auto-resume
• C. Local SSD size
• D. User count

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

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

True or False: A customer using SnowSQL / native connectors will be unable be unable to able to also
use the Snowflake Web interface (UI) unless access to the UI is explicitly granted by supported.

• A. True
• B. False

Which of the following are true of multi-cluster Warehouses? Select all that apply below.

• A. A multi-cluster Warehouse can add clusters automatically based on query activity
• B. A multi-cluster Warehouse can automatically turn itself off after a period of inactivity
• C. A multi-cluster Warehouse can scale down when query activity slows
• D. A multi-cluster Warehouse can automatically turn itself on when a query is executed against it

What are the three things customers want most from their enterprise data warehouse solution?
Choose 3 answers

• A. On-premise availability
• B. Simplicity
• C. Open source based
• D. Concurrency
• E. Performance

True or False: Snowflake charges a premium for storing semi-structured data.

• A. True
• B. False

Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)

• A. Custom
• B. Economy
• C. Optimized
• D. Standard

True or False: A single database can exist in more than one Snowflake account.

• A. True
• B. False

Which of the following roles is recommended to be used to create and manage users and roles?

• A. SYSADMIN
• B. SECURITYADMIN
• C. PUBLIC
• D. ACCOUNTADMIN