Q.1 Data can be imported in maximum ______ file formats.
A. 1
B. 2
C. 3
D. All of the mentioned
Ans : 2
Q.2 Which of the following interface is implemented by Sqoop for recording?
A. SqoopWrite
B. SqoopRecord
C. SqoopRead
D. None of the above
Ans : SqoopRecord
Q.3 _________ tool can list all the available database schemas.
A. sqoop-list-tables
B. sqoop-list-databases
C. sqoop-list-schema
D. sqoop-list-columns
Ans : sqoop-list-databases
Q.4 Sqoop is an open source tool written at ______.
A. Cloudera
B. IBM
C. Microsoft
D. All of above
Ans : Microsoft
Q.5 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
Ans : The sqoop command-line program is a wrapper which runs the bin/hadoop script shipped with Hadoop
Q.6 Sqoop uses ________ to fetch data from RDBMS and stores that on HDFS.
A. Hive
B. Map reduce
C. Imphala
D. BigTOP
Ans : Map reduce
Q.7 ________ text is appropriate for most non-binary data types.
A. Character
B. Binary
C. Delimited
D. None of the mentioned
Ans : Delimited
Q.8 ________ allows users to specify the target location inside of Hadoop.
A. Imphala
B. Oozie
C. Sqoop
D. Hive
Ans : Sqoop
Q.9 If you set the inline LOB limit to ________ all large objects will be placed in external storage.
A. 0
B. 1
C. 2
D. 3
Ans : 0
Q.10 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
Ans : By default, data is compressed while importing
Q.11 Microsoft uses a Sqoop-based connector to help transfer data from _________ databases to Hadoop.
A. PostreSQL
B. SQL Server
C. Oracle
D. MySQL
Ans : SQL Server
Q.12 ________ does not support the notion of enclosing characters that may include field delimiters in the enclosed string.
A. Imphala
B. Oozie
C. Sqoop
D. Hive
Ans : Hive
Q.13 Sqoop can also import the data into Hive by generating and executing a ____________ statement to define the data’s layout in Hive.
A. SET TABLE
B. CREATE TABLE
C. INSERT TABLE
D. All of the mentioned
Ans : CREATE TABLE
Q.14 _________ provides a couchbase server-hadoop connector by means of sqoop.
A. MemCache
B. Couchbase
C. Hbase
D. All of above
Ans : MemCache
Q.15 The __________ tool imports a set of tables from an RDBMS to HDFS.
A. export-all-tables
B. import-all-tables
C. import-tables
D. none of the mentioned
Ans : import-tables
Q.16 Sqoop direct mode does not support imports of ______ columns.
A. BLOB
B. LONGVARBINARY
C. CLOB
D. All of above
Ans : All of above
Q.17 Which of the following argument is not supported by import-all-tables tool?
A. –class-name
B. –package-name
C. –database-name
D. –table-name
Ans : –class-name
Q.18 Sqoop has been tested with Oracle _______ Express Edition.
A. 11.2.0
B. 10.2.0
C. 12.2.0
D. 10.3.0
Ans : 10.2.0
