← Back to exam page

COF-C02 – SnowPro Core Certification Exam (COF-C02)

Loading demo links...

Showing 13–15 of 15 questions

Question 13 (Exam pool A)

What features does Snowflake Time Travel enable?

Select an option, then click Submit answer.

  • ○

    Querying data-related objects that were created within the past 365 days
  • ○

    Restoring data-related objects that have been deleted within the past 90 days
  • ○

    Conducting point-in-time analysis for Bl reporting
  • ○

    Analyzing data usage/manipulation over all periods of time
Question 14 (Exam pool B)

For non-materialized views, what column in Information Schema and Account Usage identifies whether a view is secure or not?

Select an option, then click Submit answer.

  • ○

    CHECK_OPTION
  • ○

    IS_SECURE
  • ○

    IS_UPDATEABLE
  • ○

    TABLE_NAME
Question 15 (Exam pool A)

What is a best practice after creating a custom role?

Select an option, then click Submit answer.

  • ○

    Create the custom role using the SYSADMIN role.
  • ○

    Assign the custom role to the SYSADMIN role
  • ○

    Assign the custom role to the PUBLIC role
  • ○

    Add__CUSTOM to all custom role names