COF-R02 試験問題を無料オンラインアクセス

A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?

• A.The Queries currently being run on the virtual warehouse
• B.The primary cluster in the virtual warehouse
• C.The entire virtual warehouse
• D.The database in which the virtual warehouse resides

The Query History in the Snowflake Web Interface (UI) is kept for approximately:

• A.30 days
• B.14 days
• C.60 minutes
• D.1 year
• E.24 hours

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

• A.SHOW GRANTS FOR ROLE MY_ROLE
• B.SHOW GRANTS OF ROLE MY_ROLE
• C.SHOW GRANTS ON ROLE MY_ROLE
• D.SHOW GRANTS TO ROLE MY_ROLE

True or False: Micro-partition metadata enables some operations to be completed without requiring Compute.

• A.False
• B.True

Which TABLE function helps to convert semi-structured data to a relational representation?

• A.CHECK_JSON
• B.PARSE_JSON
• C.FLATTEN
• D.TO_JSON