Chapter 13

Question 1

True/False: Business intelligence is a framework that allows a business to transform data into information,
information into knowledge, and knowledge into wisdom.

Answer 1

True

Question 2

True/False: Business intelligence (BI) architecture is composed of data, people, processes, and technology working
together to facilitate and enhance a business’s management and governance

Answer 2

True

Question 3

True/False: A data store is used by data analysts to create queries that access the database

Answer 3

True

Question 4

True/False: Master data management’s main goal is to provide a partial and segmented definition of all data within an organization.

Answer 4

False

Question 5

True/False: Operational data and decision support data serve the same purpose.

Answer 5

False

Question 6

True/False: Decision support data is a snapshot of the operational data at a given point in time

Answer 6

True

Question 7

True/False: Queries against operational data typically are broad in scope and high in complexity.

Answer 7

False

Question 8

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

Answer 8

False

Question 9

True/False: Relational data warehouses use the star schema design technique to handle multidimensional data.

Answer 9

True

Question 10

True/False: The data warehouse development life cycle differs from classical systems development.

Answer 10

True

Question 11

True/False: A data warehouse designer must define common business dimensions that will be used by a data analyst to expand a search.

Answer 11

False

Question 12

True/False: By default, the fact table’s primary key is always formed by combining the super keys pointing to the dimension tables to which they are related.

Answer 12

False

Question 13

True/False: Normalizing fact tables improves data access performance and saves data storage space.

Answer 13

False

Question 14

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

Answer 14

True

Question 15

True/False: Multidimensional data analysis techniques include advanced computational functions

Answer 15

True

Question 16

True/False: Advanced OLAP feature become more useful when access to them is kept simple.

Answer 16

True

Question 17

True/False: A star schema is designed to optimize data query operations rather than data update operations.

Answer 17

True

Question 18

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

Answer 18

True

Question 19

True/False: The ROLLUP extension is used with the GROUP BY clause to generate aggregates by the listed
columns, including the last one.

Answer 19

False

Question 20

True/False: The CUBE extension enables you to get a subtotal for each column listed in the expression, in
addition to a grand total for the last column listed.

Answer 20

True