Sqoop Quiz 4 | Englishfreetest.com

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

Here's the exercise 'Sqoop Quiz 4 | 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: With MySQL, the feature used by sqoop for update or insert data into an exported table is
    A. ON DUPLICATE KEY UPDATE
    B. ON KEY UPDATE
    C. ON NEW KEY UPDATE
    D. ON NEW UPDATE
    Question 2: 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 3: Sqoop can automatically clear the staging table before loading by using the parameter
    A. clear-table
    B. clear-staging-table
    C. truncate-staging-table
    D. delete-from-staging-table
    Question 4: While using a free-form query to import data, Sqoop finds that two columns from the joined tables have the same name. In this case the job
    A. will fail
    B. will run ignoring the column from each table
    C. will prompt the user to rename one of the columns
    D. automatically create an alias for one of the columns as succeed the job
    Question 5: The parameter used to override NULL values to be inserted into relational targets is
    A. override-null
    B. input-null-string
    C. substitute-null
    D. replace-null
    Question 6: What is the disadvantage of storing password in the metastore as compared to storing in a password file?
    A. it is easily accessible
    B. it may get deleted accidentally
    C. It cannot be updated
    D. it is unencrypted
    Question 7: what option can bne used to import only some of the table from a database while using the --import-all-tables parameter?
    A. skip-tables
    B. without-tables
    C. forgo-tables
    D. exclude-tables
    Question 8: What option can be used to import the entire database from a relational system using sqoop?
    A. import-all-db
    B. import-all-tables
    C. import-all
    D. import
    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 --options-file parameter is used to
    A. save the import log
    B. specify the name of the data files to be created after import
    C. store all the sqoop variables
    D. store the parameters and their values in a file to be used by various sqoop commands