Free Snowflake SnowPro-Advanced-Architect Exam Questions

Become Snowflake Certified with updated SnowPro-Advanced-Architect exam questions and correct answers

Page: 1 / 89

Total 442 Questions | Updated On: Nov 19, 2024

Add To Cart

Question 1

What types of objects does Snowflake return when we execute the function GET_OBJECT_REFERENCES? (Choose two)

A : UDFs

B : Materialized views

C : Views (including secure views)

D : Tables

E : Streams

Answer: C,D

Question 2

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

A : Data Exchange

B : Snowflake Connector for Kafka

C : Streams

D : Snowpipe

Answer: A

Question 3

What type of authentication does the Kafka connector use?

A : Username/password requiring a password with numbers, letters, and symbols

B : Username/password requiring a password with numbers and letters

C : Key pair Authentication, which requires a 2048-bit (minimum) RSA key pair

D : Key pair Authentication, which requires a 1024-bit (minimum) RSA key pair

Answer: C

Question 4

You have a query that will take 20 minutes to be executed in a data warehouse. This warehouse auto-suspends after 15 minutes. What will happen with the query?

A : The query will be canceled after 15 minutes

B : The query will stop until the warehouse resumes again

C : The query will finish as expected

Answer: C

Question 5

Materialized views are recommended for all of the scenarios except

A : Query results contain a small number of rows and/or columns relative to the base table

B : Query results contain results that require significant processing

C : The query is on an external table

D : The view’s base table changes frequently

Answer: D

Page: 1 / 89

Total 442 Questions | Updated On: Nov 19, 2024

Add To Cart