30 Questions
What does the sale of a ticket represent in the airline industry?
Unearned revenue
What is the term for a single flight number flown by a single aircraft?
Segment
What is the level of granularity that provides an accurate picture of customer demand?
Trip
What is the term for an aircraft taking off at one airport and landing at another without any intermediate stops?
Leg
What is the purpose of the degenerate dimension in the airline's bus matrix?
To capture the bus process events
What is the equivalent of the entire airline ticket or reservation confirmation number?
Itinerary
What is the purpose of a class change indicator in a data model?
To describe relationships between purchased and flown classes
Why might combining role-playing dimensions be beneficial?
To maintain consistency across the data model
What is a potential challenge of using separate origin and destination dimensions?
Inconsistencies in labeling
Why might business users want to combine origin and destination airports?
To analyze flight activity by distance
What is a potential disadvantage of separate role-playing dimensions?
Difficulty in combining attributes
What is a potential solution to inconsistencies in labeling?
Resolving programmatically
What type of data is often captured in a patient's electronic medical record?
Both quantitative numbers and qualitative notes, as well as images
What is a common challenge in the healthcare industry, especially with legacy operational systems?
Dealing with late arriving data
What type of fact table is used to illustrate the healthcare claim billing and payment pipeline?
Accumulating snapshot grain fact table
What is an example of a metric that healthcare organizations are interested in?
Utilization and availability of assets
What is a common use of freeform text comments in healthcare?
To capture clinical notes
What is the purpose of the enterprise data warehouse bus matrix in healthcare?
To show the relationship between administrative and clinical data
What is the granularity of the second clickstream fact table?
Individual page event in each customer session
Why should you avoid grouping the table at a broader level?
Because it loses details
What is the result of using dynamically created XML-based pages on websites?
The number and type of events grow
What is the purpose of picking the right categories after deciding on the level of detail?
To establish the right categories for analysis
What can be seen in Figure 15-6?
The final layout of the clickstream fact table
What is a strength in dimensional modeling?
Similarity between designs
What can be used to label customers for periods of time with information that is not clear from the page or immediate session?
Customer status attribute
Where should labels derived from auxiliary business processes be placed in the DW/BI system?
Deep within the clickstream
What type of information is usually provided by the web server logs?
URL of the previous page
What is the purpose of the session dimension?
To group sessions for analysis
What should be considered when dealing with a large number of customer statuses?
Creating a separate customer status mini-dimension
What type of analysis can be performed using the session dimension?
Analyzing how many customers consulted product information before ordering
This quiz covers the concepts of data warehousing in transportation, including bus matrix, fact tables, correlated role-playing dimensions, and date dimensions. It is based on Chapter 12 of a data warehousing course, with a focus on airline case studies.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free