Questions
Questions

INFO20003_2025_SM2 MINI Practice Exam

Matching

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’

Options
A.Attribute
B.Business Process
C.Mini-Dimension
D.Hierarchy
E.Fact Table
F.Dimension
G.Fact
H.Intersection
View Explanation

View Explanation

Verified Answer
Please login to view
Step-by-Step Analysis
Let's break down the matching task by item and evaluate the most specific role from the provided options. 1) Amount The most suitable role for a numeric measure like Amount is a Fact. In dimensional modeling, facts represent quantitative values that can be aggregated (sums, averages, counts), and Amount fits this pattern rather than a descriptive attribute. Alternatives like Dimension, Attribute, or others don’t capture the numeric measurement aspect. 2) Business Here, Business i......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: 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

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!