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
429
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

Module C4: Chemical Patterns
remandsonic
Speed, Distance, Time
Bradley Sansom
Study Schedule- this week (1)
Lavinia Hayde
OCR AS Biology
joshbrown3397
Atomic Structure
Jenni
National 5 Biology: Cell Biology
Mhairi McCann
Unit 1 flashcards
C R
GCSE Core Chemistry Yr 9
bronwyn831
med chem 2 final exam
lola_smily
Carbohydrates
Julia Romanów
Continents & Oceans
Thomas Yoachim
Browse Library