Question3 select the best answer for an expense

This preview shows page 4 - 6 out of 6 pages.

Question 3 Select the best answer. For an expense budget line item, what is the grain of the Budget Fact table? a . Each row in the Budget Fact table represents the net change of the budget line item that occurred during the month. b . Each row in the Budget Fact table identifies what an organization in the company is allowed to spend for what purpose during a given time frame. c . Each row in the Budget Fact table represents the net change of the budget line item in an organizational cost center that occurred during the month. d . Each row in the Budget Fact table represents the cumulative amount of the
budget line item in an organizational cost center. e . Each row in the Budget Fact table is a snapshot of the current status of each line item in each budget each month. In the order transaction fact table, each line item row includes the order number as a degenerate dimension. Why do we want to include this order number in the fact table? a . The order number enables us to group the separate line items on the order and answer questions such as “What is the average number of line items on an order?” b . The order number is occasionally used to link the data warehouse back to the operational database. c . The order number may play a role in the fact table’s primary key. d . All of the above On an order, there may be a shipping charge that applies to the entire order. The dimensional modeler's first response should be to try to force all the facts down to the lowest level. This procedure is broadly referred to as _________.
a . cost streamlining b . cost replication c . cost propagation d . activity-based costing e . cost allocation

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture