Copy and Edit

CHAPTER 13: BUSINESS INTELLIGENCE AND DATA WAREHOUSES

Description

CIS 3365 Quiz on CHAPTER 13: BUSINESS INTELLIGENCE AND DATA WAREHOUSES, created by Miguel Lucero on 06/04/2017.
Miguel Lucero
Quiz by Miguel Lucero, updated more than 1 year ago
Miguel Lucero
Created by Miguel Lucero over 7 years ago
504
2
0

Resource summary

Question 1

Question
1. Business intelligence is a framework that allows a business to transform data into information, information into knowledge, and knowledge into wisdom.
Answer
  • True
  • False

Question 2

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

Question 3

Question
3. A data store is used by data analysts to create queries that access the database.
Answer
  • True
  • False

Question 4

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

Question 5

Question
5. Operational data and decision support data serve the same purpose.
Answer
  • True
  • False

Question 6

Question
6. Decision support data are a snapshot of the operational data at a given point in time.
Answer
  • True
  • False

Question 7

Question
7. Queries against operational data typically are broad in scope and high in complexity.
Answer
  • True
  • False

Question 8

Question
8. Data warehouse data are organized and summarized by table, such as CUSTOMER and ADDRESS.
Answer
  • True
  • False

Question 9

Question
9. Relational data warehouses use multidimensional data schema support to handle multidimensional data.
Answer
  • True
  • False

Question 10

Question
10. The data warehouse development life cycle differs from classical systems development.
Answer
  • True
  • False

Question 11

Question
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.
Answer
  • True
  • False

Question 12

Question
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.
Answer
  • True
  • False

Question 13

Question
13. Normalizing fact tables improves data access performance and saves data storage space.
Answer
  • True
  • False

Question 14

Question
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.
Answer
  • True
  • False

Question 15

Question
15. Multidimensional data analysis techniques include advanced computational functions.
Answer
  • True
  • False

Question 16

Question
16. Advanced OLAP feature become more useful when access to them is kept simple.
Answer
  • True
  • False

Question 17

Question
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.
Answer
  • True
  • False

Question 18

Question
18. A star schema is designed to optimize data query operations rather than data update operations.
Answer
  • True
  • False

Question 19

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

Question 20

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

Question 21

Question
21. The CUBE extension enable you to get a grand total for each column listed in the expression
Answer
  • True
  • False

Question 22

Question
22. A is optimized for decision support and is generally represented by a data warehouse or a data mart.
Answer
  • a. data store
  • b. ETL tool
  • c. data visualization
  • d. data analysis tool

Question 23

Question
23. are in charge of presenting data to the end user in a variety of ways.
Answer
  • a. Data stores
  • b. ETL tools
  • c. Data visualization tools
  • d. Data analysis tools

Question 24

Question
24. _____ provide a unified, single point of entry for information Distribution.
Answer
  • a. Decision support systems
  • b. Portals
  • c. Data warehouses
  • d. Dashboards

Question 25

Question
25. In business intelligence framework, data are captured from a production system and placed in the____ on a near real- time basis.
Answer
  • a. decision support system
  • b. portal
  • c. data warehouse
  • d. dashboard

Question 26

Question
26. Tools focus on the strategic and tactical use of information.
Answer
  • a. Business
  • b. Relational database management
  • c. Business intelligence
  • d. Networking

Question 27

Question
27. Which of the following is a personal analytics vendor for BI applications?
Answer
  • a. IBM
  • b. Kognitio
  • c. Netezza
  • d. MicroStrategy

Question 28

Question
28. From a data analyst’s point of view, decision support data differ from operational data in three main areas: time span, granularity, and .
Answer
  • a. usability
  • b. dimensionality
  • c. transaction processing
  • d. sparsity

Question 29

Question
29. Operational data are commonly stored in many tables, and the stored data represent information about a given only.
Answer
  • a. transaction
  • b. database
  • c. table
  • d. concept

Question 30

Question
30. The schema must support complex (non-normalized) data representations.
Answer
  • a. snowflake
  • b. online analytical processing
  • c. decision support database
  • d. multidimensional database

Question 31

Question
31. Data implies that all business entities, data elements, data characteristics, and business metrics are described in the same way throughout the enterprise.
Answer
  • a. visualization
  • b. analytics
  • c. mining
  • d. integration

Question 32

Question
can serve as a test vehicle for companies exploring the potential benefits of data warehouses.
Answer
  • a. Data networks
  • b. Data marts
  • c. Data cubes
  • d. OLAPs

Question 33

Question
33. Bill Inmon and Chuck Kelley created a set of 12 rules to define a(n) .
Answer
  • a. data warehouse
  • b. multidimensional cube
  • c. OLAP tool
  • d. star schema

Question 34

Question
34. The basic star schema has four components: facts, , attributes, and attribute hierarchies.
Answer
  • a. keys
  • b. relationships
  • c. cubes
  • d. dimensions

Question 35

Question
35. Computed or derived facts, at run time, are sometimes called to differentiate them from stored facts.
Answer
  • a. schemas
  • b. attributes
  • c. metrics
  • d. dimensions

Question 36

Question
36. In a star schema, attributes are often used to search, filter, or classify .
Answer
  • a. tables
  • b. sales
  • c. facts
  • d. dimensions

Question 37

Question
37. The attribute hierarchy provides a top-down data organization that is used for two main purposes:_____ and drill-down/roll-up data analysis.
Answer
  • a. decomposition
  • b. de-normalization
  • c. normalization
  • d. aggregation

Question 38

Question
38. In star schema representation, a fact table is related to each dimension table in a relationship.
Answer
  • a. many-to-one (M:1)
  • b. many-to-many (M:M)
  • c. one-to many (1:M)
  • d. one-to-one (1:1)

Question 39

Question
39. Fact and dimension tables are related by keys.
Answer
  • a. shared
  • b. primary
  • c. foreign
  • d. linked

Question 40

Question
40. In a typical star schema, each dimension record is related to thousands of records.
Answer
  • a. attribute
  • b. fact
  • c. key
  • d. primary

Question 41

Question
41. A schema is a type of star schema in which dimension tables can have their own dimension tables.
Answer
  • a. snowflake
  • b. starflake
  • c. dimension
  • d. matrix

Question 42

Question
42. _____ splits a table into subsets of rows or columns and places the subsets close to the client computer to improve data access time.
Answer
  • a. Normalization
  • b. Meta modeling
  • c. Replication
  • d. Partitioning

Question 43

Question
43. The reliance on as the design methodology for relational databases is seen as a stumbling block to its use in OLAP systems.
Answer
  • a. normalization
  • b. denormalization
  • c. star schema
  • d. multidimensional schema

Question 44

Question
44. Decision support data tend to be non-normalized, , and pre-aggregated.
Answer
  • a. unique
  • b. duplicated
  • c. optimized
  • d. sorted

Question 45

Question
45. extends SQL so that it can differentiate between access requirements for data warehouse data and operational data.
Answer
  • a. ROLAP
  • b. OLAP
  • c. DBMS
  • d. BI

Question 46

Question
46. A index is based on 0 and 1 bits to represent a given condition.
Answer
  • a. logical
  • b. multidimensional
  • c. normal
  • d. bitmapped

Question 47

Question
47. Conceptually, MDBMS end users visualize the stored data as a three-dimensional cube known as a .
Answer
  • a. multi-cube
  • b. database cube
  • c. data cube
  • d. hyper cube

Question 48

Question
48. A multidimensional database management systems (MDBMS) uses proprietary techniques to store data in n-dimensional arrays
Answer
  • a. table-like
  • b. matrix-like
  • c. network-like
  • d. cube-like

Question 49

Question
49. A _____ is a dynamic table that not only contains the SQL query command to generate the rows, but also stores the actual rows.
Answer
  • a. SQL view
  • b. materialized view
  • c. star schema
  • d. data cube
Show full summary Hide full summary

Want to create your own Quizzes for free with GoConqr? Learn more.

Similar

Chemistry Facts
beth2384
Hitler's Rise to Power
hanalou
Science Additional B3 - Animal and Plant Cells Flashcards
Stirling v
Computer Systems
lisawinkler10
Conferences of the Cold War
Alina A
Plant Anatomy Quiz
Kit Sinclair
GCSE REVISION TIMETABLE
Sonia Christopher
C1 Quiz
Leah Firmstone
The Periodic Table
asramanathan
2PR101 1.test - 1. část
Nikola Truong
Browse Library