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