Question 1

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 2

A user named USER_01 needs access to create a materialized view on a schema EDW. STG_SCHEMA. How can this access be provided?

Options :

A :

GRANT CREATE MATERIALIZED VIEW ON SCHEMA EDW.STG_SCHEMA TO USER USER_01;

B : GRANT CREATE MATERIALIZED VIEW ON DATABASE EDW TO USER USERJD1;

C :

GRANT ROLE NEW_ROLE TO USER USER_01; GRANT CREATE MATERIALIZED VIEW ON SCHEMA ECW.STG_SCHEKA TO NEW_ROLE;

D :

GRANT ROLE NEW_ROLE TO USER_01; GRANT CREATE MATERIALIZED VIEW ON EDW.STG_SCHEMA TO NEW_ROLE;

Answer: A

Question 3

After creating the table MY_TABLE, we execute the following commands:

CREATE STREAM MYSTREAM ON TABLE MYTABLE;

INSERT INTO MYTABLE VALUES (15);

What will be the output of executing the following command?

SELECT SYSTEM$STREAM_HAS_DATA('MYSTREAM');

Options :

A : It will return “True”.

B : It will return “15”.

C : It will return “False”.

D : It will return “Null”.

Answer: A

Question 4

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

Question 5

While loading data into a table from stage, which are the valid copyOptions

Options :

A : CONTINUE

B : SKIP_FILE

C : SKIP_FILE_<NUM>

D : SKIP_FILE_<NUM>%

E : ABORT_STATEMENT

F : ERROR_STATEMENT

Answer: A,B,C,D