Exam 1z0-1041-23 Topic 1 Question 16 Discussion
Actual exam question for Oracle's 1z0-1041-23 exam
Question #: 16
Topic #: 1
Question #: 16
Topic #: 1
You want to create a Sales Amount by Month report for a product. The report should display sales amount from all cities in the South region with sales amount more than 1 million USD.
Which two Alters can be applied for Region and Sales Amount
Which two Alters can be applied for Region and Sales Amount
Suggested Answer: A,B Vote an answer
Two filters that can be applied for Region and Sales Amount are:
Range filter for Region and Date filter for sales Amount. A range filter allows you to specify a range of values for a column using operators such as greater than, less than, between, or not between. A date filter allows you to specify a date or a date range for a column using operators such as before, after, on, or between. For example, you can use a range filter to select only the South region and a date filter to select only the months with sales amount more than 1 million USD.
List filter for Region and List filter for Sales Amount. A list filter allows you to select one or more values from a list of values for a column using operators such as equals, not equals, in, or not in. For example, you can use a list filter to select only the South region and another list filter to select only the sales amounts that are more than 1 million USD. Reference: [Oracle Analytics Cloud - Data Visualization User's Guide], [Oracle Analytics Cloud - Data Visualization User's Guide]
Range filter for Region and Date filter for sales Amount. A range filter allows you to specify a range of values for a column using operators such as greater than, less than, between, or not between. A date filter allows you to specify a date or a date range for a column using operators such as before, after, on, or between. For example, you can use a range filter to select only the South region and a date filter to select only the months with sales amount more than 1 million USD.
List filter for Region and List filter for Sales Amount. A list filter allows you to select one or more values from a list of values for a column using operators such as equals, not equals, in, or not in. For example, you can use a list filter to select only the South region and another list filter to select only the sales amounts that are more than 1 million USD. Reference: [Oracle Analytics Cloud - Data Visualization User's Guide], [Oracle Analytics Cloud - Data Visualization User's Guide]
by Harvey at Feb 12, 2025, 10:40 AM
0
0
0
10
Comments
tengai2007
2025-07-20 02:57:49Requirement: Include only the "South" region.
List filter is ideal because:
Regions (e.g., South, North, East, West) are discrete categorical values.
A list filter allows selecting specific values (e.g., Region = "South").
Sales Amount Filter (Requires > 1 million USD)
Option C: Expression filter
Allows writing custom logic like Sales_Amount > 1000000.
Flexible for complex conditions (e.g., combining multiple fields).
Option D: Range filter
Sets a numeric range (e.g., Min = 1000000, Max = Infinity).
Efficient for numeric thresholds (e.g., "greater than 1 million").
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Report Comment
Commenting
You can sign-up / login (it's free).