Hive Quiz 3 | Englishfreetest.com

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

Here's the exercise 'Hive Quiz 3 | 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: HCatalog is installed with Hive, starting with Hive release
    A. 0.10.0
    B. 0.9.0
    C. 0.11.0
    D. 0.12.0
    Question 2: The disadvantage of compressing files in HDFS is
    A. Unused HDFS blocks
    B. Less I/O
    C. Files do not become splittable
    D. Files have to move to local filesystem to be usable
    Question 3: A GenericUDF is a Function that
    A. Takes one or more columns form a row and returns a single value
    B. Takes one or more columns form many rows and returns a single value
    C. Take zero or more inputs and produce multiple columns or rows of output
    D. Detects the type of input programmatically and provides appropriate response
    Question 4: A View in Hive can be dropped by using
    A. Drop table
    B. Drop view
    C. Delete view
    D. Remove view
    Question 5: What Hive can not offer
    A. storing data in tables and columns
    B. Online transaction processing
    C. Handling date time data
    D. Partitioning stored data
    Question 6: On dropping an external table
    A. The schema gets dropped without dropping the data
    B. The data gets dropped without dropping the schema
    C. An error is thrown
    D. Both the schema and the data is dropped
    Question 7: The partitioning of a table in Hive creates more
    A. subdirectories under the database name
    B. subdirectories under the table name
    C. files under databse name
    D. files under the table name
    Question 8: The position of a specific column in a Hive table
    A. can be anywhere in the table creation clause
    B. must match the position of the corresponding data in the data file
    C. Must match the position only for date time data type in the data file
    D. Must be arranged alphabetically
    Question 9: The performance of an aggregate query is improved by setting which of the following property as true?
    A. hive.map.group
    B. hive.map.aggr
    C. hive.map.sort
    D. hive.map.sum
    Question 10: Which kind of keys(CONSTRAINTS) Hive can have?
    A. Primary Keys
    B. Foreign Keys
    C. Unique Keys
    D. None