Free Cheat-test Samples and Demo Questions Download
Adobe exams Adobe
Apple exams Apple
Avaya exams Avaya
Check Point exams Check Point
Cisco exams Cisco
Citrix exams Citrix
CIW exams CIW
CompTIA exams CompTIA
CWNP exams CWNP
EC-Council exams EC-Council
EMC exams EMC
Exin exams Exin
Fortinet exams Fortinet
GIAC exams GIAC
Hitachi exams Hitachi
HP exams HP
IBM exams IBM
Isaca exams Isaca
ISC exams ISC
ISEB exams ISEB
Juniper exams Juniper
LPI exams LPI
McAfee exams McAfee
Microsoft exams Microsoft
Oracle exams Oracle
PMI exams PMI
Riverbed exams Riverbed
SNIA exams SAP
Sun exams SAS
Symantec exams Symantec
VMware exams VMware
All certification exams

HP HP2-N36 Exam - Cheat-Test.com

Free HP2-N36 Sample Questions:

Q: 1
Which methods are available to optimize a projection for delete processing? (Select two.)
A. Add a low cardinality column to the beginning of all projections on the source table.
B. Add a high cardinality column to the end of all projections on the source table.
C. Add all columns used as delete predicates to all projections on the source table.
D. Add a low cardinality column to the end of all projections on the source table.
E. Add a high cardinality column to the beginning of all projections on the source table.
Answer: A,C

Q: 2
What are the advantages of a merge join versus a hash join? (Select two.)
A. Sometimes a merge join runs faster than a hash join.
B. A merge join uses memory more efficiently.
C. A merge join requires no optimization.
D. A merge join can spill to disk if the inner table is too large.
E. A merge join joins the data into a new projection.
Answer: B,C

Q: 3
If your CEO runs a query each day, how can you be assured necessary resources will be available when the query is run? (Select two.)
A. Create a resource pool with dedicated resources for the CEO.
B. Move all other users out of the general pool, leaving the CEO as the only user in the general pool.
C. Reserve one core for use by the CEO user only.
D. Assign the CEO user to the general resource pool with a high MEMORYCAP.
E. Profile the query to determine estimated resource usage.
Answer: A,E

Q: 4
What is a benefit of having identically-sorted buddy projections?
A. improved storage usage, since Vertica shares data files
B. more efficient use of disk since the data is only on one node
C. better query performance, since Vertica gets half the data from each projection
D. fast recovery of a down node
Answer: D

Q: 5
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.
Answer: A,B,E


© 2014 Cheat-Test.com, All Rights Reserved