Which command removes a role from another role or a user in Snowflak?

• A.ALTER ROLE
• B.REVOKE ROLE
• C.USE ROLE
• D.USE SECONDARY ROLES

Comment: *

Name: *

Email: *

Verification: *

The customer table in the T1 database is accidentally dropped.
Which privileges are required to restore this table? {Select TWO).

• A.ownership privilege on the customer table
• B.All privileges on the T1 database
• C.CREATE TABIE privilege on the T1 database
• D.SELECT privilege on the customer table
• E.All privileges on the customer table

Comment: *

Name: *

Email: *

Verification: *

Which of the following activities consume virtual warehouse credits in the Snowflake environment? (Choose two.)

• A.Running EXPLAIN and SHOW commands
• B.Caching query results
• C.Running COPY commands
• D.Running a custom query
• E.Cloning a database

Comment: *

Name: *

Email: *

Verification: *

Which of the following are benefits of micro-partitioning? (Select TWO)

• A.Micro-partitions are immutable objects that support the use of Time Travel.
• B.Rows are automatically stored in sorted order within micro-partitions
• C.Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses
• D.Micro-partitions can be defined on a schema-by-schema basis
• E.Micro-partitions cannot overlap in their range of values

Comment: *

Name: *

Email: *

Verification: *

A Snowflake user wants to temporarily bypass a network policy by configuring the user object property MINS_TO_BYPASS_NETWORK_POLICY.
What should they do?

• A.Use the SECURITYADMIN role.
• B.Use the SYSADMIN role.
• C.Use the USERADMIN role.
• D.Contact Snowflake Support.

Comment: *

Name: *

Email: *

Verification: *