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: Nov 13, 2024

Add To Cart

Question 1

To troubleshoot data load failure in one of your Copy Statement, Data Engineer have Executed a COPY statement with the VALIDATION_MODE copy option set to RETURN_ALL_ERRORS with reference to the set of files he had attempted to load. Which below function can facilitate analysis of the problematic records on top of the Results produced? [Select 2]

A : RESULT_SCAN

B : LAST_QUERY_ID

C : Rejected_record

D : LOAD_ERROR

Answer: A,B

Question 2

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 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

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 5

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

Page: 1 / 48

Total 240 Questions | Updated On: Nov 13, 2024

Add To Cart