New Year Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

SnowPro-Core Reviews Questions

Page: 24 / 45
Total 605 questions

SnowPro Core Certification Exam Questions and Answers

Question 93

Which statistics can be used to identify queries that have inefficient pruning? (Select TWO).

Options:

A.

Bytes scanned

B.

Bytes written to result

C.

Partitions scanned

D.

Partitions total

E.

Percentage scanned from cache

Question 94

What is the purpose of an External Function?

Options:

A.

To call code that executes outside of Snowflake

B.

To run a function in another Snowflake database

C.

To share data in Snowflake with external parties

D.

To ingest data from on-premises data sources

Question 95

A sales table FCT_SALES has 100 million records.

The following Query was executed

SELECT COUNT (1) FROM FCT__SALES;

How did Snowflake fulfill this query?

Options:

A.

Query against the result set cache

B.

Query against a virtual warehouse cache

C.

Query against the most-recently created micro-partition

D.

Query against the metadata excite

Question 96

Which stage type can be altered and dropped?

Options:

A.

Database stage

B.

External stage

C.

Table stage

D.

User stage

Page: 24 / 45
Total 605 questions