Exam Code: DEA-C02
Exam Questions: 240
SnowPro Advanced Data Engineer
Updated: 18 Feb, 2026
Viewing Page : 1 - 24
Practicing : 1 - 5 of 240 Questions
Question 1

If dataframes are used, the snowflake spark connector does not support the following operations

Options :
Answer: B,C,D

Question 2

If using a JavaScript UDF in a masking policy, Data Engineer needs to ensure the data type of the column, UDF, and masking policy match irrespective of case-sensitivity?

Options :
Answer: B

Question 3

Each micro partition contains between 50 mb and 500 MB of uncompressed data

Options :
Answer: B

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

Options :
Answer: A

Question 5

Your data transfer takes 48 hours. In this case which data transfer mode will you use with Spark connector?

Options :
Answer: B

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.