Page 1 of 1
Which of the following is not an Apache Sqoop feature?
None
Parallel import/export
Kerberos Security Integration
Import results of SQL query
Sqoop import –m1 –connect ‘jdbc:sqlserver://servername;database=DatabaseName; What is "-m" stands for?
mapper
metastore
import
mysql
Which of the following statements about Sqoop is correct?
Sqoop is used to move bulk streaming data into HDFS
Sqoop uses Agent to fetch the data
Sqoop uses Connectors to connect to respective data
Sqoop is not event-driven
Sqoop supports data imported into?
Hive
All the listed items here
Hcatalog
HDFS
Sqoop Export helps
to export a directory into a HDFS
to export an HDFS directory into a database table
to export MySQL data into HDFS
to export data from one RDBMS to another RDBMS
The default file format to import data using Apache Sqoop is
Default File Format
Parquet
Sequence File Format
Delimited Text File Format
Which one is the default database for Apache Hive
Hive Metastore
SQL Server
Derby
MySQL
To import only a subset of rows from a table, use -
LIMIT
WHERE Clause
TOP
FILTER Condition
What is ETL stands for
Extract, Transform, Load
Extract, Transfer, Load
Easy, Transfer, Load
Not in the list
The keyword “target-dir” will not work with
import-all-tables
import-partial-data
import-specific-table
import-table-where
Page 1 of 1