Data Integration and Interoperability Quiz Set

What is NOT a goal of Data Integration and Interoperability?

Provide data securely, with regulatory compliance, in the format and time frame needed
Identify meaningful events and automatically trigger alerts and actions
Support business intelligence, analytics, master data management, and operational efficiency efforts
Managing the availability of data throughout the data lifecycle
Lower cost and complexity of managing solutions by developing shared models and interfaces

In the transformation phase of an ETL process, which of these are possible transformations that can occur?

The structure of the data might change
The format of the data might change
Data elements might be reordered
Duplicated rows might be removed
All of the above

What is the key difference between an ETL job and ELT job?

When doing an ELT job, there is a need for a staging area while an ETL job does not
No difference exists
In an ELT job, transformation to the data occurs after the data has been loaded to the target system
ELT is used for analytics, whereas ETL is used for data warehousing
ELT is synonymous with batch processing while ETL is usually associated with real time processing

What is the difference between batch data processing and near-real-time data processing?

Data can be made to move more frequently in batches
There is no difference, they both integrate data
Near-real-time processing has a lower latency and system load than batch processing
Batch processing cannot be used for operational data
Batch processing has a lower latency and system load than near-real-time processing

Which method of data processing best suits the needs of capturing occurrences like a social media activities?

Batch
Streaming
Near-real-time
Micro batch
All of the above

Some data may be infrequently used, but still be data that your organisation is legally required to keep. What can be done to in a situation like this?

Move archive data using ETL to transport and transform the data to suit the data structure of a cheaper database
Have respective data owners decides which data in their domain can be removed regardless of regulations
Assign various employees from each department to be in charge of storing inactive data in their own storage devices
As long as the metadata is kept in a repository, the data itself can be deleted
Request permission from the regulators on a monthly basis to delete inactive data

Which of these options would be suitable for the role of data hub in a hub-and-spoke model?

Data Mart
MDM Hub
Operational Data Store
Data Warehouse
All of the above

What is NOT a function of an Enterprise Service Bus?

Support near real time data integration
Act as an intermediary passing messages between systems
Tightly coupling systems sending data with those receiving data
Continuously “polling” applications connected, looking for new data they're subscribed to
Allow data integration solutions to execute more frequently than batch processing otherwise allows

Which of these are benefits of the Service Oriented Architecture(SOA) approach to data integration?

SOA allows for well defined interaction between self contained software modules
With an SOA design, organisations can change systems without much impact to other systems that interfaces with it
With SOA, applications are independent and do not directly interact with or hold knowledge the about inner workings of other applications
The functionality of providing data or updating data can be provided through well-defined service calls between applications
All of the above

Which of these best describes Cloud-based integration or integration platform-as-a-service or IPaaS?

Integration requirements are serviced through an on-premises middleware platform, and typically use a service bus (ESB)
Usually these are SaaS applications in the data centres of vendors and not the organisations that own the data being integrated
Integration requirements are serviced through EDI (electronic data interchange) gateways or value-added networks (VAN) or market places
SaaS does not deal with cloud computing and is often done on premise while IPaas is solely based on cloud computing
None of the above

When embarking on a Data Integration process, the first set of activities is to plan and analyse. Which of these activities are NOT part of the planning and analysing stage?

Define data integration and lifecycle requirements
Perform Data discovery
Perform data profiling
Documenting data lineages
Develop data flow orchestration

Which of these is NOT a way business rules are used to support Data Integration and Interoperability?

Monitor operational data
Direct the flow of data
Ensure the Data Stewards are engaged in the process
Assess data in potential source and target data sets
Direct when to trigger events and alerts in an automatic fashion

When performing source to target mapping with a data integration solution, mapping specifications help to:

Specify transformations required for all intermediate staging points between source and target
Describe what calculations are required
Indicate the technical format of the source and target
Describe how each attribute in a final or intermediate target data store will be populated
All of the above

Data Migration projects often happen when legacy systems are retired in favour of newer, better systems. Which of the following is NOT true about Data Migration?

Most application development projects require some form of data migration
Data migration projects tend to be over staffed due to perceived complexity of the project
Data migration is not a one time process and require multiple testing before actual implementation
Often data being migrated from legacy to new applications do not look the same and profiling of the applications tend to show generations of data that do not meet current standards
Data migration involves transforming of data from a current format to a more suitable format that is applicable to the receiving system

Which of these tools would be least useful for a Data Integration project?

ETL tool
Enterprise service bus
Data profiling tool
Data process and modelling tool
Graphical design applications

Which of these is NOT a factor you should consider when implementing a Data Integration tool?

Ensuring that business and application experts are involved in the process and not only the IT team
Sponsorship of a data integration tool should come from parties that are sufficiently senior to prevent vendors and technology teams from choosing to locally implement their preferred tool
Readiness assessment should be around enabling enterprise integration or promoting interoperability
Data Integration is one area where the technology matters more than the business requirements, meaning the projects require less business input
Integration should be focused on area where no or limited integration exists instead of trying to improve or rework existing integration tools

What is a data sharing agreement?

A formal agreement that stipulates the appropriate use of data and details how and what data is allowed to be exchanged, accessed, shared and restricted
A set of guidelines and rules that provides the framework for data governance throughout the enterprise
A type of data protection policy specific to organisations that sell data
A formal agreement that shares the risk of regulatory penalties between companies sharing data
An agreement that details how long data can be shared externally outside the organisation

Which of these metrics measures the benefits of implementing a data integration solution?

Number of business terms defined
Latency of hard disk read/write
Speed of harvesting metadata
Volume of data transported and transformed
All of the above

What is Data Interoperability?

A technical term for data integration
The ability to share data with regulators more easily
The ability for multiple systems to communicate
The ability to ensure only clean data is loaded into the Data Lake
All of the above

How does Data Integration and Interoperability depend on Data Governance?

For designing solutions
For governing the transformation rules and message structures
For tracking the technical inventory of data
For designing data structures
For ensuring solutions protect the security of data

In an ETL process, Lookups and Mappings are part of which step?

Extract
Transform
Load
Map
Reduce

Get CDMP Certified, Fast. The quickest route to certification and the only one that's guaranteed.

Data Integration and Interoperability Quiz Set

Neil Burge

Quiz Summary

Information

Results

Results

Categories

1. Question

2. Question

3. Question

4. Question

5. Question

6. Question

7. Question

8. Question

9. Question

10. Question

11. Question

12. Question

13. Question

14. Question

15. Question

16. Question

17. Question

18. Question

19. Question

20. Question

21. Question

Get CDMP certified, FAST. Click here for guaranteed results.

Would you like to get

FREE LESSONS?