Oracle Application Testing Suite 12 Essentials — Question 8

Product status is a data element you need to include in your Planning application. Each product will have a product status that can vary over time. You will use product status in calculations and will need to report sales by product status and across products in a cross tab format.
What is the best way to meet all of these requirements?

Answer options

• A. Define Product Status as a Smart List.
• B. Define Product Status as a Separate Dimension.
• C. Define Product Status as an Attribute.
• D. Define Product Status as a Varying Attribute.
• E. Define Product Status as an alternate hierarchy in the Product dimension.

Correct answer: D

Explanation

The correct answer is D, as defining Product Status as a Varying Attribute allows it to change over time while still being used in calculations and reporting. Options A and C do not support changes in status over time. Option B would not address the need for time variation, and option E is not suitable for tracking status changes effectively.