You are here

How to Prepare for the Denodo Platform 6.0 Certified Administrator Exam

The Denodo Platform 6.0 Certified Administrator (DEN60EDUCA) exam is intended for IT administrators who deploy, manage, and monitor Denodo-based solutions. The exam tests for a high level of skill in Denodo Platform 6.0 Administration.

DEN60EDUCA aims to provide organizations that use Denodo Platform 6.0 with a means of identifying suitably qualified staff to administer and operate Denodo deployments.

This exam covers the following technical topics and subject areas:

 

 

Denodo Architecture and Components

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

  • Basic Concepts
    • Basic VQL
    • Data Definition
    • Primary Keys
    • Folders
    • Associations
    • Query Execution
  • 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

How to prepare

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

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

We recommend that you open the Virtual DataPort Administration tool and browse every option available. Below are the main areas of the administration tool with links to the official documentation: 

For information on how to launch the Virtual DataPort server and the admin tool, please see the “Installation and Execution” section.

The concepts covered in this section are included in the topics “Virtual DataPort Basic Concepts” and “Virtual DataPort Administration tool” in the official Denodo course VDP Server Administrator.

Installation and Updating Denodo Platform

This section contains all the information relating to the Denodo Control Center including installing and updating the Denodo Platform. 

How to prepare

Firstly, you should try installing and updating the Denodo Platform for yourself. We also recommend that you review all the options available in the Denodo Control Center. 

The Denodo Platform Installation Guide contains all the information relating to installing  and updating the Denodo Platform. The main areas that this section covers are:

Connecting to Data Sources

This section contains questions about all the possible data sources that will be necessary for a Denodo Administrator to understand. It also contains questions about the creation and configuration of base views.

How to prepare

We recommend that examinees gain practical experience before taking this exam; see our Connecting to Sources tutorials in the Denodo Community, where you will start by learning how to create a JDBC data source and base views.

The Denodo Virtual DataPort Administration Guide also explains how to create data sources and base views. You can review all data source connections in more detail using the administration tool or in the Virtual DataPort Administration guide.

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.

All these elements are covered in the topics “JDBC,” “LDAP,” and “JSON,” of the official course Denodo Platform Server Administrator.

 

Denodo Platform Configuration and Backup

This section includes all the topics related to the configuration of the Virtual DataPort. A Denodo Administrator should be able to understand the distribution of the views, the server configuration and best practices. Additionally, a Denodo Administrator should have a good understanding of the backup process.

How to prepare

This section is very important from a configuration point of view. The examinee should be familiar with all the options related to the configuration of the server. These are the main sections related to server administration

Additional topics related to configuration of the server are: 

  • Folder Distribution: How to structure the created elements in the Virtual DataPort Administration tool. 
  • VCS Integration: How to configure VCS integration in a Virtual DataPort server.  
  • Backup: How to backup the Denodo installation. 

The examinee should be familiar with best practices related to administration. To learn more on the subject, review Denodo Admin and Development Best Practices.

You can find further detailed explanations under the following topics: “Installation. Folder distribution”, “Backup”, “VCS Integration”, “Administration. Server Configuration” and “Administration. Best Practices” which are included in the official Denodo courses: Denodo Platform Installation & Operation and VDP Server Administrator.

 

Best Practices Using the Denodo Platform’s Cache

Virtual DataPort incorporates a system called a “cache module,” which can store a local copy of the data retrieved from data sources in a JDBC database. The questions in this section relate to information about how to configure, load, and perform maintenance on the cache module.

How to prepare

The configuration of the cache database is done in the Server Administration menu, the examinee should understand: 

To understand the cache module, we recommend that you enable the cache and change the configuration, understanding the results in every case. 

Information related to the cache database is included in the topics “Virtual DataPort. Cache” and “Virtual DataPort. Cache. Development” in the Advanced Data Virtualization Developer course.

 

Deploying Denodo Platform in Clusters

The Denodo Platform can be configured in a cluster configuration. The examinee ought to know how to configure the Denodo Platform in clusters, as well as certain best practices. 

How to prepare

Here are some useful sections related to cluster configuration as well as best practices: 

 

Promotion Between Environments

A Denodo Administrator should know how to do a promotion between environments, for example production, staging/QA, development and more.

How to prepare

You need to be familiar with the import/export scripts that Denodo provides as well as working with VCS. You should also understand how to do the promotion between environments.

To prepare for this section, please review the following sections: 

This section is included in the topic “Promotion Between Environments” of the VDP Server Administrator official course.

 

How to Monitor Denodo Platform Server

The goal of this section is to make you aware of the state of your Virtual DataPort server in real-time in order to be able to detect malfunctions as soon as possible, and take the appropriate action to solve it. In order to achieve this, you’ll need to have a good knowledge of Denodo applications.

How to prepare

This section covers the following areas: 

We recommend that you monitor the denodo platform using both configuration. You can find more information about monitoring in these articles: Auditing User Access in Virtual DataPort, Denodo Load Testing with Apache JMeter, Denodo Monitor as a Linux Service, How to monitor the number of times a VDP server is restarted and How to see the status of the cache using JMX

  • The Diagnostic and Monitoring Tool is a web tool that provides two main features:
    • Monitoring: it displays real-time information of one or more Virtual DataPort servers.
    • Diagnostic: it processes log files generated by Virtual DataPort servers and the Denodo Monitor to help diagnosing past problems.
  • The Resource Manager allows you to classify sessions into groups based on the attributes of the session, and to allocate resources to those groups in a way that optimizes resources utilization for your application environment.

All these applications and concepts are included in the Denodo Platform Installation & Operation course, under the topics “Monitoring and Management”, “Administration Resource Manager” and “Diagnostic and Monitoring Tool”.

 

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 information related to troubleshooting is included in the topic “Virtual DataPort Error Analysis” of the VDP Server Administrator.

 

Configuring Resource Limits For Users

The final section of this exam is related to security, for example, database management, user management, and roles.

How to prepare

The Virtual DataPort includes advanced security options, the most important of which are:

To understand more about security, you can check Denodo Security Overview and Kerberos Configuration and Troubleshooting

All this information is available in the section entitled “Administration. Security” in the VDP Server Administrator course.