Apache Sqoop is a tool used to move the data in bulk size between Apache Hadoop and structured datastores such as relational databases. get yourself help with Apache Sqoop Interview Questions and Answers that may help you to crack your next interview. Good Luck!
Question#1 Data can be imported in maximum __ file formats.
1.1
2.2
3.3
4.All of the mentioned
Correct Answer- 2
Question#2 Which of the following interface is implemented by Sqoop for recording?
1.SqoopWrite
2.SqoopRecord
3.SqoopRead
4.None of the above
Correct Answer- SqoopRecord
Question#3 _ tool can list all the available database schemas.
1.sqoop-list-tables
2.sqoop-list-databases
3.sqoop-list-schema
4.sqoop-list-columns
Correct Answer- sqoop-list-databases
Question#4 Sqoop is an open source tool written at __.
1.Cloudera
2.IBM
3.Microsoft
4.All of above
Correct Answer- Microsoft
Question#5 Point out the correct statement.
1.The sqoop command-line program is a wrapper which runs the bin/hadoop script shipped with Hadoop
2.If $HADOOP_HOME is set, Sqoop will use the default installation location for Cloudera’s Distribution for Hadoop
3.The active Hadoop configuration is loaded from $HADOOP_HOME/conf/, unless the $HADOOP_CONF_DIR environment variable is unset
4.None of the mentioned
Correct Answer- The sqoop command-line program is a wrapper which runs the bin/hadoop script shipped with Hadoop
Question#6 Sqoop uses __ to fetch data from RDBMS and stores that on HDFS.
1.Hive
2.Map reduce
3.Imphala
4.BigTOP
Correct Answer- Map reduce
Question#7 __ text is appropriate for most non-binary data types.
1.Character
2.Binary
3.Delimited
4.None of the mentioned
Correct Answer- Delimited
Question#8 __ allows users to specify the target location inside of Hadoop.
1.Imphala
2.Oozie
3.Sqoop
4.Hive
Correct Answer- Sqoop
Question#9 If you set the inline LOB limit to __ all large objects will be placed in external storage.
1.0
2.1
3.2
4.3
Correct Answer- 0
Question#10 Point out the wrong statement.
1.Avro data files are a compact, efficient binary format that provides interoperability with applications written in other programming languages
2.By default, data is compressed while importing
3.Delimited text also readily supports further manipulation by other tools, such as Hive
4.None of the mentioned
Correct Answer- By default, data is compressed while importing
Question#11 Microsoft uses a Sqoop-based connector to help transfer data from _ databases to Hadoop.
1.PostreSQL
2.SQL Server
3.Oracle
4.MySQL
Correct Answer- SQL Server
Question#12 __ does not support the notion of enclosing characters that may include field delimiters in the enclosed string.
1.Imphala
2.Oozie
3.Sqoop
4.Hive
Correct Answer- Hive
Question#13 Sqoop can also import the data into Hive by generating and executing a __ statement to define the data’s layout in Hive.
1.SET TABLE
2.CREATE TABLE
3.INSERT TABLE
4.All of the mentioned
Correct Answer- CREATE TABLE
Question#14 _ provides a couchbase server-hadoop connector by means of sqoop.
1.MemCache
2.Couchbase
3.Hbase
4.All of above
Correct Answer- MemCache
Question#15 The __ tool imports a set of tables from an RDBMS to HDFS.
1.export-all-tables
2.import-all-tables
3.import-tables
4.none of the mentioned
Correct Answer- import-tables
Question#16 Sqoop direct mode does not support imports of __ columns.
1.BLOB
2.LONGVARBINARY
3.CLOB
4.All of above
Correct Answer- All of above
Question#17 Which of the following argument is not supported by import-all-tables tool?
1.–class-name
2.–package-name
3.–database-name
4.–table-name
Correct Answer- –class-name
Question#18 Sqoop has been tested with Oracle _ Express Edition.
1.11.2.0
2.10.2.0
3.12.2.0
4.10.3.0
Correct Answer- 10.2.0
