True or False: AWS Private Link provides a secure connection from the Customer's on-premise data center to the Snowflake.

A. True

B. False

When can a Virtual Warehouse start running queries?

A. 12am-5am

B. Only during administrator defined time slots

C. When its provisioning is complete

D. After replication

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

Which Snowflake technique can be used to improve the performance of a query?

A. Clustering

B. Indexing

C. Fragmenting

D. Using INDEX__HINTS

Which of the following objects can be shared through secure data sharing?

A. Masking policy

B. Stored procedure

C. Task

D. External table

True or False: A 4X-Large Warehouse may, at times, take longer to provision than a X-Small Warehouse.

A. True

B. False

Which Snowflake SQL statement would be used to determine which users and roles have access to a role called MY_ROLE?

A. SHOW GRANTS OF ROLE MY_ROLE

B. SHOW GRANTS TO ROLE MY_ROLE

C. SHOW GRANTS FOR ROLE MY_ROLE

D. SHOW GRANTS ON ROLE MY_ROLE

If a Snowflake user decides a table should be clustered, what should be used as the cluster key?

A. The columns that are queried in the select clause.

B. The columns with very high cardinality.

C. The columns with many different values.

D. The columns most actively used in the select filters.

A user is preparing to load data from an external stage Which practice will provide the MOST efficient loading performance?

A. Organize files into logical paths

B. Store the files on the external stage to ensure caching is maintained

C. Use pattern matching for regular expression execution

D. Load the data in one large file

In a Snowflake role hierarchy, what is the top-level role?

A. SYSADMIN

B. ORGADMIN

C. ACCOUNTADMIN D. SECURITYADMIN