Question 1

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 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 architecture

d. Highly agile

Options :

A : Data Warehouse

B : Data Mart

C : Data Lake

D : Data Hub

Answer: C

Question 3

Mark the incorrect statement in case Data engineer using the COPY INTO command to load data from files into Snowflake tables?

Options :

A : For Data loading of files with semi-structured file formats (JSON, Avro, etc.), the only supported character set is UTF-16.

B : For loading data from all semi-structured supported file formats (JSON, Avro, etc.), as well as unloading data, UTF-8 is the only supported character set.

C : For Local environment, Files are first copied (“staged”) to an internal (Snowflake) stage, then loaded into a table.

D : UTF-32 & UTF-16 both encoding character sets supported for loading data from de-limited files (CSV, TSV, etc.)

Answer: A

Question 4

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 5

For a business group, you need to create a table with customer demography data in snowflake. Business users will need to do both range and equality searches on the table. Which of the below techniques will you use to speed up the queries.

Options :

A : Create a materialized view on the table and create the required clustering key

B : Turn on search optimization for the table

C : Create a secure view for each of the search access patterns

Answer: A