Free Snowflake SnowPro-Advanced-Data-Engineer Exam Questions
Try our Free Demo Practice Tests for Comprehensive SnowPro-Advanced-Data-Engineer Exam 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: Mar 12, 2026
-
Rated: 4.9 |
-
Online Users: 480
-
Question 1
-
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 2
-
Snowflake charges a per-byte fee when users transfer data from your snowflake account into cloud storages in another region on the same cloud platform or into cloud storage in another cloud platform
Answer: A
-
Snowflake charges a per-byte fee when users transfer data from your snowflake account into cloud storages in another region on the same cloud platform or into cloud storage in another cloud platform
-
Question 3
-
Your data transfer takes 48 hours. In this case which data transfer mode will you use with Spark connector?
Answer: B
-
Your data transfer takes 48 hours. In this case which data transfer mode will you use with Spark connector?
-
Question 4
-
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 5
-
The smaller the average depth, the better clustered the table is with regards to the specified column?
Answer: A
-
The smaller the average depth, the better clustered the table is with regards to the specified column?