Question 1

You have written a procedure and a function in snowflake. How do you find your procedures and functions in snowflake?

Options :

A : SHOW PROCEDURES;SHOW FUNCTIONS;

B : SHOW ALL PROCEDURES AND FUNCTIONS

C : SHOW PROCEDURES, FUNCTIONS

Answer: A

Question 2

Which command can we use to refresh a materialized view?

Options :

A : RESTART MATERIALIZED_VIEW

B : Materialized views are automatically refreshed by Snowflake

C : ALTER MATERIALIZED_VIEW REFRESH=TRUE

Answer: B

Question 3

Where can you define the file format settings?

Options :

A : While creating named file formats

B : In the table definition

C : In the named stage definition

D : Directly in the COPY INTO TABLE statement when loading data

Answer: A,B,C,D

Question 4

What considerations need to be taken when using database cloning as a tool for data lifecycle management in a development environment? (Select TWO).

Options :

A : Any pipes in the source are not cloned.

B : Any pipes in the source referring to internal stages are not cloned.

C : Any pipes in the source referring to external stages are not cloned.

D : The clone inherits all granted privileges of all child objects in the source object, including the database.

E : The clone inherits all granted privileges of all child objects in the source object, excluding the database.

Answer: A,C

Question 5

VALIDATION_MODE does not support COPY statements that transform data during a load

Options :

A : TRUE

B : FALSE

Answer: A

Free ARA-C01 Mock Exam – Practice Online Confidently