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: Apr 01, 2022

Add To Cart

Question 1

When using the CURRENT_ROLE and CURRENT_USER functions with secure views that will be shared to other Snowflake accounts, Snowflake returns a NULL value for these functions?

A : FALSE

B : TRUE

Answer: B

Question 2

Data Engineer is using existing pipe that automates data loads using event notifications, later he figured out

the needs to modify pipe properties. For the same, He decided to recreate the pipe as best practice. He

followed the below steps for the same.

1. Query the SYSTEM$PIPE_STATUS function and verify that the pipe execution state is RUN-NING.

2. Recreate the pipe (using CREATE OR REPLACE PIPE).

3. Query the SYSTEM$PIPE_STATUS function and verify that the pipe execution state is RUN-NING.

Which are the Missing recommended steps while Recreating Pipes for Automated Data Loads?

A : CREATE OR REPLACE PIPE command will recreate the PIPE successfully.

B : Terminate the existing pipe (using ALTER PIPE … SET PIPE_EXECUTION_TERMINATE = true) before recreation

C : Pause the pipe (using ALTER PIPE … SET PIPE_EXECUTION_PAUSED = true) Pre & Post recreation & Resume after recreation (using ALTER PIPE … SET PIPE_EXECUTION_PAUSED = false).

D : Force the pipe to resume (using SYSTEM$PIPE_FORCE_RESUME).

Answer: C

Question 3

Michael, a Data Engineer Running a Data query to achieve Union of Data sets coming from Multi-ple data sources, later he figured out that Data processing query is taking more time than expected. He started analyzing the Query performance using query profile interface. He discovered & realized that he used UNION when the UNION ALL semantics was sufficient. Which Extra Data Processing Operator Michael figured out while doing query profile analysis in this case which helps him to identify this performance bottlenecks?

A : Aggregate

B : UNION ALL

C : Flatten

D : Join

E : Filter

Answer: A

Question 4

What can you infer from the below query profile?

A : Less number of bytes of data are read from the cloud storage

B : More bytes are read from the cloud storage

C : The query did a good partition pruning

Answer: A

Question 5

Which of the below concepts/functions helps while implementing advanced Column-level Security?

A : CURRENT_ROLE

B : INVOKER_ROLE

C : Role Hierarchy

D : CURRENT_CLIENT

Answer: A,B,C

Page: 1 / 48

Total 240 Questions | Updated On: Apr 01, 2022

Add To Cart