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

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 architectured. Highly agile

Options :

A : Data Warehouse

B : Data Mart

C : Data Lake

D : Data Hub

Answer: C

Question 3

While using kafka connector, what charges are applied to your account?

Options :

A : Snowpipe processing time

B : Data storage

C : Kafka connector usage

Answer: A,B

Question 4

It is a best practice to avoid binding data using Python's formatting function due to the risk of SQL injection.

Options :

A : TRUE

B : FALSE

Answer: A

Question 5

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

Free SnowPro-Advanced-Data-Engineer Mock Exam – Practice Online Confidently

Buying Options: