Online Access Free COF-C01 Practice Test

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

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

Which are true of Snowflake roles?

• A.All grants to objects are given to roles, and never to users
• B.The public role controls at other roles
• C.In order to do DML/DOL, a user needs to have selected a single role that has that specific access to the object and operation
• D.Roles are a subset of users and users own objects In Snowflake

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

• A.False
• B.True

What services does Snowflake automatically provide for customer that they may have been responsible for with their on premise system? Select all the below that apply.

• A.Installing and configuring hardware
• B.Maintaining metadata and statists
• C.Patching software
• D.Physical security

When loading data into Snowflake, the COPY command supports: Choose 2 answers

• A.Joins
• B.Aggregates
• C.Column reordering
• D.Fitters
• E.Data type conversions