Question 1

Does sensitive data in Snowflake is modified in an existing table while applying Masking policies?

Options :

A : YES

B : NO

Answer: B

Question 2

David, a Lead Data engineer with XYZ company looking out to improve query performance & oth-er benefitswhile working with Tables, Regular Views, MVs and Cached Results.Which one of the following does not shows key similarities and differences between tables, regular views,cached query results, and materialized views while choosing any of them by David?

Options :

A : Regular views do not cache data, and therefore cannot improve performance by cach-ing.

B : As with non-materialized views, a materialized view automatically inherits the privileges of its base table.

C : Cached Query Results: Used only if data has not changed and if query only uses de-terministic functions (e.g. not CURRENT_DATE).

D : Materialized views are faster than tables because of their “cache” (i.e. the query results for the view); in addition, if data has changed, they can use their “cache” for data that hasn’t changed and use the base table for any data that has changed.

E : Both materialized views and regular views enhance data security by allowing data to be exposed or hidden at the row level or column level.

Answer: B

Question 3

Each micro partition contains between 50 mb and 500 MB of uncompressed data

Options :

A : TRUE

B : FALSE

Answer: B

Question 4

What can you infer from the below query profile?

Options :

A : Less number of bytes of data are read from the cloud storage

B : More bytes are read from the cloud storage

C : The query did a good partition pruning

Answer: A

Question 5

An existing clustering key is copied in which of the below scenarios

Options :

A : CREATE TABLE...CLONE

B : CREATE TABLE...LIKE

C : CREATE TABLE...AS SELECT

Answer: A

Higher Test Marks with Free Online DEA-C02 Exam Practice

Buying Options: