← Back to exam page

Free COF-C02 – SnowPro Core Certification Exam (COF-C02) Practice Test Question

Free demo downloads

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