Business Intelligence Exam 1 Questions and Answers

Data content - Answer- Operational: Current Values Informational: Archived, derived, summarized Data Structure - Answer- Operational: Optimized for transactions Informational: Optimized for complex queries Access Frequency - Answer- Operational: High Informational: Medium to low Access Type - Answer- Operational: Read, Update, Delete Informational: Read Usage - Answer- Operational: Predictable, Repetitive Informational: Ad hoc, Random, Heuristic Response Time - Answer- Operational: Sub-seconds Informational: Several seconds to minutes Users - Answer- Operational: Large number Informational: Relatively small number Data Warehouse: Integrated - Answer- Data inconsistencies are removed; data from diverse operational applications is integrated Data Warehouse: Non-volatile - Answer- Usually the data in the data warehouse is not updated or deleted Data Warehouse: Granularity - Answer- Refers to the LEVEL OF DETAIL. Depending on the requirements, multiple levels of detail may be present Fact Tables - Answer- Define the information the must be included in a table. Key information such as product ID and cashier Star Schema - Answer- A Fact table surrounded by the dimensions that make up the table itself Core Elements of DW/BI Architecture - Answer- Source Transactions<->Back Room<->Front Room-> What is the Back Room - Answer- ETL System What is the Front Room - Answer- Presentation Area BI Applications Life Cycle Overview - Answer- Business Requirements Definition Modeling and Design Selection, Installation and Physical Design ETL Design and Development, App Development Deployment Maintenance & Growth Dimensional Modeling - Answer- Identify the Business Process Declare the grain Choose the dimensions Choose the facts Growth - Answer- Ongoing expansion and additional value delivery at the expense of a "Master Plan"