Question 1

A role is a set of access rights that we can grant to users, which one of the following is not True about assignprivileges Role?

Options :

A : It grants the privilege of granting/revoking privileges to other users

B : Without this role, a user cannot grant/revoke privileges to the users/roles, But administrator can

C : New administrator users have this role by default but you can revoke it from them

D : You cannot grant privileges or roles to it. This is why it is not listed in the “Role Management” panel, but it is listed in the “Assign roles” dialogs

E : Only administrators with this role can grant/revoke roles to users or other roles

Answer: B

Question 2

Which one is valid Values of the “State” attribute of the nodes of a query’s execution trace?

Options :

A : PAUSED

B : STOP

C : RESTART

D : PROCESSING

Answer: D

Question 3

In Which of the following cases, Virtual DataPort actually creates an index in the database?

Options :

A : Remote tables

B : Summaries

C : Cached views

D : All of the Above

Answer: D

Question 4

Which Optimization performed by Execution Engine uses Statistics about the views’ data?

Options :

A : Static Optimization

B : Data Movement

C : Parallel Processing

D : Smart Query Acceleration

E : Cost Based Optimization

Answer: E

Question 5

Which one is an incorrect reason to define associations between base views or derived views?

Options :

A : From the perspective of the Data Catalog, the associations allow business users to discover views that are related

B : From a usability perspective, they simplify the join views definition

C : From a metadata perspective, they help define a better semantic model

D : From a performance perspective, some queries are executed much faster

E : None of the above

Answer: E

Free DEN80EDUCDP Mock Exam – Practice Online Confidently

Buying Options: