Hadoop Questions and Answers – Sqoop with Hadoop – 1

This set of Hadoop Questions & Answers for online test 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
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.

Sanfoundry Certification Contest of the Month is Live. 100+ Subjects. Participate 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.

advertisement

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.

To practice all areas of Hadoop for online test, 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.