Online Access Free HP2-N36 Exam Questions

What are characteristics of projections in Vertica? (Select three.)

• A.Each projection contains all rows from the source table.
• B.Each projection contains all columns from the source table.
• C.A projection can contain data from one or more source tables.
• D.A projection can contain data from only one source table.
• E.A projection can contain a subset of columns from the source table.
• F.A projection can contain a subset of rows from the source table.

Which statements are true of a projection? (Select two.)

• A.They can contain aggregate functions.
• B.They can be created at any time, either before or after data is loaded into a table.
• C.They can only be created prior to loading data
• D.They can contain a join condition.
• E.They can contain a comparison predicate.

Who can log in to the Management Console?

• A.any user with permission granted
• B.root and dbadmin users only
• C.dbadmin user only
• D.root user only

What are the benefits of loading data into WOS?

• A.The data is sorted.
• B.The data is broken out into projections.
• C.The data is able to be queried as soon as it is loaded.
• D.The data is cached in memory for quick access.

What is the process for online recovery of a failed node? (Select two.)

• A.The recovered node must be rebuilt from epoch 0.
• B.The recovered node verifies that it is current once a recovery cycle completes.
• C.The recovered node uses spread to speed up the recovery process.
• D.The recovered node gathers the necessary files from nodes with its buddy projections.
• E.The recovered node restores all files from the last backup.