Question 1

If your role does not own the share, but owns the objects in the share, how can you block access to the objects

Options :

A : Revoking the USAGE or SELECT privileges with CASCADE on the objects from the share owner.

B : Revoking the USAGE or SELECT privileges on the objects from the share owner

C : You will need to connect with the share owner

Answer: A

Question 2

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 3

Data sharing is supported only between provider and consumer accounts in same region

Options :

A : TRUE

B : FALSE

Answer: B

Question 4

Which Snowflake architecture recommendation needs multiple Snowflake accounts for implementation?

Options :

A : Enable a disaster recovery strategy across multiple cloud providers.

B : Create external stages pointing to cloud providers and regions other than the region hosting the Snowflake account.

C : Enable zero-copy cloning among the development, test, and production environments.

D : Enable separation of the development, test, and production environments.

Answer: D

Question 5

Your business team runs a set of identical queries every day after the batch ETL run is complete. From the following actions, what is the best action that you will recommend.

Options :

A : After the ETL run, execute the identical queries so that they remain in the result cache

B : After the ETL run, resize the warehouse to a larger warehouse

C : After the ETL run, copy the tables to another schema for the business users to query

Answer: A

Free ARA-C01 Mock Exam – Practice Online Confidently

Buying Options: