Interview question based on skill :
Take as many assements as you can to improve your validate your skill rating
Total Questions: 20
1. _______ supports a new command shell Beeline that works with HiveServer2.
Correct Answer is : HiveServer2
2. In ______ mode HiveServer2 only accepts valid Thrift calls.
Correct Answer is : Remote
3. Hive specific commands can be run from Beeline, when the Hive _______ driver is used.
Correct Answer is : JDBC
4. Point out the correct statement :
Correct Answer is : Starting with Hive 0.14, there are improved SV output formats
5. _________ reduce the amount of informational messages displayed (true) or not (false).
Correct Answer is : –silent=[true/false].
6. Which of the following is used to set transaction isolation level ?
Correct Answer is : –isolation=LEVEL
7. Point out the wrong statement :
Correct Answer is : CSV and TSV output formats are maintained for forward compatibility
8. The ________ allows users to read or write Avro data as Hive tables.
Correct Answer is : AvroSerde
9. Starting in Hive _______, the Avro schema can be inferred from the Hive table schema.
Correct Answer is : 0.14
10. The AvroSerde has been built and tested against Hive 0.9.1 and later, and uses Avro _______ as of Hive 0.13 and 0.14.
Correct Answer is : None of the mentioned
11. Which of the following data type is supported by Hive ?
Correct Answer is : enum
12. Which of the following data type is converted to Array prior to Hive 0.12.0 ?
Correct Answer is : bytes
13. The IBM _____________ Platform provides all the foundational building blocks of trusted information, including data integration, data warehousing, master data management, big data and information governance.
Correct Answer is : InfoStream
14. Point out the correct statement :
Correct Answer is : All of the mentioned
15. InfoSphere DataStage has __________ levels of Parallelism.
Correct Answer is : 3
16. InfoSphere DataStage uses a client/server design where jobs are created and administered via a ________ client against central repository on a server
Correct Answer is : Windows
17. Point out the wrong statement :
Correct Answer is : In 2012 the suite was renamed to InfoSphere Information Server and the product was renamed to InfoSphere DataStage
18. __________ is a name given to the version of DataStage that had a parallel processing architecture and parallel ETL jobs.
Correct Answer is : Enterprise Edition
19. ___________ is used for processing complex transactions and messages,
Correct Answer is : TX
20. InfoSphere ___________ provides you with the ability to flexibly meet your unique information integration requirements
Correct Answer is : Information Server
