HP HP2-N36 Certification Exam Syllabus

HP Vertica Solutions Syllabus, HP Vertica Solutions PDF Download, HP HP Vertica Solutions Dumps, HP Vertica Solutions [2012] Dumps PDF Download, HP Vertica Solutions [2012] PDF Download

This page is a one-stop solution for any information you may require for HP Vertica Solutions [2012] (HP2-N36) Certification exam. The HP HP2-N36 Exam Summary, Syllabus Topics and Sample Questions provide the base for the actual HPE Vertica Solutions exam preparation, we have designed these resources to help you get ready to take your dream exam.

The HP Vertica Solutions [2012] credential is globally recognized for validating HP Vertica Solutions knowledge. With the HPE Vertica Solutions Certification credential, you stand out in a crowd and prove that you have the HP Vertica Solutions knowledge to make a difference within your organization. The HP Vertica Solutions [2012] Certification (HP2-N36) exam will test the candidate's knowledge on following areas.

HP HP Vertica Solutions Exam Summary:

Exam Name HP Vertica Solutions [2012]
Exam Code HP2-N36
Exam Duration 90 minutes
Exam Questions 50
Passing Score 70%
Exam Price $100 (USD)
Books HPE Press books
Exam Registration Pearson VUE
Sample Questions HP Vertica Solutions [2012] Certification Sample Question
Practice Exam HP Vertica Solutions [2012] Certification Practice Exam

HP HP Vertica Solutions Exam Topics:

Objective Details
Vertica Architecture (10%)
  • Identify key features of Vertica
  • Describe high availability capabilities and describe Vertica's transaction model
  • Differentiate between compression and encoding
  • Installation of Vertica
Projection Design (10%)
  • Identify characteristics and determine features of projections used in Vertica
  • Define RLE
  • Describe ORDER BY importance in projection design
  • Describe the purpose of projection segmentation
  • Understanding buddy projections
  • Determining segmentation and partitioning
Loading Data into Vertica (20%)
  • Identify benefits of loading data into WOS and directly into ROS
  • Define the actions of the moveout and mergeout tasks
  • Describe how mergeout purges data marked for deletion
  • Copying data directly to ROS
  • Identifying characteristics of data file directory
  • Understanding both WOS and ROS
  • Distinguishing between moveout and mergeout actions
Removing Data Permanently from Vertica and Advanced Projection Design (16%)
  • Describe the process used to mark records for deletion
  • Identify the advantages and disadvantages of using delete vectors to identify records marked for deletion
  • Identify the process for processing a large delete or update
  • Distinguish between deleting partitions and deleting records
  • Identify the advantages of a merge join versus a hash join
  • Identify the advantages of a group by pipe versus a group by hash
  • Describe the characteristics of a prejoin projection
  • Determine methods available to optimize a projection for delete processing
Cluster Management in Vertica (10%)
  • Identify the steps used to add nodes to an existing cluster
  • Describe the benefits of having identically sorted buddy projections
  • Identify the steps of online recovery of a failed node
  • Define local segmentation capability in Vertica
  • Distinguish between the items in a Vertica cluster
Backup/Restore and Resource Management in Vertica (10%)
  • Identify situations when a backup is recommended
  • Identify features of the Vertica file used for backup and restore
  • Define the Resource Manager's role in query processing
  • Describe the differences between maxconcurrency and plannedconcurrency
  • Using query profiles and resource pools
Monitoring and Troubleshooting Vertica (10%)
  • Define the use of Management Console in monitoring Vertica
  • Determine methods to troubleshoot spread
  • Describe how to disallow user connections, while preserving dbadmin connectivity
  • Defining, using and logging into Management Console
  • Administering a cluster using Management Console
Analytics and Performance Tuning (14%)
  • Understanding analytics syntax
  • Using Event Based Windows, Time Series, Event Series Join, and Pattern Matching
  • Using explain plans and query profiles
  • Improving query performance
  • Analyzing an explain plan

The HP has created this credential to assess the knowledge and understanding of a candidate in the area as above via the certification exam. The HP Vertica Solutions (HP2-N36) Certification exam contains a high value in the market being the brand value of the HP attached with it. It is highly recommended to a candidate to do a thorough study and also get a hand full of the practice to clear HP Vertica Solutions [2012] exam without any hiccups.

Rating: 4.9 / 5 (77 votes)