Practice Sqoop Interview Multiple Choice Questions with Answers Quiz-1

Q.1.

_________ tool can list all the available database schemas.

Explanation

Q.2.

Point out the correct statement.

a) The sqoop command-line program is a wrapper which runs the bin/hadoop script shipped with Hadoop
b) If $HADOOP_HOME is set, Sqoop will use the default installation location for Cloudera’s Distribution for Hadoop
c) The active Hadoop configuration is loaded from $HADOOP_HOME/conf/, unless the $HADOOP_CONF_DIR environment variable is unset
d) None of the mentioned

Explanation

Q.3.

Data can be imported in maximum ______ file formats.

Explanation

Q.4.

________ text is appropriate for most non-binary data types.

Explanation

Q.5.

Point out the wrong statement.

a) Avro data files are a compact, efficient binary format that provides interoperability with applications written in other programming languages
b) By default, data is compressed while importing
c) Delimited text also readily supports further manipulation by other tools, such as Hive
d) None of the mentioned

Explanation

Q.6.

If you set the inline LOB limit to ________ all large objects will be placed in external storage.

Explanation

Q.7.

________ does not support the notion of enclosing characters that may include field delimiters in the enclosed string.

Explanation

Q.8.

Sqoop can also import the data into Hive by generating and executing a ____________ statement to define the data’s layout in Hive.

Explanation

Q.9.

The __________ tool imports a set of tables from an RDBMS to HDFS.

Explanation

Q.10.

Which of the following argument is not supported by import-all-tables tool?

Explanation