1.
Which of the following describes common methods for enriching an initial dimension map?
2.
A consultant realizes after determining business requirements, that a complete solution will require several related but separate projects. The consultant must choose one project to deliver first. Which of the following describes the considerations that should govern that choice?
3.
Which of the following is a common mistake made by designers when creating dimension models?
4.
A user makes the following request:I need to see actual sales compared with projected sales, and margin range for branches within each division, by product line, sales rep by sales manager, and cost center over time. Based on the users request, Actual Sales and Projected Sales have been identified as required measures. Which of the following other measures would be included in an initial dimension map?
5.
A user makes the following request: I need to see the number of flights throughout the year that arrived or departed more than 15 minutes early or late by origin and destination airport, by carrier, and by time of day. I want to see if the number of flights delayed is greater for large carriers or small carriers. Based on this request, the following metrics have been identified: Flight count, and minutes early or late. Large carriers operate signifigantly more flights than small carriers. Which of the following additional metrics or calculations would provide the MOST value to the user?
6.
When following the Information Focused approach, what should the users bring to the initial interview?