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

Auto-suspend

Auto-resume

Local SSD size

User count

Number of users

Warehouse size

Amount of data processed

# of clusters for the Warehouse

All columns in a micro-partition

Any columns accessed during the query

The columns in the result set of the query

All rows accessed during the query

A reader account can consume data from the provider account that created it and combine it with its own data.

A consumer needs to become a licensed Snowflake customer as data sharing is only supported between Snowflake accounts.

The users in a reader account can query data that has been shared with the reader account and can perform DML tasks.

The SHOW MANAGED ACCOUNTS command will view all the reader accounts that have been created for an account.

90 days

1 day

7 days

45 days

Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of execution

Querying (select) the size of the stream content would help determine the warehouse size. For example, if querying large stream content, use a larger warehouse size

If using the stored procedure to execute multiple SQL statements, it's best to test run the stored procedure separately to size the compute resource first

Since task infrastructure is based on running the task body on schedule, it's recommended to configure the virtual warehouse for automatic concurrency handling using Multi-cluster warehouse (MCW) to match the task schedule

Metadata cache

Result cache

Remote cache

Local file cache

STATEMENT_TIMEOUT__IN__SECONDS

STATEMENT_QUEUED_TIMEOUT_IN_SECONDS

MAX_CONCURRENCY__LEVEL

QUERY_TIMEOUT_IN_SECONDS

VARIANT

ARRAY

VARCHAR

XML

BLOB