Hadoop Questions and Answers – Sqoop with Hadoop – 1

This set of Hadoop Multiple Choice Questions & Answers (MCQs) focuses on “Sqoop with Hadoop – 1”.

1. Which of the following interface is implemented by Sqoop for recording?
a) SqoopWrite
b) SqoopRecord
c) SqoopRead
d) None of the mentioned
View Answer

Answer: b
Explanation: Class SqoopRecord is an interface implemented by the classes generated by sqoop orm.ClassWriter.

2. Point out the correct statement.
a) Interface FieldMapping is used for mapping of field
b) Interface FieldMappable is used for mapping of field
c) Sqoop is nothing but NoSQL to Hadoop
d) Sqoop internally uses ODBC interface so it should work with any JDBC compatible database
View Answer

Answer: b
Explanation: FieldMappable Interface describes a class capable of returning a map of the fields of the object to their values.

3. Sqoop is an open source tool written at ________
a) Cloudera
b) IBM
c) Microsoft
d) All of the mentioned
View Answer

Answer: c
Explanation: Sqoop allows users to import data from their relational databases into HDFS and vice versa.

4. Sqoop uses _________ to fetch data from RDBMS and stores that on HDFS.
a) Hive
b) Map reduce
c) Imphala
d) BigTOP
View Answer

Answer: b
Explanation: While fetching, it throttles the number of mappers accessing data on RDBMS to avoid DDoS.

advertisement

5. Point out the wrong statement.
a) Sqoop is used to import complete database
b) Sqoop is used to import selected columns from a particular table
c) Sqoop is used to import selected tables
d) All of the mentioned
View Answer

Answer: d
Explanation: Apache Sqoop is a tool which allows users to import data from relational databases to HDFS and export data from HDFS to relational database.

6. _________ allows users to specify the target location inside of Hadoop.
a) Imphala
b) Oozie
c) Sqoop
d) Hive
View Answer

Answer: c
Explanation: Sqoop is a connectivity tool for moving data from non-Hadoop data stores – such as relational databases and data warehouses – into Hadoop.

Free 30-Day C Certification Bootcamp is Live. Join Now!

7. Microsoft uses a Sqoop-based connector to help transfer data from _________ databases to Hadoop.
a) PostreSQL
b) SQL Server
c) Oracle
d) MySQL
View Answer

Answer: b
Explanation: Sqoop is a command-line interface application for transferring data between relational databases and Hadoop.

8. __________ provides a Couchbase Server-Hadoop connector by means of Sqoop.
a) MemCache
b) Couchbase
c) Hbase
d) All of the mentioned
View Answer

Answer: a
Explanation: Exports can be used to put data from Hadoop into a relational database.

9. Sqoop direct mode does not support imports of ______ columns.
a) BLOB
b) LONGVARBINARY
c) CLOB
d) All of the mentioned
View Answer

Answer: d
Explanation: Use JDBC-based imports for these columns; do not supply the –direct argument to the import tool.

10. Sqoop has been tested with Oracle ______ Express Edition.
a) 11.2.0
b) 10.2.0
c) 12.2.0
d) 10.3.0
View Answer

Answer: b
Explanation: Oracle is notable in its different approach to SQL from the ANSI standard and its non-standard JDBC driver. Therefore, several features work differently.

advertisement

Sanfoundry Global Education & Learning Series – Hadoop.

Here’s the list of Best Books in Hadoop.

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
I’m Manish - Founder and CTO at Sanfoundry. I’ve been working in tech for over 25 years, with deep focus on Linux kernel, SAN technologies, Advanced C, Full Stack and Scalable website designs.

You can connect with me on LinkedIn, watch my Youtube Masterclasses, or join my Telegram tech discussions.

If you’re in your 40s–60s and exploring new directions in your career, I also offer mentoring. Learn more here.