Question 1

When loading data into a table that captures the load time in a column with a default value of either CURRENT_TIME () or CURRENT_TIMESTAMP() what will occur?

Options :

A :

All rows loaded using a specific COPY statement will have varying timestamps based on when the rows were inserted.

B :

Any rows loaded using a specific COPY statement will have varying timestamps based on when the rows were read from the source.

C :

Any rows loaded using a specific COPY statement will have varying timestamps based on when the rows were created in the source.

D : All rows loaded using a specific COPY statement will have the same timestamp value.

Answer: D

Question 2

A healthcare company is deploying a Snowflake account that may include Personal Health Information (PHI). The company must ensure compliance with all relevant privacy standards. Which best practice recommendations will meet data protection and compliance requirements? (Choose three.)

Options :

A : Use, at minimum, the Business Critical edition of Snowflake.

B : Create Dynamic Data Masking policies and apply them to columns that contain PHI.

C : Use the Internal Tokenization feature to obfuscate sensitive data.

D : Use the External Tokenization feature to obfuscate sensitive data.

E : Rewrite SQL queries to eliminate projections of PHI data based on current_role().

F : Avoid sharing data with partner organizations.

Answer: A,B,D

Question 3

An Architect would like to save quarter-end financial results for the previous six years.

Which Snowflake feature can the Architect use to accomplish this?

Options :

A : Search optimization service

B : Materialized view

C : Time Travel

D : Zero-copy cloning

E : Secure views

Answer: D

Question 4

An Architect is troubleshooting a query with poor performance using the QUERY_HIST0RY function. The

Architect observes that the COMPILATIONJHME is greater than the EXECUTIONJTIME.

What is the reason for this?

Options :

A : The query is processing a very large dataset.

B : The query has overly complex logic.

C : The query is queued for execution.

D : The query is reading from remote storage.

Answer: B

Question 5

The following DDL command was used to create a task based on a stream:

Assuming MY_WH is set to auto_suspend – 60 and used exclusively for this task, which statement is true?

Options :

A : The warehouse MY_WH will be made active every five minutes to check the stream.

B : The warehouse MY_WH will only be active when there are results in the stream.

C : The warehouse MY_WH will never suspend.

D : The warehouse MY_WH will automatically resize to accommodate the size of the stream.

Answer: B