Question 1

Which of the below commands lists all the pipes for which you have access?

Options :

A : Display Pipes()

B : SHOW PIPES()

C : LIST PIPES()

D : LIST @PIPES

Answer: B

Question 2

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.)

Options :

A : Use Snowpipe with auto-ingest.

B : Use a COPY command with a task.

C : Use a materialized view on an external table.

D : Use the COPY INTO command.

E : Use a combination of a task and a stream.

Answer: A,E

Question 3

An architect wants to extract the content of PDF files stored in Snowflake stages.How can this requirement be met?

Options :

A : Window function

B : HyperLogLog (HLL) function

C : FLATTEN function

D : Java User-Defined Function (UDF)

Answer: D

Question 4

External functions must be scalar functions

Options :

A : TRUE

B : FALSE

Answer: A

Question 5

A Snowflake Architect is designing a multiple-account design strategy. This strategy will be MOST cost-effective with which scenarios? (Select TWO).

Options :

A : The company wants to clone a production database that resides on AWS to a development database that resides on Azure.

B : The company needs to share data between two databases, where one must support Payment Card Industry Data Security Standard (PCI DSS) compliance but the other one does not.

C : The company needs to support different role-based access control features for the development, test, and production environments.

D : The company security policy mandates the use of different Active Directory instances for the development, test, and production environments.

E : The company must use a specific network policy for certain users to allow and block given IP addresses.

Answer: B,D

Free ARA-C01 Mock Exam – Practice Online Confidently

Buying Options: