← Back to exam page

Free COF-R02 – SnowPro Core Recertification Exam Practice Test Question

Free demo downloads

Loading demo links...

Showing 13–15 of 15 questions

Question 13 (Exam pool B)

A user needs to create a materialized view in the schema MYDB.MYSCHEMA.

Which statements will provide this access?

Select an option, then click Submit answer.

  • ○

    GRANT ROLE MYROLE TO USER USER1;
    CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO ROLE MYROLE;
     
  • ○

    GRANT ROLE MYROLE TO USER USER1;
    CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1;
     
  • ○

    GRANT ROLE MYROLE TO USER USER1;
    CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER1;
     
  • ○

    GRANT ROLE MYROLE TO USER USER1;
    CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE;
Question 14 (Exam pool A)

When can a Virtual Warehouse start running queries?

Select an option, then click Submit answer.

  • ○

    12am-5am
  • ○

    Only during administrator defined time slots
  • ○

    When its provisioning is complete
  • ○

    After replication
Question 15 (Exam pool A)

What privileges are required to create a task?

Select an option, then click Submit answer.

  • ○

    The global privilege create task is required to create a new task.
  • ○

    Tasks are created at the Application level and can only be created by the Account Admin role.
  • ○

    Many Snowflake DDLs are metadata operations only, and create task DDL can be executed without virtual warehouse requirement or task specific grants.
  • ○

    The role must have access to the target schema and the create task privilege on the schema itself.