7222678
Pregunta 1
Pregunta
1.Implementing BI in an organization involves capturing not only business data (internal and external) but also the ____.
Respuesta
-
a.metadata
-
b.facts
-
c.information
-
d.rules
Pregunta 2
Pregunta
2.Analyzing decision support data to generate information is part of ____.
Respuesta
-
a.data warehousing
-
b.very large database systems
-
c.business intelligence
-
d.distributed processing
Pregunta 3
Pregunta
3.Data mining is part of the “____” section of the business intelligence framework.
Respuesta
-
a.Peopl
-
b.Management
-
c.Processes
-
d.Governance
Pregunta 4
Pregunta
4.A data mart is part of the “____” section of the business intelligence framework.
Respuesta
-
a.People
-
b.Management
-
c.Processes
-
d.Governance
Pregunta 5
Pregunta
5.____’s main goal is to provide a comprehensive and consistent definition of all data within an organization.
Respuesta
-
a.DBMS
-
b.OLAP
-
c.Data warehousing
-
d.MDM
Pregunta 6
Pregunta
6.The ____ contains business data extracted from the operational database and from external data sources.
Respuesta
-
a.data store
-
b.ETL tools
-
c.data visualization tool
-
d.data analysis tool
Pregunta 7
Pregunta
7.____ are in charge of presenting the 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 8
Pregunta
8.____provide a unified, single point of entry for information distribution.
Respuesta
-
a.Decision support systems
-
b.Portals
-
c.Data warehouses
-
d.Dashboards
Pregunta 9
Pregunta
9.Data is captured from the OLTP system and placed on the ____ on a near-real time basis.
Respuesta
-
a.decision support system
-
b.portal
-
c.data warehouse
-
d.dashboard
Pregunta 10
Pregunta
10.BusinessObjects is a(n) ____ tool
Respuesta
-
a.OLAP
-
b.data visualization
-
c.data mining
-
d.data warehouse
Pregunta 11
Pregunta
11.Had ____ been as pivotal to business operations a few years back, crises precipitated by the likes of Enron, WorldCom, and Arthur Andersen might have been avoided.
Respuesta
-
a.OLAP
-
b.data mining
-
c.governance
-
d.networking
Pregunta 12
Pregunta
12.____ systems provided no data extraction/integration process.
Respuesta
-
a.Third-generation Mobile BI and cloud-based
-
b.First-generation BI
-
c.First-generation departmental decision support
-
d.Traditional mainframe-based online transaction processing
Pregunta 13
Pregunta
13.From the 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 14
Pregunta
14.A characteristic of decision support data is ____.
Respuesta
-
a.high query activity
-
b.high update volumes
-
c.highly normalized
-
d.low aggregation level
Pregunta 15
Pregunta
15.A characteristic of operational data is ____.
Respuesta
-
a.summarized data
-
b.hundreds of gigabytes
-
c.high normalization
-
d.historic data
Pregunta 16
Pregunta
16.In 2008, Wal-Mart, the world’s largest company, had over four ____ of data in its data warehouses.
Respuesta
-
a.megabytes
-
b.gigabytes
-
c.terabytes
-
d.petabytes
Pregunta 17
Pregunta
17.Data ____ implies that all business entities, data elements, data characteristics, and business metrics are described in the same way throughout the enterprise.
Respuesta
-
a.volatility
-
b.time-variation
-
c.subject-orientation
-
d.integration
Pregunta 18
Pregunta
18.____ 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 19
Pregunta
19.There are 12 rules that define a(n) ____.
Respuesta
-
a.data warehouse
-
b.multidimensional cube
-
c.OLAP tool
-
d.star schema
Pregunta 20
Pregunta
20.The basic star schema has four components: facts, ____, attributes, and attribute hierarchies.
Respuesta
-
a.keys
-
b.relationships
-
c.cubes
-
d.dimensions
Pregunta 21
Pregunta
21.Computed or derived facts are sometimes called ____to differentiate them from stored facts.
Respuesta
-
a.details
-
b.attributes
-
c.metrics
-
d.fact tables
Pregunta 22
Pregunta
22.In a star schema, dimensions are normally stored in ____.
Respuesta
-
a.attributes
-
b.indexes
-
c.fact tables
-
d.dimension tables
Pregunta 23
Pregunta
23.In a star schema, attributes are often used to search, filter, or classify ____.
Respuesta
-
a.tables
-
b.stars
-
c.fact
-
d.dimensions
Pregunta 24
Pregunta
24.The ____ dimension of a data cube provides a framework from which sales patterns can be analyzed and possibly
predicted.
Respuesta
-
a.time
-
b.cube
-
c.third
-
d.multi
Pregunta 25
Pregunta
25.The attribute hierarchy provides a top-down data organization that is used for two main purposes: ____and drilldown/roll up data analysis
Respuesta
-
a.hierarchy
-
b.de-normalization
-
c.normalization
-
d.aggregation
Pregunta 26
Pregunta
26.Fact and dimension tables are related by ____ keys.
Respuesta
-
a.shared
-
b.primary
-
c.foreign
-
d.linked
Pregunta 27
Pregunta
27.In a typical star schema, each dimension record is related to thousands of ____ records.
Respuesta
-
a.attribute
-
b.fact
-
c.key
-
d.star
Pregunta 28
Pregunta
28.A ____ schema is a type of star schema in which the dimension tables can have their own dimension tables.
Respuesta
-
a.snowflake
-
b.starflake
-
c.mesh
-
d.matrix
Pregunta 29
Pregunta
29.____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 30
Pregunta
30.In a MOLAP system, the MOLAP ____ allows end users to interact with the MOLAP server and request data for analysis.
Respuesta
-
a.GUI
-
b.operational database
-
c.multidimensional database
-
d.data cube
Pregunta 31
Pregunta
31.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 32
Pregunta
32.Decision support data tend to be non-normalized, ____, and pre-aggregated.
Respuesta
-
a.unique
-
b.duplicated
-
c.relational
-
d.sorted
Pregunta 33
Pregunta
33.The ____ schema is designed to optimize data query operations rather than data update operations.
Respuesta
-
a.relational
-
b.circle
-
c.star
-
d.matrix
Pregunta 34
Pregunta
34.ROLAP extends ____ so that it can differentiate between access requirements for data warehouse data and operational data.
Respuesta
-
a.SQL
-
b.OLAP
-
c.DDS
-
d.BI
Pregunta 35
Pregunta
35.A ____ index is based on 0 and 1 bits to represent a given condition.
Respuesta
-
a.logical
-
b.multidimensional
-
c.star
-
d.bitmapped
Pregunta 36
Pregunta
36.Conceptually, MDBMS end users visualize the stored data as a three-dimensional cube known as a____.
Respuesta
-
a.multi cube
-
b.data matrix
-
c.data cube
-
d.hyper cube
Pregunta 37
Pregunta
37.A MOLAP system stores data in an MDBMS, using proprietary ____ and array technology to simulate the multidimensional cube.
Respuesta
-
a.table
-
b.matrix
-
c.network
-
d.cube
Pregunta 38
Pregunta
38.What is one of the main characteristics of OLAP systems?
Respuesta
-
a.They use single-dimensional data analysis techniques.
-
b.They provide complex command-line end-user interfaces.
-
c.They provide minimal database support.
-
d.They support client/server architecture.
Pregunta 39
Pregunta
39.What is a characteristic of ROLAP?
Respuesta
-
a.It uses the star schema
-
b.It does not require high resources.
-
c.It is limited to predefined dimensions.
-
d.It has low flexibility.
Pregunta 40
Pregunta
40.A(n) ____is a dynamic table that not only contains the SQL query command to generate the rows, but also stores the actual rows.
Respuesta
-
a.OLAP
-
b.materialized view
-
c.star schema
-
d.data cube
¿Quieres crear tus propios Tests gratis con GoConqr? Más información.