Frage 1
Frage
1.Implementing BI in an organization involves capturing not only business data (internal and external) but also the ____.
Antworten
-
a.metadata
-
b.facts
-
c.information
-
d.rules
Frage 2
Frage
2.Analyzing decision support data to generate information is part of ____.
Frage 3
Frage
3.Data mining is part of the “____” section of the business intelligence framework.
Antworten
-
a.Peopl
-
b.Management
-
c.Processes
-
d.Governance
Frage 4
Frage
4.A data mart is part of the “____” section of the business intelligence framework.
Antworten
-
a.People
-
b.Management
-
c.Processes
-
d.Governance
Frage 5
Frage
5.____’s main goal is to provide a comprehensive and consistent definition of all data within an organization.
Antworten
-
a.DBMS
-
b.OLAP
-
c.Data warehousing
-
d.MDM
Frage 6
Frage
6.The ____ contains business data extracted from the operational database and from external data sources.
Frage 7
Frage
7.____ are in charge of presenting the data to the end user in a variety of ways.
Frage 8
Frage
8.____provide a unified, single point of entry for information distribution.
Frage 9
Frage
9.Data is captured from the OLTP system and placed on the ____ on a near-real time basis.
Frage 10
Frage
10.BusinessObjects is a(n) ____ tool
Antworten
-
a.OLAP
-
b.data visualization
-
c.data mining
-
d.data warehouse
Frage 11
Frage
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.
Antworten
-
a.OLAP
-
b.data mining
-
c.governance
-
d.networking
Frage 12
Frage
12.____ systems provided no data extraction/integration process.
Antworten
-
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
Frage 13
Frage
13.From the 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 14
Frage
14.A characteristic of decision support data is ____.
Antworten
-
a.high query activity
-
b.high update volumes
-
c.highly normalized
-
d.low aggregation level
Frage 15
Frage
15.A characteristic of operational data is ____.
Antworten
-
a.summarized data
-
b.hundreds of gigabytes
-
c.high normalization
-
d.historic data
Frage 16
Frage
16.In 2008, Wal-Mart, the world’s largest company, had over four ____ of data in its data warehouses.
Antworten
-
a.megabytes
-
b.gigabytes
-
c.terabytes
-
d.petabytes
Frage 17
Frage
17.Data ____ implies that all business entities, data elements, data characteristics, and business metrics are described in the same way throughout the enterprise.
Antworten
-
a.volatility
-
b.time-variation
-
c.subject-orientation
-
d.integration
Frage 18
Frage
18.____ 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 19
Frage
19.There are 12 rules that define a(n) ____.
Antworten
-
a.data warehouse
-
b.multidimensional cube
-
c.OLAP tool
-
d.star schema
Frage 20
Frage
20.The basic star schema has four components: facts, ____, attributes, and attribute hierarchies.
Antworten
-
a.keys
-
b.relationships
-
c.cubes
-
d.dimensions
Frage 21
Frage
21.Computed or derived facts are sometimes called ____to differentiate them from stored facts.
Antworten
-
a.details
-
b.attributes
-
c.metrics
-
d.fact tables
Frage 22
Frage
22.In a star schema, dimensions are normally stored in ____.
Antworten
-
a.attributes
-
b.indexes
-
c.fact tables
-
d.dimension tables
Frage 23
Frage
23.In a star schema, attributes are often used to search, filter, or classify ____.
Antworten
-
a.tables
-
b.stars
-
c.fact
-
d.dimensions
Frage 24
Frage
24.The ____ dimension of a data cube provides a framework from which sales patterns can be analyzed and possibly
predicted.
Antworten
-
a.time
-
b.cube
-
c.third
-
d.multi
Frage 25
Frage
25.The attribute hierarchy provides a top-down data organization that is used for two main purposes: ____and drilldown/roll up data analysis
Antworten
-
a.hierarchy
-
b.de-normalization
-
c.normalization
-
d.aggregation
Frage 26
Frage
26.Fact and dimension tables are related by ____ keys.
Antworten
-
a.shared
-
b.primary
-
c.foreign
-
d.linked
Frage 27
Frage
27.In a typical star schema, each dimension record is related to thousands of ____ records.
Antworten
-
a.attribute
-
b.fact
-
c.key
-
d.star
Frage 28
Frage
28.A ____ schema is a type of star schema in which the dimension tables can have their own dimension tables.
Antworten
-
a.snowflake
-
b.starflake
-
c.mesh
-
d.matrix
Frage 29
Frage
29.____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 30
Frage
30.In a MOLAP system, the MOLAP ____ allows end users to interact with the MOLAP server and request data for analysis.
Frage 31
Frage
31.The reliance on ____ as the design methodology for relational databases is seen as a stumbling block to its use in
OLAP systems.
Frage 32
Frage
32.Decision support data tend to be non-normalized, ____, and pre-aggregated.
Antworten
-
a.unique
-
b.duplicated
-
c.relational
-
d.sorted
Frage 33
Frage
33.The ____ schema is designed to optimize data query operations rather than data update operations.
Antworten
-
a.relational
-
b.circle
-
c.star
-
d.matrix
Frage 34
Frage
34.ROLAP extends ____ so that it can differentiate between access requirements for data warehouse data and operational data.
Frage 35
Frage
35.A ____ index is based on 0 and 1 bits to represent a given condition.
Antworten
-
a.logical
-
b.multidimensional
-
c.star
-
d.bitmapped
Frage 36
Frage
36.Conceptually, MDBMS end users visualize the stored data as a three-dimensional cube known as a____.
Antworten
-
a.multi cube
-
b.data matrix
-
c.data cube
-
d.hyper cube
Frage 37
Frage
37.A MOLAP system stores data in an MDBMS, using proprietary ____ and array technology to simulate the multidimensional cube.
Antworten
-
a.table
-
b.matrix
-
c.network
-
d.cube
Frage 38
Frage
38.What is one of the main characteristics of OLAP systems?
Antworten
-
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.
Frage 39
Frage
39.What is a characteristic of ROLAP?
Antworten
-
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.
Frage 40
Frage
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.
Antworten
-
a.OLAP
-
b.materialized view
-
c.star schema
-
d.data cube