Q&A Hero

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

Q: In a typical star schema, each dimension record is related to thousands of ____ records.a. attribute b. fact c. keyd. star

Q: Fact and dimension tables are related by ____ keys.a. shared b. primary c. foreignd. linked

Q: The attribute hierarchyprovides a top-down data organization that is used for two main purposes: ____ and drill-down/roll-up data analysis.a. hierarchy b. de-normalization c. normalizationd. aggregation

Q: The ____ dimension of a data cube provides a framework from which sales patterns can be analyzed and possibly predicted.a. time b. cube c. thirdd. multi-

Q: In a star schema, attributes are often used to search, filter, or classify ____.a. tables b. stars c. factsd. dimensions

Q: In a star schema, dimensions are normally stored in ____.a. attributes b. indexes c. fact tablesd. dimension tables

Q: Computed or derived facts are sometimes called ____to differentiate them from stored facts.a. details b. attributes c. metricsd. fact tables

Q: The basic star schema has four components: facts, ____, attributes, and attribute hierarchies.a. keys b. relationships c. cubesd. dimensions

Q: There are 12 rules that define a(n) ____.a. data warehouse b. multidimensional cube c. OLAP toold. star schema

Q: How should storage volumes be allocated for indexes, system, and high-usage tables?

Q: How can queries be written to perform the fastest when equality and inequality comparisons are needed?

Q: Why do we need to optimize a DBMS with SQL performance tuning, even though they automatically optimize SQL queries?

Q: Describe query optimization and the modes that an optimizer can operate in.

Q: List and describe some typical DBMS processes.

Q: The ____________________ table space is the most frequently accessed table space and should be stored in its own volume.

Q: Use __________________________________________________ to provide balance between performance and fault tolerance.

Q: A conditional expression is normally expressed within the ____________________ or HAVING clauses of a SQL statement.

Q: ____________________ is a measure of how likely an index will be used in query processing.

Q: ____________________ are special instructions for the optimizer that are embedded inside the SQL command text.

Q: ____________________ are ordered sets of values that are crucial in speeding up data access.

Q: Once an SQL statement is transformed, the DBMS creates what is commonly known as a(n) ____________________ plan.

Q: The ____________________ analyzes the SQL query and finds the most efficient way to access the data.

Q: DBMS query processing has ____________________ phases.

Q: A(n) ____________________ request is a low-level (read or write) data access operation to/from computer devices.

Q: The ____________________ cache is a shared, reserved memory area that stores the most recently executed SQL statements or PL/SQL procedures, including triggers and functions.

Q: ____________________ is another name for table space.

Q: Database ____________________ activities can be divided into those taking place either on the client side or on the server side.

Q: The system will perform best when its hardware and software resources are ____________________.

Q: End users and the DBMS interact through the use of ____________________ to generate information.

Q: The ____ table space is used as a temporary storage area for merge, sort, or set aggregate operations.a. system b. user data c. temporaryd. rollback segment

Q: The ____ table space is used to store the data dictionary tables.a. system b. user data c. temporaryd. rollback segment

Q: The ____ table space is used to store end-user data.a. system b. user data c. temporaryd. rollback segment

Q: The ____ table space is used for transaction-recovery purposes.a. system b. user data c. temporaryd. rollback segment

Q: Most DBMSs operate in one of two optimization modes: cost-based or rule-based. Others automatically determine the ____ based on whether database statistics are available.a. data cache b. SQL cache c. sort cached. optimization mode

Q: The ____ cache is used as a temporary storage area for ORDER BY or GROUP BY operations, as well as for index-creation functions.a. data b. SQL c. sortd. optimizer

Q: The ____ cache stores the most recently executed SQL statements.a. data b. SQL c. sortd. optimizer

Q: The majority of primary memory resources will be allocated to the ____ cache.a. data b. SQL c. sortd. optimizer

Q: The ____ must be set large enough to permit as many data requests to be serviced from cache as possible.a. data cache b. SQL cache c. sort cached. optimizer mode