Question 1

When loading data into a table that captures the load time in a column with a default value of either CURRENT_TIME () or CURRENT_TIMESTAMP() what will occur?

Options :

A :

All rows loaded using a specific COPY statement will have varying timestamps based on when the rows were inserted.

B :

Any rows loaded using a specific COPY statement will have varying timestamps based on when the rows were read from the source.

C :

Any rows loaded using a specific COPY statement will have varying timestamps based on when the rows were created in the source.

D : All rows loaded using a specific COPY statement will have the same timestamp value.

Answer: D

Question 2

Which data models can be used when modeling tables in a Snowflake environment? (Select THREE).

Options :

A : Graph model

B : Dimensional/Kimball

C : Data lake

D : lnmon/3NF

E : Bayesian hierarchical model

F : Data vault

Answer: B,D,F

Question 3

An Architect is troubleshooting a query with poor performance using the QUERY function. The Architect observes that the COMPILATION_TIME Is greater than the EXECUTION_TIME. What is the reason for this?

Options :

A : The query is processing a very large dataset.

B : The query has overly complex logic.

C : The query Is queued for execution.

D : The query Is reading from remote storage

Answer: B

Question 4

What is a key consideration when setting up search optimization service for a table?

Options :

A : Search optimization service works best with a column that has a minimum of 100 K distinct values.

B : Search optimization service can significantly improve query performance on partitioned external tables.

C :

Search optimization service can help to optimize storage usage by compressing the data into a GZIP format.

D : The table must be clustered with a key having multiple columns for effective search optimization.

Answer: A

Question 5

The following DDL command was used to create a task based on a stream:

Assuming MY_WH is set to auto_suspend – 60 and used exclusively for this task, which statement is true?

Options :

A : The warehouse MY_WH will be made active every five minutes to check the stream.

B : The warehouse MY_WH will only be active when there are results in the stream.

C : The warehouse MY_WH will never suspend.

D : The warehouse MY_WH will automatically resize to accommodate the size of the stream.

Answer: B

Confidently Practice Online with Free ARA-R01 Exam Cram

Buying Options: