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: Mar 27, 2025

Add To Cart

Question 1

Which of the below transformations are supported by Snowflake while loading a table using the COPY statement?

A : Column reordering

B : Column renaming

C : Column omission

D : Casts

E : Truncating text strings that exceed the target column length

Answer: A,C,D

Question 2

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 3

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 4

The employee project details has the project names as array against each employee as shown below

Which of the query below will convert the array into individual rows?

A : select emp_id, emp_name, p.value::string as project_names from employee_project_details,table(flatten(employee_project_details.project_names)) p ;

B : select emp_id, emp_name, p.value::string as project_names from employee_project_details,lateral(flatten(employee_project_details.project_names)) p ;

C : select emp_id, emp_name, p.value::string as project_names from employee_project_details,lateral flatten(employee_project_details.project_names)) p

Answer: A

Question 5

Data Engineer wants to analyze query performance & looking out for profiling information, He went to Query/Operator Details also called Profile Overview of Query Profile Interface & searching for statistics attributes around I/O. Which of the following information he can’t get from there?

A : Percentage scanned from cache — the percentage of data scanned from the local disk cache.

B : Bytes written — bytes written (e.g. when loading into a table).

C : External bytes scanned — bytes read from an external object, e.g. a stage.

D : Bytes sent over the wireframe — amount of data sent over the wireframe

E : Bytes read from result — bytes read from the result object.

Answer: D

Page: 1 / 48

Total 240 Questions | Updated On: Mar 27, 2025

Add To Cart