COF-C02 Questions Bank

SnowPro Core Certification Exam Questions and Answers

Question 129

When working with a managed access schema, who has the OWNERSHIP privilege of any tables added to the schema?

The database owner

The object owner

The schema owner

The Snowflake user's role

Question 130

How should clustering be used to optimize the performance of queries that run on a very large table?

Manually re-cluster the table regularly.

Choose one high cardinality column as the clustering key.

Use the column that is most-frequently used in query select clauses as the clustering key.

Assess the average table depth to identify how clustering is impacting the query.

Question 131

A tag object has been assigned to a table (TABLE_A) in a schema within a Snowflake database.

Which CREATE object statement will automatically assign the TABLE_A tag to a target object?

CREATE TABLE LIKE TABLE_A;

CREATE VIEW AS SELECT * FROM TABLE_A;

CREATE TABLE AS SELECT * FROM TABLE_A;

CREATE MATERIALIZED VIEW AS SELECT * FROM TABLE A;

Question 132

Which metadata table will store the storage utilization information even for dropped tables?

DATABASE_STORAGE_USAGE_HISTORY

TABLE_STORAGE_METRICS

STORAGE_DAILY_HISTORY

STAGE STORAGE USAGE HISTORY