Question 1

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

Question 2

Which feature is available starting from the Enterprise Edition of Snowflake?

Options :

A : Secure Data Sharing

B : Multi-cluster Warehouses

C : Time Travel up to 1 day

D : Customer Managed Encryption

Answer: B

Question 3

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

Options :

A : True

B : False

Answer: B

Question 4

A data engineer is running some transformation jobs using a M virtual warehouse. The virtual warehouse seems to be suspending between the jobs, making subsequent jobs take longer. What could be the issue? Choose one correct value.

Options :

A : The Virtual Warehouse AUTO_RESUME property is set to FALSE.

B : The Virtual Warehouse AUTO_SUSPEND property (in seconds) is set too low.

C : The Virtual Warehouse is too small for the workload they're running.

D : The Virtual Warehouse INITIALLY_SUSPEND property is set to TRUE.

Answer: B

Question 5

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

Higher Test Marks with Free Online COF-C03 Exam Practice

Buying Options: