Question 1

create or replace table result_scan_table_1 like result_scan_table;Will the above query cost compute credits?

Options :

A : No, since it is a metadata operation only

B : Yes, it will need compute as the table structure is also getting created

C : It is hard to say without looking at query profile

Answer: A

Question 2

Removing files from a stage after you are done loading the files improves performance when subsequently loading data

Options :

A : TRUE

B : FALSE

Answer: A

Question 3

A company security requirement states that encryption keys used for encrypting files in Snowflake need to be re-encrypted using new keys every 12 months. The company is using an Enterprise edition of Snowflake.How can this requirement be met?

Options :

A : Set the periodic_data_rekeying parameter to true.

B : Contact Snowflake Support to enable periodic rekeying.

C : Create a task to run the rekeying function on a 12-month schedule.

D : Upgrade to a Business Critical edition of Snowfiake.

Answer: A

Question 4

Materialized views are recommended for all of the scenarios except

Options :

A : Query results contain a small number of rows and/or columns relative to the base table

B : Query results contain results that require significant processing

C : The query is on an external table

D : The view’s base table changes frequently

Answer: D

Question 5

For this object, Snowflake executes code outside Snowflake; the executed code is known as remote service. What is this object called?

Options :

A : External procedure

B : External function

C : External Script

D : External job

Answer: B

Free SnowPro-Advanced-Architect Mock Exam – Practice Online Confidently

Buying Options: