Free Online Snowflake SnowPro-Core Practice Test

Prepare Your Snowflake SnowPro-Core Exam Questions with Free online SnowPro-Core Practice Test. Get Brilliant SnowPro Core Certification (COF-C02) Exam Results with Valid SnowPro Core Exam Dumps.

Page: 1 / 279

Total 1392 Questions | Updated On: May 16, 2024

Add To Cart

Question 1

How can be Micro-Partitions well defined in SnowFlake?

A : Contiguous units of storage

B : Similar to Static partitioning in Traditional data warehouses

C : Database Micro Services

D : Hybrid Columnar MPP

Answer: A

Question 2

What is the most granular object that the Time Travel retention period can be defined on? Select one.

A : Account

B : Database

C : Schema

D : Schema

Answer: D

Question 3

What is the PUT command used for?

A : Transfer data from cloud object storage to on-premise storage

B : Transfer data into a Snowflake external stage.

C : Transfer data into a Snowflake internal stage.

D : Transfer data from on-premise storage to cloud object storage

Answer: C

Question 4

When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?

A : A single join node uses more than 50% of the query time

B : Partitions scanned is equal to partitions total

C : An AggregateOperacor node is present

D : The query is spilling to remote storage

Answer: D

Question 5

In a VARIANT column, the NULL values are stored as a literal string "null"

A : False

B : True

Answer: B

Page: 1 / 279

Total 1392 Questions | Updated On: May 16, 2024

Add To Cart