Introduction

The Denodo Platform 8.0 Certified Developer Associate (DEN80EDUCDA) exam tests developers’ knowledge of the Denodo Platform and validates if they have the skills required by companies that use Denodo Platform 8.0.

DEN80EDUCDP aims to provide organizations that use Denodo Platform 8.0 with a means of identifying suitably qualified staff for designing, developing, and deploying real projects with the Denodo Platform.

Denodo recognizes that not all the people interested in Denodo Certification have the same experience.

Contents of the exam

This exam covers the following technical topics and subject areas:

Preparing for the Certification Exam

Based on your previous experience with the Denodo Platform, use this guide to help plan and prepare for Denodo Certifications.

If you need it, there are some examples of questions that can be found in the Exam Guide.

You don’t have any experience with the Denodo Platform

As you know, certification exams are hard. Preparation is critical to pass. Before taking the exam, we recommend you:

You have taken the recommended Denodo Training courses for the Denodo 8.0 Certified Developer Associate exam

If you have finished the recommended Denodo Training courses to achieve the Denodo Platform 8.0 Certified Developer Associate certification, try to get some hands-on experience with Denodo Platform 8.0 before doing the certification exam. 

If you already have experience with data virtualization concepts, terminology, and skills needed to develop a Denodo data virtualization project, you know the concepts of linked data and checking/solving errors, and you have advanced knowledge about data virtualization techniques and best practices needed to get the most out of Denodo data virtualization projects, then you are ready to do the Certification exam.

You have taken the recommended Denodo Training courses for Denodo Platform 7.0 Certified Developer exam

If you have completed the recommended Denodo Training courses for the Denodo Platform 7.0 Certified Developer exam, we recommend the following additional courses and resources to ensure you are well-versed in the latest version of the Denodo Platform 8.0.

To do that, we recommend you:

You earned an older version of the Denodo Platform Certified Developer

The older versions of the Denodo Platform Certified Developer are not compatible with the newer version of the certification program. To get the new certifications you will need to take the Denodo Platform 8.0 Certified Developer exams.

Please check Denodo Certification FAQ for additional information in this instance.

Exam Topics

In this section you can find the details of the technical topics and subject areas covered by the exam.

The Principles of Data Virtualization

In this section the examinee should demonstrate that they understand the basic concepts of data virtualizacion:

  • The Current Data Problem
  • Data Virtualization: The Basic Definition
  • The Principles of Data Virtualization
  • Data Virtualization Use Cases

How to prepare

This is a theoretical section that covers the basic definition, principles and use cases of data virtualization.

To start preparing for this section we recommend that you visit the Denodo Site where you can find helpful content, such as:  A Data Virtualization Overview, How It Works, Benefits and Data Virtualization Solutions

Next step is to start reviewing the Denodo Community tutorial, the introduction includes a definition of the common data problems that organizations face nowadays and how they can be solved using data virtualization.

All the content related to this section is included in the topic “Data Virtualization. Introduction” which is included in the official Denodo courses Introduction to Data Virtualization and Denodo Essentials.

Denodo Architecture and Components

This section covers the basic concepts and an overview of the Virtual DataPort Administration and Scheduler tool. The examinee should have some knowledge on the following topics:

  • Data Access Layer
    • Wrappers
    • Base Views
  • Data Integration Layer
    • Derived Views
    • How VDP Works When a Query is Received
  • Data Publishing Layer
    • How to Access the Created Virtual Schema
  • Basic Concepts
    • Basic VQL
    • Data Definition
    • Primary Keys
    • Folders
    • Associations
    • Query Execution

How to prepare

This section is mainly theoretical, it is important to have a good understanding of the Virtual DataPort and Scheduler Architectures including the different layers and the basic concepts related to the Virtual Data Port.

The first step you should take is to review the official documentation that explains the General Architecture of the Virtual DataPort and Scheduler. In this section, the physical layer, logical layer and user layer are explained in detail.

The best way to start learning about the basic concepts of the Virtual DataPort is to review the first steps section of the tutorials which are available in the Denodo Community.

This section also includes the basic concepts of primary keys and associations.

These concepts are included under the topics “Virtual DataPort. Architecture”, “Scheduler. Architecture” and “Virtual Data Port. Basic Concepts” included in the official Denodo course: Denodo Essentials.

The Denodo Administrations Tools

This section covers all the options and menus that are available in the Virtual DataPort Administration Tool.

The main areas that are covered in this section are:

  • Starting Up the Virtual DataPort Server
  • Virtual DataPort Administration Tool
    • How to Start the Tool
    • Main Areas
    •  Folders
    • Available Data Sources
    • Available Operations
    • Publishing Views
    • Quick Search
    • Administration Menu
    • Tools Menu
  • Scheduler Administration Tool
    • Accessing the system
    • Configuring scheduler server
    • Main sections
    • Managing projects

How to prepare

The best way to prepare for this section is by using the Virtual DataPort and Scheduler Administration tools and trying out different options. Here are the main options of the administration tools and the links to the official documentation:

In order to launch the Virtual DataPort server and the admin tool, we recommend that you read the “Start the Virtual DataPort server” section. You can find this information for the Scheduler admin tool in the “Installation and Execution” section.

All the available options of the Virtual DataPort and Scheduler administration tools are explained in the topics “Virtual DataPort Administration tool” and “Scheduler Administration tool” included in the official Denodo course Denodo Essentials.

You can also see the following videos to have more information about the administration tools:

Connecting to Data Sources

This section contains all the information on the possible data sources that you can connect to using the Denodo Platform. It also contains further information on the creation and configuration of base views.

How to prepare

In order to prepare for this section properly, it is preferable that you have practical experience. You can gain the necessary experience by completing various tutorials available in the Denodo Community. You can start by creating a JDBC data source and base views which is covered in the Connecting to Sources tutorial.

Next, there is an example in the Virtual DataPort Administration Guide which explains how to create different data sources and base views graphically, starting with JDBC and web services data sources.

The creation of data sources and base view is very similar, it is simply a case of changing the connection parameters. Once you have understood this process, you can review every data source in more detail in the administration tool or in the Virtual DataPort Administration guide

As well as the basic way of creating the different data sources, we recommend that you also review the following information related to this section:

We recommend that you create a data source and a base view of every type to check the necessary configuration and understand what is required for each data source.

Finally, it is important to note that this section contains questions related to the topic of JMS listeners. It’s a good idea to try configuring a JMS listener in the Virtual DataPort Administration tool for yourself to understand how it works.

All these elements are explained in more detail in the topics “JDBC”, “ODBC”, “Web Services”, “Delimited Files”, “JSON / XML”, “Excel” and “Path Types in Data Sources” in the official course Connecting and Combining Data with Denodo.

Also, you can complete the Denodo Platform tutorials. In the Data Virtualization Basics you will get more information about the different data sources available in the Denodo Platform.

You can see the following videos to have more information about how to connect to different data sources:

And you can get more information on the following videos about how to be connected to a cloud data source:

Views in Virtual DataPort

The Denodo Virtual DataPort uses VQL (Virtual Query Language) for data definition and data manipulation. VQL enables administrators to create and update the elements that constitute the system catalog, as well as enabling them to query and update the unified information views. The examiner should be familiar with VQL.

Please note: VQL supports two types of sentences: DDL and DML.

  • DDL (Data Definition Language): is used to create and manage views. For example: CREATE, DROP, ALTER, DESC…
  • DML (Data Manipulation Language): is like SELECT, which enables query execution and the definition of derived views.

Virtual DataPort supports normal queries, but it also contains a set of predefined stored procedures and enables users to import custom developed Java stored procedures.

How to prepare

The examinee should be able to understand the VQL language. The best way to prepare for this section is to create different elements and execute different queries in the VQL Shell of the Virtual DataPort Administration tool. This is a list of all the main parts of the VQL language:

All the information related to VQL is contained in the guide “Virtual DataPort VQL Guide”. The Connecting and Combining Data with Denodo course also contains all the information related to this section under the topics “Execution of Denodo Views” and “View Management”.

In the Data Virtualization Basics tutorial you will get more information about how to create views using Virtual DataPort.

And you can also get more information on the following videos: 

Combining Data Sets

This section contains questions about how to create derived views, which combine data from different sources.

The following sections describe the process of creating the following types of views using our example to illustrate the process:

  • Selection Views
  • Union Views
  • Join Views
  • Flatten Views
  • Intersect Views
  • Minus Views

How to prepare

The examinee should be able to understand all the available operations in Virtual DataPort and how to configure them. The best way to understand how to create different derived views is to create a view of every type. These are all the operations that are contained in this section:

All these operations are explained in the topics “Operations. Unions”, “Operations. Selection & Projection”, “Operations. Aggregation”, “Operations. Joins”, “Functions”, and “Compound types” included in the official Denodo courses: Connecting and Combining Data with Denodo

In the following videos you will find more information about the derived views:

Issues Troubleshooting and Logs

This is an important section for administration, you should be able to understand the logs and how to resolve issues. 

How to prepare

To be able to handle any potential issues that arise when using the Denodo platform, an administrator should understand the following: 

All this information is included in the official course Connecting and Combining Data with Denodo

Organizing Teams

The final section of this exam is related to organizing your developments with your team, for example, database management, user management and roles.

How to prepare

The Virtual DataPort includes several ways to organize a team, the most important of which are:

All this information is available in the sections entitled “Data Virtualization Project Management” and “Development with Version Control Systems” in the course Denodo Project Management.

Data and Metadata management in Denodo

This section covers advanced view management and data governance in Virtual DataPort.

Regarding advanced view management, the exam taker should have a good knowledge of the following topics:

  • Cache
  • Memory
  • Internationalisation Configuration
  • Search Methods
  • Indexes
  • Statistics
  • Execution Plan

The exam taker should be aware of all the Denodo tools related to data governance:

  • Tree View
  • Used by
  • Source Refresh
  • Change Impact Analysis
  • Data Lineage

How to prepare

The exam taker should have a good knowledge of the following areas of advanced view management and data governance:

We highly recommend that candidates review all the documentation and try changing the configuration to understand the differences between options.

Use of the above tools should be reviewed in the Virtual DataPort Administration tool, to better understand how to use them and when.

All this information is included in the topics “Data Management”, “Metadata Documentation” and “Metadata Management” in the course Denodo Performance Best Practices.

Conclusions

In this guide, we have reviewed all the sections that are part of the Denodo Platform 8.0 Certified Developer exam with details and links to the official documentation. As we have indicated in different sections, the best way to understand the Denodo Platform and to acquire practical experience is creating and configuring the different parts that we have explained in every section.

After reviewing all the materials, these are some examples of questions that can be found in this link.