Intelligent Big Data SQL Assessment Test

10 Questions

Settings
Please wait...
Assessment Test Quizzes & Trivia

.


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