Question : You have a query with the where clause and all the predicates use equality operator like =, != etc. What is correct in this scenario, with regards to mapping rule? 1. search attributes, which are used in a query predicate, map to the prefix columns of a table primary key.
2. Such columns must include all partition key columns and, optionally, one or more clustering key columns.
Correct Answer : Get Lastest Questions and Answer : Explanation: MR2 (Equality Search Attributes). Equality search attributes, which are used in a query predicate, map to the prefix columns of a table primary key. Such columns must include all partition key columns and, optionally, one or more clustering key columns. Violation of this rule may result in inability to support query requirements.
Question : Which of the following is correct with regards to mapping rule Inequality Search Attributes 1. An inequality search attribute, which is used in a query predicate, maps to a table clustering key column.
2. In the primary key definition, a column that participates in inequality search must follow columns that participate in equality search.
Correct Answer : Get Lastest Questions and Answer : Explanation: MR3 (Inequality Search Attributes). An inequality search attribute, which is used in a query predicate, maps to a table clustering key column. In the primary key definition, a column that participates in inequality search must follow columns that participate in equality search. Violation of this rule may result in inability to support query requirements.
Question : You have a query, where you have to order by the data by a particular column. In this case you have to use this column with the clustering key? 1. True 2. False
Correct Answer : Get Lastest Questions and Answer : Explanation: MR4 (Ordering Attributes). Ordering attributes, which are specified in a query, map to clustering key columns with ascending or descending clustering order as prescribed by the query. Violation of this rule may result in inability to support query requirements.