Free Snowflake SnowPro-Advanced-Data-Engineer Exam Questions
Absolute Free SnowPro-Advanced-Data-Engineer Exam Practice for Comprehensive Preparation
-
Snowflake SnowPro-Advanced-Data-Engineer Exam Questions
-
Provided By: Snowflake
- Exam: SnowPro Advanced Data Engineer (DEA-C02)
- Certification: SnowPro Certification
-
Total Questions: 240
-
Updated On: Dec 08, 2025
-
Rated: 4.9 |
-
Online Users: 480
-
Question 1
-
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?
Answer: A
-
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?
-
Question 2
-
David, a Lead Data engineer with XYZ company looking out to improve query performance & oth-er benefitswhile working with Tables, Regular Views, MVs and Cached Results.Which one of the following does not shows key similarities and differences between tables, regular views,cached query results, and materialized views while choosing any of them by David?
Answer: B
-
-
Question 3
-
Lets say you created a schema and a table as below
CREATE OR REPLACE SCHEMA TIME_TRAVEL_SCHEMA DATA_RETENTION_TIME_IN_DAYS =10;
CREATE OR REPLACE TABLE TIME_TRAVEL_SCHEMA.TIME_TRAVEL_TABLE (ID NUMBER) DATA_RETENTION_TIME_IN_DAYS =20;
Later you dropped the schema. In this scenario what data retention value will be honored for the table, if we need to retrieve the table data
Answer: A
-
Lets say you created a schema and a table as below
-
Question 4
-
Streams cannot be created to query change data on which of the following objects? [Select All that Apply]
Answer: D
-
Streams cannot be created to query change data on which of the following objects? [Select All that Apply]
-
Question 5
-
Snowpipe API provides a REST endpoint for defining the list of files to ingest that Informs Snow-flake about
the files to be ingested into a table. A successful response from this endpoint means that Snowflake has
recorded the list of files to add to the table. It does not necessarily mean the files have been ingested. What is
name of this Endpoint?
Answer: D
-
Snowpipe API provides a REST endpoint for defining the list of files to ingest that Informs Snow-flake about
the files to be ingested into a table. A successful response from this endpoint means that Snowflake has
recorded the list of files to add to the table. It does not necessarily mean the files have been ingested. What is
name of this Endpoint?