Exam Topics

  • Describe the building blocks of the Vertica platform
  • Read a projection DDL to determine its structure
  • Identify replicated and segmented projections
  • Use the database K-safety value to identify dependent nodes
  • Review the structure of tables and projections
  • Load data using Vertica hybrid storage model
  • Manually run the moveout and mergeout tasks
  • Generate a query plan
  • Time a query
  • Identify the database epochs
  • Find data loaded at different epochs
  • Create a comprehensive database design using Management Console
  • Review the Database Designer output files
  • Deploy the comprehensive database designs
  • Create partitioned tables
  • Load data into partitions Move partitioned data into archived tables
  • Remove data by dropping and truncating tables Bulk delete data from tables
  • Create new database Users
  • Create new database user roles
  • Assign a role to a user Create a role hierarchy
  • Review the default resource pools and parameters
  • Create a backup configuration file
  • Back up the database
  • Review the database backups
  • Restore the database
  • Discuss the structure of an analytic query
  • Review Vertica-specific functions
  • Review User authentication options
  • Secure your environment from outside threats

Suggested courses

Suggested courses are based on product compatibility, popularity, and newness.


VT120 1.0
More info Less info
Related products
Course outline

Vertica administrators
Delivery Type:
Certification Exam
1 hour, 22 minutes



Unsubscribe from notifications

You are receiving release updates for this course because you have subscribed to the following products:
If you unsubscribe, you will no longer receive any notifications for these products.
Tip: to update your subscription preferences, go to Manage Subscriptions from your Dashboard, uncheck the products you no longer want to receive notifications for, and click 'Save'.

Marketplace Terms of Service

In order to continue, you must accept the updated Marketplace Terms of Service
Since you are downloading an app from the Micro Focus Marketplace, you need to accept the updated Marketplace Terms of Service before you can continue. Use the link to review the Marketplace Terms of Service. Once complete check the, "I accept the Marketplace Terms of Service" box below and click accept to continue your download.

Your download has begun...

Your download has begun

Related content and resources

Your browser is not supported!

Please upgrade to one of the following broswers: Internet Explorer 11 (or greater) or the latest version of Chrome or Firefox

release-rel-2022-8-2-5007 | Wed Aug 17 09:05:29 PDT 2022