Question 1

What is a key consideration when setting up search optimization service for a table?

Options :

A : Search optimization service works best with a column that has a minimum of 100 K distinct values.

B : Search optimization service can significantly improve query performance on partitioned external tables.

C :

Search optimization service can help to optimize storage usage by compressing the data into a GZIP format.

D : The table must be clustered with a key having multiple columns for effective search optimization.

Answer: A

Question 2

An Architect needs to grant a group of ORDER_ADMIN users the ability to clean old data in an ORDERS table (deleting all records older than 5 years), without granting any privileges on the table. The group’s manager (ORDER_MANAGER) has full DELETE privileges on the table. How can the ORDER_ADMIN role be enabled to perform this data cleanup, without needing the DELETE privilege held by the ORDER_MANAGER role?

Options :

A :

Create a stored procedure that runs with caller’s rights, including the appropriate "> 5 years" business logic, and grant USAGE on this procedure to ORDER_ADMIN. The ORDER_MANAGER role owns the procedure.

B :

Create a stored procedure that can be run using both caller’s and owner’s rights (allowing the user to specify which rights are used during execution), and grant USAGE on this procedure to ORDER_ADMIN. The ORDER_MANAGER role owns the procedure.

C :

Create a stored procedure that runs with owner’s rights, including the appropriate "> 5 years" business logic, and grant USAGE on this procedure to ORDER_ADMIN. The ORDER_MANAGER role owns the procedure.

D :

This scenario would actually not be possible in Snowflake – any user performing a DELETE on a table requires the DELETE privilege to be granted to the role they are using.

Answer: C

Question 3

Which of the below commands will use warehouse credits?

Options :

A : SHOW TABLES LIKE 'SNOWFL%';

B : SELECT MAX(FLAKE_ID) FROM SNOWFLAKE;

C : SELECT COUNT(*) FROM SNOWFLAKE;

D : SELECT COUNT(FLAKE_ID) FROM SNOWFLAKE GROUP BY FLAKE_ID;

Answer: B,C,D

Question 4

Which data models can be used when modeling tables in a Snowflake environment? (Select THREE).

Options :

A : Graph model

B : Dimensional/Kimball

C : Data lake

D : lnmon/3NF

E : Bayesian hierarchical model

F : Data vault

Answer: B,D,F

Question 5

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

Options :

A : CONTINUE

B : SKIP_FILE

C : ABORT_STATEMENT

D : FAIL

Answer: A,B,C

Smartly Prepare Exam with Free Online ARA-R01 Practice Test

Buying Options: