nerdexam
Dell-EMC

E20-465 · Question #41

You have enabled data partitioning on your High-Volume Server installation. You need to perform a number of operations on a large set of objects using DQL. Which actions could improve the…

The correct answer is B. Retrieve the r_object_id and i_partition properties of the objects. See the full explanation below for the reasoning.

Question

You have enabled data partitioning on your High-Volume Server installation. You need to perform a number of operations on a large set of objects using DQL. Which actions could improve the performance of those queries?

Options

  • ARetrieve the r_object_id and shared_parent_type properties of the objects.
  • BRetrieve the r_object_id and i_partition properties of the objects.
  • CExecute the GENERATE_PARTITION_SCHEME_SQL administrative method just before
  • DRetrieve the r_object_id and shared_parent_type properties of those objects.

How the community answered

(41 responses)
  • A
    7% (3)
  • B
    78% (32)
  • C
    2% (1)
  • D
    12% (5)

Community Discussion

No community discussion yet for this question.

Full E20-465 Practice