Kopieren und bearbeiten

CHAPTER 13: BUSINESS INTELLIGENCE AND DATA WAREHOUSES

Beschreibung

CIS 3365 Quiz am CHAPTER 13: BUSINESS INTELLIGENCE AND DATA WAREHOUSES, erstellt von Miguel Lucero am 06/04/2017.
Miguel Lucero
Quiz von Miguel Lucero, aktualisiert more than 1 year ago
Miguel Lucero
Erstellt von Miguel Lucero vor mehr als 7 Jahre
504
2
0

Zusammenfassung der Ressource

Frage 1

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

Frage 2

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

Frage 3

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

Frage 4

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

Frage 5

Frage
5. Operational data and decision support data serve the same purpose.
Antworten
  • True
  • False

Frage 6

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

Frage 7

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

Frage 8

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

Frage 9

Frage
9. Relational data warehouses use multidimensional data schema support to handle multidimensional data.
Antworten
  • True
  • False

Frage 10

Frage
10. The data warehouse development life cycle differs from classical systems development.
Antworten
  • True
  • False

Frage 11

Frage
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.
Antworten
  • True
  • False

Frage 12

Frage
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.
Antworten
  • True
  • False

Frage 13

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

Frage 14

Frage
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.
Antworten
  • True
  • False

Frage 15

Frage
15. Multidimensional data analysis techniques include advanced computational functions.
Antworten
  • True
  • False

Frage 16

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

Frage 17

Frage
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.
Antworten
  • True
  • False

Frage 18

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

Frage 19

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

Frage 20

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

Frage 21

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

Frage 22

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

Frage 23

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

Frage 24

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

Frage 25

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

Frage 26

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

Frage 27

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

Frage 28

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

Frage 29

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

Frage 30

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

Frage 31

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

Frage 32

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

Frage 33

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

Frage 34

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

Frage 35

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

Frage 36

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

Frage 37

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

Frage 38

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

Frage 39

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

Frage 40

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

Frage 41

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

Frage 42

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

Frage 43

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

Frage 44

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

Frage 45

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

Frage 46

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

Frage 47

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

Frage 48

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

Frage 49

Frage
49. A _____ is a dynamic table that not only contains the SQL query command to generate the rows, but also stores the actual rows.
Antworten
  • a. SQL view
  • b. materialized view
  • c. star schema
  • d. data cube
Zusammenfassung anzeigen Zusammenfassung ausblenden

Möchten Sie mit GoConqr kostenlos Ihre eigenen Quiz erstellen? eigenen Mehr erfahren.

ähnlicher Inhalt

Einkaufsmarketing (Instrumente)
Budd9r
Kleines Biologie-Quiz
AntonS
Stoffwechsel/Energieumsatz
Anja Buster
Epochen und Literaturströmungen für das Abitur 2015
barbara91
A2 Konjunktiv Präteritum (hätte / wäre)
Anna Kania
Gute Gewohnheiten erfolgreicher Schüler
Laura Overhoff
Fend - 4 Funktionen von Schule
Josephine .
Forschungs- und Anwendungsfelder der Soziologie Teil 2
stelly Welly
Vetie Radiologie 2017
Péroline de Gail
Repro 2017 Vetie
Kim Langner
Vetie - Fleisch- und Geflügelfleischhygiene 2017
Birte Schulz
Bibliothek durchsuchen