题目
题目

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

匹配题

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

选项
A.Attribute is missing.
B.Granularity is not sufficient.
C.Dimension is missing.
D.Different business process.
查看解析

查看解析

标准答案
Please login to view
思路分析
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

登录即可查看完整答案

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

类似问题

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

更多留学生实用工具

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