Sqoop Quiz 2 | Englishfreetest.com

  • Do test 20 minutes
  • Number Questions: 10 questions
  • By: englishfreetest.com
Do test

Here's the exercise 'Sqoop Quiz 2 | Englishfreetest.com' about Technical Quiz - Technical Tests.


Put your knowledge about all things technology to the test Because everything tech, from computers and the internet to software and big data, changes rapidly on a day-to-day basis, it’s now a must to stay up to date with the technology that dominates our modern day lives. Are you up to speed on what’s going on in the tech industry today? Take our quiz to find out. Test how much you know about technology

You can find more to the lesson and more exercises. Technical Quiz - Technical Tests in here.

Finally, click here to "Test" for start practice exercise .

  • Test content
    Question 1: While SequenceFile stores each record as key-value pair, the avro system stored records as
    A. Simple text
    B. chained lists
    C. Linked lists
    D. schema and data
    Question 2: What are the two different incremental modes of importing data into sqoop?
    A. merge and add
    B. append and modified
    C. merge and lastmodified
    D. append and lastmodified
    Question 3: What is achieved by using the --meta-connect parameter in a sqoop command?
    A. run metastore as a service accessible remotely
    B. run metastore as a service accessible locally
    C. connect to the meastore tables
    D. connect to the metadata of the external relational tables form which data has to be imported
    Question 4: When does sqoop gather the metadata of the relational table into which it exports the data?
    A. Gathers the metadata of all tables only once during establishing the connection to the database
    B. Never as it relies on the user to ensure the exported data matches the table’s structure
    C. Every time the sqoop export command it submitted and just before the data transfer starts
    D. Only if the export fails, Sqoop accesses the metadata of the table
    Question 5: The insert query used to insert exported data into tables is generate by
    A. Sqoop command and processed as such
    B. Sqoop command and modified suitably by JDBC drive
    C. JDBC driver
    D. Database specific driver
    Question 6: When using –update-mode allowinsert parameter with oracle database the feature of oracle used by sqoop is
    A. UPSERT statement
    B. MERGE statement
    C. MULTITABLE INSERT statement
    D. BULK LOAD statement
    Question 7: The parameter which can be used in place of --table parameter to insert data into table is
    A. call
    B. insert-into
    C. populate
    D. load-into
    Question 8: During import to hive using sqoop the data is
    A. directly loaded to existing hive table
    B. first moved into a hive directory as a hdfs file
    C. first moved into any temporary location as a HDFS file
    D. First validated against the table schema in hive
    Question 9: The parameter --hive-import can be used with
    A. only importing to hive
    B. importing to hive as well as text file
    C. importing to hive and relational tables
    D. importing to hive and binary data
    Question 10: The sqoop export/import jobs canbe stored and used again and again by using
    A. sqoop- jobname
    B. sqoop-save-job
    C. Sqoop-all-jobs
    D. sqoop-job