Oracle
1Z0-531 · Question #27
Which two options would provide a better design for the following accounts and metrics?
The correct answer is B. If there are a large number of accounts that require FTE and Expense dollars, split Accounts and D. If block size is large, then keep Accounts and Metrics as one dimension with a dense dimension. Use Application Design Best Practices, Minimize the number of dimensions, Avoid Repetition in dimensions, Avoid inter dimensional irrelevance.
Creating and Managing Cubes
Question
Which two options would provide a better design for the following accounts and metrics?
Exhibit
Options
- AIf there are a small number of accounts that require FTE and Expense dollars, split Accounts and
- BIf there are a large number of accounts that require FTE and Expense dollars, split Accounts and
- CIf reporting dictates FTE and dollars in the columns and accounts in the rows, split Accounts and
- DIf block size is large, then keep Accounts and Metrics as one dimension with a dense dimension
How the community answered
(64 responses)- A19% (12)
- B75% (48)
- C6% (4)
Explanation
Use Application Design Best Practices, Minimize the number of dimensions, Avoid Repetition in dimensions, Avoid inter dimensional irrelevance.
Topics
#dimension design#accounts dimension#block size#dense dimension
Community Discussion
No community discussion yet for this question.