C192- OLAP/Datawarehousing UPDATED ACTUAL Questions and CORRECT Answers
3 vues 0 fois vendu
Cours
C192- OLAP/Datawarehousing
Établissement
C192- OLAP/Datawarehousing
C192- OLAP/Datawarehousing UPDATED
ACTUAL Questions and CORRECT
Answers
What are the high-level components that compose a DSS? - CORRECT ANSWER- data
store, data extraction and data filtering, end user query tool and end user presentation tool
The components of a data warehouse are _________...
C192- OLAP/Datawarehousing UPDATED
ACTUAL Questions and CORRECT
Answers
What are the high-level components that compose a DSS? - CORRECT ANSWER✔✔- data
store, data extraction and data filtering, end user query tool and end user presentation tool
The components of a data warehouse are __________. - CORRECT ANSWER✔✔-
integrated
Which of the following is a rule that defines the data warehouse? - CORRECT
ANSWER✔✔- data is subject-oriented
Which of the following is a characteristic of an OLAP? - CORRECT ANSWER✔✔-
supports client/server architecture
The DSS tools that use multidimensional data analysis techniques are known as online
___________ processing. - CORRECT ANSWER✔✔- analytical
A complete data warehouse ____ includes support for a DSS data store, a data extraction and
integration filter, and a specialized presentation interface. - CORRECT ANSWER✔✔-
architecture
____ data must conform to uniform structures and formats to avoid data conflicts. -
CORRECT ANSWER✔✔- data warehouse
Multidimensional data analysis refers to the processing of data such that data are viewed as
part of the _____ structure. - CORRECT ANSWER✔✔- multidimensional
Many of the OLAP interface features are "borrowed" from previous generations of data ____
tools. - CORRECT ANSWER✔✔- analysis
, Client/server ____ provides a framework within which new systems can be designed,
developed, and implemented. - CORRECT ANSWER✔✔- architecture
When the OLAP GUI runs on the client workstations, and the OLAP engine runs on a shared
computer, the _____ is more practical than running both on the same computer. - CORRECT
ANSWER✔✔- architecture
The end user GUI might be customer-made program or a plug-in module that is integrated
with Lotus 123, Microsoft Excel, or other third party data____ and query tools. - CORRECT
ANSWER✔✔- analysis
Multidimensional data analysis requires some type of multidimensional data representations,
which is normally provided by the ____ engine. - CORRECT ANSWER✔✔- OLAP.
What is OLAP? - CORRECT ANSWER✔✔- online analytical processing
What is MDA? - CORRECT ANSWER✔✔- multidimesional analytical
What does OLAP do? - CORRECT ANSWER✔✔- It is an approach to answer multi-
dimensional analytical (MDA) queries swiftly in computing. OLAP is part of the broader
category of business intelligence, which also encompasses relational databases, report writing
and data mining.
What is ROLAP? - CORRECT ANSWER✔✔- Relational online analytical processing
What does ROLAP do? - CORRECT ANSWER✔✔- It performs dynamic multidimensional
analysis of data stored in a relational database rather than in a multidimensional database
(which is usually considered the OLAP standard).
The datawarehouse and OLAP are two interrelated and complementary _____. - CORRECT
ANSWER✔✔- environments
Les avantages d'acheter des résumés chez Stuvia:
Qualité garantie par les avis des clients
Les clients de Stuvia ont évalués plus de 700 000 résumés. C'est comme ça que vous savez que vous achetez les meilleurs documents.
L’achat facile et rapide
Vous pouvez payer rapidement avec iDeal, carte de crédit ou Stuvia-crédit pour les résumés. Il n'y a pas d'adhésion nécessaire.
Focus sur l’essentiel
Vos camarades écrivent eux-mêmes les notes d’étude, c’est pourquoi les documents sont toujours fiables et à jour. Cela garantit que vous arrivez rapidement au coeur du matériel.
Foire aux questions
Qu'est-ce que j'obtiens en achetant ce document ?
Vous obtenez un PDF, disponible immédiatement après votre achat. Le document acheté est accessible à tout moment, n'importe où et indéfiniment via votre profil.
Garantie de remboursement : comment ça marche ?
Notre garantie de satisfaction garantit que vous trouverez toujours un document d'étude qui vous convient. Vous remplissez un formulaire et notre équipe du service client s'occupe du reste.
Auprès de qui est-ce que j'achète ce résumé ?
Stuvia est une place de marché. Alors, vous n'achetez donc pas ce document chez nous, mais auprès du vendeur MGRADES. Stuvia facilite les paiements au vendeur.
Est-ce que j'aurai un abonnement?
Non, vous n'achetez ce résumé que pour €9,28. Vous n'êtes lié à rien après votre achat.
