Snowflake COF-C02 Exam Practice Test Instant Access

Question 1

What metadata does Snowflake store concerning all rows stored in a micro-partition? (Select TWO).

AA count of the number of total values in the micro-partition

BThe range of values for each partition in the micro-partition

CThe range of values for each of the rows in the micro-partition

DThe range of values for each of the columns in the micro-partition

EThe number of distinct values for each column in the micro-partition

Answer : A, D

Question 2

Using which object-level parameters will help limit query processing and concurrency slowdowns? (Select TWO).

AOption A

BOption B

COption C

DOption D

EOption E

Answer : C, D

Question 3

Which statement will trigger a stream to advance its offset?

ADESCRIBE STREAM

BALTER STREAM

CDROP STREM

DCREATE OR REPLACE STREAM

Answer : D

Question 4

What kind of value does a User-Defined Function (UDF) return? (Select TWO).

ADictionary

BList

CObject

DScalar

ETabular

Answer : D, E

Question 5

What virtual warehouse feature or setting will reduce the performance impact when running larger-than-average queries by offloading portions of the query processing work to shared compute resources?

AUsing a multi-cluster virtual warehouse

BUsing the query acceleration service

CUsing the search optimization service

DDisabling auto-suspend

Answer : B

Question 6

Which multi-duster virtual warehouse setting will help process queued queries as quickly as possible?

AAn economy scaling policy

BA standard scaling policy

CMaximized mode

DAuto-scale mode

Answer : C, D

Question 7

Which JSON paths are considered to be equivalent in Snowflake? (Select TWO).

AOption A

BOption B

COption C

DOption D

EOption E

Answer : A

Snowflake COF-C02 SnowPro Core Certification Exam Practice Test