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

Select all that apply, then click Submit answer.

• ○

  SCIM

• ○

  Federated authentication

• ○

  TLS 1.2

• ○

  Key-pair authentication

• ○

  OAuth

• ○

  OCSP authentication

Select all that apply, then click Submit answer.

• ○

  Users

• ○

  Tables

• ○

  Databases

• ○

  Internal Stages
  

Select all that apply, then click Submit answer.

• ○

  When dropping an external stage, the files are not removed and only the stage is dropped

• ○

  When dropping an external stage, both the stage and the files within the stage are removed

• ○

  When dropping an internal stage, the files are deleted with the stage and the files are recoverable

• ○

  When dropping an internal stage, the files are deleted with the stage and the files are not recoverable

• ○

  When dropping an internal stage, only selected files are deleted with the stage and are not recoverable

Select all that apply, then click Submit answer.

• ○

  Snowflake data and services are deployed in a single availability zone within a cloud provider's region.

• ○

  Snowflake data and services are available in a single cloud provider and a single region, the use of multiple cloud providers is not supported.

• ○

  Snowflake can be deployed in a customer's private cloud using the customer's own compute and storage resources for Snowflake compute and storage

• ○

  Snowflake uses the core compute and storage services of each cloud provider for its own compute and storage

• ○

  All three layers of Snowflake's architecture (storage, compute, and cloud services) are deployed and managed entirely on a selected cloud platform

• ○

  Snowflake data and services are deployed in at least three availability zones within a cloud provider's region

Select all that apply, then click Submit answer.

• ○

  Schemas

• ○

  Roles

• ○

  Secure Views

• ○

  Stored Procedures

• ○

  Tables

• ○

  Secure User-Defined Functions (UDFs)

Select all that apply, then click Submit answer.

• ○

  ORC

• ○

  XML

• ○

  Avro

• ○

  Parquet

• ○

  JSON

Select all that apply, then click Submit answer.

• ○

  Compute

• ○

  Tri-Secret Secure

• ○

  Storage

• ○

  Cloud Services
  

Select an option, then click Submit answer.

• ○

  The USERS view in ACCOUNT_USAGE

• ○

  The LOGIN_HISTORY view in ACCOUNT_USAGE

• ○

  The ACCESS_HISTORY view in ACCOUNT_USAGE

• ○

  The SESSIONS view in ACCOUNT_USAGE

Select an option, then click Submit answer.

• ○

  Standard

• ○

  Premier

• ○

  Enterprise

• ○

  Business Critical Edition

Select an option, then click Submit answer.

• ○

  8-16 MB

• ○

  16-24 MB

• ○

  10-99 MB

• ○

  100-250 MB

Select an option, then click Submit answer.

• ○

  The filtering or disregarding of micro-partitions that are not needed to return a query.

• ○

  The return of micro-partitions values that overlap with each other to reduce a query's runtime.

• ○

  A service that is handled by the Snowflake Cloud Services layer to optimize caching.

• ○

  The ability to allow the result of a query to be accessed as if it were a table.

Select an option, then click Submit answer.

• ○

  The data is cloned into a historical object.

• ○

  The data moves to Fail-safe

• ○

  Time Travel on the historical data is dropped.

• ○

  The object containing the historical data is dropped.

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;

Select an option, then click Submit answer.

• ○

  12am-5am

• ○

  Only during administrator defined time slots

• ○

  When its provisioning is complete

• ○

  After replication

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.