Question 1

John, Denodo Sr. Developer used JDBC connection to create Base views, but later identified that base view is degrading over time. He analyzed further & found that direct SQL query on the Source provides much better consistent performance, so he recreated base views from SQL queries. As Best Practices, John follows the below

list of consideration while creating base views from SQL queries.

I.SQL query has to use the SQL dialect of that database, not the SQL dialect of Virtual DataPort.

II. Remove single line comments from the SQL query.

III. If the SQL query invokes a PL/SQL function using an interpolation variable, you need to assign an alias to the return value.

IV. If the SQL query is a SELECT query, after creating the view, John recommends setting to “yes” the “Delegate SQL sentence as subquery” property of the view.

V. SQL query should not have interpolation variables, otherwise SQL query would fail.

Mark the Correct Statements from the below list?

Options :

A : I,II,III,IV

B : I,II

C : I

D : III,IV,V

E : IV,V

Answer: A

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

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

Question 4

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 5

We can secure the access to a REST or SOAP Web service by configuring its authentication method, in which of following Authentication method Uses the Credentials of the Web Service’s Clients for Web Services Authentication?

Options :

A : HTTP Basic

B : HTTP Digest

C : WSS Basic with VDP

D : WSS Digest with VDP

Answer: C

Higher Test Marks with Free Online DEN80EDUCDP Exam Practice

Buying Options: