A(n) _______________ optimizer uses a set of preset conditions and points to determine the best approach to execute a query. The conditions assign a “cost” to each SQL operation; the costs are then added to yield the cost of the execution plan.
What database statistics measurements are typical of environment resources?
____________________ describes a process on the server side that will properly configure the DBMS environment to respond to clients’ requests in the fastest way possible, while making optimum use of existing resources.
How are database statistics obtained?
Which of the following is NOT a phase the DBMS goes through when processing a query?
A(n) _______________ uses 0s and 1s to represent the existence of a value or condition.
What database statistics measurements are typical of tables?
______________ refers to the number of different values a column could possibly have.
The term __________________ refers to a number of measurements gathered by the DBMS to describe a snapshot of the database objects’ characteristics.
Which of the following is NOT one of the general guidelines for creating and using indexes?
Which of the following phase is where the DBMS runs the SQL query using the chosen plan?
_____________ database systems are optimized to store large portions (if not all) of the database in primary (RAM) storage rather than secondary (disk) storage.
In simple terms, the DBMS processes queries in ________ phase(s).
Which of the following phase is where the DBMS analyzes the SQL query and chooses the most efficient access/execution plan?
RAID level _______________ is when the data and the parity are striped across separate drives, providing good read performance and fault tolerance via parity data.
Optimizer ______ are special instructions for the optimizer that are embedded inside the SQL command text.
Which of the following is NOT one of the steps you would follow when formulating a query?
What query optimization factors should you keep in mind if you intend to write conditional expressions in SQL code?
What type of SQL statement updates the data dictionary tables or system catalog?
Most performance-tuning activities focus on doing what to the number of I/O operations, which are much slower than reading data from the data cache?
A(n) _______________ optimizer uses sophisticated algorithms based on the statistics about the objects being accessed to determine the best approach to execute a query.
You use ________________ to provide both performance improvement and fault tolerance, and a balance between them as part of DBMS performance tuning.
Which of the following are recommendations you would make for managing the data files in a DBMS with many tables and indexes?
Which of the following is an example of an optimizer hint used in standard SQL?
___________________ describes a process on the client side that will generate an SQL query to return the correct answer in the least amount of time, using the minimum amount of resources at the server end.
DBMS performance tuning at the server end focuses on setting the parameters used for:
The data warehouse is usually a ___________ database optimized for data analysis and query processing.
Which of the following are problems when operational data are integrated into the data warehouse?
A(n) ___________________ is an arrangement of computerized tools used to assist managerial decision making.
A(n) ___________________ is a web-based system in BI that presents key business performance indicators or information in a single, integrated view with clear and concise graphics.
The _______ clause in a materialized view indicates that the view rows are populated right after the command is entered.
The ____________ is a data-modeling technique used to map multidimensional decision support data into a relational database.
__________ uses star schemas while _____________ uses data cubes.
The fact table from the star schema diagram below is ____________.
Which of the following is a basic component of the BI architecture?
A(n) _______ in a star schema is a numeric measurement or value that represents a specific business aspect or activity.
Which SQL extension is used with the GROUP BY clause to generate aggregates by different dimensions?
Which of the following are common characteristics of operational data?
One of the main characteristics of OLAP is ____________.
Which of the following techniques is NOT used to optimize data warehouse design?
The _______ clause in a materialized view indicates when the rows are actually populated.
Which type of OLAP would be best suited for the relational database environment?
A modern BI system provides which of the following distinctive reporting styles?
A(n) _______ in a star schema is a qualifying characteristic that provides additional perspective to a fact.
Decision support data requires managers to _________ and to ________ the data in different situations.
Multidimensional _________________ refers to the processing of data in which data are viewed as part of a multidimensional structure, one in which data are related in many different ways.
which of the following is NOT a major component of the Business Intelligence framework?
Which of the following is NOT a key performance indicator in BI?
A data cube that grows to n number of dimensions is known as a _____________.
On which level of the BI framework is data analytics used?
A(n) _______ in a star schema provides a top-down data organization that is sued for aggregation and drill-down/roll-up data analysis.
_______ has a larger database size than __________ .
_______ measures the density of the data held in the data cube; it is computed by dividing the total number of actual values in the cube by the total number of cells.
Which SQL extension is useful when you want to compute all possible subtotals within groupings based on multiple dimensions?
Which SQL extension is used with the GROUP BY clause to generate aggregates by the listed columns, including the last one?
The ______________ table in the star schema represented below is NOT a dimension.
A(n) _______ in a star schema is often used to search, filter, or classify facts.
A ___________ is a small, single-subject data warehouse subset that provides decision support to a small group of people.
Which type of OLAP system works faster for large data sets with predefined dimensions?
The _______ clause in a materialized view lets you indicate when and how to update the view when new rows are added to the base tables.
Which of the following is NOT a dissemination format of BI that started in the 2000s?
A _____ view is a dynamic table that not only contains the SQL query command to generate the rows, it stores the actual rows.
______ integrates people and processes using technology in order to add value to the business.
_____ is a framework that allows a business to transform data into information, information into knowledge, and knowledge into wisdom.
From the data analyst’s point of view, decision support data differ from operational data in what three areas?
A(n) ______________ is an integrated, subject-oriented, time-variant and non-volatile database that provides support for decision-making.
In the ROLLUP SQL extension, the ____________ of the column list within GROUP BY ROLLUP is very important.
Which of the following is a basic component of the star schema?
The power of multidimensional analysis resides in its ability to focus on specific _______ of the cube.
The ___________ component of the BI architecture performs data analysis and data-mining tasks using the data in the data store.
You have been asked by a client to normalize the driver dimension and to create multiple fact tables for the receipts that a driver collects for each of the new aggregation levels. Fill in the blanks with the field names used in the star schema to accomplish this task.
Drag the correct answers in alphabetical order in to corresponding pockets.
Fill in the blanks with words that would best complete the passage.
A(n) ________________________ is one in which all data integrity constraints are satisfied.