E20-485 Latest Exam Braindumps
Question 20: An engineer designs the data model that is shown for a shipping application in a repository that doesnot have fulltext search enabled.
It is required that a query returns all shipping_transaction documents, shipped on a given shipping_date,
with a particular shipping_code.
Querying with either shipping_code or shipping_date alone would return hundreds of thousands of
objects. Querying on both shipping_date and shipping_code, returns a selective set of objects.
Given the example query:
select r_object_id, customer_id, shipping_date
from shipping_transaction
where na_specific_data.shipping_code=4267.86
and shipping_date = date('11/25/2008')
Which statement is true about use of aspects in this scenario?
A. It will cause a DQL parser error, because it is NOT possible to include both aspect and standard
attributes within the same query.
B. It will improve query response time, because the aspect metadata is only applied to some
shipping_transaction documents.
C. It will degrade query response time, because a database index on the combination of attributes that
make the query selective CANNOT be created.
D. It will degrade query response time, because the aspect metadata is only applied to some
shipping_transaction documents.
Correct Answer: C
