Oracle 1Z0-1041-23 Exam Actual Questions

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]

The correct use of BI Ask is that it is used to enable user input in natural language. It extracts column names from the user input and quickly builds visuals for the columns extracted. BI Ask is a feature that allows you to create analyses using natural language queries instead of dragging and dropping columns from the subject area pane. You can type or speak your query in BI Ask and it will automatically generate the best visualization for your query based on the columns extracted from your input. Reference: [Oracle Analytics Cloud - Data Visualization User's Guide], [Oracle Analytics Cloud - Data Visualization User's Guide]

To create a line chart visualization of revenue data at the day level that displays the last 365 days of data and the next 90 days of forecast, you need to add a forecast and change the Period value to 90. A forecast is a feature that allows you to predict future values of a measure based on historical data using various methods, such as linear, exponential, or seasonal. The Period value specifies how many future values you want to forecast. For example, you can add a forecast to your line chart and set the Period value to 90 to see the projected revenue for the next 90 days. Reference: [Oracle Analytics Cloud - Data Visualization User's Guide], [Oracle Analytics Cloud - Data Visualization User's Guide]

Two types of filters that can be used to display as prompts in your Publisher report are:

Number filters. A number filter allows you to specify a numeric value or a range of numeric values for a column using operators such as equals, not equals, greater than, less than, or between. For example, you can use a number filter to prompt users to enter a minimum or maximum sales amount for your report.

Expression filters. An expression filter allows you to specify a logical expression for a column using operators such as AND, OR, NOT, or parentheses. For example, you can use an expression filter to prompt users to enter a combination of conditions for your report, such as region equals South AND sales amount greater than 1 million USD. Reference: [Oracle Analytics Cloud - Data Visualization User's Guide], [Oracle Analytics Cloud - Data Visualization User's Guide]

To change the dashboard prompt range from all pages to only the Sales page, you need to do the following steps:

In the Dashboard editor, edit the dashboard prompt properties by clicking the Edit View button on the top right corner of the prompt.

In the Scope tab, select Page as the scope option and choose Sales as the page name from the drop-down list.

Click OK to save your changes and apply the dashboard prompt only to the Sales page. Reference:Oracle Analytics Cloud - Data Visualization User's Guide,Oracle Analytics Cloud - Data Visualization User's Guide