Practice SnowPro-Core Exam Online

Question 1

Which of the following operations can be fulfilled without needing an active virtual warehouse? Select all that apply.

A : Find the average of a numeric column

B : Count the number of rows in a table

C : Find the total of a numeric column

D : Find the maximum value of a numeric column

Answer: B,D

Question 2

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 3

For idP Setup in SnowFlake, Customers have option to choose which of the below setup providers type as of today?

A : OKTA setup

B : ADFS setup

C : Custom IdP setup

D : PingFederate setup

E :

KeyClock setup

Answer: A,B,C

Question 4

Which one of the following is supported by Snowflake for the purpose of auto-provisioning users and group membership?

A : ABAC

B : RBAC

C : SCIM

D : DAC

Answer: C

Question 5

What happens when a virtual warehouse is resized?

A : When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected

B : When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements.

C : The warehouse will be suspended while the new compute resource is provisioned and will resume automatically once provisioning is complete.

D : Users who are trying to use the warehouse will receive an error message until the resizing is complete

Answer: B

Name:	SnowPro Core Certification (COF-C02)
Exam Code:	SnowPro-Core
Certification:	SnowPro Core
Vendor:	Snowflake
Total Questions:	1392
Last Updated:	Apr 24, 2024

Snowflake SnowPro-Core