8457669
Descripción
Test por Miguel Lucero, actualizado hace más de 1 año
|
Creado por Miguel Lucero
hace más de 7 años
|
|
Pregunta 1
Pregunta
1. Business intelligence is a framework that allows a business to transform data into information, information into knowledge, and knowledge into wisdom.
Respuesta
- True
- False
Pregunta 2
Pregunta
2. Business intelligence (BI) architecture is composed of data, people, processes, technology, and the management of such components.
Respuesta
- True
- False
Pregunta 3
Pregunta
3. A data store is used by data analysts to create queries that access the database.
Respuesta
- True
- False
Pregunta 4
Pregunta
4. Master data management’s main goal is to provide a partial and segmented definition of all data within an organization
Respuesta
- True
- False
Pregunta 5
Pregunta
5. Operational data and decision support data serve the same purpose.
Respuesta
- True
- False
Pregunta 6
Pregunta
6. Decision support data are a snapshot of the operational data at a given point in time.
Respuesta
- True
- False
Pregunta 7
Pregunta
7. Queries against operational data typically are broad in scope and high in complexity.
Respuesta
- True
- False
Pregunta 8
Pregunta
8. Data warehouse data are organized and summarized by table, such as CUSTOMER and ADDRESS.
Respuesta
- True
- False
Pregunta 9
Pregunta
9. Relational data warehouses use multidimensional data schema support to handle multidimensional data.
Respuesta
- True
- False
Pregunta 10
Pregunta
10. The data warehouse development life cycle differs from classical systems development.
Respuesta
- True
- False
Pregunta 11
Pregunta
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.
Respuesta
- True
- False
Pregunta 12
Pregunta
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.
Respuesta
- True
- False
Pregunta 13
Pregunta
13. Normalizing fact tables improves data access performance and saves data storage space.
Respuesta
- True
- False
Pregunta 14
Pregunta
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.
Respuesta
- True
- False
Pregunta 15
Pregunta
15. Multidimensional data analysis techniques include advanced computational functions.
Respuesta
- True
- False
Pregunta 16
Pregunta
16. Advanced OLAP feature become more useful when access to them is kept simple.
Respuesta
- True
- False
Pregunta 17
Pregunta
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.
Respuesta
- True
- False
Pregunta 18
Pregunta
18. A star schema is designed to optimize data query operations rather than data update operations.
Respuesta
- True
- False
Pregunta 19
Pregunta
19. ROLAP and MOLAP vendors are working toward the integration of their respective solutions within a unified decision support framework.
Respuesta
- True
- False
Pregunta 20
Pregunta
20. The ROLLUP extension is used with the GROUP BY clause to generate aggregates by the listed columns, including the last one.
Respuesta
- True
- False
Pregunta 21
Pregunta
21. The CUBE extension enable you to get a grand total for each column listed in the expression
Respuesta
- True
- False
Pregunta 22
Pregunta
22. A is optimized for decision support and is generally represented by a data warehouse or a data mart.
Respuesta
-
a. data store
-
b. ETL tool
-
c. data visualization
-
d. data analysis tool
Pregunta 23
Pregunta
23. are in charge of presenting data to the end user in a variety of ways.
Respuesta
-
a. Data stores
-
b. ETL tools
-
c. Data visualization tools
-
d. Data analysis tools
Pregunta 24
Pregunta
24. _____ provide a unified, single point of entry for information Distribution.
Respuesta
-
a. Decision support systems
-
b. Portals
-
c. Data warehouses
-
d. Dashboards
Pregunta 25
Pregunta
25. In business intelligence framework, data are captured from a production system and placed in the____ on a near real- time basis.
Respuesta
-
a. decision support system
-
b. portal
-
c. data warehouse
-
d. dashboard
Pregunta 26
Pregunta
26. Tools focus on the strategic and tactical use of information.
Respuesta
-
a. Business
-
b. Relational database management
-
c. Business intelligence
-
d. Networking
Pregunta 27
Pregunta
27. Which of the following is a personal analytics vendor for BI applications?
Respuesta
-
a. IBM
-
b. Kognitio
-
c. Netezza
-
d. MicroStrategy
Pregunta 28
Pregunta
28. From a data analyst’s point of view, decision support data differ from operational data in three main areas: time span, granularity, and .
Respuesta
-
a. usability
-
b. dimensionality
-
c. transaction processing
-
d. sparsity
Pregunta 29
Pregunta
29. Operational data are commonly stored in many tables, and the stored data represent information about a given
only.
Respuesta
-
a. transaction
-
b. database
-
c. table
-
d. concept
Pregunta 30
Pregunta
30. The schema must support complex (non-normalized) data representations.
Respuesta
-
a. snowflake
-
b. online analytical processing
-
c. decision support database
-
d. multidimensional database
Pregunta 31
Pregunta
31. Data implies that all business entities, data elements, data characteristics, and business metrics are described in the same way throughout the enterprise.
Respuesta
-
a. visualization
-
b. analytics
-
c. mining
-
d. integration
Pregunta 32
Pregunta
can serve as a test vehicle for companies exploring the potential benefits of data warehouses.
Respuesta
-
a. Data networks
-
b. Data marts
-
c. Data cubes
-
d. OLAPs
Pregunta 33
Pregunta
33. Bill Inmon and Chuck Kelley created a set of 12 rules to define a(n) .
Respuesta
-
a. data warehouse
-
b. multidimensional cube
-
c. OLAP tool
-
d. star schema
Pregunta 34
Pregunta
34. The basic star schema has four components: facts, , attributes, and attribute hierarchies.
Respuesta
-
a. keys
-
b. relationships
-
c. cubes
-
d. dimensions
Pregunta 35
Pregunta
35. Computed or derived facts, at run time, are sometimes called to differentiate them from stored facts.
Respuesta
-
a. schemas
-
b. attributes
-
c. metrics
-
d. dimensions
Pregunta 36
Pregunta
36. In a star schema, attributes are often used to search, filter, or classify .
Respuesta
-
a. tables
-
b. sales
-
c. facts
-
d. dimensions
Pregunta 37
Pregunta
37. The attribute hierarchy provides a top-down data organization that is used for two main purposes:_____ and
drill-down/roll-up data analysis.
Respuesta
-
a. decomposition
-
b. de-normalization
-
c. normalization
-
d. aggregation
Pregunta 38
Pregunta
38. In star schema representation, a fact table is related to each dimension table in a relationship.
Respuesta
-
a. many-to-one (M:1)
-
b. many-to-many (M:M)
-
c. one-to many (1:M)
-
d. one-to-one (1:1)
Pregunta 39
Pregunta
39. Fact and dimension tables are related by keys.
Respuesta
-
a. shared
-
b. primary
-
c. foreign
-
d. linked
Pregunta 40
Pregunta
40. In a typical star schema, each dimension record is related to thousands of records.
Respuesta
-
a. attribute
-
b. fact
-
c. key
-
d. primary
Pregunta 41
Pregunta
41. A schema is a type of star schema in which dimension tables can have their own dimension tables.
Respuesta
-
a. snowflake
-
b. starflake
-
c. dimension
-
d. matrix
Pregunta 42
Pregunta
42. _____ splits a table into subsets of rows or columns and places the subsets close to the client computer to improve data access time.
Respuesta
-
a. Normalization
-
b. Meta modeling
-
c. Replication
-
d. Partitioning
Pregunta 43
Pregunta
43. The reliance on as the design methodology for relational databases is seen as a stumbling block to its use in OLAP systems.
Respuesta
-
a. normalization
-
b. denormalization
-
c. star schema
-
d. multidimensional schema
Pregunta 44
Pregunta
44. Decision support data tend to be non-normalized, , and pre-aggregated.
Respuesta
-
a. unique
-
b. duplicated
-
c. optimized
-
d. sorted
Pregunta 45
Pregunta
45. extends SQL so that it can differentiate between access requirements for data warehouse data and operational data.
Respuesta
-
a. ROLAP
-
b. OLAP
-
c. DBMS
-
d. BI
Pregunta 46
Pregunta
46. A index is based on 0 and 1 bits to represent a given condition.
Respuesta
-
a. logical
-
b. multidimensional
-
c. normal
-
d. bitmapped
Pregunta 47
Pregunta
47. Conceptually, MDBMS end users visualize the stored data as a three-dimensional cube known as a .
Respuesta
-
a. multi-cube
-
b. database cube
-
c. data cube
-
d. hyper cube
Pregunta 48
Pregunta
48. A multidimensional database management systems (MDBMS) uses proprietary techniques to store data in
n-dimensional arrays
Respuesta
-
a. table-like
-
b. matrix-like
-
c. network-like
-
d. cube-like
Pregunta 49
Pregunta
49. A _____ is a dynamic table that not only contains the SQL query command to generate the rows, but also stores the actual rows.
Respuesta
-
a. SQL view
-
b. materialized view
-
c. star schema
-
d. data cube
¿Quieres crear tus propios Tests gratis con GoConqr? Más información.