Smartly Prepare Exam with Free Online SnowPro-Advanced-Architect Practice Test

We offer the latest SnowPro-Advanced-Architect practice test designed for free and effective online SnowPro Advanced, Architect certification preparation. It's a simulation of the real SnowPro-Advanced-Architect exam experience, built to help you understand the structure, complexity, and topics you'll face on exam day.

Question 1

External functions must be scalar functions

Options :

A : TRUE

B :

FALSE

Answer: A

Question 2

Which of these Snowflake components/objects is NOT typically used in building continuous ELT pipelines?

Options :

A : Data Exchange

B : Snowflake Connector for Kafka

C : Streams

D : Snowpipe

Answer: A

Question 3

One of your joins is taking a lot of time. The query profile view looks like this. What may be the issue?

2020-09-06-20-26-48-21b07202e527a5b67bbba720952a3ecf

Options :

A : This may be an "exploding join" issue. The query has provided a condition where records from one table match multiple records from another table resulting in a cartesian product

B : There is not enough memory to process the join query

C : Looks like tablescan is the most expensive operation in the profile.

Answer: A

Question 4

What is the function of Resource Monitors regarding data pipelines?

Options :

A : Make data not being replicated twice in the same pipeline

B : It performs backups for your pipelines every 5 minutes

C : It helps you monitor and control the costs of your pipelines

Answer: C

Question 5

Loading data using snowpipe REST API is supported for external stage only

Options :

A : TRUE

B : FALSE

Answer: B