Intelligent Big Data SQL Assessment Test
10 Questions
| Total Attempts: 105
Settings
.
Questions and Answers
- 1.What is the best tool for transferring data between Hadoop and relational database servers?
- A.
SQL
- B.
Sqoop
- C.
Hive
- D.
Groovy
- 2.Where does swoop import copy data from?
- A.
RDBMS
- B.
HDFS
- C.
FCT
- D.
HIVE
- 3.What is the default file format for data import in sqoop?
- A.
Doc
- B.
Sequence file format
- C.
Delimited text file format
- D.
JPEG
- 4.How can you import only a subset of rows from a table?
- A.
By using the WHERE clause
- B.
By using IMPORT
- C.
By using SUBSETS
- D.
By using SELECT
- 5.Which of these tools transfer data from HDFS to RDBMS?
- A.
Hadoop
- B.
Sqoop export
- C.
Sqoop import
- D.
Sqoop mover
- 6.A tool that sqoop hosts a shared metadata repository is called____
- A.
Metallica
- B.
MetaStock
- C.
Metastore
- D.
Warehouse
- 7.In Sqoop merge, which of the dataset is preserved?
- A.
The new one
- B.
The old one
- C.
The correct one
- D.
The incorrect one
- 8.Where cab metastore database be hosted?
- A.
Only inside the Hadoop cluster
- B.
Only outside the Hadoop cluster
- C.
Both inside and outside the Hadoop cluster
- D.
Only on map
- 9.Which of these commands helps to generate code to interact with database records?
- A.
Help
- B.
Import
- C.
Eval
- D.
Codegen
- 10.Which of these evaluates SQL statements and displays results in Sqoop?
- A.
Help
- B.
Display
- C.
Eval
- D.
Version
Back to top