Question : Which of the following is correct for collections in Cassandra table ? 1. Use collections when you want to denormalize a small amount of data.
2. Use collections when you want to store a small amount of data.
Correct Answer : Get Lastest Questions and Answer : Explanation: Use collections when you want to store or denormalize a small amount of data. Values of items in collections are limited to 64K. Other limitations also apply. Collections work well for storing data such as the phone numbers of a user and labels applied to an email. If the data you need to store has unbounded growth potential, such as all the messages sent by a user or events registered by a sensor, do not use collections. Instead, use a table having a compound primary key and store data in the clustering columns.
Question : Which of the following statement true, with regards to Cassandra Index?
1. An index provides a means to access data in Cassandra using attributes other than the partition key.
Correct Answer : Get Lastest Questions and Answer : Explanation: An index provides a means to access data in Cassandra using attributes other than the partition key. The benefit is fast, efficient lookup of data matching a given condition. The index indexes column values in a separate, hidden table from the one that contains the values being indexed. Cassandra has a number of techniques for guarding against the undesirable scenario where a data might be incorrectly retrieved during a query involving indexes on the basis of stale values in the index.
As mentioned earlier, in Cassandra 2.1 and later, you can index collection columns.
Question : The more unique values that exist in a particular column, the more overhead you will have, on average, to query and maintain the index. 1. True 2. False
Correct Answer : Get Lastest Questions and Answer : Explanation: The more unique values that exist in a particular column, the more overhead you will have, on average, to query and maintain the index. For example, suppose you had a books table with a billion books and wanted to look up book by the author. Many books will share the same column value for author. The author column is a good candidate for an index.