OAC Expert Certification
Which of the following are true about Variable Prompt in dashboards? (Choose three) - A variable prompt must be dependent upon a column - A variable prompt isn't dependent upon a column - A variable prompt enables the user to select a value that is specified in the variable prompt to display on the dashboard - You can override a selection step with a prompt
- A variable prompt enables the user to select a value that is specified in the variable prompt to display on the dashboard - A variable prompt isn't dependent upon a column - You can override a selection step with a prompt
What happens when you add data elements directly to a canvas? - You can't add data elements directly to a canvas. - A visualization will automatically be created. - You will be prompted to choose a visualization type.
- A visualization will be created
Which of the following products are part of Oracle Analytics Cloud? (Choose three) - Analysis and Dashboards - Essbase - Report Studio - Pixel Perfect Reporting
- Analysis and Dashboards - Essbase - Pixel Perfect Reporting
Users with the following application role can manage data models: - BI Consumer - BI Data model author - DV Data model author - DV consumer
- BI Data model author
When using the explain feature on attributes not measures, you can gather insights to your data by (pick 4): - Basic Facts - Anomalies - Segments - Disparities - Allocations - Key Drivers
- Basic Facts - Anomalies - Segments - Key Drivers
What 4 train model types are available in data flows? - Binary Classifier - Clustering - Segmentation Classifier - Multi-Classifier - Numeric Prediction
- Binary Classifier (Y/N) - Clustering (Categories) - Multi-Classifier (Groupings) - Numeric Prediction (Target)
Which of the following are true about Dashboard Prompts? (Choose three) - Can be saved in the Catalog as Prompt object for reuse - Created outside a specific dashboard - Appears on the dashboard page - Cannot be applied against any dashboard or dashboard page that contains the specified column
- Can be saved in the Catalog as Prompt object for reuse - Created outside a specific dashboard - Appears on the dashboard page
You need to create an ADW connection for your Enterprise Data Model. You can create this connection on what page? - Connections accessed in from Console Page. - Home Page - Data Page - Project Page
- Connections accessed in from Console Page.
Which of the following are use cases for Data Flows? - Create Machine Learning training models. - Create Projects - Apply Machine Learning training models. - Curate Data Sets
- Create Machine Learning training models. - Apply Machine Learning training models. - Curate Data Sets
You want to create an autonomous database. Which two workload types you can choose from? - Data Warehouse - Database - OLAP - Transaction Processing
- Data Warehouse - Transaction Processing
Pixel Perfect Reports is best suited for which purpose? - Ad hoc reporting. - Delivering highly formatted documents. - Map based reporting. - Creating dashboards.
- Delivering highly formatted documents.
Curating Data in DF
- Join datasets on proper column - Add select columns to customize - Add Filter - Add Save Dataset - Go back to data flows and run
The Day By Day mobile app is part of which Oracle Analytics Cloud edition? - Oracle Analytics Cloud Essbase - Oracle Analytics Cloud Plus - Oracle Analytics Cloud Enterprise - Oracle Analytics Cloud Standard
- Oracle Analytics Cloud Enterprise
OCPU is an acronym for: - Oracle Computer Units - Oracle Computer Processing Units - Oracle Client Processing Utility
- Oracle Compute Units
When applying a machine learning model, which columns can be created? - PredictionTotal - PredictedOutcome - PredictedValue - PredictionConfidencePercent - PredictionGroup
- PredictedOutcome - PredictionGroup - PredictionConfidencePercent
A well-designed data table should include what? - Primary keys, Foreign keys, & fact columns - Primary keys & descriptive columns - Primary keys & descriptive columns, & Facts - Primary keys & fact columns
- Primary keys & descriptive columns
Monitoring information is updated automatically. You can also run a health check to update the display of monitoring information at any time. What are the correct steps to explicitly run a health check? - Select an Analytics Cloud service on the OAC dashboard; click the Display monitoring information icon on the Overview pane; click the Export Healthcheck Details icon. - Select an Analytics Cloud service on the OAC dashboard; click the View Healthcheck Details Icon In the Resources section; click the Export Healthcheck Details icon. - Select an Analytics Cloud service on the OAC dashboard; click the Display monitoring information Icon on the Overview pane; click the View Healthcheck Details icon in the Resources section. - On the Overview pane, click the Display monitoring information icon and select an Analytics Cloud service; In the Resources section, click the View Healthcheck Details icon.
- Select an Analytics Cloud service on the OAC dashboard; click the Display monitoring information Icon on the Overview pane; click the View Healthcheck Details icon in the Resources section.
What is the criteria if you want to add trendline to your visualization? - Visualization should have a period column in both of its axes - Visualization should have a period column in one of its axes - Visualization should not contain any period column in either of its axes - None of the above
- Visualization should have a period column in one of its axes
Which statement is false about log files generated by Oracle BI Analyses? The log file is not accessible via the repository Administration client. Catalog Manager provides rapid access to the log file. An Analysis that references two fact tables will generate two database-specific SQL queries in the log file. The log file can be accessed via the Fusion Middleware Control.
An Analysis that references two fact tables will generate two database-specific SQL queries in the log file.
To add advanced analytic functions to a visualization, do one of the following:
Drag and drop an advanced analytic function (such as Clusters, Outliers, Reference Line) from the Analytics pane to a visualization. Right-click a visualization, and select an advanced analytic function.In the properties pane select the Analytics icon and click Add (+), then select a function such as Add Clusters or Add Outliers.
Search and BI Ask
If you use a comma in your search criteria the search returns no results! For example, if you want to search for quarterly sales equal to $665,399 and enter 665,399 in the search field, then no results are returned. However, entering 655399 does return results.
You have rainfall amount by date on a bar graph. Which data element if any are considered a measure? - Both rainfall and date - Neither - Just rainfall - Just date
Just rainfall
Time Dimension Wizard
The wizard allows the selection of hierarchy levels. Make the necessary adjustments, and click Next. Clicking Create creates the table, loads time data, and creates dimension and hierarchy. Data is at day level.
Which three statements about Agents are TRUE? - They can be run conditionally. - They can be used to seed the cache. - There is no method to override the recipient's delivery profile - They can be configured to run on a schedule.
They can be run conditionally. They can be used to seed the cache. They can be configured to run on a schedule.
Which option is false with respect to the Presentation Catalog Catalog Manager is a client administration tool that can be used to view and manage the Presentation Catalog. Object permissions for Analyses and Prompts can be archived along with the object in the catalog. Multiple objects can be archived into a single file. To prevent corruption of the catalog, storage of objects of different types must be segregated into their own folders.
To prevent corruption of the catalog, storage of objects of different types must be segregated into their own folders.
Why would an analyst create a story in the narrate tab? To share with others as pdf To have it in the homepage for consumers to use To have story available in Day to Day
To share with others as pdf
You've created a visualization of revenue data over time. The revenue data over time exhibits some curvature in the line visualization. What trending algorithm should you use to refine the trendline? Set the confidence interval to 95%. Use the linear option. Use the polynomial option. Use the exponential option.
Use the polynomial option.
Prompts & Variables
Variables Types - Presentation, Repository, Session, SQL Expression - Static: Physically changed - Dynamic: Scheduled SQL changes Prompts - filters that are embedded in a column, variable, image, & currency that create a more refined filter that can be called upon
How can you track usage on OAC?
Usage can be tracked in ADW, ATP, and Oracle DB's in the cloud (DBC) where the system stores usage in three database tables: Logical, Physical, & Initializing Block. You can also create a usage tracking schema user, Oracle Analytics Developer Client Tool (RPD file), or pull up "Real Time Sandbox Usage USA" .dva which is a prebuilt visual project of your query activity
OBIEE Migrate from 11g
download migration utility from OAC and export to JAR file
Narrate offers what four export options?
dva, png, pptx, & pdf
You created an Enterprise Edition instance with the BI - Enterprise Data Models feature set. Which 3 are valid URLS? - https://instancename-ocuocictrng16.analytics.ocp.oraclecloud.com/dv/ui - https://instancename-ocuocictrng16.analytics.ocp.oraclecloud.com/xmlpserver - https://instancename-ocuocictrng16.analytics.ocp.oraclecloud.com/analysis - https://instancename-ocuocictrng16.analytics.ocp.oraclecloud.com/analytics - https://instancename-ocuocictrng16.analytics.ocp.oraclecloud.com/ppr
- https://instancename-ocuocictrng16.analytics.ocp.oraclecloud.com/dv/ui - https://instancename-ocuocictrng16.analytics.ocp.oraclecloud.com/xmlpserver - https://instancename-ocuocictrng16.analytics.ocp.oraclecloud.com/analytics
Which of the following statements are TRUE about an Analysis? - A compound layout can have many views. - The maximum amount of views for an Analysis is 8. - A compound layout can have only a single view. - An Analysis can have more than one compound layout.
A compound layout can have many views. An Analysis can have more than one compound layout.
Which three of the following are TRUE about Hierarchies? - There is a limit to the number of levels you can have in a hierarchy. - A hierarchy shows relationships among groups of columns in a dimension table. - All hierarchies for a given dimension must have a common lowest level. - A dimension table can have one or more hierarchies.
A hierarchy shows relationships among groups of columns in a dimension table. All hierarchies for a given dimension must have a common lowest level. A dimension table can have one or more hierarchies.
Which two are TRUE about Master View? - A master view contains a master column, where you set up the interaction that sends master-detail events on a channel. - The master column can display on the page edge or section slider. - A channel carries master-detail events to the detail view. - All of these
A master view contains a master column, where you set up the interaction that sends master-detail events on a channel. A channel carries master-detail events to the detail view.
Sequence in data prep
A sequence is a saved sequential list of specified data flows and is useful when you want to run multiple data flows as a single transaction. If any flow within a sequence fails, then all the changes done in the sequence are rolled back. You can execute or schedule a sequence to run a specific time
What does a confusion matrix illustrate?
A table that reports the occurrences of false positives, false negatives, true positives, and true negatives for machine learning models
You have created a visualization of revenue data by date (at DAY level) for the last three years. What functionality should you use to create a prediction of ongoing revenue throughout the next three months? Create a custom calculation based on the revenue metric. Add a forecast with a forward period of approximately 90. Add a forecast with a forward period of 3. Add a trend line with exponential option.
Add a forecast with a forward period of approximately 90.
In which two ways can you use Oracle Analytics Cloud to determine which values of a given data set may provide the greatest opportunity due to their stand out qualities? (Choose two.) 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.
Add an outlier visualization to your canvas. This will highlight data points that stand out and may justify further investigation. Use a combination of Max / Min value reference lines.
You create a visualization of revenue data by date (at day level) for the past three years. You then add a forecast. How can you check the accuracy of the forecast? Add reference lines for the maximum and minimum. Combine a polynomial trend line with a suitable reference line. Change the model employed by the algorithm. Select the option to highlight the prediction interval for a given percentage.
Add reference lines for the maximum and minimum.
Map Layers
Add this layer by using a geometric data file with the .json extension Console > Maps > Add Custom Layer (has to be GeoJSON File) > Enter Name > Select Layer Keys > Add
How is a project with 3 visualizations displayed on mobile using a project link? All same size First one 50%, other two 25% Can't view projects in mobile
All same size
Data Gateway
Allows us to connect to on-premise data sources to pull data to OAC remotely There are two types: Server & Personal Plug in URL & gather auto generated json Key from DG agent Can deploy multiple agents to enhance performance
Which two statements are true regarding the source of Oracle BI Enterprise Edition Analyses? (Choose two.) Analyses can be created from multiple subject areas as long as at least one metric is included from each, and the Dimensionality Flag is enabled. Analyses can be created from multiple business models as long as they contain common, conformed dimensions. Analyses cannot be created from multiple subject areas even though they contain common, conformed dimensions. Analyses can be created with measures from multiple physical tables defined as sources in a single logical fact table
Analyses can be created from multiple business models as long as they contain common, conformed dimensions. Analyses can be created with measures from multiple physical tables defined as sources in a single logical fact table
In order to navigate from DV into a publisher report you need to use what data action? - URL Navigation - Publish - HTTP API - Analytics Link
Analytics Link
A bank has a requirement for detecting fraudulent transactions in customer accounts. This could be very rare across all customer accounts over a period of time. Which algorithm or approach will you use to accomplish this? - Support Vector Machine - Decision Tree - Anomaly detection - Logistic Regression
Anomaly detection
Which two statements are true regarding configuring filters to control visual content? (Choose two.) Expression filters cannot be applied in the filter steps of Oracle Analytics Cloud Data Visualization data flows. Variables may be employed in all Data Visualization filter types (that is, Range, List, Date, Expression). Application role filters for fact and dimension tables are defined in the Oracle Analytics Cloud Data Modeler. When the Oracle Business Intelligence Enterprise Edition repository is used as a data source, filters defined in the initialization blocks with the client administration tool are automatically inherited in Data Visualization.
Application role filters for fact and dimension tables are defined in the Oracle Analytics Cloud Data Modeler. When the Oracle Business Intelligence Enterprise Edition repository is used as a data source, filters defined in the initialization blocks with the client administration tool are automatically inherited in Data Visualization.
Audit Data Modeler
Auditing enables information to be collected about data models downloaded from the repository. You can use auditing features to track how long queries take to process, which tables and columns are used most often, and even record the full SQL statement that is sent to the database. Steps: - Create a document repository with an inventory of distributed data models. - Create a database table in which to log audit events. - Use data model options to define events that you want to audit for each data model. - Save the audited data models to the document repository. - Use Interactive Reporting to query the audit table and to analyze the data it contains.
You are trying to get a quick view of the number of orders placed without having to create a project. In the "What are you interested in" field of the home page, you enter the search string Number of Orders and BI Ask search returns a visual of order numbers. Select two options that describe what occurred. (Choose two.) The indexes that BI Ask uses to search are corrupt and cache needs to be cleared. BI Ask used fuzzy logic to determine that you really wanted a list of the order numbers and complied. There is no metric defined with the name Number of Orders. Resubmit the search using a wildcard. There is no metric defined with the name Number of Orders. Resubmit with another variation of the name (for example, # of Orders) and see if results are returned.
BI Ask used fuzzy logic to determine that you really wanted a list of the order numbers and complied. There is no metric defined with the name Number of Orders. Resubmit with another variation of the name (for example, # of Orders) and see if results are returned.
You uploaded a data set in OAC using Data Wrangling. What two can be used to edit a column when preparing the data? - Bin - Mod - Sentence Case - Floor
Bin & Sentence Case
What is the best way to Migrate from OBIEE to OAC? - Migrate from OBIEE 12c - Migrate from OBIEE 11g - You cannot upgrade - Both A and B
Both A and B
Which statement are true with respect to the ability to adjust visualization properties when placing multiple visuals on a canvas? Change the visual's location on a canvas by selecting and dragging it to the desired location. Duplicate a visual that is on the canvas, changing the visual type in the duplicated visual. Resize the canvas by changing the Canvas Layout option from Auto Fit to Freeform. Hide a visual by right-clicking the canvas and selecting Hide from the drop-down menu.
Change the visual's location on a canvas by selecting and dragging it to the desired location. Duplicate a visual that is on the canvas, changing the visual type in the duplicated visual. Resize the canvas by changing the Canvas Layout option from Auto Fit to Freeform.
You created a sort on the Year Column. What happens If you click Sort Ascending on the Quarter column? - This would happen if Add Ascending Sort was clicked. - Clicking Sort Ascending on Quarter will remove the sort on Year. - The only way to sort is by grouping. - The analysis will first be sorted on Year and then it will be sorted on Quarter. - You can only sort on a single column.
Clicking Sort Ascending on Quarter will remove the sort on Year.
What are the two steps to create a relative time filter? Click the filter context menu, select Filter Type on date columns that already exist in the data source, and Relative Time to switch to a relative time filter. Click the filter context menu, select Filter Type on Year or Quarter, and Relative Time to switch to a relative time filter. Apply relative time filter on any date element Select the type, number of increments, & time level - details
Click the filter context menu, select Filter Type on date columns that already exist in the data source, and Relative Time to switch to a relative time filter. Select the properties - type, number of increments, & time level
You've created a machine learning model and investigated how accurate it is. How should you use it in Oracle Analytics Cloud? Use a data flow with a Commit Model step and save as a new data set. Create a custom calculation based on a related formula. Connect Model directly inside a project Embed the model into a data flow sequence. Create a data flow with a cumulative value prediction
Connect Model directly inside a project
How can Oracle Analytics Cloud be used to visualize group relationships between data points on a particular canvas Use a variety of colors for each data point. Create a cluster with a suitable number of groups for the specific analysis. Use a combination of a tree diagram and a trellis visualization. Visualize the data by using a network chart.
Create a cluster with a suitable number of groups for the specific analysis.
You have a data set that you wish to use to train a machine learning model in Oracle Analytics Cloud. The attribute you are interested in predicting has one of two text values (e.g. Yes/No or True/False). How should you perform this operation? Create a data flow that includes a step to train a fuzzy prediction model and save the model for later use. Create a data flow that includes a step to analyze sentiment and save the model for later use. Create a data flow that includes a step to train a clustering model and save the model for later use. Create a data flow that includes a step to train a binary classifier model and save the model for later use.
Create a data flow that includes a step to train a binary classifier model and save the model for later use.
How should you use a machine learning model within a canvas of an Oracle Analytics Cloud project? Create a custom calculation. Create a scenario using the required model. Use the machine learning model visualization. Create a data sequence.
Create a scenario using the required model.
You have created a visualization of revenue data over time. It displays some seasonality (e.g. high revenue around typical holiday periods) but there is no obvious pattern to the data overall. In which two ways can you start to get insight from this data? (Choose two.) Create a trend line. Create a column trellis over the prominent dimension value. Add a filter to remove the oldest data. Create a reference line which displays the average revenue
Create a trend line. Create a reference line which displays the average revenue
BI publisher: what are two correct steps when creating pixel perfect reports with BI Publisher? (Choose two.) Generate and save to a folder in the Presentation Catalog a sample set of data that can be used for configuring and testing the report. Define a data model to set the business view of the data, join data sets, and create custom measures. Create connections to sources, some of which include Oracle 10g/11g, Oracle BI Server, JDBC, and MS SQL Server 2005/2008. Test connections between BI Publisher and configured sources using Oracle Fusion Middleware Control.
Create connections to sources, some of which include Oracle 10g/11g, Oracle BI Server, JDBC, and MS SQL Server 2005/2008. Generate and save to a folder in the Presentation Catalog a sample set of data that can be used for configuring and testing the report.
How do you download a wallet?
DB connection > choose wallet > click Download Wallet > insert password and retype > download wallet
When creating a data flow, where can you save the data to?
Data Set Storage & Database Connection
What statements are true regarding how Data Flow Sequences can be configured? Sequences can be configured to fork multiple Data Flows to be run in parallel so as to complete data preparation more quickly than running flows serially. Data Set prepare execution can be encapsulated by embedding Sequences inside of other Sequences. To remove an item from a Sequence, click the Action menu icon at the far right of the line upon which the item is found and then select Remove from the drop-down menu. To change the order of an item in the Sequence, the item can be selected by clicking it and dragging it up or down. It will be placed immediately below the highlighted item.
Data Set prepare execution can be encapsulated by embedding Sequences inside of other Sequences. To remove an item from a Sequence, click the Action menu icon at the far right of the line upon which the item is found and then select Remove from the drop-down menu. To change the order of an item in the Sequence, the item can be selected by clicking it and dragging it up or down. It will be placed immediately below the highlighted item.
Which two statements are true about the Data Sync functionality? (Choose two.) Data Sync can create and manage surrogate keys in target tables. Data Sync is the only mechanism available in Oracle Analytics Cloud Standard Edition for loading data into DBaaS tables. To manage extractions and loads from cloud-based sources, DataSync can invoke the REST APIs of the Oracle Database Cloud Service as well as the Oracle Business Intelligence Cloud Service. Data Sync cannot load incremental source insertions and updates; only full refresh loads are supported.
Data Sync can create and manage surrogate keys in target tables. To manage extractions and loads from cloud-based sources, Data Sync can invoke the REST APIs of the Oracle Database Cloud Service as well as the Oracle Business Intelligence Cloud Service.
Which two statements are true regarding the ways in which Oracle Analytics Cloud provides self-service data preparation capabilities? (Choose two.) The Oracle Data Integrator tool used for extraction, load, and transformation of data is a foundational component of the Oracle Analytics Cloud and is essential for data preparation. Join rules for mashing up data from relational sources and delimited flat files can only be defined within the Oracle Analytics Cloud Data Modeler. Data flows within the data preparation feature of Data Visualization can be used to extract, wrangle, and format data content from all supported data sources to create data sets upon which visuals may be constructed. Data sources can include application tables, data warehouses, data lake reservoirs, delimited flat files, and Microsoft Excel spreadsheets in the .xlsx format.
Data flows within the data preparation feature of Data Visualization can be used to extract, wrangle, and format data content from all supported data sources to create data sets upon which visuals may be constructed. Data sources can include application tables, data warehouses, data lake reservoirs, delimited flat files, and Microsoft Excel spreadsheets in the .xlsx format.
Extract option in data wrangling function is available for which data type? - Attribute - Measure - Date
Date
Which two elements does a well modeled Fact Table consist of? (Choose two.) Dimension Keys REST APIs Nulls Measures
Dimension Keys Measures
Which two are Oracle Analytics Cloud Editions? - Enterprise - Professional - Standard - Special
Enterprise (can migrate) Professional (visualization)
Expressions
Filters that can run functions within Analysis - Aggregate, time series, and advanced
What are the two data viewing options for paging content on a Table? - Moving headers with scrolling content. - Fixed headers with scrolling content. - Page numbering - Content Paging
Fixed headers with scrolling content. Content Paging
OAC Day by Day
Innovative App that learns your interests based on your searches, follows your patterns, and generates cards
Which two statements are true about the Oracle Analytics Cloud Explain functionality? - It can identify hidden groups in data. - It can be used only for measure columns. - It can be used only for attribute columns. - It can enable users with insight on data.
It can identify hidden groups in data. It can enable users with insight on data.
Which two statements are true about a segment as defined in the Oracle Analytics Cloud machine learning functionality? (Choose two.) It is a component of the output from the Explain functionality. It is a component of a data flow sequence. It is the resulting data set after applying a filter in a data flow. It is a statistically determined group of data points that may contribute to predicting the value of an attribute of interest.
It is a component of the output from the Explain functionality. It is a statistically determined group of data points that may contribute to predicting the value of an attribute of interest.
Moving from OAS to OAC (one way move)
Lift and Shift method from On-Premise RPD file to OAC steps: - replicate data to ADW - point RPD to ADW - check global consistency - upload RPD to OAC
Types of filters:
List (Applied to all data elements that are attributes) Date (Use calendar controls to adjust time or date selections) Range (Applied to data elements that are measures & dates) Expression (Advanced filters applied on all) Relative Time (Enable you to filter relative to today's date)
Which step is required to create a new curated Data Set comprised of columns from several existing Data Sets? Merge Columns Add Data Aggregate Filter
Merge Columns
Which of the following cannot be done with Data Visualization to shape stories? Visual canvases can be resized and the Auto Fit setting can be disabled. Enhance narrative transition by rearranging and/or hiding Insight canvases. Create filters to focus upon pertinent data points. Multiple projects can be combined into one project by clicking on the Share icon in the Narrate menu bar.
Multiple projects can be combined into one project by clicking on the Share icon in the Narrate menu bar.
What service do you need to create an OAC instance: - OAC - ADW - OCP
OAC
What is a typical relationship between levels in a dimension hierarchy going from top to bottom? Many to Many Relationship One to Many Relationship Zero Cardinality Multiple Relationship
One to Many Relationship
How should you determine the accuracy of a machine learning model created in Oracle Analytics Cloud? 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. Create a data flow that includes a histogram. Use the debug option in the data flow where the model was created.
Open the Inspect dialog for a given machine learning model and review the F1 score.
Which of the following Service Model contains the Service Oracle Analytics in Oracle Cloud? - DaaS - PaaS - IaaS - SaaS
PaaS (Apps & Data)
Your customer is looking to get a better understanding of their data, in particular how Oracle Analytics Cloud can help them gain a competitive advantage. Which two tasks can help them achieve their goals? (Choose two.) Import the data into Oracle Analytics Cloud and use the Data Tile functionality in the Prepare section of the product. Use the resulting combination of visualization types to determine relationships and avenues for further exploration. Perform analysis on the data by using trend lines, clustering, and outlier detection to offer new perspectives. Create a data story by using the narrate functionality to present to their management. Create a data flow to highlight the interesting data
Perform analysis on the data by using trend lines, clustering, and outlier detection to offer new perspectives. Create a data story by using the narrate functionality to present to their management.
You want to create a filter that restricts access to the Fact table so that Revenue is only visible to users assigned to a particular role.In which tab should you set this up? Permissions Row Level Data Table Filter Data Filters
Permissions
Brushing
Plugin that brushes/highlights charts in the canvas based on the dimension value. (key)
Which two statements pertaining to Action Links are true? (Choose two.) Navigation from one Analysis to another Analysis is not possible if they reside in different folders. The Navigation option on a column can be enabled conditionally. Navigation from one Analysis to another Analysis only works when both analyses are created from single subject area. Presentation variables can be used while navigating from one Analysis to another Analysis.
Presentation variables can be used while navigating from one Analysis to another Analysis. The Navigation option on a column can be enabled conditionally.
Which statement is true with respect to Dashboards? All the Analyses placed on a dashboard must be sourced from the same subject area. Prompts on the dashboards can be shared between different pages of a dashboard. Multiple Analyses can be arranged into different columns and sections with different sizes on a dashboard. Options for the Export and Refresh report links can be enabled globally at the dashboard level.
Prompts on the dashboards can be shared between different pages of a dashboard. Multiple Analyses can be arranged into different columns and sections with different sizes on a dashboard. Options for the Export and Refresh report links can be enabled globally at the dashboard level.
Know the Different Data Elements
Qualitative (Attributes): contains descriptive facts or dimensions such as names, dates, or geographical data Quantitative (Measures): contains numeric values such as revenue, quantity, or sales
Input a custom plug-in you already uploaded to OAC, what do you have to do to start using it. Plug-ins option and enable the plug-in Refresh the page Restart OAC Download
Refresh the page
Which statement is true with respect to Dashboard Prompts? Prompt values can be limited based on requirements. Repository variables and session variables can be used in prompt default values. Prompts can be developed using multiple columns from different subject areas. Images can be used in the prompts.
Repository variables and session variables can be used in prompt default values. Prompts can be developed using multiple columns from different subject areas. Images can be used in the prompts.
Oracle Analytics Cloud offers several visualization options for presenting query results. How do you explicitly invoke "best visualization" in Oracle Analytics Cloud? (pick two) Select the desired data elements from the Data Elements pane and drag them onto the Best Visualization zone in the Explore pane. Drag the Data Elements onto the Data Visualization canvas and let the tool determine the 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, right-click and select "Create Best Visualization" from the drop-down menu
Select the desired data elements from the Data Elements pane, right-click and select "Create Best Visualization" from the drop-down menu Drag the Data Elements onto the Data Visualization canvas and let the tool determine the best visualization.
You have a binary classifier model with 10 variables in it. If you remove three highly correlated variables how would this affect the accuracy of the model?
Since binary classification is supervised learning, removing any inputs would affect the output/accuracy. However, since they are very similar variables, removing each one individually would have the same impact.
What are the two commonly used dimensional modeling schemas? (Choose two.) Star Sun Moon Snowflake
Star Snowflake
You have added new columns to the source table. What should you do to include the new columns in your data model? Update Data Model Add Columns from Database Synchronize with Database Connect to Tables
Synchronize with Database
OBIEE Migrate from 12c
Use Weblogic Scripting Tool (WLST) to export your content to BAR file
You've been given a spreadsheet of employee attrition data and have been asked to determine which are the most important factors that contribute to whether an employee is likely to leave their position. What is the quickest way to start this analysis after uploading the data to Oracle Analytics Cloud? Calculate a forecast of the probability of attrition. Use Outlier identification. Use the Explain option on the attrition attribute. Perform a cluster analysis of employees.
Use the Explain option on the attrition attribute.
Which statement is false regarding arrangement of visuals on a canvas? Visuals can be stacked one on top of another. Visuals can be arranged vertically, one visual beside another. Visuals cannot be arranged automatically. Visuals can be arranged horizontally, one visual above another.
Visuals can be stacked one on top of another.
What is required for Oracle Analytics to connect to an ADW? - Wallet & Credentials - Stopwatch - TNS Descriptor - Suitcase
Wallet & Credentials
Function Shipping
With the integration of OAC and ADW, business analysts can easily take advantage of the advanced analytics capabilities built into the Oracle database through Data Flows. With this enhancement a business analyst can launch actions such as a market basket analysis from within OAC by leveraging the power of function shipping, the process of moving logical services to the physical areas of a system where they can be optimally run. these new outputs are shipped to Spark where you can see all the stored SQL query data. (invoking functions where the data lives)
Which statement is true when migrating content from Oracle BI Enterprise Edition 12c to Oracle Analytics Cloud? At this time there is no option to migrate Oracle BI Enterprise Edition 11g content to Oracle Analytics Cloud. Both the Oracle BI Enterprise Edition 12c Data Model and the Catalog must be migrated to Oracle Analytics Cloud. They cannot be migrated independently. You can migrate a snapshot from Oracle BI Enterprise Edition 12c to Oracle Analytics Cloud. You can only migrate an Oracle BI Enterprise Edition 12c Data Model to Oracle Analytics Cloud. Catalog migration is not allowed.
You can migrate a snapshot from OBIEE 12c to Oracle Analytics Cloud.
If you were given revenue amounts, how would a sum function fill in column 2? Column 1. Column 2 1000 2000
if agg sum (SUM, SUMDISTINCT) = 3000, 3000 if running agg sum (MSUM, RSUM) = 1000, 3000 respectively
