Miguel Lucero
Quiz by , created more than 1 year ago

CIS 3365 Quiz on CHAPTER 13: BUSINESS INTELLIGENCE AND DATA WAREHOUSES, created by Miguel Lucero on 06/04/2017.

504
2
0
Miguel Lucero
Created by Miguel Lucero over 7 years ago
Close

CHAPTER 13: BUSINESS INTELLIGENCE AND DATA WAREHOUSES

Question 1 of 49

1

1. Business intelligence is a framework that allows a business to transform data into information, information into knowledge, and knowledge into wisdom.

Select one of the following:

  • True
  • False

Explanation

Question 2 of 49

1

2. Business intelligence (BI) architecture is composed of data, people, processes, technology, and the management of such components.

Select one of the following:

  • True
  • False

Explanation

Question 3 of 49

1

3. A data store is used by data analysts to create queries that access the database.

Select one of the following:

  • True
  • False

Explanation

Question 4 of 49

1

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

Select one of the following:

  • True
  • False

Explanation

Question 5 of 49

1

5. Operational data and decision support data serve the same purpose.

Select one of the following:

  • True
  • False

Explanation

Question 6 of 49

1

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

Select one of the following:

  • True
  • False

Explanation

Question 7 of 49

1

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

Select one of the following:

  • True
  • False

Explanation

Question 8 of 49

1

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

Select one of the following:

  • True
  • False

Explanation

Question 9 of 49

1

9. Relational data warehouses use multidimensional data schema support to handle multidimensional data.

Select one of the following:

  • True
  • False

Explanation

Question 10 of 49

1

10. The data warehouse development life cycle differs from classical systems development.

Select one of the following:

  • True
  • False

Explanation

Question 11 of 49

1

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

Select one of the following:

  • True
  • False

Explanation

Question 12 of 49

1

12. By default, the fact table’s primary key is always formed by combining the superkeys pointing to the
Dimension tables to which they are related.

Select one of the following:

  • True
  • False

Explanation

Question 13 of 49

1

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

Select one of the following:

  • True
  • False

Explanation

Question 14 of 49

1

14. 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.

Select one of the following:

  • True
  • False

Explanation

Question 15 of 49

1

15. Multidimensional data analysis techniques include advanced computational functions.

Select one of the following:

  • True
  • False

Explanation

Question 16 of 49

1

16. Advanced OLAP feature become more useful when access to them is kept simple.

Select one of the following:

  • True
  • False

Explanation

Question 17 of 49

1

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

Select one of the following:

  • True
  • False

Explanation

Question 18 of 49

1

18. A star schema is designed to optimize data query operations rather than data update operations.

Select one of the following:

  • True
  • False

Explanation

Question 19 of 49

1

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

Select one of the following:

  • True
  • False

Explanation

Question 20 of 49

1

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

Select one of the following:

  • True
  • False

Explanation

Question 21 of 49

1

21. The CUBE extension enable you to get a grand total for each column listed in the expression

Select one of the following:

  • True
  • False

Explanation

Question 22 of 49

1

22. A is optimized for decision support and is generally represented by a data warehouse or a data mart.

Select one of the following:

  • a. data store

  • b. ETL tool

  • c. data visualization

  • d. data analysis tool

Explanation

Question 23 of 49

1

23. are in charge of presenting data to the end user in a variety of ways.

Select one of the following:

  • a. Data stores

  • b. ETL tools

  • c. Data visualization tools

  • d. Data analysis tools

Explanation

Question 24 of 49

1

24. _____ provide a unified, single point of entry for information Distribution.

Select one of the following:

  • a. Decision support systems

  • b. Portals

  • c. Data warehouses

  • d. Dashboards

Explanation

Question 25 of 49

1

25. In business intelligence framework, data are captured from a production system and placed in the____ on a near real- time basis.

Select one of the following:

  • a. decision support system

  • b. portal

  • c. data warehouse

  • d. dashboard

Explanation

Question 26 of 49

1

26. Tools focus on the strategic and tactical use of information.

Select one of the following:

  • a. Business

  • b. Relational database management

  • c. Business intelligence

  • d. Networking

Explanation

Question 27 of 49

1

27. Which of the following is a personal analytics vendor for BI applications?

Select one of the following:

  • a. IBM

  • b. Kognitio

  • c. Netezza

  • d. MicroStrategy

Explanation

Question 28 of 49

1

28. From a data analyst’s point of view, decision support data differ from operational data in three main areas: time span, granularity, and .

Select one of the following:

  • a. usability

  • b. dimensionality

  • c. transaction processing

  • d. sparsity

Explanation

Question 29 of 49

1

29. Operational data are commonly stored in many tables, and the stored data represent information about a given
only.

Select one of the following:

  • a. transaction

  • b. database

  • c. table

  • d. concept

Explanation

Question 30 of 49

1

30. The schema must support complex (non-normalized) data representations.

Select one of the following:

  • a. snowflake

  • b. online analytical processing

  • c. decision support database

  • d. multidimensional database

Explanation

Question 31 of 49

1

31. Data implies that all business entities, data elements, data characteristics, and business metrics are described in the same way throughout the enterprise.

Select one of the following:

  • a. visualization

  • b. analytics

  • c. mining

  • d. integration

Explanation

Question 32 of 49

1

can serve as a test vehicle for companies exploring the potential benefits of data warehouses.

Select one of the following:

  • a. Data networks

  • b. Data marts

  • c. Data cubes

  • d. OLAPs

Explanation

Question 33 of 49

1

33. Bill Inmon and Chuck Kelley created a set of 12 rules to define a(n) .

Select one of the following:

  • a. data warehouse

  • b. multidimensional cube

  • c. OLAP tool

  • d. star schema

Explanation

Question 34 of 49

1

34. The basic star schema has four components: facts, , attributes, and attribute hierarchies.

Select one of the following:

  • a. keys

  • b. relationships

  • c. cubes

  • d. dimensions

Explanation

Question 35 of 49

1

35. Computed or derived facts, at run time, are sometimes called to differentiate them from stored facts.

Select one of the following:

  • a. schemas

  • b. attributes

  • c. metrics

  • d. dimensions

Explanation

Question 36 of 49

1

36. In a star schema, attributes are often used to search, filter, or classify .

Select one of the following:

  • a. tables

  • b. sales

  • c. facts

  • d. dimensions

Explanation

Question 37 of 49

1

37. The attribute hierarchy provides a top-down data organization that is used for two main purposes:_____ and
drill-down/roll-up data analysis.

Select one of the following:

  • a. decomposition

  • b. de-normalization

  • c. normalization

  • d. aggregation

Explanation

Question 38 of 49

1

38. In star schema representation, a fact table is related to each dimension table in a relationship.

Select one of the following:

  • a. many-to-one (M:1)

  • b. many-to-many (M:M)

  • c. one-to many (1:M)

  • d. one-to-one (1:1)

Explanation

Question 39 of 49

1

39. Fact and dimension tables are related by keys.

Select one of the following:

  • a. shared

  • b. primary

  • c. foreign

  • d. linked

Explanation

Question 40 of 49

1

40. In a typical star schema, each dimension record is related to thousands of records.

Select one of the following:

  • a. attribute

  • b. fact

  • c. key

  • d. primary

Explanation

Question 41 of 49

1

41. A schema is a type of star schema in which dimension tables can have their own dimension tables.

Select one of the following:

  • a. snowflake

  • b. starflake

  • c. dimension

  • d. matrix

Explanation

Question 42 of 49

1

42. _____ splits a table into subsets of rows or columns and places the subsets close to the client computer to improve data access time.

Select one of the following:

  • a. Normalization

  • b. Meta modeling

  • c. Replication

  • d. Partitioning

Explanation

Question 43 of 49

1

43. The reliance on as the design methodology for relational databases is seen as a stumbling block to its use in OLAP systems.

Select one of the following:

  • a. normalization

  • b. denormalization

  • c. star schema

  • d. multidimensional schema

Explanation

Question 44 of 49

1

44. Decision support data tend to be non-normalized, , and pre-aggregated.

Select one of the following:

  • a. unique

  • b. duplicated

  • c. optimized

  • d. sorted

Explanation

Question 45 of 49

1

45. extends SQL so that it can differentiate between access requirements for data warehouse data and operational data.

Select one of the following:

  • a. ROLAP

  • b. OLAP

  • c. DBMS

  • d. BI

Explanation

Question 46 of 49

1

46. A index is based on 0 and 1 bits to represent a given condition.

Select one of the following:

  • a. logical

  • b. multidimensional

  • c. normal

  • d. bitmapped

Explanation

Question 47 of 49

1

47. Conceptually, MDBMS end users visualize the stored data as a three-dimensional cube known as a .

Select one of the following:

  • a. multi-cube

  • b. database cube

  • c. data cube

  • d. hyper cube

Explanation

Question 48 of 49

1

48. A multidimensional database management systems (MDBMS) uses proprietary techniques to store data in
n-dimensional arrays

Select one of the following:

  • a. table-like

  • b. matrix-like

  • c. network-like

  • d. cube-like

Explanation

Question 49 of 49

1

49. A _____ is a dynamic table that not only contains the SQL query command to generate the rows, but also stores the actual rows.

Select one of the following:

  • a. SQL view

  • b. materialized view

  • c. star schema

  • d. data cube

Explanation

Previous
Next