IBM
P2090-712 · Question #75
Assuming the CUSTOMERS table has a related child table ORDERS, what is the best sampling method to extract only a maximum of 5 order rows for each of the customer record?
The correct answer is D. Specify Child Limit on the relationship between CUSTOMERS and ORDERS. See the full explanation below for the reasoning.
Question
Assuming the CUSTOMERS table has a related child table ORDERS, what is the best sampling method to extract only a maximum of 5 order rows for each of the customer record?
Options
- ASpecify Row Limit on table ORDERS in a Table Map
- BSpecify Grouping in an Access Definition
- CSpecify Selection Criteria in a Table Map
- DSpecify Child Limit on the relationship between CUSTOMERS and ORDERS
How the community answered
(23 responses)- A9% (2)
- B17% (4)
- C4% (1)
- D70% (16)
Community Discussion
No community discussion yet for this question.