Question 1

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

Question 2

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 3

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 4

Angela, Data Engineer using Denodo to extract delimited files source using DF data source. While configuring connection, she has discovered “Data route” option as Local, FTP / SFTP / FTPS Client, HDFS or S3 and the route points to a directory & wants to create base views on files available at source directory. which is the incorrect understanding of Angela from the below points while designing the data source configuration?

Options :

A : The base views created over this data source will retrieve the data from all the files in the directory and not just one file. Thus, a base view schema will be created including all different fields in all the files at that time

B : If in the configuration of the route, the filter is Decompress (zip format) and the .zip file has several files, the base view created over it will retrieve data from all the files in the compressed file. Thus, all the files inside the .zip file must have the same schema.

C : While using DF data Source, provided path can’t be parameterized using interpolation variables

D : When “Data route” option selected as the route points to a directory but Angela only wants to process some of the files in this directory, then she needs to enter a regular expression that matches the names of these files, in the File name pattern box

Answer: C

Question 5

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

Free DEN80EDUCDP Mock Exam – Practice Online Confidently

Buying Options: