OACs

6回閲覧 • 40問 • 12ヶ月前

通報

問題一覧

You have been tasked with building an analysis that requires data from two subjects areas. How do you accomplish this?

Create an analysis and add the second subject area for a union.

What does Oracle Analytics Explain work on?

Data sets and Subject Areas

You are building a model that will be used for sales report. Which two statements are true about hierarchy and levels?

Hierarchies enable drilling in reports, Skipped levels and unbalanced hierarchies can be enabled for all the dimension tables.

The order page of the sales dashboard contains a report. When a user clicks the value of the states columns, 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 the drill in place option in section properties.

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 reports links for different analysis. How do you first enable the report links for all the dashboard pages, and then set the different report links for thr different reports.

Enable all the dashboard report links from dashboard properties and then the report links for each reach report.

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?

Forecast

You have created the product type dashboard prompt and applied it to the sales dashboard. In the sales dashboard, you have three pages: Sales, Order, and revenue. The dashboard prompt is applied to all pages, but you want it only for the sales page. What configuration changes are required to change the dashboard prompt range?

In the Dashboard editor, edit the dashboard prompt properties and change the scope from dashboard to page.

Which two maps use an API key to add as Map Background?

Google Map, Baidu Map

Oracle Applications Connector Supports Oracle Fusion Applications Cloud. Which is valid about Oracle Applications Connector?

When Creating a connection, enter the URL for oracle fusion applications.

Using Narrate Insights, you can take a snapshot of any information that you see in a visualization and keep track of any moments of sudden realization while you work with the data. You can then share these with other users. Which statement is true about sharing with insights.

Insights is shared as a story and everybody will see their information based on permission.

You are creating a Data Model for a sales order and do not have the time dimension table created in the database. You decide to use the dimension creation feature of Oracle Analytics Could (OAC). What are the task performed by the Time Dimension Wizard on execution.

The Time Dimension wizard creates the Time dimension table in the database, loads time data, and creates the time dimension and hierarchy in the Data Model.

Which data action must you use to connect to Oracle Analytics Publisher reports?

URL Navigation

Which two can be defined on a canvas in a story in Oracle Analytics Cloud?

Narration, Filters

You are creating data model for a healthcare provider. Patient information is contained in related tables for contact information, primary physician, insurance, information and billing details. For management and personal information reasons, the project owner requires that these tables not be merged. What is the correct relational topology to model the patient dimension?

Star

You are developer designing a solution to analyze retail sales. A Key requirement for the solution is a product hierarchy with multiple levels that supports drill-down in an Oracle Analytics Cloud workbook. Which two configurations are appropriate for your solution?

Data set merging a semantic model with the hierarchy and additional data., Data set with hierarchy created in OAC data flow.

What does a fact table use to reference dimension tables?

Foreign Key

An Analyst is creating a story in the Narrate tab of the project. Wha is the most likely reason they have done this

To share the story by exporting to PDF.

Your Oracle Analytics client ask you to shape a story and share it as a file. Which are three valid types for sharing a story?

Acrobat(.PDF), Image(.PNG), Package(.DVA)

Which is a supported source for registering and using Machine Learning models?

Autonomous Data Warehouse

Which two are true about creating a story in Oracle Analytics Cloud?

Insights always take a snapshot data for a story., A story can have multiple canvanses

You have created a Machine Learning model and investigated how accurate it is. How should you use it in Oracle Analytics Cloud (OAC)

Use data flow with an apply model step and save as a new data set.

Which two statements are true about Oracle Analytics (OAC) self-service data preparation?

Data flows have many built-in steps that can be used to prepare the data., Database data can be extended with spreadsheet data.

What does a single transaction mean in a sequence of data flows?

Multiple data flows in a sequence run one after the other. However, if any flow fails, all the changes made in the sequence are rolled back.

Which three could improve the results from Natural Language Query (NLQ) with oracle Day by Day

Pre-Catching NLQ metadata search elements , Synonyms, Acronyms

Which two statements are true about data wrangling?

In data wrangling, transformations available are dependent on the data type., It is used to perform some lightweight transformation within the data visualization UI

Which technique does data preparation in OAC use for recommendation with sensitive information such as SSN, Credit card number, and customer number.

Obfuscation to protect sensitive information.

How should you use Machine Learning Model within a canvas of an Oracle Analytics Cloud Project?

Create a scenario using the required model.

You are developer and are asked to create custom sales report for each of the 2,300 sales representatives, by using Oracle Analytics Cloud Enterprise Edition. Which tool must you use and why?

Pixel Perfect Reporting with bursting to create the sales report.

You need to curate data for Country Dimension and dependent Sales Facts that Store country sales data. How do you design the data flow and load data for these two seperate data sets in data storage.

Create two seperate data flows for the country and sales data sets. Then create a sequence where the data flow for Country is called first followed by the data flow for sales.

How should you determine the accuracy of a Machine Learning Model created using in Oracle Analytics Cloud.

Open the Inspect dialog for a given Machine Learning Model and review the F1 score.

Your Client wants you to build visualization that will help them understand their data better. Which two methods will help them achieve this?

Add trend lines, clustering and outliers to visualizations to offer new perspectives., Use the explain feature to quickly identify Basic Facts, Key Drivers, Segments, and Anomalies. Add the relevant visualization to a canvas.

Which service do you need to subscribe to for creating an Oracle Analytics Cloud (OAC) instance?

Oracle Analytics Cloud

You have a global data set for oil prices for a period of time for each country. However, you need to perform analysis on asian countries for a period of one month. Which two combinations of filters could you use to achieve this?

List and Data Range, List and Range

Your client want to implement a custom plug-in from Oracle Analytics Library. You just finished uploading the extension to Oracle Analytics Cloud (OAC). What action do you need to take before the extension is available for use in projects.

Refresh the Page.

You are a BI administrator of an Oracle Analytics Cloud (OAC) and you want to provide a power user access to create workbooks, and load data for data visualization, analysis, dashboard, and pixel-perfect reports. Which is application role must you grant to the user.

BI Data Model Author

You are creating an analytics solution for a financial institution using Oracle Analytics Cloud. One of the requirements is a workbook with a model identifies customers with multiple potential fraudulent transactions. Which algorithm would be the best fit for this purpose?

Anomaly Detection

You have data set of stocks with the columns date, MaxStockPrice and MinStockPrice. Which column cannot be removed when performing a trend analysis.

Date

Which of these steps is REQUIRED in data flow to create a new curated data set?

Add data

Your company wants to start auditing Pixel perfect reports and catalog objects. How do you enable auditing?

Select the enable monitor and audit check box, set audit level, create a jndi connection.