Practice DEA-C01 Exam Online

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

To help manage STAGE storage costs, Data engineer recommended to monitor stage files and re-move them from the stages once the data has been loaded and the files which are no longer needed. Which option he can choose to remove these files either during data loading or afterwards?

A : He can choose to remove stage files during data loading (using the COPY INTO command).

B : Files no longer needed, can be removed using the PURGE=TRUE command.

C : Files no longer needed, can be removed using the REMOVE command.

D : Script can be used during data loading & post data loading with DELETE command.

Answer: A,B

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

For the most efficient and cost-effective Data load experience, Data Engineer needs to inconsider-ate which of the following considerations?

A : Split larger files into a greater number of smaller files, maximize the processing over-head for each file.

B : Enabling the STRIP_OUTER_ARRAY file format option for the COPY INTO < ta-ble > command to remove the outer array structure and load the records into separate table rows.

C : Amazon Kinesis Firehose can be convenient way to aggregate and batch data files which also allows defining both the desired file size, called the buffer size, and the wait interval after which a new file is sent, called the buffer interval.

D : When preparing your delimited text (CSV) files for loading, the number of columns in each row should be consistent.

E : if the “null” values in your files indicate missing values and have no other special mean-ing, Snowflake recommend setting the file format option STRIP_NULL_VALUES to TRUE when loading the semi-structured data file.

Answer: A

Question 5

What will happen if you try to create a materialized view as below
    create or replace materialized view employee_view as
        select id, role, name
            from employee where role = current_role();

A : Only users with the desired role will be able to retrieve results from the view

B : Only users with the correct role assigned and SYSADMIN will be able to retrieve the results from the view

C : The operation will error out since the function used is a non-deterministic one.

Answer: C

Name:	SnowPro Advanced Data Engineer Certification
Exam Code:	DEA-C01
Certification:	SnowPro Certification
Vendor:	Snowflake
Total Questions:	240
Last Updated:	Apr 23, 2024

Snowflake DEA-C01