Question 1

What are the limitations about external functions? (Choose two.)

Options :

A : We can only write functions, not stored procedures.

B : The maximum response size per batch is 16MB.

C : External functions must be scalar, so it returns a single value for each input row.

D : Future grants of privileges on external functions are supported.

Answer: A,C

Question 2

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

Options :

A : Set up replication to allow users to connect from outside the company VPN.

B : Provision a unique company Tri-Secret Secure key.

C : Use private connectivity from a cloud provider.

D : Set up SSO for federated authentication.

E : Use a proxy Snowflake account outside the VPN, enabling client redirect for user logins.

Answer: C,D

Question 3

Data loading transformation as part of copying data to a table from stage supports selecting data from user stage and named stages(internal and external) only

Options :

A : TRUE

B : FALSE

Answer: A

Question 4

When does a stream become stale?

Options :

A : When it’s dropped

B : When its offset is outside of the data retention period for its source table

C : When it’s consumed

D : When it-s created

Answer: B

Question 5

When using the Snowflake Connector for Kafka, what data formats are supported for the messages? (Choose two.)

Options :

A : CSV

B : XML

C : Avro

D : JSON

E : Parquet

Answer: C,D

Higher Test Marks with Free Online ARA-C01 Exam Practice

Buying Options: