Free Snowflake DEA-C01 Exam Questions

Become Snowflake Certified with updated DEA-C01 exam questions and correct answers

Page: 1 / 48

Total 240 Questions | Updated On: Jun 06, 2025

Add To Cart

Question 1

Which option needs to be followed to allow a user to have only OWNERSHIP privilege on the table, but should not be able to manage privilege grants on the object

A : Create a managed schema

B : Create a regular schema

C : By default object owner will not be able to manage privileges on the object

Answer: A

Question 2

Data Engineer is looking out to delete staged files automatically/periodically when the data is suc-cessfully loaded into tables by the Snowpipe. For achieving the same, which options/command is best suited: [Select 2]

A : PURGE option can be set as True in the COPY INTO Command embedded in PIPE objects definition.

B : To remove staged files that no longer needed, periodically REMOVE command can be executed to delete the files.

C : To remove staged files that no longer needed, periodically DELETE command can be executed to delete the files.

D : REMOVE_STAGE_FILES option can be set as True in the COPY INTO Command embedded in PIPE objects definition.

Answer: A,B

Question 3

Which Function would Data engineer used to recursively resume all tasks in Chain of Tasks rather than resuming each task individually (using ALTER TASK … RESUME)?

A : SYSTEM$TASK_DEPENDENTS

B : SYSTEM$TASK_DEPENDENTS_ENABLE

C : SYSTEM$TASK_DEPENDENTS_RESUME

D : SYSTEM$TASK_RECURSIVE_ENABLE

Answer: B

Question 4

Jeff, a Data Engineer, accessing elements in JSON object in its 3 data loading scripts, he unknow-ingly use the

upper case while accessing the elements. e.g.

Script 1 --> fruits:apple.sweet

Script 2 --> FRUITS:apple.sweet

Script 3 --> FRUITS:Apple.Sweet

Which are the correct statements?

A : Script 1 & Script 2 traverse path twill be treated same, but Script 2 will not.

B : Script 1,2,3 traverse path will treat in same way.

C : Script 1 & 3 traverse path will be treated in same way.

D : Script 2&3 traverse path will be same.

Answer: A

Question 5

Which of the below techniques leverages performance efficiencies by enabling large and complex Spark logical plans (in their entirety or in parts) to be processed in Snowflake, thus using Snowflake to do most of the actual work.

A : Query Pushdown

B : Query Optimization

C : Query Plan Pushdown

Answer: A

Page: 1 / 48

Total 240 Questions | Updated On: Jun 06, 2025

Add To Cart