Free Snowflake ARA-C01 Exam Questions

A company wants to deploy its Snowflake accounts inside its corporate network with no visibility on the internet. The company is using a VPN infrastructure and Virtual Desktop Infrastructure (VDI) for its Snowflake users. The company also wants to re-use the login credentials set up for the VDI to eliminate redundancy when managing logins. What Snowflake functionality should be used to meet these requirements? (Choose two.)

Removing files from a stage after you are done loading the files improves performance when subsequently loading data

For the best performance while loading data into table from a stage, you should avoid applying patterns that filter on a large number of files.

You have written a procedure and a function in snowflake. How do you find your procedures and functions in snowflake?

Files arrive in an external stage every 10 seconds from a proprietary system. The files range in size from 500 K to 3 MB. The data must be accessible by dashboards as soon as it arrives. How can a Snowflake Architect meet this requirement with the LEAST amount of coding? (Choose two.)