Hadoop Questions and Answers – IBM InfoSphere

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

Answer: a
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

Answer: d
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

Answer: c
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

Answer: b
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.

advertisement
advertisement

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

Answer: c
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

Answer: a
Explanation: DataStage 5 added Sequence Jobs and DataStage 6 added Parallel Jobs via Enterprise Edition.

Note: Join free Sanfoundry classes at Telegram or Youtube

7. ___________ is used for processing complex transactions and messages.
a) PX
b) Server Edition
c) MVS Edition
d) TX
View Answer

Answer: d
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

Answer: b
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.

advertisement

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

Answer: a
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

Answer: b
Explanation: ISD stands for Information Services Director.

advertisement

Sanfoundry Global Education & Learning Series – Hadoop.

Here’s the list of Best Books in Hadoop.

To practice puzzles on all areas of Hadoop, here is complete set of 1000+ Multiple Choice Questions and Answers.

If you find a mistake in question / option / answer, kindly take a screenshot and email to [email protected]

advertisement
advertisement
Subscribe to our Newsletters (Subject-wise). Participate in the Sanfoundry Certification contest to get free Certificate of Merit. Join our social networks below and stay updated with latest contests, videos, internships and jobs!

Youtube | Telegram | LinkedIn | Instagram | Facebook | Twitter | Pinterest
Manish Bhojasia - Founder & CTO at Sanfoundry
Manish Bhojasia, a technology veteran with 20+ years @ Cisco & Wipro, is Founder and CTO at Sanfoundry. He lives in Bangalore, and focuses on development of Linux Kernel, SAN Technologies, Advanced C, Data Structures & Alogrithms. Stay connected with him at LinkedIn.

Subscribe to his free Masterclasses at Youtube & discussions at Telegram SanfoundryClasses.