nerdexam
CDMP

DMF-1220 · Question #240

There are several reasons to denormalize dat

The correct answer is A. The first is to improve performance by: C. None of the above E. Making tables more readable when no foreign key exists. See the full explanation below for the reasoning.

Question

There are several reasons to denormalize dat

Options

  • AThe first is to improve performance by:
  • BCreating smaller copies of fata to reduce costly run-time calculations and/or table scans of large
  • CNone of the above
  • DPre-calculating and sorting costly data calculations to avoid runt-time system resource competition.
  • EMaking tables more readable when no foreign key exists
  • FCombining data from multiple other tables in advance to avoid costly run-time joins
  • GAll of the above

How the community answered

(26 responses)
  • A
    77% (20)
  • B
    4% (1)
  • D
    12% (3)
  • G
    8% (2)

Community Discussion

No community discussion yet for this question.

Full DMF-1220 Practice