Free Practice Snowflake DEA-C01 Exam Questions 2025

Stay ahead with 100% Free SnowPro Advanced Data Engineer Certification DEA-C01 Dumps Practice Questions

Page: 1 / 48

Total 240 Questions | Updated On: Apr 09, 2025

Add To Cart

Question 1

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 2

Which of the below privileges are required to add or remove search optimization?

A : OWNERSHIP privilege on the table

B : ADD SEARCH OPTIMIZATION privilege on the schema that contains the table

C : ACCOUNTADMIN privilege

D : ALL OF THE ABOVE

Answer: A,B

Question 3

Which of the below query will be used to identify the long running queries in the last 1 hour?

A : select * from table(information_schema.query_history(dateadd('hours',-1,current_timestamp()),current_timestamp())) order by total_elapsed_time

B : select * from information_schema.query_history where execution_time

C : select * from my_database.my_schema.query_history where execution_time

Answer: A

Question 4

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 5

Which one of the below is true about clustering depth?

A : The smaller the average depth, the better clustered the table is with respect to the specified columns

B : The larger the average depth, the better clustered the table is with respect to the specified columns

C : The smaller the maximum depth, the better clustered the table is with respect to the specified columns

Answer: A

Page: 1 / 48

Total 240 Questions | Updated On: Apr 09, 2025

Add To Cart