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

Vce COF-C02 Questions Latest

Page: 25 / 52
Total 693 questions

SnowPro Core Certification Exam Questions and Answers

Question 97

Which snowflake objects will incur both storage and cloud compute charges? (Select TWO)

Options:

A.

Materialized view

B.

Sequence

C.

Secure view

D.

Transient table

E.

Clustered table

Question 98

A single user of a virtual warehouse has set the warehouse to auto-resume and auto-suspend after 10 minutes. The warehouse is currently suspended and the user performs the following actions:

1. Runs a query that takes 3 minutes to complete

2. Leaves for 15 minutes

3. Returns and runs a query that takes 10 seconds to complete

4. Manually suspends the warehouse as soon as the last query was completed

When the user returns, how much billable compute time will have been consumed?

Options:

A.

4 minutes

B.

10 minutes

C.

14 minutes

D.

24 minutes

Question 99

Network policies can be set at which Snowflake levels? (Choose two.)

Options:

A.

Role

B.

Schema

C.

User

D.

Database

E.

Account

F.

Tables

Question 100

The Snowflake Search Optimization Services supports improved performance of which kind of query?

Options:

A.

Queries against large tables where frequent DML occurs

B.

Queries against tables larger than 1 TB

C.

Selective point lookup queries

D.

Queries against a subset of columns in a table

Page: 25 / 52
Total 693 questions