You are here

How to Prepare for the Denodo Platform 7.0 Certified Administrator Exam

The Denodo Platform 7.0 Certified Administrator (DEN70EDUCS) 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 7.0 Administration.

DEN70EDUCS aims to provide organizations that use Denodo Platform 7.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:

 

 

Installing and Updating the 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:

You can find further detailed explanations under the following topics: “Defining a Deployment Configuration”, “Installation & Licenses Overview”, “Installation”, “Denodo Platform Folder Distribution”, “Denodo Control Center”, “Installation in Cluster” and “Installation of Denodo Updates” which are included in the official Denodo courses: Denodo Platform Installation & Operation.

Denodo Platform Configuration

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: “Denodo Platform Control Center”, “Virtual DataPort Server Configuration” and “Denodo Web Tools Configuration” which are included in the official Denodo courses: Denodo Platform Installation & Operation and Denodo Platform Server Administrator.

Administration Best Practices

This is a practical section related to administration best practices.

How to prepare

As well as the official documentation, candidates should review knowledge base articles related to best practices. The article Denodo Admin and Development Best Practices also contains relevant information for this section.

Information related to the cache database is included in the topic “Administration Best Practices” in the Denodo Platform Server Administrator course.

Denodo Platform Backup and restore

This section includes all the topics that 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 backup and restore:

  • Backup: How to backup the Denodo installation.

You can find further detailed explanations under the following topic: “Backup and Restore” which are included in the official Denodo courses: Denodo Platform Installation & Operation and Denodo Platform Server Administrator.

Denodo Platform 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 topic “Cache Configuration” in the Denodo Platform Server Administrator course.

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 topics “Promotion Between Environments”, “Version Control System Configuration” and “Solution Manager. Promotion management” of the Denodo Platform Server Administrator official course.

Resource Management

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 Server Administrator course, under the topics “Threads and request Management”, “Resource Manager” and “Memory Management”.

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 “Error Analysis” of the Denodo Platform Server Administrator.

Databases and access rights

This section of this exam is related to database management, user management, and roles.

How to prepare

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

All this information is available in the sections entitled “Data Sources. LDAP”, “Database Management”, “User and Role Management” and “Advanced Privileges” in the Denodo Platform Server Administrator course.

Security in Denodo

The final section of this exam is related to security, for example, database management, publishing data services, SSL / TLS, Kerberos and other security mechanisms.

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 “Security Overview”, “SSL - TLS”, “Kerberos authentication” and “Other security mechanisms (SAML, OAuth, ...)” in the Denodo Platform Server Administrator course.

Conclusions

In this document, we have reviewed all the sections that are part of the Denodo Platform 7.0 Certified Administrator 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.

Here is a summary of all the resources that are available for preparing for the Denodo Platform 7.0 Certified Administrator exam, which we have used in the explanation of every section:

Denodo Community

The Denodo Community is where customers, partners, and users have access to information that can help them learn about the Denodo Platform and data virtualization. To earn a Denodo certification, begin by following these steps to start learning about data virtualization:

  • Complete the tutorials. These tutorials offer the first steps to learn about data virtualization and the Denodo Platform.
  • View the free videos. These videos offer help with specific topics.
  • Explore the technical articles in our knowledge base.
  • Get deeper knowledge with the official manuals.

Denodo Training

We recommend that professionals looking to achieve a Denodo certification start by looking at our Denodo training offers on the Denodo Education Site.

These training courses will prepare you for the certification exam:  

  • Denodo Platform Installation & Operation: This course provides in-depth information on all activities required to install and configure the Denodo Platform.
  • Denodo Platform Server Administrator: Learn how to configure the Denodo Platform for data virtualization to satisfy the operational needs in different execution environments. Topics include: managing users and roles, configuring advanced deployment parameters, setting auditing processes, and configuring caching and other optimization features.

Sample Questions

Which users can perform a migration between environments?

1. Normal users with read privileges.
2. Developers.
3. Administrators of the virtual database.
4. Privileges in VDP are not necessary for migrating VQL.

Can Denodo servers be installed in different locations?

1. No, all Denodo instances must be installed in the same location.
2. Yes, but only when using a Active-Passive architecture.
3. Yes, but only when using a Active-Active architecture.
4. Yes, in any case.

The main purpose of swapping is:

1. Storing the intermediate results of the execution of a query in secondary storage, if their size exceeds a certain limit.
2. To decrease the execution time of a query
3. To decrease the stress on main memory
4. To store all the results in secondary storage to free up main memory for queries that require HASH join.

Can you create a JSON data source from a local file?

1. Yes.
2. No. You only can create a JSON from a variable or a HTTP source.
3. Yes. But you have to put the file in a FTP server.
4. None of above.

What are the types of caches available in Virtual DataPort?

1. On, Off.
2. Off, Full, Partial.
3. Entire, Partial, Query.
4. Whole, Half, Skim.