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匹配题