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: Mar 05, 2026
-
Rated: 4.9 |
-
Online Users: 480
-
Question 1
-
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.
Answer: A
-
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.
-
Question 2
-
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 3
-
Which are the Cloud Platforms that Support Calling an External Function?
Answer: D
-
Which are the Cloud Platforms that Support Calling an External Function?
-
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
-
Which of the below stored procedure will convert null to string?
Answer: A
-
Which of the below stored procedure will convert null to string?