Question 1

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 2

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 3

Which one of the below is not the predefined data types included in the Virtual DataPort catalog?

Options :

A : XML

B : BLOB

C : VARCHAR2

D : localdate

E : register

Answer: C

Question 4

Data virtualization supports many critical use cases within an organization, principally which one could not be the key solutions enabled by data virtualization as of today?

Options :

A : Data Marketplace

B : Enterprise Data Fabric

C : Mobile Application Development

D : Data Warehouse offloading

E : Hybrid Data Fabric

Answer: C

Question 5

Mark the Incorrect statement about Cache Invalidation in Denodo 8.0 Platform?

Options :

A :

This is command for Partial invalidation of View

B : FULL & PARTIAL are the only types of Cache Invalidation

C : CACHE_CONTENT stored procedure returns information about all the valid content in the cache database, including views whose cache mode was set to off but the data is still valid

D : The cache of views with “Full” cache can be invalidated on cascade. But if you invalidate on cascade the cache of a view, the cache of the subviews whose cache mode is “Full”, will not be invalidated

Answer: D

Confidently Practice Online with Free DEN80EDUCDP Exam Cram

Buying Options: