Questions
Questions

INFO20003_2025_SM2 Exam: Database Systems (INFO20003_2025_SM2)- Requires Respondus LockDown Browser

Matching

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

Options
A.Attribute is missing.
B.Granularity is not sufficient.
C.Dimension is missing.
D.Different business process.
View Explanation

View Explanation

Verified Answer
Please login to view
Step-by-Step Analysis
Begin by restating the scenario to set the context: the data warehouse (data mart) was designed to answer a specific set of original queries, and now three new queries are asked that test the model’s limitations. For each query, we must pick the most correct or specific limitation from the given options. Query 1: 'How many clients used Bitcoin as a partial payment method last month?' - Option: Different business process. This suggests the warehouse design is misaligned with the new business process or reporting requirement, implying that the data marts were structured around existing processes and would need a different data integration or modeling approach to capture a new payment method scenario. This can be a valid reason if the requested metric crosses process boundaries or requires data not captured by the current process model. - Option: Granularity is not sufficient. If the warehouse already records payments and clients, but the granularity (e.g., monthly) does not support the need to identify Bitcoin usage by client, this could be a reason. However, the scenario states the data mart stored data necessary for the original queries and does not imply granularity would be insufficient for a monthly aggregate by payment method unless the payment method detail is not captured at a fine enough level. - Option: Dimension is missing. This would mean the data model lacks a dimension to categorize by payment me......Login to view full explanation

Log in for full answers

We've collected over 50,000 authentic exam questions and detailed explanations from around the globe. Log in now and get instant access to the answers!

Similar Questions

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) ________.

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

In a consumer society, many adults channel creativity into buying things

More Practical Tools for Students Powered by AI Study Helper

Join us and instantly unlock extensive past papers & exclusive solutions to get a head start on your studies!