Question 1

For a particular business group, number of concurrent users are large but do not fluctuate. These users run queries on snowflake and expects extremely low latency response. The queries are all standard and same and need to be served from the result cache to meet the low latency requirement. Which of the below option will you choose?

Options :

A : Provision a multi-cluster warehouse and run it in maximized mode

B : Provision a multi-cluster warehouse and run it in economy mode

C : Provision a small warehouse and monitor the query overload metrics

Answer: A

Question 2

Streams record the differences between two offsets. If a row is added and then updated in the cur-rent offset, what will be the value of METADATA$ISUPDATE Columns in this scenario?

Options :

A : TRUE

B : FALSE

C : UPDATE

D : INSERT

Answer: B

Question 3

If a user is granted ROLE-A, what roles he can switch from the Snowflake UI?

Options :

A : SYSADMIN, ROLE-A, ROLE-B,ROLE-C,ROLE-D,ROLE-E

B : ROLE-A,ROLE-B,ROLE-C

C : ROLE-A, ROLE-B,ROLE-C,ROLE-D,ROLE-E

D : ROLE-A

Answer: C

Question 4

David, a Lead Data engineer with XYZ company looking out to improve query performance & oth-er benefits

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

Which of the following System keeps the following characteristics?

a. It will keep in it all the raw data.

b. Generally, the users of it is data scientists and data developers.

c. Flat architecture

d. Highly agile

Options :

A : Data Warehouse

B : Data Mart

C : Data Lake

D : Data Hub

Answer: C

Confidently Practice Online with Free SnowPro-Advanced-Data-Engineer Exam Cram

Buying Options: