Question 1

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 2

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 3

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 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

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: