Intelligent Big Data SQL Assessment Test

10 Questions | Total Attempts: 116

SettingsSettingsSettings
Intelligent Big Data SQL Assessment Test - Quiz

SQL is a programming language that is used for many purposes. Our super intelligent big data SQL assessment test will test your knowledge of this computer language. All you have to do is to answer a few very simple questions about it. Think you can do it with ease? Then, why don't you give it a try? Please make sure to read all the questions carefully before answering. You are expected to answer all the questions in the quiz. There is no time limit to this quiz. Have fun and keep learning!


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

Related Topics
Back to Top Back to top
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.