HP2-N36 試験問題を無料オンラインアクセス

What is the purpose of Vertica's transaction model? (Select three.)

• A.Transactions are used to maintain segmentation.
• B.Transactions are only written upon an explicit commit being issued
• C.Transactions are used to delete data.
• D.Transactions mean that undo logs are not needed.
• E.Transactions are used to maintain partitions.
• F.Transactions are used for data recovery.

What is local segmentation capability in Vertica?

• A.Vertica automatically splits current segments in half to redistribute them to new nodes.
• B.Vertica automatically creates more segments than are currently needed, allowing some segments to be moved to new nodes as needed.
• C.Vertica automatically partitions the data, allowing partitions to be dropped and recreated on new nodes.
• D.Vertica automatically partitions the segmented data, allowing some partitions to be moved to new nodes as needed.

How are records marked for deletion?

• A.Vertica deletes the records from the original source files.
• B.Vertica creates a delete vector, Identifying records to be deleted.
• C.Vertica removes the file that stores the deleted data.
• D.Vertica rewrites the files that contained the deleted records, ignoring records to be deleted.

What are the advantages of a group by pipe versus a group by hash? (Select two.)

• A.A group by pipe requires no optimization.
• B.A group by pipe builds its entire output table in memory.
• C.A group by pipe can be processed spill to disk if the join result is large.
• D.A group by pipe is at least as fast as a group by hash.
• E.A group by pipe uses memory more efficiently.

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.