Question 1

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 2

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 3

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 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 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

Confidently Practice Online with Free COF-C03 Exam Cram

Buying Options: