Intelligent Big Data - Sqoop Assessment Test

10 Questions | Total Attempts: 351

SettingsSettingsSettings
Intelligent Big Data - Sqoop Assessment Test - Quiz

With or without the approach of big data, Sqoop is a tool with a command-line interface designed and used for conveniently and efficiently transferring bulk data between relational databases (and other structured datastores) and Hadoop.


Questions and Answers
  • 1. 
    What is the best tool transfering data between Hadoop and relational database servers? 
    • A. 

      Hive

    • B. 

      Groovy

    • C. 

      SQL

    • D. 

      Sqoop

  • 2. 
    Where does Sqoop 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. 

      Sequence file format

    • B. 

      Doc

    • C. 

      JPEG

    • D. 

      Delimited Text File Format

  • 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 SUBSET

    • D. 

      By using SELECT

  • 5. 
    Which of these tools transfer data from HDFS to RDBMS? 
    • A. 

      Handoop

    • 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 can the 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. 

      Codegen

    • B. 

      Help

    • C. 

      Import

    • D. 

      Eval

  • 10. 
     Which of these evaluates SQL statements and display results in Sqoop? 
    • A. 

      Eval

    • B. 

      Version

    • C. 

      Help

    • D. 

      Display

Back to Top Back to top