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

Which objects are included in replication when a primary database is replicated? Select TWO.

• A.Pipes
• B.External tables
• C.Secure views
• D.Dynamic tables
• E.Event tables

What metadata does Snowflake store for rows in micro-partitions? (Select TWO).

• A.Distinct values
• B.Range of values
• C.Index values
• D.Null values
• E.Sorted values

Which strategy for optimizing virtual warehouse performance should be used to speed the execution of a very large query?

• A.Increase the size of the warehouse.
• B.Convert to a multi-cluster warehouse.
• C.Use the query acceleration service.
• D.Enable the search optimization service.

How can a user work with multiple assigned roles without the need to frequently switch roles?

• A.Grant the user the ACCOUNTADMIN role.
• B.Use secondary roles and primary roles.
• C.Grant the user the parent role of the roles that have been assigned.
• D.Create a new role and grant it to the user, then grant the existing roles to the new role.

A user created a transient table and made several changes to it over the course of several days. Three days after the table was created, the user would like to go back to the first version of the table.
How can this be accomplished?

• A.Contact Snowflake Support to have the data retrieved from Fail-safe storage.
• B.Use Time Travel, as long as DATA_RETENTION_TIME_IN_DAYS was set to at least 3 days.
• C.The transient table version cannot be retrieved after 24 hours.
• D.Use the FAIL_SAFE parameter for Time Travel to retrieve the data from Fail-safe storage.