In the Snowflake access control model, which entity owns an object by default?

• A.Ownership depends on the type of object
• B.The user who created the object
• C.The SYSADMIN role
• D.The role used to create the object

Comment: *

Name: *

Email: *

Verification: *

True or false: it is best practice to define a clustering key on every table.

• A.True
• B.False

Comment: *

Name: *

Email: *

Verification: *

When loading data into Snowflake, how should the data be organized?

• A.Into single files with 1-100 MB of compressed data per file
• B.Into files of maximum size of 1 GB of compressed data per file
• C.Into single files with 100-250 MB of compressed data per file
• D.Into files of maximum size of 4 GB of compressed data per file

Comment: *

Name: *

Email: *

Verification: *

A user has a standard multi-cluster warehouse auto-scaling policy in place.
Which condition will trigger a cluster to shut-down?

• A.When after 5-6 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.
• B.When after 5-6 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.
• C.When after 2-3 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.
• D.When after 2-3 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.

Comment: *

Name: *

Email: *

Verification: *

True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.

• A.True
• B.False

Comment: *

Name: *

Email: *

Verification: *