1Z0-1058-26 practice question 5 of 10

Which filter can be used to identify expense reports that contain suspicious expense type combinations, such as, a report for a single trip that contains taxi, car rental, and mileage expenses?

Answer options

A: Inclusive function filter grouped by the “Expense Report Information” object’s “Report Number” where the “Expense Type” has an “Equals” condition for values that include taxi, car, mileage.

B: Inclusive function filter grouped by the “Expense Report Information” object’s “Report Number” where the “Expense Type” has an “In” condition for values that include taxi, car, mileage.

C: Inclusive function filter grouped by the “Expense Report Information” object’s “Person” where the “Expense Type” has an “In” condition for values that include taxi, car, mileage.

D: Inclusive function filter grouped by the “Expense Report Information” object’s “Report Number” where the “Expense Type” has an “In” condition for values that include taxi, car, mileage. Correct answer

E: Inclusive function filter grouped by the “Expense Report Information” object’s “Person” where the “Expense Type” has an “In” condition for values that include taxi, car, mileage.

Correct Answer:

D. Inclusive function filter grouped by the “Expense Report Information” object’s “Report Number” where the “Expense Type” has an “In” condition for values that include taxi, car, mileage.

Explanation

The Inclusive Function filter keeps only those groups that contain ALL of the specified values. To find reports that simultaneously include Taxi, Car Rental, and Mileage lines, group the data by Expense-Report “Report Number” (one group per report) and apply an Inclusive filter on the “Expense Type” attribute with an “IN (Taxi, Car, Mileage)” condition. Any report returned by the filter necessarily contains the suspicious combination.

Why Incorrect

A – Using “Equals” would look for a single row where Expense Type equals all three values—impossible. B – Duplicate of D; one option retained. C – Grouping by Person mixes multiple reports; may flag employees who happened to submit the three types on different reports. E – Same grouping problem as C.

References

1. Oracle Risk Management Cloud User Guide 24A, “Use of Inclusive and Exclusive Function Filters”, example 2 (Expense types), paragraphs 1-3.

2. Oracle Risk Management Cloud Tutorial: “Detect Expense-Type Combinations with Inclusive Function” (Oracle Learning Library Video RM-2204).

Keep practicing

Take the free 1Z0-1058-26 practice test

Ten exam-style questions with answers and explanations, plus the exam facts and study guides.

Start the free practice test