PrepAway - Latest Free Exam Questions & Answers

How would you design the schema?

You have two tables in an existing RDBMS. One table contains order information (item, quantity,
price, etc.) and the other contains store information (address, phone, manager, etc). These two
tables are not often accessed simultaneously. You would like to move this data into HBase. How
would you design the schema?

PrepAway - Latest Free Exam Questions & Answers

A.
Create two tables each with a single column family

B.
Create a single table with one column family

C.
Create a single table with two column families

D.
Create two tables each with multiple column families

Explanation:
Physically, all column family members are stored together on the filesystem.
Because tunings and storage specifications are done at the column family level, it is advised that
all column family members have the same general access pattern and size characteristics.
Reference:The Apache HBaseReference Guide,Column Family

One Comment on “How would you design the schema?


Leave a Reply to seenagape Cancel reply

Your email address will not be published. Required fields are marked *