Interview question based on skill :
Take as many assements as you can to improve your validate your skill rating
Total Questions: 20
1. Which of the following statement will create column with varchar datatype ?
Correct Answer is : CREATE TABLE foo (bar VARCHAR(10))
2. _________ will overwrite any existing data in the table or partition
Correct Answer is : INSERT INTO
3. Hive does not support literals for ______ types.
Correct Answer is : Complex
4. ________ systems are scale-out file-based (HDD) systems moving to more uses of memory in the nodes.
Correct Answer is : NoSQL
5. Point out the correct statement :
Correct Answer is : Hadoop is ideal for the analytical, post-operational, data-warehouse-ish type of workload
6. Hadoop data is not sequenced and is in 64MB to 256MB block sizes of delimited record values with schema applied on read based on:
Correct Answer is : HCatalog
7. __________ are highly resilient and eliminate the single-point-of-failure risk with traditional Hadoop deployments
Correct Answer is : Isilon solutions
8. Point out the wrong statement :
Correct Answer is : NoSQL systems do provide high latency access and accommodate less concurrent users
9. HDFS and NoSQL file systems focus almost exclusively on adding nodes to :
Correct Answer is : Scale out
10. Which is the most popular NoSQL database for scalable big data store with Hadoop ?
Correct Answer is : Hbase
11. The ___________ can also be used to distribute both jars and native libraries for use in the map and/or reduce tasks.
Correct Answer is : DistributedCache
12. HBase provides ___________ like capabilities on top of Hadoop and HDFS.
Correct Answer is : Bigtable
13. _______ refers to incremental costs with no major impact on solution design, performance and complexity.
Correct Answer is : Scale-up
14. The minimum number of row versions to keep is configured per column family via :
Correct Answer is : HColumnDescriptor
15. Point out the correct statement :
Correct Answer is : The default for max versions is 1
16. HBase supports a ____________ interface via Put and Result
Correct Answer is : “bytes-in/bytes-out”
17. One supported data type that deserves special mention are :
Correct Answer is : counters
18. Point out the wrong statement :
Correct Answer is : HBase does not currently support ‘constraints’ in traditional (SQL) database parlance
19. The _________ suffers from the monotonically increasing rowkey problem
Correct Answer is : rowkey
20. __________ does re-write data and pack rows into columns for certain time-periods.
Correct Answer is : OpenTSDB
