MC	Ideally, data integration should include...	only processes.	incorrect	only data.	incorrect	both processes and data.	correct	
MC	Which statement is CORRECT?	An ETL process typically induces a certain measure of latency, so the timeliness dimension may suffer, with the data being slightly out of date.	correct	Enterprise Application Integration (EAI) and Enterprise Data Replication (EDR) are examples of data federation.	incorrect	SQL is well suited to query structured collections of records as well as unstructured data such as text.	incorrect	An important disadvantage of the consolidation approach is that it does not cater for historical data.	incorrect	
MC	Ideally, data integration should include...	only processes.	incorrect	both processes and data.	correct	only data.	incorrect	
MC	Which statement is NOT CORRECT?	The operational usage of business intelligence aims for a low (or even zero) latency so interesting events or trends in the data can be immediately detected and accompanied with the appropriate response.	incorrect	Nowadays, we see a complete divergence of the operational and tactical/strategic data needs and of the corresponding data integration tooling.	correct	Analytics for tactic/strategic decision making increasingly uses real-time operational data combined with the aggregated and historical data found in more traditional data warehouses.	incorrect	Analytics techniques are more and more used at the operational level as well by front-line employees.	incorrect	
MC	Ideally, data integration should include...	both processes and data.	correct	only data.	incorrect	only processes.	incorrect	
MC	Which statement is CORRECT?	Data virtualization extensively uses data consolidation techniques such as ETL.	incorrect	The focus of MDM is on unifying company-wide reference data types such as customers and products.	correct	Enterprise Information Integration (EII) is an example of data consolidation.	incorrect	Enterprise Application Integration (EAI) and Enterprise Data Replication (EDR) are examples of data virtualization.	incorrect	
MC	Which statement is NOT CORRECT?	Contrary to a federated database as offered by basic EII, data virtualization does not impose a single data model on top of the heterogeneous data sources.	incorrect	Data virtualization isolates applications and users from the actual (combinations of) data integration patterns used.	incorrect	Data virtualization extensively uses data consolidation techniques such as ETL.	correct	In many real-life contexts, a data integration exercise is an ongoing initiative within an organization, and will often combine a variety of integration strategies and approaches.	incorrect	
MC	Ideally, data integration should include...	only processes.	incorrect	only data.	incorrect	both processes and data.	correct	
MC	Which statement is NOT CORRECT?	The data flow perspective of a business process focusses on the inputs of the tasks (e.g., the interest rate offered depends on the credit score). 	incorrect	In a service oriented context, there is a tendency to physically integrate services with the purpose of task coordination with services that perform the actual task execution and services that provide access to the necessary data.	correct	The control flow perspective of a business process specifies the correct sequencing of tasks (e.g., a loan offer can only be made when the credit score has been calculated). 	incorrect	Process integration is to integrate and harmonize the various business processes in an organization as much as possible.	incorrect	
MC	Which statement is NOT CORRECT?	The essence of data consolidation as a data integration pattern is to capture the data from multiple, heterogeneous source systems and integrate it into a single persistent store (e.g., a data warehouse or data mart). 	incorrect	An important disadvantage of the consolidation approach is that it does not cater for historical data.	correct	An ETL process typically induces a certain measure of latency, so the timeliness dimension may suffer, with the data being slightly out of date.	incorrect	Besides the traditional set-up with ETL and a data warehouse, data lakes can also be considered an implementation of the consolidation pattern. 	incorrect