Denodo Data Engineer using Excel DS to process Excell files, while configuring the Connection options, He selected each of the below Options.:1. If “StartCell” is B2 and “EndCell” is Z99, the view will return the data in the range B2:Z99.2. If “StartCell” is B2 and “EndCell” is empty, the view will retrieve all the data from the cell B2 to the end of the file.3. If “StartCell” is empty and “EndCell” is Z99, the view will generate errors as it would required Start position for processing.4. If “StartCell” is empty and “EndCell” is Z99, the view will retrieve all the data in the range A1:Z99.5. If both parameters are empty, the view will retrieve all the data in the sheet.6. It is mandatory either both parameters can be empty or Non-Null to process the Excel Data Sheet.Please select the Correct group of statements

Authentication methods Uses the Credentials of the Web Service for Web Services Authentication?

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

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

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?