Weekend Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: Board70

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

Question # 214

What feature of Snowflake Continuous Data Protection can be used for maintenance of historical data?

Options:

A.

Access control

B.

Fail-safe

C.

Network policies

D.

Time Travel

Buy Now
Question # 215

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

Options:

A.

Manually re-cluster the table regularly.

B.

Choose one high cardinality column as the clustering key.

C.

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

D.

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

Buy Now
Question # 216

What are key characteristics of virtual warehouses in Snowflake? (Select TWO).

Options:

A.

Warehouses that are multi-cluster can have nodes of different sizes.

B.

Warehouses can be started and stopped at any time.

C.

Warehouses can be resized at any time, even while running.

D.

Warehouses are billed on a per-minute usage basis.

E.

Warehouses can only be used for querying and cannot be used for data loading.

Buy Now
Question # 217

Which object can be used with Secure Data Sharing?

Options:

A.

View

B.

Materialized view

C.

External table

D.

User-Defined Function (UDF)

Buy Now
Question # 218

What happens when a cloned table is replicated to a secondary database? (Select TWO)

Options:

A.

A read-only copy of the cloned tables is stored.

B.

The replication will not be successful.

C.

The physical data is replicated

D.

Additional costs for storage are charged to a secondary account

E.

Metadata pointers to cloned tables are replicated

Buy Now
Question # 219

How often are encryption keys automatically rotated by Snowflake?

Options:

A.

30 Days

B.

60 Days

C.

90 Days

D.

365 Days

Buy Now
Question # 220

True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.

Options:

A.

True

B.

False

Buy Now
Question # 221

What is the recommended file sizing for data loading using Snowpipe?

Options:

A.

A compressed file size greater than 100 MB, and up to 250 MB

B.

A compressed file size greater than 100 GB, and up to 250 GB

C.

A compressed file size greater than 10 MB, and up to 100 MB

D.

A compressed file size greater than 1 GB, and up to 2 GB

Buy Now
Question # 222

Which of the following describes external functions in Snowflake?

Options:

A.

They are a type of User-defined Function (UDF).

B.

They contain their own SQL code.

C.

They call code that is stored inside of Snowflake.

D.

They can return multiple rows for each row received

Buy Now
Question # 223

How can a row access policy be applied to a table or a view? (Choose two.)

Options:

A.

Within the policy DDL

B.

Within the create table or create view DDL

C.

By future APPLY for all objects in a schema

D.

Within a control table

E.

Using the command ALTER ADD ROW ACCESS POLICY ;

Buy Now