Oracle
1Z0-531 · Question #27
1Z0-531 Question #27: Real Exam Question with Answer & Explanation
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.
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
Explanation
Use Application Design Best Practices, Minimize the number of dimensions, Avoid Repetition in dimensions, Avoid inter dimensional irrelevance.
Community Discussion
No community discussion yet for this question.