HP HP2-N36

Free Questions in OTE format

About HP HP2-N36 dump

This exam is for Vertica system administrators, database analysts, and application developers.
Prior to taking the exam, you are expected to complete the “Vertica Introduction” training (formerly titled “Vertica Boot Camp”) or equivalent self-directed study, plus 3-6 months of production level experience with the Vertica platform.
You should have 1-3 years Linux experience and experience with a scripting language such as Perl or Python. Extensive working knowledge of SQL plus 3-4 years of technical, hands on experience with a relational database is suggested. A solid understanding of relational database systems including theory, design, and structure is important.
This exam validates that you can successfully perform the following:

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