Your manager asks you for a report on profit by customer. We learned about facts (or measures) and dimensions. Which is the dimension?单项选择题

A

Profit

B

Neither is a dimension

C

Customer

登录即可查看完整答案

我们收录了全球超50000道真实原题与详细解析,现在登录,立即获得答案。

类似问题

Data Warehousing: Case Study Model Limitations The CEO really likes the data warehouse you’ve built! However, one day, the CFO Lucy and the CTO Sandy come to your office and asks you some tough questions: Query X: “ How many clients used Bitcoin as a partial payment method last month? ” (by the CFO and CTO) Query Y: “ How many contracts were finalised at 11:59pm in Melbourne? ”  (by the CTO, to plan for Windows Updates!) Query Z: “ Which in-house lawyers worked more than 12 hours overtime with in-house projects last month? ” (by the CFO, as this cost a lot of money!) You tell the CFO and CTO that the current warehouse (data mart) doesn’t support these queries, and they seem puzzled. Why can your model not support each of these queries? Assume you didn't over-engineer your original model, you only stored the data required to answer the original queries in the introduction. Choose the MOST correct / specific answer in each case. 1: Query X 2: Query Y 3: Query Z

Data Warehousing B Match the aspects/components to their role in the model (choose the most specific role/term that applies). 1: Amount 2: Business 3: BankExpenditure 4: Country 5: TypeCategory 6: ‘Customer making a purchase’

Dimensional databases are used to track historical data, and therefore must have a(n) ________.

Pedersen Industries wants to initiate a new project. To facilitate the project, an increase in cash of $20,000 will be required and the firm needs to build up $15,000 in inventory. The firm is expecting revenues of $500,000 per year and cost of goods sold (COGS) of $400,000. Pedersen Industries is expecting that Accounts Receivables (AR) will account for 5% of annual sales and Accounts Payables (AP) will account for 10% of COGS. All these changes will occur in year t=1. ​ What is the incremental cash flow effect from the change in Net Working Capital (NWC) in year 1?

更多留学生实用工具

加入我们，立即解锁 海量真题 与 独家解析，让复习快人一步！