Ora

Which one is consisting Input and Output to produce the predictive data?. Model. Data set. All of them. Data flow.

You can share a Visualization, Canvas, or Story to social media. Which one in not part of available social media?. Slack. LinkedIn. Twitter. Facebook. Oracle Content and Experience (OCE). Oracle Social Network (OSN).

Trendline shows how one measure or business KPI relates with the other?. TRUE. FALSE.

When you Copy a Visualization or Canvas you can only within the same workbook. You can't past it to another open workbook, or to another workbook open in a different browser tab?. False. True.

You use an Image as a Map Background and Draw Map Layer Shapes on the Image, What are Custom Map Layer types? (Select three answers). Circle. Point. Square. Polygon. Line.

Analytics Task Classification are?. Descriptive. Prescriptive. Diagnostics. All of the above. Predictive.

When you copy a visualization or canvas from one workbook to another, Oracle Analytics Include? (Select four answers). Data. Filters. Calculations. Dashboard Prompts. Color Assignments.

Imported Projects with dva extension includes?. Connection credentials. Associated data set. Connection string. All of the above. Stored data.

You can Add Notes to Visualizations, can you add URL to open a website from Oracle Analytics?. Yes. No.

Which Data wrangling function can't be applied on Number data type?. Log. Square Root. Bin. Extract. Power. Quantile.

In which edition you can use Data Gateway?. All of them. Oracle Business Intelligence. Oracle Analytics Professional. Oracle Analytics Essbase. Oracle Analytics Cloud Enterprise.

When you Copy and Paste a Visualization's Data you can copy all of a visualization's data to the clipboard and then paste the data to another application like? (Select Two Answers). Microsoft Access. Notepad. Microsoft Excel. Microsoft Word.

In Narrate when you change the Present mode to ON, which tasks can you apply?. Drill through. Keep selected and remove selected. Apply a new filter, modify the existing filter and remove the existing filter. Sort data. All of them.

Narrate Presentation mode (Style)? (Select two answers). Distribution. Compact. ReportMode. Filmstrip.

Each dataset has an assigned, unique, fixed object ID. You can use this ID to?. All of them. Log an Oracle Support request. Help troubleshoot Oracle Analytics errors and issues. Search log files.

Bursting in BI Publisher is used for?. It's a process of splitting data into blocks, generating documents for each block, and delivering the documents to one or more destinations. Highlights a general pattern or direction of data when seen in relation to a time series. Highlight feature in selected items in the chart to effect in the other charts. When apply a filter or select a data set to reflect in all analysis in the canvases.

Master-Detail is defined through which tab in Column Properties?. Interaction. Style. Conditional Formatting. Data Format. Column Format.

Action links types? (Select two answers). Dashboard Action link. Named action link. Dashboard Prompt. Inline Action link.

You can add Notes to Visualizations, what is the maximum points to connect a note to data points on a visualization or canvas?. 5 data points. 1 data points. 16 data points. 10 data points.

Which statement is false for Data Gateway?. You can deploy multiple data gateway agents for high availability. You can deploy only single data gateway agent. For Personal type you install DG by copy DG binaries onto a Windows or MacOS machine. For Server type you install DG using Oracle university installer on Linux platform.

Which of the following is not part of Service Models?. SaaS. PaaS. Packaged Software. Iaas. Caas.

You can Embed a Visualization in a classic Dashboard?. True. False.

Use conditional formatting to highlight important data events in your visualizations so that you can take action. What can you do for each canvas? (Select four answers). Turn rules on and off for a canvas. Apply multiple rules to a canvas at the same time. Change the order in which rules are applied. Turn rules on and off for a visualization. Apply multiple rules to a measure at the same time.

You can explore your data at your desk and on the move using the browser in mobile devices, for which operating systems? (Select three answers). Linux. Android. Apple. Windows.

Multiple Subject area can be used through? (Select four answers). intersect. intersect all. Union. Union all. Minus. All of the above.

You have a data set that you wish to use to train a ML model. The attribute contains three text values (Good, Fair and Bad). How should you perform this operation?. Create a data flow that includes a step to train a Clustering model. Create a data flow that includes a step to train a Numeric Prediction model. Create a data flow that includes a step to train a Multi Classifier model. Create a data flow that includes a step to train a binary classifier model.

Classification and Regression are example of which ML algorithm?. All of the above. Supervised. Unsupervised. Reinforcement.

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

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 Reach report. Enable all the Dashboard Report links from Dashboard Properties and then the Report links for each Reach report. Enable all the Dashboard Report links from Dashboard Properties and then the Page Report links.

Your Oracle Analytics client asks you to shape a story and story and share it as a file. Which are three valid file types for sharing a story?. image (.png). AutoCad (.dxf). Acrobat (.pdf). Word (.docx). Package (.dva).

You have been given a spreadsheet that contribute to employee attrition data to determine the most important factors that contribute to employee attrition. What is the quickest way to start this analysis after uploading data to Oracle Analytics Cloud (OAC)?. Perform a cluster analysis of employees. Use Outlier identification. Use the Explain option on the Attrition attribute. Calculate a forecast of the probability of attrition.

How can Oracle Analytics Cloud (OAC) be used to categorize a large number of data points on a particular canvas?. Create a trend line and apply OAC Advanced Analytics. Create a cluster with a suitable number of groups for the specific analysis. Visualize the data by using a network chart. Use a combination of a tree diagram and a trellis visualization.

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

Which three statements are true about usage tracking in Oracle Analytics Cloud?. It is available only for Enterprise Edition. You create a new connection pool in Data Modeler. You create a new connection pool in the Oracle Analytics Developer Client tool. After a change has been made to the Usage Tracking Connection Pool setting in the console, a restart is required. It is available for both Professional and Enterprise Edition.

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 Time Dimension create feature of Oracle Analytics Cloud (OAC) What are the tasks performed by the Time Dimension wizard execution?. The Time Dimension wizard creates the Time dimension table in the database, load time data, and create the time dimension and hierarchy in the Data Model. The Time Dimension wizard generated the DDL query for the Time dimension table and inserts SQL for data load, which you need to run on your respective database schema. The Time Dimension wizard creates the time dimension table in the database, loads time data, and creates the time dimension in the Data Model. The Time Dimension wizard creates the Time dimension table in the database and loads time data.

Which two statements are true about Action Links?. Navigation from one analysis to another is not possible if they reside in different folders. A column's navigation option can be enabled conditionally. Presentation variables can be used while navigating from one analysis to another. Navigation from one analysis to another works only when both analyses are created from a single subject area.

Which three could improve the results from Natural Language Query (NLQ) with Oracle Day By Day?. Pre-caching NLQ metadata search elements. Acronyms. Synonyms. Exposing a limited number of data sets for Day By Day NLQ. Curating the exposed data sets by removing duplicate or unnecessary attributes.

Which two are true about dashboard prompts?. Prompts can be developed using only a single column. Prompt values can be limited based on values selected in other prompts. All prompts must be displayed on a single page. Repository variables and session variables can be used in prompt default values.

Oracle Applications Connector supports Oracle Fusion Applications Cloud. Which is valid about Oracle Applications Connector?. When abating a connection, enter the URL for Oracle Fusion Applications. When creating a connection, enter the Business Intelligence URL for Oracle Fusion Applications. The Active User's Credentials option in the Create Oracle Application Connection dialog box. It cannot be used with Oracle Applications Connector. It cannot connect to on-premises Oracle BI Enterprise Edition. It can be used with the Thin Client Modeler.

Which two filters can be applied to all Dimensional data types?. List. Date. Expression. Range.

What does a fact table use to reference dimension tables?. Dimension attribute. Primary key. Aggregate type. Foreign key. Master key.

You are creating a 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 table not be merged. What is the correct relational topology to model the patient dimension?. Distributed tree. Universe. Balance tree. Start.

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, and low. This is the property you set as the target. Which train data step is required to train a model in. Train Clustering. Train Text Prediction. Train Multi-Classifier. Train Multi-Value. Train Numeric Prediction. Train Binary-Classifier.

Identify the correct use of BI Ask. is used to power the type ahead functionality. is used to enter column names into the search hold, select them, and quickly see them added to a project. is used to search for projects. is used to search for visualizations. is used to enable user input in Natural Language. It extracts column names from the User Input and quickly build visuals for the columns extracted.

Your client has created new custom map layer. How can this map layer be exposed in a project?. Create a new project. Add a map visualization. Change the layer property to new. Click upload. Select the Json file to upload. Create a new project. Add a map visualization, change the layer property to new. click upload. Select the geojson file to upload. Navigate to the Console. Click Maps. From the Map Layers tab, upload the geojson file. Navigate to the Console. Click Maps. On the Map Layers tab, upload the xml file.

Which role is required to edit and create a new semantic model in Oracle Analytics Cloud Enterprise Edition?. BI Data Model Author. BI RPD Model Author. DV Consumer Role. BI Data Load Author. BI Content Author.

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. TODATE. AGO. PERIODROLLING. BI Content Author.

Which two are true about creating a story in Oracle Analytics Cloud?. Insight always take a snapshot data for a story. A story can have multiple canvases. A project can have only one story. You can only export the active visual.

You have created a Machine Learning model and investigated how accurate it is. How should you use it in Oracle Analytics Cloud (OAC)?. Connect to the model as a new project. Create Data Flow with a cumulative value prediction. Create a custom calculation based on a related formula. Use Data Flow with an Apply Model step and save as a new data set. Use a data flow with a Commit Model step and save as a new data set.

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 separate data sets in data storage? (Choose two). Create a single data flow that loads data to the Country data storage in the first step and then loaders data storage in the seconds the flows for the Country and Sales data sets. Create two separate data flows for the Country and Sales data sets. Then call one data flow from another. Create two separate data flows for the Country and Sales data sets. Then create a sequence flow for Country is called first followed by the data flow for Sales. Create data flows for the Country and Sales data sets. Then create a sequence where the data flow for Sales is called first followed by the data flow for Country.

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

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

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

A column in your data has a wide range of numerical values. You want to create a column that labels these values as Large, Medium, or Small. Which data preparation action helps you to accomplish this?. Convert. Bin. Extrapolate. Bundle.

Which are two use-cases for Data Flow?. To curate data sets that can be used for visualizations. Create a custom Python Machine Learning model. Perform some lightweight transformation within the Project. Train and test the Machine Learning model.

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

You have a global data set for oil prices for a period of time for each country. However, you need to perform analyses on Asian countries for a period of one month. Which two combinations of filters could you use to achieve this?. Expression and Date Range. Range and Expression. List and Range. Date Range and Top Bottom N. List and Date Range.

Which relational database schema consists than in single-dimension tables?. Network. Star schema. Sun Snowflake schema. Leaf.

Your client wants 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?. Enable the plug-in from the Plug-in menu. Restart the OAC instance. No additional action is needed. Refresh the page.

In Oracle Analytics Cloud (OAC), you can quickly search for saved objects. However, if your input or search criteria is not formed correctly, it will not return any results. What could be the problem with your input?. The input contains an asterisk (*) in the search text (for example, *revenue). The input contains the object name only as search text. The input contains a comma (,) in the search text. The input contains the date attribute in the year-month-day format.

You have the Bl Service Administrator application role and you are notified that a user cannot get answers when using Day by Day with Oracle Analytics Cloud Professional Edition. They asked a question related to an existing data set and the language was English. Which three statements are valid about investigating this issue?. Verify that the user has been assigned the BI Content Author and Bl Data Load Author roles. Inspect the data set and check the access control. Verify that the user is assigned the BI Content Author and DV Consumer roles. Day by Day does not work with Oracle Analytics Cloud Professional Edition. Inspect the data set and make sure that it is certified, indexed for searching, and English language is selected.

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 section and add a condition to change the scope. In the Dashboard editor, go to dashboard properties and charge the scope from Dashboard to Page. In the Prompt Configuration option, change the Choose input Type. In the Dashboard editor, edit the dashboard prompt properties and change the scope from Dashboard to Page.

You are designing an analytics solution for a company that distributes packaged foods for independent retailers. The solution requires self-service analytics capabilities for product management and In addition, highly formatted reports must be delivered by scheduled email to external resellers. Which edition of Oracle Analytics must you use?. OA Data Visualization Cloud. OAC Business Intelligence Edition. OAC Professional Edition. OAC Enterprise Edition. OA Fusion Analytics Warehouse Edition.

The Administrator has navigated to the console page and clicked on search index. Which three items can be included in the index?. User Folders. Templates. Shared Folders. Data Models. Content Folder.

You are a 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 (OAC) workbook. Which two configurations are appropriate for your solution?. Data set created with data preparation. Semantic model created in the OA Admin tool. Semantic model created in the Thin Client Modeler. Hierarchy created in a proper snowflake multi-table data set. Data set with a hierarchy created in OAC Data Flow. Data set merging a semantic model with the hierarchy and additional data.

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?. Range filter for Region and Date filter for sales Amount. List filter for Region and List filter for Sales Amount. List filter for Region and Expression filter for Sales Amount. List filter for Region and Range filter for Sales Amount.

Which type of report is an example of the bursting feature in Pixel Perfect Reporting?. Ad hoc reporting. Customized regional marketing reports. Interactive data exploration. Bar codes. Government PDF forms.

Which service do you need to subscribe for creating an Oracle Analytics Cloud (OAC) instance?. Oracle Back Storage. Oracle Autonomous Database. Oracle Analytics Cloud. Oracle Big Data Cloud Storage.

In which two layers can you use Oracle Analytics Cloud (OAC) to determine which values of a given data set may provide the greatest opportunity due to their outlier qualities?. Add an outlier visualization to your canvas. This will highlight data points that stand out and may justify further investigation. Modify the color palette to highlight unique values. Use a combination of Max/Min value reference lines. Create a box plot visualization of your data set.

Your client wants you to build visualizations that will help them understand their data better. Which two methods will help them achieve this?. Use the explain feature to quickly identify Basic Facts, Key Drivers, Segments, and Anomalies. Add the relevant visualizations to a canvas. Add trend lines, clustering, and outliers to visualizations to offer new perspectives. Create Data Flow to highlight interesting data. Create a sequence and schedule it to run on a nightly basis.

Which two are supported on the home page of a BI Ask visualization?. Opening visualizations in the Oracle Analytics Cloud home page to customize and add to a project. Drilling down on the visualizations. Saving visualizations displayed on the Oracle Analytics Cloud home page. View data from multiple data sets in a single query.

What does a trend line highlight in Oracle Analytics Cloud?. A general pattern or direction of data when viewed in relation to a time series. A line representing the median values of a measure. A general pattern or direction of data when viewed in relation to other dimensions. A line representing the average values of a measure.

Which application role must you grant to the user?. Bl Content Author. DV Content Author. Bl Data Model Author. Bl Dataload Author.

You have created a line chart visualization of revenue data at the day level. The chart display the last 365 days of data. Add a forecast and change the Period value to 3. Add 3 Relative Time filter for the next 3 months. Add a trend line and change the Method value to polynomial. Add a trend line and change the Method value to Exponential. Add a forecast and change the Period value to 90.

Which two can be used to display as prompts in your Publisher report?. Number filters. Lists of values. Date Filters. Expression Filters. List filters.

An analyst is creating a story on the Narrate tab of the project. What is the most likely reason they have done this?. To share the story on Day by Day with their decision makers. To share the story by exporting to MS Excel. To share the story with consumers on the Home Page. To share the story by exporting to pdf.

Using Narrate insight, you can take a snapshot of any moments 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? (Choose two). It is not possible to share Insights with other users. By default all users cannot share Insights. Insights is always shared in form of story so everybody will see the same information. Insights is shared as a story and everybody will see their information based on permissions.

Which two can be defined on a canvas in a story in Oracle Analytics Cloud?. Notifications. Filters. Notes. Narration.

In Oracle Analyt.es Cloud (OAC), an Enterprise BI application database has many dimensions. Which option helps you to visualize on a subset of the original data?. Sorting. Indexing. Filtering. Selecting.

Which two statements are true about Presentation Catalog?. You can grant ownership of items you create to other users. Catalog items can be set to read-only. My Folders can be shared with other users. To prevent corrupter, of the catalog, storage of objects of different types must be segregated into their own folders.

Which two statements are true about Oracle Analytics Cloud (OAC) self-service data preparation?. Database data can be extended with spreadsheet data. The Oracle Data Integrator (ODI) tool, which is used for extract, load, and transformation, foundational component of Oracle Analytics Cloud and is essential for data preparation. Data flows have many built-in steps that can be used to prepare the data. Joins can be created only in Oracle Analytics Cloud Data Modeler.

You are building a model that will be used for a sales report. Which two statements are the about hierarchy and levels?. Each level is based on one or multiple columns. Hierarchies enable drilling in reports. A hierarchy must have one to many relationships between attributes. Skipped levels and unbalanced hierarchies can be enabled for all the dimension tables. A hierarchy shows relationships among a group of columns in a fact table. A dimension table must have only one hierarchy. When defining a level. Key Columns must be the same as Display Columns.

You are creating an analytics solution for a financial institution using Oracle Analytics Cloud. One of the requirements is a workbook with a model that identifies customers with multiple potential in fraudulent transactions. Which algorithm would be the best fit for this purpose?. Support Vector Machine. Decision Tree. Anomaly Detection. Logistic Regression.

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

Which two steps do you perform to create a Relative Time filter?. Add a date column to the Filter bar. Select Relative Time as the filter type. Select Date Range as the filter type. Select Relative Time as the filter type and set the Relative To property.

Which two statements are true about data wrangling?. It is used to perform some lightweight transformation within the data visualization UI. In data wrangling, transformations available are dependent on the data type. It is used to tram and test the Machine Learning model. It is used to curate data sets that can be used for complex visualizations.

Which is a supported source for registering and using Machine Learning models7. Autonomous Data Warehouse. Mongo Database. SQL Server Oracle Data Science. Oracle Cloud Object Storage.

You have been tasked with building an analysis that requires data from two subject areas. How do you accomplish this?. Create two separate analyses and use the merge feature. A subject area must be modified to include all the columns required. Create an analysis and add a second subject area for a union. Create two separate analyses and use the union feature.

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. Change the project's properties to Always use Best Visualization. Select the Best Visualization option from the project's Canvas Settings drop-down menu. Select the desired data elements from the Data Elements pane and drag them to the Best visualization zone in the Explore pane.

How 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?. Spreadsheet. All Rows. Data Set Storage. Database Connection.

You have a data set of stocks with the columns Date, MaxStockPrice and MinStockPrince. Which column cannot be removed when performing a trend analysis?. Date. MintStockPrince. All columns are required. MaxStackPrince.

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