Copiar e Editar

CHAPTER 13: BUSINESS INTELLIGENCE AND DATA WAREHOUSES

Descrição

CIS 3365 Quiz sobre CHAPTER 13: BUSINESS INTELLIGENCE AND DATA WAREHOUSES, criado por Miguel Lucero em 06-04-2017.
Miguel Lucero
Quiz por Miguel Lucero, atualizado more than 1 year ago
Miguel Lucero
Criado por Miguel Lucero mais de 7 anos atrás
504
2
0

Resumo de Recurso

Questão 1

Questão
1. Business intelligence is a framework that allows a business to transform data into information, information into knowledge, and knowledge into wisdom.
Responda
  • True
  • False

Questão 2

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

Questão 3

Questão
3. A data store is used by data analysts to create queries that access the database.
Responda
  • True
  • False

Questão 4

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

Questão 5

Questão
5. Operational data and decision support data serve the same purpose.
Responda
  • True
  • False

Questão 6

Questão
6. Decision support data are a snapshot of the operational data at a given point in time.
Responda
  • True
  • False

Questão 7

Questão
7. Queries against operational data typically are broad in scope and high in complexity.
Responda
  • True
  • False

Questão 8

Questão
8. Data warehouse data are organized and summarized by table, such as CUSTOMER and ADDRESS.
Responda
  • True
  • False

Questão 9

Questão
9. Relational data warehouses use multidimensional data schema support to handle multidimensional data.
Responda
  • True
  • False

Questão 10

Questão
10. The data warehouse development life cycle differs from classical systems development.
Responda
  • True
  • False

Questão 11

Questão
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.
Responda
  • True
  • False

Questão 12

Questão
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.
Responda
  • True
  • False

Questão 13

Questão
13. Normalizing fact tables improves data access performance and saves data storage space.
Responda
  • True
  • False

Questão 14

Questão
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.
Responda
  • True
  • False

Questão 15

Questão
15. Multidimensional data analysis techniques include advanced computational functions.
Responda
  • True
  • False

Questão 16

Questão
16. Advanced OLAP feature become more useful when access to them is kept simple.
Responda
  • True
  • False

Questão 17

Questão
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.
Responda
  • True
  • False

Questão 18

Questão
18. A star schema is designed to optimize data query operations rather than data update operations.
Responda
  • True
  • False

Questão 19

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

Questão 20

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

Questão 21

Questão
21. The CUBE extension enable you to get a grand total for each column listed in the expression
Responda
  • True
  • False

Questão 22

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

Questão 23

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

Questão 24

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

Questão 25

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

Questão 26

Questão
26. Tools focus on the strategic and tactical use of information.
Responda
  • a. Business
  • b. Relational database management
  • c. Business intelligence
  • d. Networking

Questão 27

Questão
27. Which of the following is a personal analytics vendor for BI applications?
Responda
  • a. IBM
  • b. Kognitio
  • c. Netezza
  • d. MicroStrategy

Questão 28

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

Questão 29

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

Questão 30

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

Questão 31

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

Questão 32

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

Questão 33

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

Questão 34

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

Questão 35

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

Questão 36

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

Questão 37

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

Questão 38

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

Questão 39

Questão
39. Fact and dimension tables are related by keys.
Responda
  • a. shared
  • b. primary
  • c. foreign
  • d. linked

Questão 40

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

Questão 41

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

Questão 42

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

Questão 43

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

Questão 44

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

Questão 45

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

Questão 46

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

Questão 47

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

Questão 48

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

Questão 49

Questão
49. A _____ is a dynamic table that not only contains the SQL query command to generate the rows, but also stores the actual rows.
Responda
  • a. SQL view
  • b. materialized view
  • c. star schema
  • d. data cube

Quer criar seus próprios Quizzes gratuitos com a GoConqr? Saiba mais.

Semelhante

Guia de Estudos para OAB 1a Fase
Alessandra S.
Plano de Estudos com Mapas Mentais
Alessandra S.
Mind Map
Marina Faria
Enem - o que estudar
Luiz Fernando
Sistema Reprodutor Masculino
Ana Inês Kruecck Quintas
Mapa Mental de GoConqr
GoConqr suporte .
Geografia - Cartografia
Jessica Caroline de Macedo
SIMULADÃO EA-HSG FATOS DA HISTÓRIA NAVAL PARTE 2
isac rodrigues
Brasil: Primeiro Reinado e Período Regencial
Professor Junior
MAPA MENTAL
luciano.silva
A Célula
Nathalia - GoConqr
Explore a Biblioteca