Free Snowflake COF-R02 Practice Exam with Questions & Answers | Set: 3

Metadata cache

Result cache

Remote cache

Local file cache

SELECT LAST_SUCCESS_LOGIN, LOGIN_NAME

FROM ACCOUNT_USAGE.USERS;

SELECT EVENT_TIMESTAMP, USER_NAME

FROM table(information_schema.login_history_by_user())

SELECT EVENT_TIMESTAMP, USER_NAME

FROM ACCOUNT_USAGE.ACCESS_HISTORY;

SELECT EVENT_TIMESTAMP, USER_NAME

FROM ACCOUNT_USAGE.LOGIN_HISTORY;

Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.

Yes. because the compute resource is replaced in its entirety with a new compute resource.

No. because the size of the cache is independent from the warehouse size

Yes. became the new compute resource will no longer have access to the cache encryption key

The user has the appropriate privileges on the objects associated with the query

Micro-partitions have been reclustered since the query was last run

The new query is run using the same virtual warehouse as the previous query

The query includes a User Defined Function (UDF)

The query has been run within 24 hours of the previously-run query

Alation

DataRobot

dbt

Tableau

Query against the result set cache

Query against a virtual warehouse cache

Query against the most-recently created micro-partition

Query against the metadata excite

Cluster keys

Time Travel

Fail-safe

Cloning

A Materialized View cannot support any aggregate functions

A Materialized View can only reference up to two tables

A Materialized View cannot be joined with other tables

A Materialized View cannot be defined with a JOIN

Compute resources

Query execution

Authentication

Data storage

Metadata

Credits are billed per-minute with a 60-minute minimum

Credits are used to pay for cloud data storage usage

Credits are consumed based on the number of credits billed for each hour that a warehouse runs

Credits are consumed based on the warehouse size and the time the warehouse is running