This set of Hadoop Puzzles focuses on “IBM InfoSphere”.
1. The IBM _____________ Platform provides all the foundational building blocks of trusted information, including data integration, data warehousing, master data management, big data and information governance.
a) InfoStream
b) InfoSphere
c) InfoSurface
d) InfoData
View Answer
Explanation: InfoStream platform provides an enterprise-class foundation for information-intensive projects, providing the performance, scalability, reliability and acceleration needed to simplify difficult challenges and deliver trusted information to your business faster.
2. Point out the correct statement.
a) IBM InfoSphere DataStage is an ETL tool
b) IBM InfoSphere DataStage is a part of the IBM Information Platforms Solutions suite and IBM InfoSphere
c) InfoSphere uses a graphical notation to construct data integration solutions
d) All of the mentioned
View Answer
Explanation: InfoSphere DataStage is a powerful data integration tool.
3. InfoSphere DataStage has __________ levels of Parallelism.
a) 1
b) 2
c) 3
d) 4
View Answer
Explanation: InfoSphere DataStage also facilitates extended metadata management and enterprise connectivity.
4. InfoSphere DataStage uses a client/server design where jobs are created and administered via a ________ client against a central repository on a server.
a) Ubuntu
b) Windows
c) Debian
d) Solaris
View Answer
Explanation: The IBM InfoSphere DataStage is capable of integrating data on demand across multiple and high volumes of data sources and target applications using a high-performance parallel framework.
5. Point out the wrong statement.
a) InfoSphere DataStage also facilitates extended metadata management and enterprise connectivity
b) Real-Time Integration pack can turn server or parallel jobs into SOA services
c) In 2012 the suite was renamed to InfoSphere Information Server and the product was renamed to InfoSphere DataStage
d) None of the mentioned
View Answer
Explanation: In 2006 the product was released as part of the IBM Information Server under the Information Management family but was still known as WebSphere DataStage.
6. __________ is a name given to the version of DataStage that had a parallel processing architecture and parallel ETL jobs.
a) Enterprise Edition
b) Server Edition
c) MVS Edition
d) TX
View Answer
Explanation: DataStage 5 added Sequence Jobs and DataStage 6 added Parallel Jobs via Enterprise Edition.
7. ___________ is used for processing complex transactions and messages.
a) PX
b) Server Edition
c) MVS Edition
d) TX
View Answer
Explanation: MVS Edition developed on a Windows or Unix/Linux platform and transferred to the mainframe as compiled mainframe jobs.
8. InfoSphere ___________ provides you with the ability to flexibly meet your unique information integration requirements.
a) Data Server
b) Information Server
c) Info Server
d) All of the mentioned
View Answer
Explanation: IBM InfoSphere Information Server is a market-leading data integration platform which includes a family of products that enable you to understand, cleanse, monitor, transform, and deliver data.
9. DataStage originated at __________ a company that developed two notable products: UniVerse database and the DataStage ETL tool.
a) VMark
b) Vzen
c) Hatez
d) None of the mentioned
View Answer
Explanation: The first VMark ETL prototype was built by Lee Scheffler in the first half of 1996.
10. DataStage RTI is real time integration pack for __________
a) STD
b) ISD
c) EXD
d) None of the mentioned
View Answer
Explanation: ISD stands for Information Services Director.
Sanfoundry Global Education & Learning Series – Hadoop.
Here’s the list of Best Books in Hadoop.
- Check Hadoop Books
- Check Programming Books
- Practice Programming MCQs
- Apply for Computer Science Internship