OAC Expert Certification

Study online at https://quizlet.com/_9t2t0v

1. Extract option in data wrangling function is available for which data type?

- Attribute
- Measure
- Date: Date
2. A bank has a requirement for detecting fraudulent transactions in cus-
tomer 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
3. 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.
4. 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.

1 / 28
 OAC Expert Certification
Study online at https://quizlet.com/_9t2t0v
5. 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.

6. What service do you need to create an OAC instance:

- OAC
- ADW
- OCP: OAC
7. 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.

8. 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
2 / 28
 OAC Expert Certification
Study online at https://quizlet.com/_9t2t0v
- Content Paging: Fixed headers with scrolling content.

Content Paging
9. 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.

10. 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.
11. 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

3 / 28
 OAC Expert Certification
Study online at https://quizlet.com/_9t2t0v
12. Which two are Oracle Analytics Cloud Editions?

- Enterprise
- Professional
- Standard
- Special: Enterprise (can migrate)

Professional (visualization)
13. Which of the following Service Model contains the Service Oracle Ana-
lytics in Oracle Cloud?

- DaaS
- PaaS
- IaaS
- SaaS: PaaS (Apps & Data)
14. 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

15. 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.

4 / 28
 OAC Expert Certification
Study online at https://quizlet.com/_9t2t0v
16. 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

17. 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.
18. What is required for Oracle Analytics to connect to an ADW?

- Wallet & Credentials

- Stopwatch
- TNS Descriptor
- Suitcase: Wallet & Credentials
19. 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
20. OCPU is an acronym for:

- Oracle Computer Units

- Oracle Computer Processing Units
- Oracle Client Processing Utility: - Oracle Compute Units
21. You created an Enterprise Edition instance with the BI - Enterprise Data
Models feature set. Which 3 are valid URLS?
5 / 28
 OAC Expert Certification
Study online at https://quizlet.com/_9t2t0v

- https://instancename-ocuocictrng16.analytics.ocp.oraclecloud.com/dv/ui

-
https://instancename-ocuocictrng16.analytics.ocp.oracle-
cloud.com/xmlpserver

- https://instancename-ocuocictrng16.analytics.ocp.oraclecloud.com/analy-
sis

- https://instancename-ocuocictrng16.analytics.ocp.oraclecloud.com/ana-
lytics

- 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
22. 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
23. 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
24. When using the explain feature on attributes not measures, you can
gather insights to your data by (pick 4):

6 / 28
 OAC Expert Certification
Study online at https://quizlet.com/_9t2t0v
- Basic Facts
- Anomalies
- Segments
- Disparities
- Allocations
- Key Drivers: - Basic Facts
- Anomalies
- Segments
- Key Drivers
25. 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)
26. When applying a machine learning model, which columns can be creat-
ed?

- PredictionTotal
- PredictedOutcome
- PredictedValue
- PredictionConfidencePercent
- PredictionGroup: - PredictedOutcome
- PredictionGroup
- PredictionConfidencePercent
27. 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)

7 / 28
 OAC Expert Certification
Study online at https://quizlet.com/_9t2t0v
28. 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
29. 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.

30. 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.
31. 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.

8 / 28
 OAC Expert Certification
Study online at https://quizlet.com/_9t2t0v
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 differ-
ent sizes on a dashboard.

Options for the Export and Refresh report links can be enabled globally at the
dashboard level.
32. 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.
33. 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.
9 / 28
 OAC Expert Certification
Study online at https://quizlet.com/_9t2t0v

Use a combination of Max / Min value reference lines.

34. 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.
35. 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.
36. 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.
10 / 28
 OAC Expert Certification
Study online at https://quizlet.com/_9t2t0v

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.

37. What are the two commonly used dimensional modeling schemas?
(Choose two.)

Star
Sun
Moon
Snowflake: Star
Snowflake
38. 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.

11 / 28
 OAC Expert Certification
Study online at https://quizlet.com/_9t2t0v
39. 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.
40. 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.
41. 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).
12 / 28
 OAC Expert Certification
Study online at https://quizlet.com/_9t2t0v

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.: Appli-
cation 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.
42. 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, Ora-

cle 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.
43. 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.

13 / 28
 OAC Expert Certification
Study online at https://quizlet.com/_9t2t0v

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.
44. 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.
45. Which statement is true when migrating content from Oracle BI Enter-
prise 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 indepen-
dently.

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.
46. Which two statements are true about the Data Sync functionality?
(Choose two.)

14 / 28
 OAC Expert Certification
Study online at https://quizlet.com/_9t2t0v
Data Sync can create and manage surrogate keys in target tables.

Data Sync is the only mechanism available in Oracle Analytics Cloud Stan-
dard 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.
47. Which two elements does a well modeled Fact Table consist of? (Choose
two.)

Dimension Keys
REST APIs
Nulls
Measures: Dimension Keys
Measures
48. 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
49. 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.

15 / 28
 OAC Expert Certification
Study online at https://quizlet.com/_9t2t0v
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.
50. 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.
51. Which two statements are true regarding the ways in which Oracle An-
alytics 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.

16 / 28
 OAC Expert Certification
Study online at https://quizlet.com/_9t2t0v
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 reser-
voirs, delimited flat files, and Microsoft Excel spreadsheets in the .xlsx format.
52. 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

53. 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.

17 / 28
 OAC Expert Certification
Study online at https://quizlet.com/_9t2t0v
Visuals can be arranged horizontally, one visual above another.: Visuals can
be stacked one on top of another.
54. 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
55. 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.
56. 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 function-
ality 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
18 / 28
 OAC Expert Certification
Study online at https://quizlet.com/_9t2t0v
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 manage-
ment.
57. 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.
58. 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
59. You've been given a spreadsheet of employee attrition data and have
been asked to determine which are the most important factors that con-
tribute 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.

19 / 28
 OAC Expert Certification
Study online at https://quizlet.com/_9t2t0v

Use the Explain option on the attrition attribute.

Perform a cluster analysis of employees.: Use the Explain option on the attrition
attribute.
60. 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
61. How do you download a wallet?: DB connection > choose wallet > click
Download Wallet > insert password and retype > download wallet
62. 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
63. 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
64. 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

65. Prompts & Variables: Variables Types - Presentation, Repository, Session,
SQL Expression
- Static: Physically changed
20 / 28
 OAC Expert Certification
Study online at https://quizlet.com/_9t2t0v
- 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
66. OAC Day by Day: Innovative App that learns your interests based on your
searches, follows your patterns, and generates cards
67. Expressions: Filters that can run functions within Analysis - Aggregate, time
series, and advanced
68. Which two statements are true regarding the source of Oracle BI Enter-
prise 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
69. 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.

21 / 28
 OAC Expert Certification
Study online at https://quizlet.com/_9t2t0v
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.
70. 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-spe-
cific 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.
71. Brushing: Plugin that brushes/highlights charts in the canvas based on the
dimension value. (key)
72. 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.
73. 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
74. OBIEE Migrate from 11g: download migration utility from OAC and export to
JAR file
75. OBIEE Migrate from 12c: Use Weblogic Scripting Tool (WLST) to export your
content to BAR file
76. You uploaded a data set in OAC using Data Wrangling. What two can be
used to edit a column when preparing the data?
22 / 28
 OAC Expert Certification
Study online at https://quizlet.com/_9t2t0v

- Bin
- Mod
- Sentence Case
- Floor: Bin & Sentence Case
77. 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.
78. Narrate offers what four export options?: dva, png, pptx, & pdf
79. 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
80. 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
81. Monitoring information is updated automatically. You can also run a
health check to update the display of monitoring information at any time.
23 / 28
 OAC Expert Certification
Study online at https://quizlet.com/_9t2t0v
What are the correct steps to explicitly run a health check?

- Select an Analytics Cloud service on the OAC dashboard; click the Dis-
play 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 Dis-
play 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.
82. Know the Different Data Elements: Qualitative (Attributes): contains descrip-
tive facts or dimensions such as names, dates, or geographical data

Quantitative (Measures): contains numeric values such as revenue, quantity, or

sales
83. 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
84. 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
85. Which of the following are true about Variable Prompt in dashboards?
(Choose three)
24 / 28
 OAC Expert Certification
Study online at https://quizlet.com/_9t2t0v

- 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

86. 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

87. 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

25 / 28
 OAC Expert Certification
Study online at https://quizlet.com/_9t2t0v
88. What does a confusion matrix illustrate?: A table that reports the occur-
rences of false positives, false negatives, true positives, and true negatives for
machine learning models
89. 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.
90. 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.
91. 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

92. 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

93. 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

26 / 28
 OAC Expert Certification
Study online at https://quizlet.com/_9t2t0v

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

94. 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

95. 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)
96. To add advanced analytic functions to a visualization, do one of the fol-
lowing:: 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 proper-

ties pane select the Analytics icon and click Add (+), then select a function such
as Add Clusters or Add Outliers.
97. 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
98. 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.

27 / 28
 OAC Expert Certification
Study online at https://quizlet.com/_9t2t0v
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
99. When creating a data flow, where can you save the data to?: Data Set
Storage & Database Connection
100. 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

28 / 28