Description

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

Details

Course
VT120 1.0
More info Less info
Related products
Vertica
10.0
9.0
Course outline

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


Languages
English

Resources

Similar courses

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

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 Marketplace Terms of Service and Micro Focus Terms of Service
Since you are downloading an app from the Micro Focus unified Marketplace using an Access Manager account, you need to also accept the Micro Focus 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 and the Micro Focus 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-2020-10-2-3328 | Wed Oct 14 04:20:43 PDT 2020