Question 1

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

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 4

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 5

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

Confidently Practice Online with Free DEN80EDUCDP Exam Cram

Buying Options: