Exam Code: SnowPro-Advanced-Data-Engineer
Exam Questions: 240
SnowPro Advanced Data Engineer (DEA-C02)
Updated: 25 Jul, 2026
Viewing Page : 1 - 24
Practicing : 1 - 5 of 240 Questions
Question 1

Streams record the differences between two offsets. If a row is added and then updated in the cur-rent offset, what will be the value of METADATA$ISUPDATE Columns in this scenario? 

Options :
Answer: B

Question 2

For a business group, you need to create a table with customer demography data in snowflake. Business users will need to do both range and equality searches on the table. Which of the below techniques will you use to speed up the queries.

Options :
Answer: A

Question 3

For a particular business group, number of concurrent users are large but do not fluctuate. These users run queries on snowflake and expects extremely low latency response. The queries are all standard and same and need to be served from the result cache to meet the low latency requirement. Which of the below option will you choose?

Options :
Answer: A

Question 4

Which system table will you use to get the total credit consumption over a specific time period?

Options :
Answer: A

Question 5

Streams cannot be created to query change data on which of the following objects? [Select All that Apply]

Options :
Answer: D

Viewing Page : 1 - 24
Practicing : 1 - 5 of 240 Questions

© Copyrights FreePDFQuestions 2026. All Rights Reserved

We use cookies to ensure that we give you the best experience on our website (FreePDFQuestions). If you continue without changing your settings, we'll assume that you are happy to receive all cookies on the FreePDFQuestions.