试题详情
- 单项选择题You need to ensure the Order Control team is able to track the number of orders that reach the production department. What should you do?（）
A、Create a new Time dimension based on the Holiday table. Use derived columns for the month and the year.
B、Create a Server Time dimension. Within this dimension， enable the time periods year， month， and date. Select the Additional Manufacturing calendar option.
C、Create a new Time dimension based on the date values within the ProductOrderStatus table. Flag those days on which no orders were received as Holiday.
D、Create a new Time dimension based on a data source view named query. Derive the data for this data source view from unique dates within the ProductOrderStatus table. Use a subquery to identify the holidays and derived columns for the month and the year.
- D
关注下方微信公众号，在线模考后查看
热门试题