Question 1

What will happen to ALTER a column setting it to NOT NULL if it contains NULL values?

Options :

A : Snowflake deletes the rows with NULL values.

B : NULL values are changed to an empty string " "

C : Snowflake returns an error

D : NULL values are changed to 0

Answer: C

Question 2

What is the meaning of “Processing” in the query profiler menu when running a query?

Options :

A : The time when the processing was waiting for the network data transfer.

B : The time spent on data processing by the CPU.

C : The time when the processing was blocked by local disk access.

Answer: B

Question 3

Remote service in external function can be an AWS Lambda function

Options :

A : TRUE

B : FALSE

Answer: A

Question 4

To convert JSON null value to SQL null value, you will use

Options :

A : STRIP_NULL_VALUE

B : IS_NULL_VALUE

C : NULL_IF

Answer: A

Question 5

What is the definition of securable objects?

Options :

A : Entity that cannot be removed from Snowflake

B : Entity to which access can be granted

C : Entity that cannot be shared from Snowflake

Answer: B

Free ARA-C01 Mock Exam – Practice Online Confidently