Business Intelligence Exam 2 (Chapter 2&3) Questions with Correct Answers

Typical charts, graphs, and other visual elements used in visualization-based applications usually involve ________ dimensions. - Answer-two ________ charts or network diagrams show precedence relationships among the project activities/tasks. - Answer-PERT ________ regression is a very popular, statistically sound, probability-based classification algorithm that employs supervised learning. - Answer-Logistic ________ charts are a special case of horizontal bar charts that are used to portray project timelines, project tasks/activity durations, and overlap among the tasks/activities. - Answer-Gantt ________ plots are often used to explore the relationship between two or three variables (in 2-D or 2-D visuals). - Answer-Scatter ________ management reports are used to manage business performance through outcome-oriented metrics in many organizations. - Answer-Metric ________ charts are effective when you have nominal data or numerical data that splits nicely into different categories so you can quickly see comparative results and trends within your data. - Answer-Bar Information dashboards enable ________ operations that allow the users to view underlying data sources and obtain more detail. - Answer-drill-down/drill-through A(n) ________ is a communication artifact, concerning business matters, prepared with the specific intention of relaying information in a presentable form. - Answer-report When validating the assumptions of a regression, ________ assumes that the errors of the response variable are normally distributed. - Answer-normality Dashboards present visual displays of important information that are consolidated and arranged on a single ________. - Answer-screen ________ statistics is about drawing conclusions about the characteristics of the population. - Answer-Inferential ________ series forecasting is the use of mathematical modeling to predict future values of the variable of interest based on previously observed values. - Answer-Time A(n) ________ data store (ODS) provides a fairly recent form of customer information file. - Answer-operational The ________ Model, also known as the data mart approach, is a "plan big, build small" approach. A data mart is a subject-oriented or department-oriented data warehouse. It is a scaled-down version of a data warehouse that focuses on the requests of a specific department, such as marketing or sales. - Answer-Kimball In ________ oriented data warehousing, operational databases are tuned to handle transactions that update the database. - Answer-product Given that the size of data warehouses is expanding at an exponential rate, ________ is an important issue. - Answer-scalability ________ describe the structure and meaning of the data, contributing to their effective use. - Answer-Metadata ________ is a mechanism for pulling data from source systems to satisfy a request for information. It is an evolving tool space that promises real-time data integration from a variety of sources, such as relational databases, Web services, and multidimensional databases. - Answer-Enterprise information integration (EII) A(n) ________ data mart is a subset that is created directly from the data warehouse.. - Answer-dependent The ________ data warehouse architecture involves integrating disparate systems and analytical resources from multiple sources to meet changing needs or business conditions. - Answer-federated Most data warehouses are built using ________ database management systems to control and manage the data. - Answer-relational ________ is a mechanism that integrates application functionality and shares functionality (rather than data) across systems, thereby enabling flexibility and reuse. - Answer-Enterprise application integration (EAI) Data ________ comprises data access, data federation, and change capture. - Answer-integration The three main types of data warehouses are data marts, operational ________, and enterprise data warehouses. - Answer-data stores The role responsible for successful administration and management of a data warehouse is the ________, who should be familiar with high-performance software, hardware, and networking technologies, and also possesses solid business insight. - Answer-data warehouse administrator (DWA)