OAC Certification || A+ Guaranteed.
1. The extensive palette of visualization options delivered with Oracle Analytics Cloud can be
extended with custom plugins. What option is false about implementing custom visualization
plugins?
- The bicreateplugin script, provided with Oracle Analytics Cloud, can be used to create a
skeleton visualization to facilitate custom development.
- Oracle Analytics Cloud provides a Software Development Kit (SDK) to enable builds of
custom plugins.
- To be implemented, custom plugins must be deployed in the Bi_HOME\Analytics\src\
customVi2 directory and BI Services need to be restarted.
- Plugins for rendering sophisticated visuals can be downloaded from the Oracle Data
Visualization Library. correct answers - To be implemented, custom plugins must be deployed in
the Bi_HOME\Analytics\src\customVi2 directory and BI Services need to be restarted.
2. Which feature does the Data Lake Edition uniquely offer?
- Use the Day by Day mobile app
- Execute data flows on Apache Spark
- Migrate content from your existing on-premises environment
- Live optimized connectivity to your on-premises database correct answers - Execute data flows
on Apache Spark
4. Which two elements does a well modeled Fact Table consist of?
- Dimension Keys
- REST APIs
- Nulls
- Measures correct answers - Dimension Keys
- Measures
3. 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. correct answers Add a forecast with a forward period
of approximately 90.
5. Which is not a step that can be followed to create a Story?
- Create and position annotations on the canvas as desired.
- Capture a story insight from one or more Visualization canvases in a project by navigating from
Visualize to Narrate and dragging the desired Visualization canvas(es) onto the Narration
canvas.
- Share the Story in presentation mode by setting the reportMode parameter in the project
properties to FullDisplay.
- Create a new project for the Story by clicking the Save As button in the project toolbar. correct
answers - Share the Story in presentation mode by setting the reportMode parameter in the
project properties to FullDisplay.
6. Oracle Analytics Cloud offers several visualization options for presenting query results. How
do you explicitly invoke "best visualization" in Oracle Analytics Cloud?
- Select the desired data elements from the Data Elements pane and drag them onto the Best
Visualization zone in the Explore pane
- Drag an entire Data Set from the Data Elements pane 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. correct answers - Select the desired data elements
from the Data Elements pane, right-click and select "Create Best Visualization" from the drop-
down menu.
7. 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. correct answers - Create a cluster with a suitable
number of groups for the specific analysis.
8. 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 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. correct answers - You can migrate a snapshot from
Oracle BI Enterprise Edition 12c to Oracle Analytics Cloud.
9. Which two statements are true about the Data Sync functionality?
- 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, Data Sync 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. correct answers - 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.
- Data Sync can create and manage surrogate keys in target tables.
10. 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.
1. The extensive palette of visualization options delivered with Oracle Analytics Cloud can be
extended with custom plugins. What option is false about implementing custom visualization
plugins?
- The bicreateplugin script, provided with Oracle Analytics Cloud, can be used to create a
skeleton visualization to facilitate custom development.
- Oracle Analytics Cloud provides a Software Development Kit (SDK) to enable builds of
custom plugins.
- To be implemented, custom plugins must be deployed in the Bi_HOME\Analytics\src\
customVi2 directory and BI Services need to be restarted.
- Plugins for rendering sophisticated visuals can be downloaded from the Oracle Data
Visualization Library. correct answers - To be implemented, custom plugins must be deployed in
the Bi_HOME\Analytics\src\customVi2 directory and BI Services need to be restarted.
2. Which feature does the Data Lake Edition uniquely offer?
- Use the Day by Day mobile app
- Execute data flows on Apache Spark
- Migrate content from your existing on-premises environment
- Live optimized connectivity to your on-premises database correct answers - Execute data flows
on Apache Spark
4. Which two elements does a well modeled Fact Table consist of?
- Dimension Keys
- REST APIs
- Nulls
- Measures correct answers - Dimension Keys
- Measures
3. 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. correct answers Add a forecast with a forward period
of approximately 90.
5. Which is not a step that can be followed to create a Story?
- Create and position annotations on the canvas as desired.
- Capture a story insight from one or more Visualization canvases in a project by navigating from
Visualize to Narrate and dragging the desired Visualization canvas(es) onto the Narration
canvas.
- Share the Story in presentation mode by setting the reportMode parameter in the project
properties to FullDisplay.
- Create a new project for the Story by clicking the Save As button in the project toolbar. correct
answers - Share the Story in presentation mode by setting the reportMode parameter in the
project properties to FullDisplay.
6. Oracle Analytics Cloud offers several visualization options for presenting query results. How
do you explicitly invoke "best visualization" in Oracle Analytics Cloud?
- Select the desired data elements from the Data Elements pane and drag them onto the Best
Visualization zone in the Explore pane
- Drag an entire Data Set from the Data Elements pane 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. correct answers - Select the desired data elements
from the Data Elements pane, right-click and select "Create Best Visualization" from the drop-
down menu.
7. 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. correct answers - Create a cluster with a suitable
number of groups for the specific analysis.
8. 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 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. correct answers - You can migrate a snapshot from
Oracle BI Enterprise Edition 12c to Oracle Analytics Cloud.
9. Which two statements are true about the Data Sync functionality?
- 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, Data Sync 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. correct answers - 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.
- Data Sync can create and manage surrogate keys in target tables.
10. 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.
