nerdexam
Dell-EMC

E20-465 · Question #38

What is the purpose of partition pruning?

The correct answer is D. To constrain DQL queries to a specific partition. See the full explanation below for the reasoning.

Question

What is the purpose of partition pruning?

Options

  • ATo reduce the number of rows in a partition by moving objects with higher values to another
  • BTo move partitions that are used infrequently to second tier storage
  • CTo move all related objects together with their parent sysobjects
  • DTo constrain DQL queries to a specific partition

How the community answered

(56 responses)
  • A
    11% (6)
  • B
    5% (3)
  • C
    4% (2)
  • D
    80% (45)

Community Discussion

No community discussion yet for this question.

Full E20-465 Practice