Question 1

When will you use the maximized mode of a multi-cluster warehouse?

Options :

A : When we want Snowflake to start and stop clusters as needed to manage the load on the warehouse dynamically.

B : When you have to control the available compute resources, particularly if you have large numbers of concurrent user sessions and/or queries and the numbers do not fluctuate significantly.

Answer: B

Question 2

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

Question 3

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

Options :

A : TRUE

B : FALSE

Answer: A

Question 4

Remote service in external function can be an AWS Lambda function

Options :

A : TRUE

B : FALSE

Answer: A

Question 5

A company has built a data pipeline using Snowpipe to ingest files from an Amazon S3 bucket. Snowpipe is configured to load data into staging database tables. Then a task runs to load the data from the staging database tables into the reporting database tables. The company is satisfied with the availability of the data in the reporting database tables, but the reporting tables are not pruning effectively. Currently, a size 4X-Large virtual warehouse is being used to query all of the tables in the reporting database. What step can be taken to improve the pruning of the reporting tables?

Options :

A : Eliminate the use of Snowpipe and load the files into internal stages using PUT commands.

B : Increase the size of the virtual warehouse to a size 5X-Large.

C :

D : Create larger files for Snowpipe to ingest and ensure the staging frequency does not exceed 1 minute.

Answer: C

Higher Test Marks with Free Online ARA-C01 Exam Practice

Buying Options: