CertsTopics Logo

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

SnowPro Core Certification COF-C02 Dumps PDF

Page: 4 / 71
Total 948 questions
Get COF-C02 Full Access Download COF-C02 PDF

SnowPro Core Certification Exam Questions and Answers

Question 13

Which actions can be performed using a resource monitor in Snowflake? (Select TWO).

Options:

A.

Monitor the performance of individual queries in real-time

B.

Automatically allocate more storage space to a virtual warehouse

C.

Modify the queries being executed within a virtual warehouse.

D.

Suspend a virtual warehouse when its credit usage reaches a defined limit.

E.

Trigger a notification to account administrators when credit usage reaches a specified threshold

Question 14

What Snowflake features are recommended to restrict unauthorized users from accessing Personal Identifiable Information (PII)? (Select TWO).

Options:

A.

Dynamic Data Masking

B.

Transient tables

C.

Secure views

D.

Multi-Factor Authentication (MFA)

E.

Data encryption

Question 15

Which statement will execute a stored procedure?

Options:

A.

CALL proc1(SELECT COUNT(*) FROM

);

B.

CALL proc1(1) + proc1(2);

C.

CALL proc1(1) + IF

D.

CALL proc1(proc2(1));

Question 16

How can a Snowflake user access near real-time metrics that can be used to identify queries affected by disk spilling?

Options:

A.

Use a load monitoring chart.

B.

Review the history section of the Query Profile.

C.

Implement a Snowsight dashboard.

D.

Use a worksheet.

Page: 4 / 71
Total 948 questions
Get COF-C02 Full Access Download COF-C02 PDF