Free Snowflake ARA-R01 Exam Questions

Become Snowflake Certified with updated ARA-R01 exam questions and correct answers

Page: 1 / 34

Total 166 Questions | Updated On: Nov 20, 2024

Add To Cart

Question 1

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

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

Question 2

A Snowflake Architect is designing a multi-tenant application strategy for an organization in the Snowflake Data Cloud and is considering using an Account Per Tenant strategy. Which requirements will be addressed with this approach? (Choose two.)

A : There needs to be fewer objects per tenant.

B : Security and Role-Based Access Control (RBAC) policies must be simple to configure.

C : Compute costs must be optimized.

D : Tenant data shape may be unique per tenant.

E : Storage costs must be optimized.

Answer: D,E

Question 3

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

A : CONTINUE

B : SKIP_FILE

C : ABORT_STATEMENT

D : FAIL

Answer: A,B,C

Question 4

Based on the Snowflake object hierarchy, what securable objects belong directly to a Snowflake account? (Select THREE).

A : Database

B : Schema

C : Table

D : Stage

E : Role

F : Warehouse

Answer: A,E,F

Question 5

A company has a table with that has corrupted data, named Data. The company wants to recover the data as it

was 5 minutes ago using cloning and Time Travel.

What command will accomplish this?

A : CREATE CLONE TABLE Recover_Data FROM Data AT(OFFSET => -60*5);

B : CREATE CLONE Recover_Data FROM Data AT(OFFSET => -60*5);

C : CREATE TABLE Recover_Data CLONE Data AT(OFFSET => -60*5);

D : CREATE TABLE Recover Data CLONE Data AT(TIME => -60*5);

Answer: C

Page: 1 / 34

Total 166 Questions | Updated On: Nov 20, 2024

Add To Cart