Question 1

What does a response error code of 429 from the insertFiles, insertReport, or loadHistoryScan API of Snowpipe mean?

Options :

A : Failure. Request rate limit exceeded

B : Failure. Invalid request due to an invalid format or limit exceeded

C : Failure. PipeName not recognized

Answer: A

Question 2

An Architect is using SnowCD to investigate a connectivity issue. Which system function will provide a list of endpoints that the network must be able to access to use a specific Snowflake account, leveraging private connectivity?

Options :

A : SYSTEMSALLOWLIST ()

B : SYSTEMSGET_PRIVATELINK

C : SYSTEMSAUTHORIZE_PRIVATELINK

D : SYSTEMSALLOWLIST_PRIVATELINK ()

Answer: B

Question 3

Which privilege is required for a role to be able to resume a suspended warehouse if auto-resume is not enabled?

Options :

A : OPERATE

B : MONITOR

C : MODIFY

D : USAGE

Answer: A

Question 4

Which alter command below may affect the availability of column with respect to time travel?

Options :

A : ALTER TABLE...DROP COLUMN

B : ALTER TABLE...SET DATA TYPE

C : ALTER TABLE...SET DEFAULT

Answer: B

Question 5

To convert JSON null value to SQL null value, you will use

Options :

A : STRIP_NULL_VALUE

B : IS_NULL_VALUE

C : NULL_IF

Answer: A

Higher Test Marks with Free Online ARA-C01 Exam Practice

Buying Options: