Question 1

Files stored in snowflake stage are automatically encrypted using either AES 128 or 256 strong encryption.

Options :

A : TRUE

B : FALSE

Answer: A

Question 2

A healthcare company wants to share data with a medical institute. The institute is running a Standard edition of Snowflake; the healthcare company is running a Business Critical edition. How can this data be shared?

Options :

A : The healthcare company will need to change the institute’s Snowflake edition in the accounts panel.

B : By default, sharing is supported from a Business Critical Snowflake edition to a Standard edition.

C : Contact Snowflake and they will execute the share request for the healthcare company.

D : Set the share_restriction parameter on the shared object to false.

Answer: D

Question 3

Which ALTER commands will impact a column's availability in Time Travel?

Options :

A : ALTER TABLE … DROP COLUMN …

B : ALTER TABLE … SET NOT NULL …

C : ALTER TABLE … SET DATA TYPE …

D : ALTER TABLE … RENAME COLUMN …

Answer: C

Question 4

You have a query that will take 20 minutes to be executed in a data warehouse. This warehouse auto-suspends after 15 minutes. What will happen with the query?

Options :

A : The query will be canceled after 15 minutes

B : The query will stop until the warehouse resumes again

C : The query will finish as expected

Answer: C

Question 5

A user named USER_01 needs access to create a materialized view on a schema EDW. STG_SCHEMA. How can this access be provided?

Options :

A :

GRANT CREATE MATERIALIZED VIEW ON SCHEMA EDW.STG_SCHEMA TO USER USER_01;

B : GRANT CREATE MATERIALIZED VIEW ON DATABASE EDW TO USER USERJD1;

C :

GRANT ROLE NEW_ROLE TO USER USER_01; GRANT CREATE MATERIALIZED VIEW ON SCHEMA ECW.STG_SCHEKA TO NEW_ROLE;

D :

GRANT ROLE NEW_ROLE TO USER_01; GRANT CREATE MATERIALIZED VIEW ON EDW.STG_SCHEMA TO NEW_ROLE;

Answer: A

Smartly Prepare Exam with Free Online ARA-C01 Practice Test

Buying Options: