Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?

• A.CREATE_SHARE on the account
• B.SHARE on databases and schemas
• C.SELECT on tables used by the secure view
• D.REFERENCE_USAGE on databases

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.All users granted ACCOUNTADMIN role must also be granted SECURITYADMIN role.
• C.All users granted ACCOUNTADMIN role must be owned by the ACCOUNTADMIN role.
• D.Ensure all ACCOUNTADMIN roles use Multi-factor Authentication (MFA).
• E.The ACCOUNTADMIN role must be granted to only one user.

Comment: *

Name: *

Email: *

Verification: *

Which of the following statements describe features of Snowflake data caching? (Choose two.)

• A.When a virtual warehouse is suspended, the data cache is saved on the remote storage layer.
• B.When the data cache is full, the least-recently used data will be cleared to make room.
• C.A user can only access their own queries from the query result cache.
• D.A user must set USE_METADATA_CACHE to TRUE to use the metadata cache in queries.
• E.The RESULT_SCAN table function can access and filter the contents of the query result cache.

Comment: *

Name: *

Email: *

Verification: *

Which of the following describes external functions in Snowflake?

• A.They are a type of User-defined Function (UDF).
• B.They contain their own SQL code.
• C.They call code that is stored inside of Snowflake.
• D.They can return multiple rows for each row received

Comment: *

Name: *

Email: *

Verification: *

Which command allows a user to unload data from a Snowflake database table into one or more files in a Snowflake or external stage?

• A.GET
• B.LIST
• C.PUT
• D.COPY INTO <location>

Comment: *

Name: *

Email: *

Verification: *