Question 1

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

Question 2

When using the sampling methods in Snowflake, which of the following is true about the SYSTEM sampling method?

Options :

A : It cannot be combined with a seed value.

B : It applies sampling at the individual row level.

C : It provides a perfectly random sample of the dataset.

D : It operates at the micro-partition level, offering improved efficiency.

Answer: D

Question 3

Which of the following values are Snowflake editions? Choose two correct values.

Options :

A : Standard

B : Premium

C : Enterprise

D : Economy

E : Plus

Answer: A,C

Question 4

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 5

What is the function of the AUTO_SUSPEND property of a Virtual Warehouse? Choose one correct value.

Options :

A : Specifies if a Virtual Warehouse should be suspended immediately after its created.

B : Specifies whether to automatically resume a warehouse when a SQL statement is submitted to it.

C : Specifies the number of seconds of inactivity after which a warehouse is automatically suspended.

D : Specifies the max threshold of queries after which point a virtual warehouse will be automatically suspended.

Answer: C