24018974
Descrição
Quiz por Craig Willey, atualizado more than 1 year ago
|
Criado por Craig Willey
mais de 4 anos atrás
|
|
Questão 1
Questão
Which of the following is a characteristic of an OLAP?
Responda
-
Uses single dimensional data analysis techniques
-
Provides introductory database support and complex end user interfaces
-
Provides introductory end-user interfaces
-
Supports client/server architecture
Questão 2
Questão
Many of the OLAP interface features are "borrowed" from previous generations of data ____ tools.
Responda
-
module
-
processing
-
filtering
-
analysis
Questão 3
Questão
____ is defined as an advanced data analysis environment that supports decision making, business modeling, and an operation’s researching activities.
Responda
-
VLAD
-
ROLAP
-
OLAP
-
DSS
Questão 4
Questão
The data warehouse and OLAP are two interrelated and complementary ____.
Responda
-
environments
-
programs
-
systems
-
warehouses
Questão 5
Questão
To provide better performance, some OLAP systems merge the data warehouse and data mart approaches by storing small extracts of the data warehouse at end user ____.
Responda
-
workstations
-
queries
-
schemas
-
servers
Questão 6
Questão
MOLAP extends OLAP functionality to multidimensional ____ management systems.
Responda
-
online
-
database
-
processing
-
data
Questão 7
Questão
The location of each data value in the data cube is a function of the x, y, and z axes in a ____ space.
Responda
-
one-dimensional
-
two-dimensional
-
three-dimensional
-
multidimensional
Questão 8
Questão
Data cubes are created by extracting data from the operational database or from the data ____.
Responda
-
base
-
management system
-
processing system
-
warehouse
Questão 9
Questão
Since the data cube is predefined with a set number of dimensions, the addition of a new dimension requires that the entire data cube be ____.
Responda
-
modified
-
updated
-
deleted
-
re-created
Questão 10
Questão
____ schemas yield an easily implemented model for multidimensional data analysis, while still preserving the relational structures on which the operational database is built.
Responda
-
Fact
-
Star
-
Dimensional
-
Operational
Questão 11
Questão
____ are qualifying characteristics that provide additional perspectives to a given fact.
Responda
-
Views
-
Attributes
-
Dimensions
-
Fact Tables
Questão 12
Questão
The ____ hierarchy provides a top-down data organization that is used for two main purposes: aggregation and drill-down/roll-up data analysis.
Responda
-
relational
-
dimensional
-
multidimensional
-
attribute
Questão 13
Questão
____ splits a table into subsets of rows or columns and places the subsets close to the client computer to improve data access time.
Responda
-
Partitioning
-
Replication
-
Aggregation
-
Denormalizing
Questão 14
Questão
____ makes a copy of a table and places it in a different location, to improve access time.
Responda
-
Periodicity
-
Aggregation
-
Partitioning
-
Replication
Questão 15
Questão
____ provides information about the timespan of the data stored in the table.
Responda
-
Periodicity
-
Partitioning
-
Replication
-
Aggregation
Questão 16
Questão
During the data ____ phase of data mining, the main data sets to be used by the data mining operation are identified and cleansed of any data impurities.
Responda
-
analysis
-
preparation
-
classification
-
acquisition
Questão 17
Questão
During the data ____ phase of data mining, common characteristics or patterns are identified.
Responda
-
analysis
-
preparation
-
extraction
-
acquisition
Questão 18
Questão
During the ____ phase of data mining, the data mining findings are used to predict future behavior and forecast business outcomes.
Responda
-
analysis and classification
-
preparation
-
prognosis
-
knowledge acquisition
Questão 19
Questão
The ____ schema creates the near equivalent of a multidimensional database schema from the existing relational database.
Responda
-
star
-
square
-
OLAP
-
ROLAP
Questão 20
Questão
Which of the following is NOT a basic component of a star schema?
Responda
-
Attribute hierarchy
-
Fact
-
Domain
-
Dimension
Questão 21
Questão
Using multidimensional jargon, the ability to focus on slices of the cube to perform a more detailed analysis is known as ____.
Responda
-
star cuts
-
slice and dice
-
microscoping
-
TPL processing
Questão 22
Questão
In contrast to the traditional DSS tools, data mining is ____.
Responda
-
proactive
-
protective
-
automatic
-
costly
Quer criar seus próprios Quizzes gratuitos com a GoConqr? Saiba mais.