Question 1

Fail-safe is available for external tables. True or false?

Options :

A : True

B : False

Answer: B

Question 2

A 2.5 TB sales fact table is queried 90% of the time with predicates on ORDER_DATE and REGION_CODE (approximately 150 distinct regions). The remaining 10% of queries are ad-hoc and use various columns. In which scenario is defining a clustering key most beneficial?

Options :

A : The table receives 50 million new rows daily via COPY commands

B : The table is joined daily with a 5 GB dimension table on REGION_CODE

C : The table is constantly updated with DELETE and UPDATE statements on random rows

D : Most queries contain WHERE ORDER_DATE BETWEEN … and filter on REGION_CODE

Answer: D

Question 3

What is the section in bold of the following Snowflake account URL referred to as: xy12345.us-east-2.aws.snowflakecomputing.com? Choose one correct value.

Options :

A : Account Identifier

B : Account Region

C : Organisation Name

D : Cloud Platform

Answer: A

Question 4

Which types of notation are used to traverse semi-structured data natively in Snowflake? Select all that apply.

Options :

A : Dot notation.

B : Bracket notation.

C : Colon notation.

D : Dollar notation.

Answer: A,B

Question 5

Which languages can be used to develop a User Defined Function (UDF)? Choose four correct values.

Options :

A : Java

B : GO

C : JavaScript

D : Python

E : C#

F : C++

G : SQL

Answer: A,C,D,G

Free COF-C03 Mock Exam – Practice Online Confidently

Buying Options: