nerdexam
Oracle

1Z0-531 · Question #5

1Z0-531 Question #5: Real Exam Question with Answer & Explanation

Sign in or unlock 1Z0-531 to reveal the answer and full explanation for question #5. The question stem and answer options stay visible for context.

Question

Your current block storage option design includes two dimensions: Markets and Regions. The Market dimension looks like: Users need to be able to report by both regions and markets. Subtotals for Northeast and Southwest will display on some reports.

Exhibit

1Z0-531 question #5 exhibit

Options

  • AAdd another level to the market dimension for Northeast with North and East as children and Southwest
  • BAdd an alternate hierarchy to the market dimension with the states as shared members, rolling up to
  • CCreate a UDA with members Northeast and Southwest (associated to states in the Market dimension)
  • DCreate an attribute dimension with members Northeast and Southwest (associated to states in the
  • ECreate a Text list with the values containing the members Northeast and Southwest.

Unlock 1Z0-531 to see the answer

You've previewed enough free 1Z0-531 questions. Unlock 1Z0-531 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Full 1Z0-531 Practice