Question 1

How does Snowflake charge for the compute resources of the cloud services layer?

Options :

A : It’s a stable cost of 10$ per month

B : It’s included in the computing cost

C : The typical utilization of the cloud services layer (up to 10% of daily compute credits) is included for free. You pay the excess after this 10%.

D : The typical utilization of the cloud services layer (up to 10% of daily compute credits) is included for free. You pay the excess after this 20%.

Answer: C

Question 2

Your business team runs a set of identical queries every day after the batch ETL run is complete. From the following actions, what is the best action that you will recommend.

Options :

A : After the ETL run, execute the identical queries so that they remain in the result cache

B : After the ETL run, resize the warehouse to a larger warehouse

C : After the ETL run, copy the tables to another schema for the business users to query

Answer: A

Question 3

For authentication, snowflake Kafka connector relies on:

Options :

A : key pair authentication

B :

username/password

C : Both key pair authentication and username/password

Answer: A

Question 4

When using the Snowflake Connector for Kafka, what data formats are supported for the messages? (Choose two.)

Options :

A : CSV

B : XML

C : Avro

D : JSON

E : Parquet

Answer: C,D

Question 5

You ran the below query and it took a long time to run

select itembarcode from checkouts where BIBNUMBER = '2213435';

The clustering information shows the below result. What can you derive from this information

select system$clustering_information('checkouts','(BIBNUMBER)');

2020-09-06-20-26-48-21b07202e527a5b67bbba720952a3ecf

Options :

A : The data is not clustered well by BIBNUMBER and it is spread across all the micro-partitions, hence to retrieve a small number of micro-partitions, the query has to scan all the partitions in the table

B : The query is running slow because the warehouse does not have enough memory

C : The query is running slow because BIBNUMBER does not have an index created on it.

Answer: A