Question 1

Files stored in snowflake stage are automatically encrypted using either AES 128 or 256 strong encryption.

Options :

A : TRUE

B : FALSE

Answer: A

Question 2

Which data transformations are supported for data loading using the COPY INTO command? (Select THREE).

Options :

A : Column re-ordering

B : Window functions

C : Subqueries

D : Data type conversions

E : Joining to other staged data

F : Loading a subset of the data

Answer: A,D,F

Question 3

What does a successful response from the insertFiles Snowpipe endpoint mean?

Options :

A : Snowflake has recorded the list of files to add to the table.

B : The files have been ingested.

C : It Retrieves a report of files submitted via the insertFile endpoint.

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

A table, EMP_ TBL has three records as shown:

The following variables are set for the session:

Which SELECT statements will retrieve all three records? (Select TWO).

Options :

A : Select * FROM Stbl_ref WHERE Scol_ref IN ('Name1','Nam2','Name3');

B : SELECT * FROM EMP_TBL WHERE identifier(Scol_ref) IN ('Namel','Name2', 'Name3');

C : SELECT * FROM identifier WHERE NAME IN ($var1, $var2, $var3);

D : SELECT * FROM identifier($tbl_ref) WHERE ID IN Cvarl','var2','var3');

E : SELECT * FROM $tb1_ref WHERE $col_ref IN ($var1, Svar2, Svar3);

Answer: B,E

Higher Test Marks with Free Online SnowPro-Advanced-Architect Exam Practice

Buying Options: