1041

Which version of OBIEE is supported for migration to OAC?. OBIEE 12g and later. OBIEE 11.1.1.X and later. You cannot migrate content from OBIEE to OAC. OBIEE 12c only. OBIEE 10g.

The prompt values selected. But the data in the two other reports is not getting refreshed. What are two possible reasons for this?. The Report's filter formula is different from the prompt column formula. The Report's filter is set to the presentation variable. The reports have a protected filter. The Report's filter is set to be prompted.

Which two maps use an API key to add as Map Background?. Oracle Map. WMS Map. Google Map. Basile Map. Tiled Web Map.

You add a cluster statistic to your scatter chart. What does this help you identify?. Heterogeneous groups of data points. Homogeneous and heterogeneous groups of data points. Disparate groups of data points. Homogeneous groups of data points.

You have two data sets: Country (ID, Country_code, Country_name) Revenue (Row_ID, Country_code, Sales_Person_ID, Year, Revenue_amount) Year has been marked as an attribute. You added both the data sets to Data Flow. You also added a step to save the data set to Data Storage. What are the two steps to create a data set that you can use for analyzing country revenues over time?. Apply the default Aggregation on Revenue_amount. Keep Matching Rows on both data sets and match the Country_Code column on both data sets. Keep Matching Rows on both data sets and match the ID column. Apply the default Aggregation on Year.

Which data action must you use to connect to Oracle Analytics Publisher reports?. Webhooks. HTTP API. URL Navigation. Analytics Link. Publish Event.

Your client has a significant data warehouse on their premises and has regional regulatory constraints to shift to the cloud. You have decided to implement Data Gateway to enable users to view the data in Oracle Analytics Cloud. Which statement accurately describes the role and function of a Data Gateway?. It provides advanced data analysis capabilities for Oracle Database users. It is designed to optimize cloud storage usage within Oracle Analytics Cloud. It enables secure and efficient data transfer between on-premises data sources and Oracle Analytics Cloud. It serves as a tool for data visualization within Oracle Analytics Cloud.

Which three are true about adjusting visualization properties when placing multiple visuals on a canvas?. You can add a copy of a selected canvas to the project's row of canvas tabs by right-clicking the canvas and selecting Edit, and then Copy Visualization. You can duplicate a visual by right-clicking the canvas and selecting Edit, and then Duplicate Visualization. You can change a visual's location on the canvas by selecting and dragging it to the desired location. You can hide a visual by right-clicking the canvas and selecting Hide from the shortcut menu. You can resize visuals manually if the Canvas Layout option is set to Freeform.

Which technique does Data Preparation in OAC use for recommendation with sensitive information such as SSN, credit card number, and customer number?. Cryptographic algorithms to encrypt sensitive information. Advanced Analytics functions. Obfuscation to protect sensitive information. Sentiment Analysis algorithms.

Data Visualization has the powerful Natural Language Query (NLQ) feature. Which two statements are TRUE about NLQ?. NLQ is available on top of the unified Oracle Analytics Home Page. NLQ displays rows filtered by user criteria. As you enter search criteria and hit Shift + Enter, the application displays visuals based on the Keywords extracted. NLQ is available in all pages in Oracle Analytics Cloud.

What are two benefits of using Oracle Cloud Infrastructure (OCI) Logging to access Oracle Analytics Cloud (OAC) logs?. OCI Logging automatically archives OAC logs for disaster recovery purposes. OCI Logging offers a centralized location for managing logs from OAC resources. OCI Logging provides a user interface for log creation and reduces storage requirements. OCI Logging allows direct editing of OAC logs and streamlines data export for external tools. OCI Logging simplifies compliance auditing for OAC user activity.

How should you use a machine learning model within a canvas of an Oracle Analytics Cloud Workbook?. Use the machine learning model visualization. Create a data sequence. Create a scenario using the required model. Create a custom calculation.

How should you determine the accuracy of a Machine Learning model created in Oracle Analytics Cloud (OAC)?. Open the Inspect dialog for a given Machine Learning model and review the P score. Create Data Flow that includes a histogram. Open the Inspect dialog for a given Machine Learning model and review the F1 score. Run the Machine Learning model with various filter values applied. Use the Debug option in the Data Flow where the model was created.

You have a Historical Sales data set, which you use to train a model in Oracle Analytics Cloud (OAC). Your products have an attribute named `profitability`, which has one of the three values: `high`, `medium`, or `low`. You want to predict the profitability of new products. Which train data step is required to train a model in OAC?. Train Numeric Prediction. Train Clustering. Train Binary-Classifier. Train Multi-Value. Train Multi-Classifier. Train Text Prediction.

Which statement is true about Data Flows and Sequences?. Both Sequences and Data Flows can be scheduled. You cannot run a Sequence. Sequences can be scheduled but not Data Flows. Sequences cannot be scheduled but Data Flows can be scheduled.

You have a business requirement to create a three-month rolling sales calculation in an Oracle Analytics Cloud (OAC) workbook. Which time series function are you going to use?. PERIODROLLING(Sales, -1, 1). TODATES(Sales, Month). AGO(Sales, Month, 3). FORECAST(Sales, Month, 3).

Oracle Analytics Cloud (OAC) offers several visualization options for presenting query results. Which two methods do you use to invoke the best visualization in OAC?. Select the desired data elements from the Data Elements pane and then right-click and select Create Best Visualization from the drop-down menu. Select the desired data elements from the Data Elements pane and drag them to a blank area of the canvas. Select the Best Visualization option from the project's Canvas Settings drop-down menu. Change the project's properties to "Always use Best Visualization". Select the desired data elements from the Data Elements pane and drag them to the Best Visualization zone in the Explore pane.

Which of these steps is REQUIRED in a Data Flow to create a new curated data set?. Aggregate. Merge Columns. Filter. Add Data.

You have added a forecast to your visualization. Which three models are available for calculating the forecast?. ARIMA. ETS. SARIMA. Seasonal ETS. Seasonal ARIMA. Seasonal ARENA.

The EVALUATE function with Oracle Analytics Cloud (OAC) enables users to invoke various built-in database functions directly from OAC. Which two statements about the prerequisites for the EVALUATE function are valid?. Set the data access file to Live for the datasets the EVALUATE function will reference. Set the data access file to Cached for the datasets the EVALUATE function will reference. The data access connection must support the database functions invoked in the calculation. Set the Evaluate Support Level parameter to 1 or 2. Set the Evaluate Support Level parameter to 0.

You created a new Sales dashboard with three pages: Sales, Revenue, and Orders. You need to enable a different set of report links at the page level and set different report links for different analyses. How do you first enable the report links for all the dashboard pages, and then set the different report links for the different reports?. Set the column permissions of each Dashboard page and then set the Report links for each report. Enable all the Page Report links and then enable the Report links for each Report. Enable all the Dashboard Report links from Dashboard Properties and then the Report links for each Report. (Cross Verify Please). Enable all the Dashboard Report links from Dashboard Properties and then the Page Report links.

You need to compute sales for a period that starts at a quarter before and ends at a quarter after the current quarter. Which Time Series function will you use?. PERIODSUM. AGO. TODATE. PERIODROLLING.

The Order page of the Sales dashboard contains a report. When a user clicks the value of the Status column, the report is displayed in a new window. The user wants the click event drilled down in the same window. How can you achieve this requirement?. You can set publish page to dashboard in dashboard properties. It is not possible to open the drill in the report in the same window. You can set the drill in place option in section properties. You can set Link - Within the dashboard in report properties.

Which two statements are true about Presentation Catalog?. Catalog items can be set to read-only. You can grant ownership of items you create to other users. My Folders can be shared with other users.

Data Flow can take one or more data sets and integrate them to produce curated sets of data. After applying all the joins, transformations, and filters, you need to save the data. What are the two options to save data in Data Flow?. Data Set Storage. Database Connection. Spreadsheet. All Rows.

You created a workbook with your dataset and generated a set of insights. You wanted to share your findings with your colleagues. In which two ways can you efficiently share workbooks?. Export the workbook into PDF. Convert the workbook into a dashboard and export the dashboard file. Take a screenshot of each canvas. Share the workbook as a .dva file.