Q.1
_________ tool can list all the available database schemas.
  • a) sqoop-list-tables
  • b) sqoop-list-databases
  • c) sqoop-list-schema
  • d) sqoop-list-columns
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
Q.3
Data can be imported in maximum ______ file formats.
  • a) 1
  • b) 2
  • c) 3
  • d) All of the mentioned
Q.4
________ text is appropriate for most non-binary data types.
  • d) None of the mentioned
  • a) Character
  • b) Binary
  • c) Delimited
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
Q.6
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
Q.7
________ 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
Q.8
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
Q.9
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
Q.10
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
0 h : 0 m : 1 s