Key details for this exam, checked against the published exam outline
Each question shows the correct answer and an explanation of why it is right
An organization has finalized testing of new custom security data roles and modified subject area joins in their FDI Test environment. The lead administrator is preparing to deploy these verified artifacts into Production while ensuring that operational transactional data is not affected and that release versions are compatible.
Which TWO actions must the administrator perform to execute and verify this customization migration successfully?
Comprehensive and Detailed Explanation From Oracle Fusion Data Intelligence / Course Guide Topics:
B . Version Compatibility: Successful migration of semantic models and configuration artifacts requires that both the source (Test) and target (Production) environments are operating on compatible application release versions. Compatibility ensures that metadata definitions and logical object structures are consistent across instances, preventing failures during the import or promotion process.
D . Promotion or Bundle Transfer: To migrate verified security configurations, key metrics, and custom subject area joins, administrators should utilize the Promote Objects feature for direct environment-to-environment transfers or the Bundles feature if direct connectivity is unavailable (e.g., across separate OCI tenancies). These mechanisms are specifically designed to package and deploy semantic model extensions, security roles, and user experience workbooks without disrupting transactional data operations.
Why the Other Options Are Incorrect
A . Re-installing functional area data pipelines: This is not a requirement for migrating semantic customizations. Re-installing pipelines is an unnecessary and destructive process that would interrupt data ingestion and does not relate to transferring model metadata.
C . Resetting the Autonomous Data Warehouse ADMIN database password: Password management and schema refreshes are separate operational tasks. Resetting the database administrator password does not initiate a schema refresh or assist in the deployment of semantic customizations.
E . Enabling the Virus Scanner task: The platform manages security and maintenance tasks internally. Users cannot influence semantic model deployment through manual virus scanning configurations, and this is not a valid step in the customization migration workflow.
Oracle Study Guide reference area: Configuring Security
Which statement is true regarding network communication ports when deploying an Oracle Fusion Data Intelligence instance with a private endpoint?
Comprehensive and Detailed Explanation From Oracle Fusion Data Intelligence / Course Guide Topics:
C . Ingress and egress traffic rules must permit communication on Port 443 for Oracle Analytics Cloud and Port 1522 for Oracle Autonomous Data Warehouse.
Explanation
C (Correct): When deploying an Oracle Fusion Data Intelligence (FDI) instance with a private endpoint, Oracle explicitly requires that the Network Security Group (NSG) or Security List associated with the private subnet includes ingress and egress rules for two distinct ports:
Port 443 (HTTPS): Handles encrypted web traffic for the underlying Oracle Analytics Cloud (OAC) application interface and REST services.
Port 1522 (SQL*Net TCPS): Dedicated to secure database connectivity for the underlying Oracle Autonomous Data Warehouse (ADW) instance.
Why Other Options Are Incorrect
A is Incorrect: Port 8080 is an unencrypted HTTP web server port and is not used to consolidate secure analytics and database services in FDI.
B is Incorrect: Port assignments are reversed; Port 443 handles HTTPS web traffic for Oracle Analytics Cloud, while Port 1522 handles secure TCPS connections for Autonomous Data Warehouse.
D is Incorrect: Private endpoints do not automatically bypass VCN security rules. Security Lists and Network Security Groups must be explicitly configured to permit ingress and egress on Ports 443 and 1522 for communication to succeed.
Oracle Study Guide reference area: Configuring Security
Which statement is true regarding the OCI compartment and IAM policy requirements when preparing to create an Oracle Fusion Data Intelligence instance?
Comprehensive and Detailed Explanation From Oracle Fusion Data Intelligence / Course Guide Topics:
A . The IAM policy granting manage permissions for Autonomous Data Warehouse must target the same compartment where the FDI instance is created. (Correct)
Why it is Correct: Oracle Fusion Data Intelligence automatically provisions an underlying Oracle Autonomous Data Warehouse (ADW) instance within the target OCI compartment specified during setup. Therefore, the administrative IAM policies governing ADW resources (autonomous-database or autonomous-data-warehouse) must be scoped to match the designated compartment where the FDI service instance and its underlying data warehouse reside.
B . Oracle Fusion Data Intelligence instances must be created exclusively in the root compartment of the Oracle Cloud Infrastructure tenancy. (Incorrect)
Why it is Wrong: Administrators can select the root compartment or any pre-created sub-compartment/child compartment within the tenancy to house the FDI instance.
C . IAM policies for managing FDI resources must be written at the tenancy level and cannot be scoped to a specific child compartment. (Incorrect)
Why it is Wrong: OCI IAM policies follow standard compartment inheritance. Administrators can scope permissions specifically to a targeted compartment (e.g., ALLOW GROUP FDI_Admins TO MANAGE analytics-warehouses IN COMPARTMENT Production_Analytics).
D . Non-administrator users can create an FDI instance without being assigned to an OCI group if granted the Fusion Security Console admin role. (Incorrect)
Why it is Wrong: Instance creation requires explicit privileges within Oracle Cloud Infrastructure (OCI) IAM (specifically membership in an OCI group with permissions to manage analytics and database resources). SaaS duty roles inside the Fusion Security Console do not grant authorization to create OCI cloud infrastructure resources.
Oracle Study Guide reference area: Pre-requisites Before Creating an FDI Instance
An implementation team is preparing to execute data validation tests comparing metrics in Oracle Fusion Data Intelligence against Oracle Transactional Business Intelligence (OTBI). The lead consultant needs to verify that all prerequisite user setups, security roles, and credential configurations are correctly in place before creating validation sets. Which TWO actions are mandatory prerequisites for executing data validation in this environment?
Comprehensive and Detailed Explanation From Oracle Fusion Data Intelligence / Course Guide Topics:
A . Create a custom BI Abstract role and assign it to the dedicated validation user in Oracle Fusion Cloud Applications: To ensure the validation user can retrieve the necessary metrics from OTBI for comparison, they must be provisioned with the appropriate BI Abstract role within the source Oracle Fusion Cloud Applications environment.
C . Ensure the validation user exists in both FDI and Fusion Applications with identical data security privileges: It is a core requirement that the dedicated validation user accounts in both the source Fusion Applications and the FDI instance hold equivalent data security access privileges to ensure the accuracy and alignment of the data being compared.
Why the Incorrect Answers are Wrong
B . Deploy a private endpoint in OCI before enabling the Data Validation console tile: While networking configurations are important, deploying a private endpoint is not a functional prerequisite for enabling the Data Validation console tile.
D . Configure row-level data security filters within the Object Permissions tab of Semantic Model Extensions: Validation relies on comparing aggregated source metrics against warehouse data; row-level security configuration in the semantic model is not a mandatory prerequisite for setting up validation sets.
E . Reset the Autonomous Data Warehouse admin password before saving Source Credentials: The Source Credentials tab is used to configure application-level source authentication (such as the validation user credentials for Fusion Applications), not database-level administrative passwords for the Autonomous Data Warehouse.
Oracle Study Guide reference area: Data Validation
An ERP administrator leaves the Allow Financial Category Upload reporting parameter set to its default value of No in Oracle Fusion Data Intelligence.
How does the system handle financial category mappings for General Ledger reporting in this state?
Comprehensive and Detailed Explanation From Oracle Fusion Data Intelligence / Course Guide Topics:
A . Default Source Mapping: In Oracle Fusion Data Intelligence (FDI), the Allow Financial Category Upload reporting parameter controls whether administrators can maintain custom, independent financial category mappings via CSV files. When this parameter is left at its default value of No, the system automatically falls back to leveraging the standard financial category mappings defined directly in the source Oracle Fusion Cloud Applications.
Why the Incorrect Answers are Wrong
B . Financial category reports remain completely disabled until an administrator uploads a custom category CSV file: Leaving the parameter at 'No' does not disable reporting; it simply directs the system to use the built-in source definitions rather than requiring a manual override upload.
C . The system prompts the user to select a financial category mapping manually whenever opening an ERP workbook: FDI operates on standardized pipeline configurations and metadata definitions rather than prompting workbook users to perform manual structural mappings on the fly.
D . Financial category mappings are inherited directly from the Global Parameters target currency settings: Global target currency settings govern currency conversion rate types and reporting currencies, which are entirely separate from chart of accounts and financial category mappings.
Oracle Study Guide reference area: Configuring Security
Which statement is true regarding the OCI compartment and IAM policy requirements when preparing to create an Oracle Fusion Data Intelligence instance?
Comprehensive and Detailed Explanation From Oracle Fusion Data Intelligence / Course Guide Topics:
A . The IAM policy granting manage permissions for Autonomous Data Warehouse must target the same compartment where the FDI instance is created. (Correct)
Why it is Correct: Oracle Fusion Data Intelligence automatically provisions an underlying Oracle Autonomous Data Warehouse (ADW) instance within the target OCI compartment specified during setup. Therefore, the administrative IAM policies governing ADW resources (autonomous-database or autonomous-data-warehouse) must be scoped to match the designated compartment where the FDI service instance and its underlying data warehouse reside.
B . Oracle Fusion Data Intelligence instances must be created exclusively in the root compartment of the Oracle Cloud Infrastructure tenancy. (Incorrect)
Why it is Wrong: Administrators can select the root compartment or any pre-created sub-compartment/child compartment within the tenancy to house the FDI instance.
C . IAM policies for managing FDI resources must be written at the tenancy level and cannot be scoped to a specific child compartment. (Incorrect)
Why it is Wrong: OCI IAM policies follow standard compartment inheritance. Administrators can scope permissions specifically to a targeted compartment (e.g., ALLOW GROUP FDI_Admins TO MANAGE analytics-warehouses IN COMPARTMENT Production_Analytics).
D . Non-administrator users can create an FDI instance without being assigned to an OCI group if granted the Fusion Security Console admin role. (Incorrect)
Why it is Wrong: Instance creation requires explicit privileges within Oracle Cloud Infrastructure (OCI) IAM (specifically membership in an OCI group with permissions to manage analytics and database resources). SaaS duty roles inside the Fusion Security Console do not grant authorization to create OCI cloud infrastructure resources.
Oracle Study Guide reference area: Pre-requisites Before Creating an FDI Instance
Which of the following statements is true regarding the migration of semantic model customizations from a non-production instance to a Production instance?
Comprehensive and Detailed Explanation From Oracle Fusion Data Intelligence / Course Guide Topics:
Why Option D is Correct
When promoting semantic model extensions, key metrics, and reporting configurations from a non-production environment to a Production instance in Oracle Fusion Data Intelligence, both environments must be operating on compatible release versions. Ensuring release compatibility guarantees that metadata definitions, logical models, and underlying object references packaged from the source can be seamlessly interpreted and applied by the target instance without syntax failures or broken schema dependencies.
Why the Other Options Are Incorrect
A . Promoted semantic model extensions automatically erase and reset all transactional data tables in the Production Autonomous Data Warehouse: Semantic model promotions apply changes to metadata repository structures and reporting layers; they do not drop, erase, or reset transactional data tables stored within the underlying Autonomous Data Warehouse.
B . Using Promote Objects transfers user password credentials and OCI IAM identity domain policies alongside semantic model extensions: The object promotion feature targets application-specific configurations, semantic extensions, KPIs, and granular object/data security maps. It does not manage, transfer, or overwrite user account passwords or tenancy-wide OCI IAM identity domain policies.
C . Customizations promoted from non-production remain in draft status in Production until an administrator manually rebuilds the physical database schema: Promoted customizations are deployed and activated on the target environment through the managed platform workflow. They do not require manual physical database schema rebuilds to exit a draft state.
Oracle Study Guide reference area: FDI Customization
Exam domains verified against: Official Oracle 1Z0-1128-26 exam guide, last checked October 2026.
Understand the core capabilities and functional architecture of Oracle Fusion Data Intelligence solutions. Learn how FDI integrates with Oracle ecosystem components and delivers business value.
Prepare infrastructure by completing OCI requirements, ordering and activating FDI, configuring single sign-on, and setting up prerequisite Fusion applications. Ensure all foundational components are in place.
Configure and deploy FDI instances with proper administration setup. Handle private endpoint deployments and perform initial instance maintenance and monitoring tasks.
Sample question from this domain above: Q4
Implement user and group management, apply object-level security, assign data access controls, and automate security policies. Ensure proper access controls across the FDI environment.
Sample question from this domain above: Q3
Set up global and reporting parameters, manage functional areas, enable feature previews, and control release availability. Configure the data flow mechanisms for FDI.
Sample question from this domain above: Q5
Establish data quality checks through detailed and scheduled validation processes. Verify data accuracy and completeness in the FDI environment.
Adapt user interfaces, extend semantic models, customize security rules, and integrate external data sources. Leverage AI capabilities and external applications to enhance FDI functionality.
Manage incremental data uploads from Fusion applications, perform instance updates, handle upgrade and release cycles, and migrate artifacts between environments. Execute bulk uploads and rapid deployment strategies.
Common questions about the exam itself
