Q&A Hero

Q: ____ are in charge of presenting the data to the end user in a variety of ways.a. Data stores b. ETL tools c. Data visualization toolsd. Data analysis tools

Q: The ____ contains business data extracted from the operational database and from external data sources.a. data store b. ETL tools c. data visualization toold. data analysis tool

Q: ____'s main goal is to provide a comprehensive and consistent definition of all data within an organization.a. DBMS b. OLAP c. Data warehousingd. MDM

Q: A data mart is part of the "____" section of the business intelligence framework.a. People b. Management c. Processesd. Governance

Q: Data mining is part of the "____" section of the business intelligence framework.a. People b. Management c. Processesd. Governance

Q: Analyzing decision support data to generate information is part of ____.a. data warehousing b. very large database systems c. business intelligenced. distributed processing

Q: Implementing BI in an organization involves capturing not only business data (internal and external) but also the ____.a. metadatab. facts c. informationd. rules

Q: ROLAP and MOLAP vendors are working toward the integration of their respective solutions within a unified decision support framework.

Q: Because a data cube's dimensions are predefined, all cells are populated.

Q: MOLAP is a logical choice for companies that already use relational databases for their operational data.

Q: The star schema is designed to optimize data query operations rather than data update operations.

Q: To provide better performance, some OLAP systems merge the data warehouse and data mart approaches by storing small extracts of the data warehouse at end-user workstations.

Q: In most implementations, the data warehouse and OLAP are stand-alone, independent environments.

Q: The mainframe environment enables an OLAP system to be divided into several components that define its architecture.

Q: Multidimensional data analysis techniques include advanced computational functions.

Q: In the prognosis phase, the data-mining findings are used to predict future behavior and forecast business outcomes.

Q: It is a relatively easy task to provide a precise list of characteristics of data-mining tools.

Q: Periodicity, usually expressed as current year only, previous years, or all years, provides information about the time span of the data stored in the table.

Q: Normalizing fact tables improves data access performance and saves data storage space.

Q: Data warehouses usually have one fact table.

Q: The data warehouse designer must define common business dimensions that will be used by the data analyst to narrow a search, group information, or describe attributes.

Q: Facts can be computed or derived at run time.

Q: The data warehouse development life cycle differs from classical systems development.

Q: Creating a data warehouse is a simple exercise that takes little time, money, or effort.

Q: Once data enter the data warehouse, they are never removed.

Q: Data warehouse data are organized and summarized by table, such as CUSTOMER and ADDRESS.

Q: The decision support database query optimizer must be enhanced to support non-normalized structures.

Q: Queries against operational data typically are broad in scope and high in complexity.

Q: Decision support data are a snapshot of the operational data at a given point in time.

Q: Operational data and decision support data serve the same purpose.

Q: To tie a KPI to the strategic master plan of an organization, a KPI will be compared to a desired goal within a specific time frame.

Q: SAP is a portal vendor.

Q: MDM's main goal is to provide a partial and segmented definition of all data within an organization.

Q: A data store is used by the data analyst to create the queries that access the database.

Q: The BI architecture is composed of data, people, processes, technology, and the management of such components.

Q: Monitoring results to evaluate outcomes of the business decisions is outside the scope of BI.

Q: BI is a framework that allows a business to transform data into information, information into knowledge, and knowledge into wisdom.

Q: What is the ROLLUP extension to the GROUP BY clause? Provide the syntax for this extension.

Q: What is a data cube?

Q: Describe the use of SQL in relation to ROLAP.

Q: OLAP systems share three main characteristics. What are they?

Q: What is a data mart? Why do some organizations prefer to create a data mart rather than a data warehouse?

Q: ____________________ is a measurement of the density of the data held in the data cube and is computed by dividing the total number of actual values in the cube by the total number of cells in the cube.

Q: A(n) ____________________ uses special proprietary techniques to store data in matrix-like n-dimensional arrays.

Q: ____________________ online analytical processing provides OLAP functionality by using relational databases and familiar relational query tools to store and analyze multidimensional data.

Q: OLAP systems are designed to use both operational and data ____________________ data.

Q: To deliver efficient decision support, OLAP tools must have advanced data ____________________ features.

Q: The most distinct characteristic of modern OLAP tools is their capacity for ____________________ analysis.

Q: ____________________ makes a copy of a table and places it in a different location to improve access time.

Q: In a typical ____________________ schema, each dimension record is related to thousands of fact records.

Q: The ____________________ hierarchy provides the capability to perform drill-down and roll-up searches in a data warehouse.

Q: In multidimensional terms, the ability to focus on slices of the cube to perform a more detailed analysis is known as ____________________.

Q: ____________________ are qualifying characteristics that provide additional perspectives to a given fact.

Q: ____________________ are numeric measurements (values) that represent a specific business aspect or activity.

Q: A data ____________________ is a small, single-subject data warehouse subset that provides decision support to a small group of people.

Q: A data ____________________ is a centralized, consolidated database that integrates data derived from the entire organization and from multiple sources with diverse formats.

Q: To support a(n) ____________________ adequately, the DBMS might be required to use advanced hardware, such as multiple disk arrays, and even more importantly, to support multiple-processor technologies, such as a symmetric multiprocessor (SMP) or a massively parallel processor (MPP).

Q: When you ____________________ data, you are aggregating the data to a higher level.

Q: A(n) ______________________________ is an arrangement of computerized tools used to assist managerial decision making within a business.

Q: ___________________________________ are quantifiable measurements (numeric or scale based) that assess the company's effectiveness or success in reaching its strategic and operational goals.

Q: ____________________ is a method or process of government.

Q: Data ____________________ tools provide advanced visual analysis and techniques to enhance understanding of business data.

Q: Data ____________________ tools are tools that provide advanced statistical analysis to uncover problems and opportunities hidden within business data.

Q: ____________________use Web-based technologies to present key business performance indicators or information in a single integrated view, generally using graphics in a clear, concise, and easy to understand manner.

Q: ______________________________ is a collection of concepts, techniques, and processes for the proper identification, definition, and management of data elements within an organization.

Q: In practice, _________________________ provides a well-orchestrated framework for the management of data that works across all levels of the organization.

Q: ____________________ is a term used to describe a comprehensive, cohesive, and integrated set of tools and processes used to capture, collect, integrate, store, and analyze data with the purpose of generating and presenting information used to support business decision making.

Q: A(n) ____is a dynamic table that not only contains the SQL query command to generate the rows, but also stores the actual rows.a. OLAP b. materialized view c. star schemad. data cube

Q: What is a characteristic of ROLAP?a. It uses the star schema b. It does not require high resources. c. It is limited to predefined dimensions.d. It has low flexibility.

Q: What is one of the main characteristics of OLAP systems? a. They use single-dimensional data analysis techniques. b. They provide complex command-line end-user interfaces. c. They provide minimal database support. d. They support client/server architecture.

Q: A MOLAP system stores data in an MDBMS, using proprietary ____ and array technology to simulate the multidimensional cube.a. table b. matrix c. networkd. cube

Q: Conceptually, MDBMS end users visualize the stored data as a three-dimensional cube known as a ____.a. multi cube b. data matrix c. data cubed. hyper cube

Q: A ____ index is based on 0 and 1 bits to represent a given condition.a. logical b. multidimensional c. stard. bitmapped

Q: ROLAP extends ____ so that it can differentiate between access requirements for data warehouse data and operational data.a. SQL b. OLAP c. DDSd. BI

Q: The ____ schema is designed to optimize data query operations rather than data update operations.a. relational b. circle c. stard. matrix

Q: Decision support data tend to be non-normalized, ____, and pre-aggregated.a. unique b. duplicated c. relationald. sorted

Q: The reliance on ____ as the design methodology for relational databases is seen as a stumbling block to its use in OLAP systems.a. normalization b. denormalization c. star schemad. multidimensional schema

Q: In a MOLAP system, the MOLAP ____ allows end users to interact with the MOLAP server and request data for analysis.a. GUI b. operational database c. multidimensional databased. data cube

Q: ____splits a table into subsets of rows or columns and places the subsets close to the client computer to improve data access time.a. Normalization b. Meta modeling c. Replicationd. Partitioning

Q: A ____ schema is a type of star schema in which the dimension tables can have their own dimension tables.a. snowflake b. starflake c. meshd. matrix