QUESTION: 1
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?
A. Permissions
B. Row Level Data
C. Table filter
D. Data Filters
Answer(s): D
Explanation:
You can define data filters for fact tables, dimension tables, and columns that provide row-level
security for data model objects. For example, you can create a filter that restricts access to the
Products table so that only certain brands are visible to users assigned to a particular role.
Reference:
https://docs.oracle.com/en/cloud/paas/bi-cloud/bilpd/securing-access-data.html
QUESTION: 2
Oracle Analytics Cloud offers several visualization options for presenting query results. How do
you explicitly invoke "best visualization" in Oracle Analytics Cloud?
A. Select the desired data elements from the Data Elements pane and drag them onto the Best
Visualization zone in the Explore pane.
B. Drag an entire Data Set from the Data Elements pane onto the Data Visualization canvas
and let the tool determine the best visualization.
C. Select the "Best Visualization" option from the project's Canvas Settings drop-down menu.
D. Select the desired data elements from the Data Elements pane, right-click and select "Create
Best Visualization" from the drop-down menu.
Answer(s): B
Reference:
https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/visualizing-data-and-building-
reportsoracle-analytics-cloud.pdf (39)
QUESTION: 3
Which two statements are true regarding configuring filters to control visual content?
A. Expression filters cannot be applied in the filter steps of Oracle Analytics Cloud Data
Visualization data flows.
A. Variables may be employed in all Data Visualization filter types (that is, Range, List, Date,
Expression).
C. Application role filters for fact and dimension tables are defined in the Oracle Analytics Cloud
Data Modeler.
D. 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.
Answer(s): C, D
https://xcerts.com