Engineering Questions with Answers - Multiple Choice Questions
MCQs on Sqoop with Hadoop – 1
1 - Question
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.
Explanation: Class SqoopRecord is an interface implemented by the classes generated by sqoop orm.ClassWriter.
2 - Question
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 - Question
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.
Explanation: Sqoop allows users to import data from their relational databases into HDFS and vice versa.
4 - Question
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.
Explanation: While fetching, it throttles the number of mappers accessing data on RDBMS to avoid DDoS.
5 - Question
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 - Question
_________ 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.
7 - Question
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.
Explanation: Sqoop is a command-line interface application for transferring data between relational databases and Hadoop.
8 - Question
__________ 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 - Question
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 - Question
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.