JOBSEEKERS
Login
Sign Up
Jobseeker
Employer
Staffing Firm
Direct Client
Hadoop interview questions part 43
Hadoop interview questions part 43
Back
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 ?
A. CREATE TABLE foo (bar CHAR(10))
B. CREATE TABLE foo (bar VARCHAR(10))
C. CREATE TABLE foo (bar CHARVARYING(10))
D. All of the mentioned
Show Correct Answer
Correct Answer is :
CREATE TABLE foo (bar VARCHAR(10))
2. _________ will overwrite any existing data in the table or partition
A. INSERT WRITE
B. INSERT OVERWRITE
C. INSERT INTO
D. None of the mentioned
Show Correct Answer
Correct Answer is :
INSERT INTO
3. Hive does not support literals for ______ types.
A. Scalar
B. Complex
C. INT
D. CHAR
Show Correct Answer
Correct Answer is :
Complex
4. ________ systems are scale-out file-based (HDD) systems moving to more uses of memory in the nodes.
A. NoSQL
B. NewSQL
C. SQL
D. All of the mentioned
Show Correct Answer
Correct Answer is :
NoSQL
5. Point out the correct statement :
A. Hadoop is ideal for the analytical, post-operational, data-warehouse-ish type of workload
B. HDFS runs on a small cluster of commodity-class nodes
C. NEWSQL is frequently the collection point for big data
D. None of the mentioned
Show Correct Answer
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:
A. HCatalog
B. Hive
C. Hbase
D. All of the mentioned
Show Correct Answer
Correct Answer is :
HCatalog
7. __________ are highly resilient and eliminate the single-point-of-failure risk with traditional Hadoop deployments
A. EMR
B. Isilon solutions
C. AWS
D. None of the mentioned
Show Correct Answer
Correct Answer is :
Isilon solutions
8. Point out the wrong statement :
A. EMC Isilon Scale-out Storage Solutions for Hadoop combine a powerful yet simple and highly efficient storage platform
B. Isilon native HDFS integration means you can avoid the need to invest in a separate Hadoop infrastructure
C. NoSQL systems do provide high latency access and accommodate less concurrent users
D. None of the mentioned
Show Correct Answer
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 :
A. Scale out
B. Scale up
C. Both Scale out and up
D. None of the mentioned
Show Correct Answer
Correct Answer is :
Scale out
10. Which is the most popular NoSQL database for scalable big data store with Hadoop ?
A. Hbase
B. MongoDB
C. Cassandra
D. None of the mentioned
Show Correct Answer
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.
A. DataCache
B. DistributedData
C. DistributedCache
D. All of the mentioned
Show Correct Answer
Correct Answer is :
DistributedCache
12. HBase provides ___________ like capabilities on top of Hadoop and HDFS.
A. TopTable
B. BigTop
C. Bigtable
D. None of the mentioned
Show Correct Answer
Correct Answer is :
Bigtable
13. _______ refers to incremental costs with no major impact on solution design, performance and complexity.
A. Scale-out
B. Scale-down
C. Scale-up
D. None of the mentioned
Show Correct Answer
Correct Answer is :
Scale-up
14. The minimum number of row versions to keep is configured per column family via :
A. HBaseDecriptor
B. HTabDescriptor
C. HColumnDescriptor
D. All of the mentioned
Show Correct Answer
Correct Answer is :
HColumnDescriptor
15. Point out the correct statement :
A. The default for max versions is 1
B. It is recommended setting the number of max versions to an exceedingly high level
C. HBase does overwrite row values
D. All of the mentioned
Show Correct Answer
Correct Answer is :
The default for max versions is 1
16. HBase supports a ____________ interface via Put and Result
A. “bytes-in/bytes-out”
B. “bytes-in”
C. “bytes-out”
D. none of the mentioned
Show Correct Answer
Correct Answer is :
“bytes-in/bytes-out”
17. One supported data type that deserves special mention are :
A. money
B. counters
C. smallint
D. tinyint
Show Correct Answer
Correct Answer is :
counters
18. Point out the wrong statement :
A. Where time-ranges are very wide (e.g., year-long report) and where the data is voluminous, summary tables are a common approach
B. Coprocessors act like RDBMS triggers
C. HBase does not currently support ‘constraints’ in traditional (SQL) database parlance
D. None of the mentioned
Show Correct Answer
Correct Answer is :
HBase does not currently support ‘constraints’ in traditional (SQL) database parlance
19. The _________ suffers from the monotonically increasing rowkey problem
A. rowkey
B. columnkey
C. counterkey
D. all of the mentioned
Show Correct Answer
Correct Answer is :
rowkey
20. __________ does re-write data and pack rows into columns for certain time-periods.
A. OpenTS
B. OpenTSDB
C. OpenTSD
D. OpenDB
Show Correct Answer
Correct Answer is :
OpenTSDB
Similar Interview Questions
Search for latest jobs
Find Jobs