Question 1

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 2

A company wants to protect sensitive email addresses in a table so that only users with the "HR_ADMIN" role can see the actual values, while all other roles see masked data. They need the masking to be applied dynamically at query time without altering the stored data. Which Snowflake feature should they use?

Options :

A : Secure views that filter the email column based on the querying role

B : External tokenization to replace email values with tokens before loading

C : Dynamic data masking using a masking policy applied to the email column

D : Row access policies to filter rows containing email addresses

Answer: C

Question 3

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 4

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

Options :

A : True

B : False

Answer: B

Question 5

Which object does an external function make use of to hold security related information? Choose one correct value.

Options :

A : Security folder.

B : API Integration.

C : API Keystore.

D : Storage Integration.

Answer: B

Free COF-C03 Mock Exam – Practice Online Confidently

Buying Options: