COF-R02 무료 덤프문제 온라인 액세스

What are supported file formats for unloading data from Snowflake? (Choose three.)

• A.JSON
• B.ORC
• C.XML
• D.Parquet
• E.AVRO
• F.CSV

True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.

• A.True
• B.False

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

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

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

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

How often are the Account and Table master keys automatically rotated by Snowflake?

• A.60 Days
• B.30 Days
• C.90 Days
• D.365 Days.