1Z0-931-25 practice question 13 of 25

Which three advanced options can you enable or disable while creating a business model? (Choose three.)

Full set: 149 questions
Answer options
A: Autonomous Aggregate Cache Correct answer
B: Analytic View Transparency View Correct answer
C: Analytic View Base Table Query Transformation Correct answer
D: Display private tables
E: Business Object Security Feature
Correct Answer:
A. Autonomous Aggregate Cache; B. Analytic View Transparency View; C. Analytic View Base Table Query Transformation
Explanation

When creating or editing a business model (semantic model) in Oracle Analytics Cloud, you can configure several advanced properties. These options are designed to optimize performance and enhance integration with specific data source features. The "Autonomous Aggregate Cache" option enables the use of a specialized caching mechanism with Autonomous Data Warehouses. The "Analytic View Transparency View" and "Analytic View Base Table Query Transformation" options are specific settings that control how Oracle Analytics interacts with and leverages Analytic Views within an Oracle Database, allowing for more efficient query processing and optimization. These three are distinct, toggleable settings in the business model's advanced properties.

Why Incorrect

D. Display private tables: This is a display preference within the Physical Layer of the Semantic Modeler to show or hide user-specific tables, not an advanced property of the business model itself.
E. Business Object Security Feature: This is a generic term. Security is a core aspect configured through data filters, object permissions, and roles, not a single advanced option that can be enabled or disabled.

References

1. Oracle Cloud Documentation

Model Data for Oracle Analytics Cloud

"Set Advanced Business Model Properties." This official guide explicitly lists the advanced properties that can be set for a business model. The document states:

Analytic View Base Table Query Transformation: "Select this option to enable the query transformation of analytic views."

Analytic View Transparency View: "Select this option to enable the transparency view of analytic views."

Autonomous Aggregate Cache: "Select this option to enable the use of Autonomous Aggregate Cache."

(Reference: https://docs.oracle.com/en/cloud/paas/analytics-cloud/acmdg/set-advanced-business-model-properties.html#GUID-9898989A-989B-498C-989D-989E989F989G) (Note: The GUID in the URL is illustrative; the page title is the key identifier).

Scroll to Top