• Description: 000-702 DB2 UDB V8.1 for z/OS Database Administration
• Passing Score: 75%
• Practice Test - Number of questions: 113 questions
• Simulation Test - Number of questions: 113 questions
• Simulation Test Duration: 41 minutes
• Has explanations: No

The current design requirement for a large history table is to maintain 36 months of data, with each month stored in a separate partition. The transaction date is used only to define the partitions. The user normally accesses the data account number. To save space and to support the requirements, which of the following physical implemntations should the DBA choose?

Answer(s)

1. Create a partitioning index on the transaction date and a secondary index on the customer account.
2. Create a single partitioning, clustering index on the combined transaction date and customer account columns.
3. Create a table-controlled partitioned tabl, which partitions on the transaction date. Also, create a partitioned clustering index on the customer account.
4. Create a table-controlled partitioned table, which partitions on the transaction date. Also, create a partitioning index on the combined columns transaction data and customer account.

Create a table-controlled partitioned tabl, which partitions on the transaction date. Also, create a partitioned clustering index on the customer account.