24018974
Descripción
Test por Craig Willey, actualizado hace más de 1 año
|
Creado por Craig Willey
hace más de 4 años
|
|
Pregunta 1
Pregunta
Which of the following is a characteristic of an OLAP?
Respuesta
-
Uses single dimensional data analysis techniques
-
Provides introductory database support and complex end user interfaces
-
Provides introductory end-user interfaces
-
Supports client/server architecture
Pregunta 2
Pregunta
Many of the OLAP interface features are "borrowed" from previous generations of data ____ tools.
Respuesta
-
module
-
processing
-
filtering
-
analysis
Pregunta 3
Pregunta
____ is defined as an advanced data analysis environment that supports decision making, business modeling, and an operation’s researching activities.
Respuesta
-
VLAD
-
ROLAP
-
OLAP
-
DSS
Pregunta 4
Pregunta
The data warehouse and OLAP are two interrelated and complementary ____.
Respuesta
-
environments
-
programs
-
systems
-
warehouses
Pregunta 5
Pregunta
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 ____.
Respuesta
-
workstations
-
queries
-
schemas
-
servers
Pregunta 6
Pregunta
MOLAP extends OLAP functionality to multidimensional ____ management systems.
Respuesta
-
online
-
database
-
processing
-
data
Pregunta 7
Pregunta
The location of each data value in the data cube is a function of the x, y, and z axes in a ____ space.
Respuesta
-
one-dimensional
-
two-dimensional
-
three-dimensional
-
multidimensional
Pregunta 8
Pregunta
Data cubes are created by extracting data from the operational database or from the data ____.
Respuesta
-
base
-
management system
-
processing system
-
warehouse
Pregunta 9
Pregunta
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 ____.
Respuesta
-
modified
-
updated
-
deleted
-
re-created
Pregunta 10
Pregunta
____ schemas yield an easily implemented model for multidimensional data analysis, while still preserving the relational structures on which the operational database is built.
Respuesta
-
Fact
-
Star
-
Dimensional
-
Operational
Pregunta 11
Pregunta
____ are qualifying characteristics that provide additional perspectives to a given fact.
Respuesta
-
Views
-
Attributes
-
Dimensions
-
Fact Tables
Pregunta 12
Pregunta
The ____ hierarchy provides a top-down data organization that is used for two main purposes: aggregation and drill-down/roll-up data analysis.
Respuesta
-
relational
-
dimensional
-
multidimensional
-
attribute
Pregunta 13
Pregunta
____ splits a table into subsets of rows or columns and places the subsets close to the client computer to improve data access time.
Respuesta
-
Partitioning
-
Replication
-
Aggregation
-
Denormalizing
Pregunta 14
Pregunta
____ makes a copy of a table and places it in a different location, to improve access time.
Respuesta
-
Periodicity
-
Aggregation
-
Partitioning
-
Replication
Pregunta 15
Pregunta
____ provides information about the timespan of the data stored in the table.
Respuesta
-
Periodicity
-
Partitioning
-
Replication
-
Aggregation
Pregunta 16
Pregunta
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.
Respuesta
-
analysis
-
preparation
-
classification
-
acquisition
Pregunta 17
Pregunta
During the data ____ phase of data mining, common characteristics or patterns are identified.
Respuesta
-
analysis
-
preparation
-
extraction
-
acquisition
Pregunta 18
Pregunta
During the ____ phase of data mining, the data mining findings are used to predict future behavior and forecast business outcomes.
Respuesta
-
analysis and classification
-
preparation
-
prognosis
-
knowledge acquisition
Pregunta 19
Pregunta
The ____ schema creates the near equivalent of a multidimensional database schema from the existing relational database.
Respuesta
-
star
-
square
-
OLAP
-
ROLAP
Pregunta 20
Pregunta
Which of the following is NOT a basic component of a star schema?
Respuesta
-
Attribute hierarchy
-
Fact
-
Domain
-
Dimension
Pregunta 21
Pregunta
Using multidimensional jargon, the ability to focus on slices of the cube to perform a more detailed analysis is known as ____.
Respuesta
-
star cuts
-
slice and dice
-
microscoping
-
TPL processing
Pregunta 22
Pregunta
In contrast to the traditional DSS tools, data mining is ____.
Respuesta
-
proactive
-
protective
-
automatic
-
costly
¿Quieres crear tus propios Tests gratis con GoConqr? Más información.