Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)

• A.Customer-managed encryption keys through Tri-Secret Secure
• B.Automatic encryption of all data
• C.Up to 90 days of data recovery through Time Travel
• D.Object-level access control
• E.Column-level security to apply data masking policies to tables and views

Comment: *

Name: *

Email: *

Verification: *

Which command is used to unload files from an internal or external stage to a local file system?

• A.COPY INTO
• B.GET
• C.PUT
• D.TRANSFER

Comment: *

Name: *

Email: *

Verification: *

Which SQL command can be used to verify the privileges that are granted to a role?

• A.SHOW ROLES <Role Name>
• B.SHOW GRANTS FOR ROLE <Role Name>
• C.SHOW GRANTS ON ROLE <Role Name>
• D.SHOW GRANTS TO ROLE <Role Name>

Comment: *

Name: *

Email: *

Verification: *

True or False: Snowflake's Global Services Layer gathers and maintains statistics on all columns in all micro-partitions.

• A.True
• B.False

Comment: *

Name: *

Email: *

Verification: *

What are best practice recommendations for using the ACCOUNTADMIN system-defined role in Snowflake?
(Choose two.)

• A.Assign the ACCOUNTADMIN role to at least two users, but as few as possible.
• B.Ensure all ACCOUNTADMIN roles use Multi-factor Authentication (MFA).
• C.The ACCOUNTADMIN role must be granted to only one user.
• D.All users granted ACCOUNTADMIN role must be owned by the ACCOUNTADMIN role.
• E.All users granted ACCOUNTADMIN role must also be granted SECURITYADMIN role.

Comment: *

Name: *

Email: *

Verification: *