Question 1

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 2

A company has an inbound share set up with eight tables and five secure views. The company plans to make the share part of its production data pipelines. Which actions can the company take with the inbound share? (Choose two.)

Options :

A : Clone a table from a share.

B : Grant modify permissions on the share.

C : Create a table from the shared database.

D : Create additional views inside the shared database.

E : Create a table stream on the shared table.

Answer: A,D

Question 3

Which SQL alter command will MAXIMIZE memory and compute resources for a Snowpark stored procedure when executed on the snowpark_opt_wh warehouse?

Options :

A :

B :

C :

D :

Answer: A

Question 4

When loading data from stage using COPY INTO, what options can you specify for the ON_ERROR clause?

Options :

A : CONTINUE

B : SKIP_FILE

C : ABORT_STATEMENT

D : FAIL

Answer: A,B,C

Question 5

When using the copy into < table > command with the CSV file format, how does the match_by_column_name parameter behave?

Options :

A : It expects a header to be present in the CSV file, which is matched to a case-sensitive table column name.

B : The parameter will be ignored.

C : The command will return an error.

D : The command will return a warning stating that the file has unmatched columns.

Answer: B

Free ARA-R01 Mock Exam – Practice Online Confidently

Buying Options: