Question 1

For the best performance while loading data into table from a stage, you should avoid applying patterns that filter on a large number of files.

Options :

A : FALSE

B : TRUE

Answer: B

Question 2

A Snowflake Architect Is working with Data Modelers and Table Designers to draft an ELT framework specifically for data loading using Snowpipe. The Table Designers will add a timestamp column that Inserts the current tlmestamp as the default value as records are loaded into a table. The Intent is to capture the time when each record gets loaded into the table; however, when tested the timestamps are earlier than the loae_take column values returned by the copy_history function or the Copy_HISTORY view (Account Usage). Why Is this occurring?

Options :

A : The timestamps are different because there are parameter setup mismatches. The parameters need to be realigned

B : The Snowflake timezone parameter Is different from the cloud provider-s parameters causing the mismatch.

C : The Table Designer team has not used the localtimestamp or systimestamp functions in the Snowflake copy statement.

D : The CURRENT_TIMEis evaluated when the load operation is compiled in cloud services rather than when the record is inserted into the table.

Answer: D

Question 3

A copy command is executed to load a file.After the file has loaded and the metadata has expired, what options can be used to reload the file? (Select TWO).

Options :

A : Set the FORCE option to TRUE.

B : Set the DISABLE_SNOWFLAKE_DATA option to TRUE.

C : Set the ALLOW_DUPLICATE option to TRUE.

D : Set the LOAD_UNCERTAIN_FILES option to TRUE.

E : Set the PRESERVE_SPACE option to TRUE.

Answer: A,D

Question 4

What will happen if you try to ALTER a COLUMN(which has NULL values) to set it to NOT NULL

Options :

A : An error is returned and no changes are applied to the column

B : Snowflake automatically assigns a default value and let the change happen

C : Snowflake drops the row and let the change happen

Answer: A

Question 5

Data replication in snowflake helps in

Options :

A : Disaster recovery

B : Data sharing

C : Account Migration

D : Fail safe

Answer: A,B,C

Free ARA-C01 Mock Exam – Practice Online Confidently

Buying Options: