Winter Sale Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: v4s65

  1. Home
  2. Snowflake
  3. SnowPro Core Certification
  4. COF-C02 - SnowPro Core Certification Exam

COF-C02 Exam Dumps - SnowPro Core Certification Exam

Go to page:
Question # 57

What does Snowflake recommend as a best practice for using secure views?

A.

Use sequence-gen era ted values

B.

Programmatically reveal the identifiers.

C.

Use secure views solely for query convenience.

D.

Do not expose the sequence-generated column(s)

Full Access
Question # 58

Which virtual warehouse consideration can help lower compute resource credit consumption?

A.

Setting up a multi-cluster virtual warehouse

B.

Resizing the virtual warehouse to a larger size

C.

Automating the virtual warehouse suspension and resumption settings

D.

Increasing the maximum cluster count parameter for a multi-cluster virtual warehouse

Full Access
Question # 59

Snowflake users can create a resource monitor at which levels? (Select TWO).

A.

User level

B.

Pipe level

C.

Account level

D.

Cloud services level

E.

Virtual warehouse level

Full Access
Question # 60

Given the statement template below, which database objects can be added to a share?(Select TWO).

GRANT ON To SHARE ;

A.

Secure functions

B.

Stored procedures

C.

Streams

D.

Tables

E.

Tasks

Full Access
Question # 61

What virtual warehouse configuration should be used when processing a large number of complex queries?

A.

Use the auto-resume feature.

B.

Run the warehouse in auto-scale mode.

C.

Increase the size of the warehouse.

D.

Increase the number of warehouse clusters.

Full Access
Question # 62

A user needs to MINIMIZE the cost of large tables that are used to store transitory data. The data does not need to be protected against failures, because the data can be reconstructed outside of Snowflake.

What table type should be used?

A.

Permanent

B.

Transient

C.

Temporary

D.

Externa

Full Access
Question # 63

What are the main differences between the account usage views and the information schema views? (Select TWO).

A.

No active warehouse to needed to query account usage views but one is needed to query information schema views.

B.

Account usage views do not contain data about tables but information schema views do.

C.

Account issue views contain dropped objects but information schema views do not.

D.

Data retention for account usage views is 1 year but is 7 days to 6 months for information schema views, depending on the view.

E.

Information schema views are read-only but account usage views are not.

Full Access
Question # 64

What action should be taken if a Snowflake user wants to share a newly created object in a database with consumers?

A.

Use the automatic sharing feature for seamless access.

B.

Drop the object and then re-add it to the database to trigger sharing.

C.

Recreate the object with a different name in the database before sharing.

D.

Use the grant privilege ... TO share command to grant the necessary privileges.

Full Access
Go to page:

Hot Exams

ADM-201 Dumps
Platform-App-Builder Dumps
AZ-500 Dumps
350-701 Dumps
SY0-601 Dumps
NCSE-Core Dumps
PDP9 Dumps
DP-203 Dumps
AZ-700 Dumps
NSE7_EFW-7.0 Dumps
Integration-Architect Dumps
CS0-003 Dumps