COF-R02 Exam Dumps - Snowflake SnowPro Core Certification Questions and Answers

CREATE SHARE

ALTER WAREHOUSE

DROP ROLE

SHOW SCHEMAS

DESCRBE TABLE

Authentication

Resource management

Virtual warehouse caching

Query parsing and optimization

Query execution

Physical storage of micro-partitions

account__usage . query history view

account__usage.query__history__archive View

information__schema . cruery_history view

information__schema - query history_by_ses s i on view

Standard Edition

Enterprise Edition

Business Critical Edition

Virtual Private Snowflake Edition

ROLEADMIN

ACCOUNTADMIN

SYSADMIN

SECURITYADMIN

USERADMIN

CREATE_SHARE on the account

SHARE on databases and schemas

SELECT on tables used by the secure view

REFERENCE_USAGE on databases

Amazon Web Services

Docker

IBM Cloud

Microsoft Azure Cloud

Google Cloud Platform

Oracle Cloud

When a virtual warehouse is suspended, the data cache is saved on the remote storage layer.

When the data cache is full, the least-recently used data will be cleared to make room.

A user can only access their own queries from the query result cache.

A user must set USE_METADATA_CACHE to TRUE to use the metadata cache in queries.

The RESULT_SCAN table function can access and filter the contents of the query result cache.

Grant the OWNERSHIP privilege on the schema.

Grant the OWNERSHIP privilege on the database.

Grant the MANAGE GRANTS global privilege.

Grant ALL privileges on the schema.

SINGLE=TRUE

MULTIPLE=TRUE

MULTIPLE=FALSE

SINGLE=FALSE