Certbus > HP > HP ExpertONE Certification > HP2-N36 > HP2-N36 Online Practice Questions and Answers

HP2-N36 Online Practice Questions and Answers

Questions 4

During Vertica installation, how do you install onto multiple nodes of a cluster?

A. You must install the application individually on each node.

B. Run the installation script from the Console machine once per node.

C. Pass the IP address or node names as part of the -s argument, and it will install the application on each node.

D. Pass the IP addresses or node names to spread, and it will install the application on each node.

Browse 50 Q&As
Questions 5

What are the disadvantages of using delete vectors to identify records marked for deletion? (Select two.)

A. Delete vectors are stored in a different location, minimizing storage impact.

B. Delete vectors rewrites files, causing additional overhead.

C. Delete vectors must be recognized during the query process to remove records marked for deletion from the result set, slowing down the processing of a query.

D. Delete vectors do not instantly reclaim space used by deleted records.

E. Delete vectors must be maintained forever.

Browse 50 Q&As
Questions 6

What are the benefits of loading data into WOS?

A. The data is cached in memory for quick access.

B. The data is able to be queried as soon as it is loaded.

C. The data is broken out into projections.

D. The data is sorted.

Browse 50 Q&As
Questions 7

How are records marked for deletion?

A. Vertica removes the file that stores the deleted data.

B. Vertica rewrites the files that contained the deleted records, ignoring records to be deleted.

C. Vertica deletes the records from the original source files.

D. Vertica creates a delete vector, identifying records to be deleted.

Browse 50 Q&As
Questions 8

What is the process to add hosts to an existing cluster? (Select two.)

A. Restart spread on all hosts in the cluster.

B. Recreate all projections on the new hosts.

C. Update spread.conf on the new host(s) only.

D. Install Vertica on the new hosts.

E. Redistribute data to the new host(s).

Browse 50 Q&As
Questions 9

What is the Resource Manager's role in query processing?

A. serializing all requests to simulate concurrency

B. determination and allocation of request importance

C. determination and allocation of memory, threads, and file handles for the request

D. allowing queries to run in place of background tasks

Browse 50 Q&As
Questions 10

What are features of using the Vertica backup script? (Select two.)

A. It uses a lightweight locking protocol, stopping data loading for a brief period of time

B. It can be run remotely via the Management Console

C. It enables recovery by database, node, or table

D. It enables backup of the entire database only

E. It can be run while the database is not running.

Browse 50 Q&As
Questions 11

Which statements are true about a prejoin projection? (Select three.)

A. A prejoin projection enforces primary and foreign key constraints.

B. A prejoin projection does not increase the storage footprint.

C. A prejoin projection slows down data loading.

D. A prejoin projection can process any type of join.

E. A prejoin projection adds no limitations to the tables in the join.

F. A prejoin projection improves query run time performance.

Browse 50 Q&As
Questions 12

What is a difference between maxconcurrency and plannedconcurrency?

A. Maxconcurrency is a hard limit to the number of queries running within a pool; plannedconcurrency is used to create a query budget.

B. Maxconcurrency is used to create a query budget; plannedconcurrency is a hard limit to the number of queries running within a pool.

C. Maxconcurrency is a hard limit to the number of queries running within a pool; plannedconcurrency limits the number of queries running on the cluster.

D. Maxconcurrency limits the number of queries running on the cluster; plannedconcurrency is a hard limit to the number of queries running within a pool.

Browse 50 Q&As
Questions 13

What is a Vertica cluster?

A. a collection of projection files

B. a grouping of several Vertica databases

C. the set of nodes running one instance of Vertica

D. a physical machine configured to run an instance of Vertica

Browse 50 Q&As
Questions 14

How can you disallow user connections, while preserving dbadmin connectivity?

A. SELECT close_session (session_id);

B. SELECT close_all_sessions;

C. SELECT set_config_parameter ('MaxClientSessionsVS');

D. SELECT set_config_parameter ('MaxClientSessionsVO');

Browse 50 Q&As
Questions 15

Which statement is true about a query explain plan?

A. It determines how to run the query, runs it, and returns the result.

B. It writes the SQL to execute a query.

C. It tells exactly how many rows will be returned by the query.

D. It displays the results of Optimizer to the user, showing projection(s) used and the query process.

Browse 50 Q&As
Questions 16

What can be used to determine memory resources needed by a query?

A. Generate an EXPLAIN plan on the query.

B. Review the digraph of the query.

C. PROFILE the query.

D. Run the query and view the information in the results.

Browse 50 Q&As
Questions 17

Which methods exist to troubleshoot spread? (Select two.)

A. Power cycle the server

B. Restart the spread daemon on the node.

C. Restart the Vertica process on the node.

D. Verify that spread.conf is the same on all nodes.

E. Verify that spread.conf is different on all nodes.

Browse 50 Q&As
Questions 18

What are the standard clauses in an analytics query?

A. It includes a PARTITION clause, with required over_clause, order_clause, and frame_clause.

B. It includes an OVER clause, with required partition_clause, order_clause, and frame_clause

C. It includes an OVER clause, with optional partition_clause, order_clause, and frame_clause.

D. It includes a PARTITION clause, with optional over_clause, order_clause, and frame clause.

Browse 50 Q&As
Exam Code: HP2-N36
Exam Name: HP Vertica Solutions [2012]
Last Update:
Questions: 50 Q&As

PDF

$45.99

VCE

$49.99

PDF + VCE

$59.99