Question 1

Which of the below standard API objects are supported by the Snowflake connector for Python

Options :

A : Connection

B : Cursor

C : SnowflakeConnection

D : SnowflakeCursor

Answer: A,B

Question 2

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

Question 3

Which of the below statement is true when search access path hasn’t been updated yet by search optimization?

Options :

A : Queries might run slower but will always return up-to-date results.

B : There will be no impact on performance but queries might return stale data

C : Queries will fail when the access path is getting updated

Answer: A

Question 4

Which of the following objects are automatically created by the KAFKA connector?

Options :

A : One internal stage to temporarily store data files for each topic.

B : One pipe to ingest the data files for each topic partition.

C : One table for each topic

D : One external stage to temporarily store data files for each topic.

Answer: A,B,C

Question 5

Changing the retention period for your account or individual objects changes the value for all lower-level objects that do not have a retention period explicitly set?

Options :

A : TRUE

B : FALSE

Answer: A