Question 1

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?

Options :

A : Aggregate

B : UNION ALL

C : Flatten

D : Join

E : Filter

Answer: A

Question 2

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?

Options :

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

Question 3

Which one of the below is true about clustering depth?

Options :

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

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

Options :

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 concepts/functions helps while implementing advanced Column-level Security?

Options :

A : CURRENT_ROLE

B : INVOKER_ROLE

C : Role Hierarchy

D : CURRENT_CLIENT

Answer: A,B,C

Higher Test Marks with Free Online DEA-C01 Exam Practice

Buying Options: