A00-205 SAS Webaf Server-Side Application Development Exam Questions

Demo Question 9.

Click on the Exhibit button to display an entity-relationship data model for a stock broker program. The data model needs to be optimized for queries to gather a customer's net worth on a given day. The broker has two customers holding stock in several hundred different companies. Daily pricing history goes back ten years for each company. Which one of the following index schemes allows optimal performance of the query? Exhibit:

A. composite index on cusip and date in the Prices table composite index on cust_name, cusip, and trandate in the Transaction table
B. simple index on cusip in the Prices table simple index on date in the Prices table composite index on cusip and trandate in the Transaction table
C. composite index on date and cusip in the Prices table simple index on cusip in the Transaction table simple index on trandate in the Transaction table
D. composite index on cusip and date in the Prices table composite index on cusip and trandate in the Transaction table


Display Answer

Answer: B

Explanation: