Data Integration/Quiz/Multiple Choice Questions:

Data integration
MCQ: Integration of
data

Quiz 1 o
Lesson: Integration of
data

Quiz oflevel 17.

Previous Quiz:Summary

In order to verify that you have understood the lesson on data integration, please answer this multiple choice questionnaire and
test your knowledge!

You can always proofread yourself if you have a doubt!

Please refer to the course on thehistory and prefacethe main integration approaches
of dataas well as theconsolidation

Point added for a correct answer: 1

Point deducted for an incorrect answer: 0
Ignore the coefficients of the questions:

1 What is the added value of BI?

Permanent control of internal management, inventory management and the possibility

to anticipate and predict the trends and habits of consumers.
Allow the consolidation of a large volume of data.
Organize data uniformly.

2 What is the purpose of a data warehouse?

 Facilitate decision-making in business.
Make a precise analysis.
Develop a VBA language.

3 What is the main objective of data integration?

In the long run, for the data to be usable in a uniform manner as if they
constituted a single database thus allowing an analysis of the existing.
Ultimately, the data should be duplicable through the Cloud.
Ultimately, that the data be controlled only by the administrator.

4 What is a data warehouse?

A computer server in which data from different sources is consolidated.

A tray in which data sheets are placed.
A physical warehouse containing all the data from the IT sectors.

5 Quels sont les synonymes d’ " entrepôt de données " ? (Plusieurs réponses possibles)

Decision-making databases
Data coming
Data Warehouse
Data Mining

6 Find the correct designation of ETL

Exchange – transmit – Legal

Exchange - Transmit - Load
Extract – Transform – Load

7 Answer the following statements with True or False

TRUE FALSE
Google Refine is a standardization tool
Consolidation allows for the construction of several databases.
Mr. Data converter is the name of the creator of Oracle.
SQL language is the most used in databases

8 I am a software program that allows you to modify and manage the data of a database. I am: (In
Maj)
 A G-System of B- of D-

9 Which software does not come from BI?

SAP
Oracle
Excel

10 Which of the following pieces of information are correct?

TRUE FALSE
The Data Warehouse relies on the principle of information traceability.
Excel has a limitation on the data size that amounts to 1,000,000.
data
The standardization phase is preceded by consolidation.

11 What is the purpose of data integration? (Multiple answers possible)

Allow to standardize the data and thus enable the data to "speak" to each other.
they
Answering the questions of decision-makers
Extract data from a database

12 Data integration is a component of

Quantum computing
Business Intelligence
Virtual computing
The motherboard

13 For what volume of data is the ETL integrator used?

A large volume of data

An average volume of data
A small volume of data

14 CITEZ DEUX EXEMPLES DE PRODUITS COMMERCE POUR L'INTÉGRATEUR EII ?

 - BusinessObjects Data Federator.

- WebSphere Federation Server.

15 WHAT ARE THE THREE OPERATIONS FOR THE ETL INTEGRATOR?

- Identify and extract data from sources that have undergone a

modification since the last execution

- Apply various transformations to the data to

clean, integrate and aggregate

- Insert the transformed data into the warehouse and manage the

changes to existing data (e.g., SCD strategies)

16 When did data centers appear?

In the 1970s
In the 1980s
In the early 1990s
In the late 1990s

17 For what volume of data is the EII integrator used?

A large volume of data

An average volume of data
A small volume of data

18 Number each of the following steps.

Database

Data integration

Data analysis

Data extraction
 19 WHAT ARE THE MAIN INTEGRATION APPROACHES?

1- I am 'Extract, Transform and Load'

2- I am "Enterprise Information Integration"

3- I am 'Enterprise Application Integration'

20 WHAT ARE THE TWO CONSOLIDATION METHODS IN EXCEL?

1 - By

(For this method, it is necessary that the data from the different sheets and/or
the classes would be arranged in the same way
with the same row and/or column labels.

2 - By

(For this method, it is necessary that the data from the different sheets and/or
classes are not arranged in the same way
but they have the same line and/or column labels.

21 What does the term BI mean?

Business Intelligence
Build Intelligent
International Base
Base Computer

Submit

Retrieved from "[Link]

Data Integration/Quiz/QCM: Data Integration»

The last modification of this page was made on September 16, 2018 at 21:24.

The texts are available underCreative Commons Attribution-ShareAlike License;

other conditions may apply. See [Link] of usefor more details.