This set of Hadoop Questions & Answers for online test focuses on “Sqoop with Hadoop”.
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
Explanation: Class SqoopRecord is 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
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
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
Explanation: While fetching , it throttles the number of mappers accessing data on RDBMS to avoid DDoS.
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
Explanation: Apache Sqoop is 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
Explanation: Sqoop is a connectivity tool for moving data from non-Hadoop data stores – such as relational databases and data warehouses – into Hadoop.
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
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
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
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
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.
Sanfoundry Global Education & Learning Series – Hadoop.
Here’s the list of Best Reference Books in Hadoop.
