Free Oracle 1z0-1118-23 Practice Exam with Questions & Answers

The purpose of the system groups (like FAW Licensed ERP Authors and FAW Functional Administrator) in the FAW Security framework is to grant a user access to FAW based on the system groups to which they are assigned. System groups are predefined groups that specify the user’s system permissions, such as whether they can consume, author, or administer content for a specific module5. System groups do not map duty and data roles or define job-specific roles for users. 

Data Augmentation is a feature in FAW that supports both data movement and semantic model extensibility to provide missing data elements. Data Augmentation allows you to extract data from additional data sources that are not part of the FAW data pipeline and load them into ADW. You can then use the data to customize the semantic model and create new dimensions, facts, and subject areas2

To back up your extensions and all custom artifacts in FAW, you can use snapshots. Snapshots are a feature in FAW that allows you to create a backup of your service instance, including the semantic model, data sets, reports, dashboards, and other analytics content2. You can also restore your service instance from a snapshot if needed3. OAC built-in utilities and FAW bundles are not available for backing up FAW artifacts

FAW provides two features to customize and extend the semantic model: Semantic Model Extensions and Data Augmentation. Semantic Model Extensions allow you to modify the existing dimensions, facts, and subject areas, as well as create new ones from existing data sources. Data Augmentation allows you to create new dimensions, facts, and subject areas from custom data sources that are not part of the FAW data pipelin

The tool in OAC that you should use to create your report in FAW using the FAW subject areas and the data sets that you created using Data Augmentation is Data Visualization. Data Visualization is a feature in OAC that allows you to create and share interactive visualizations, stories, and dashboards. You can use Data Visualization to connect to the FAW subject areas and the data sets that you created using Data Augmentation and explore the data using various charts, maps, tables, and filters12. You do not need to use Data Modeler or Data Flow to create your report in FAW, as these are not tools for creating reports, but for creating data models and data transformations

To test your customization, you need to publish the branch that contains your customization. This will apply the changes to the model and make them available in the subject areas. You can then use OAC console to create and view reports based on your customized model3

To scale up your associated Oracle Autonomous Data Warehouse (ADW) and OAC as part of your FAW customization, you need an OCI Administrator with access to OCI pages for OAC and ADW instances. The OCI Administrator can use the OCI Console or APIs to scale up or down the compute resources (CPU cores) or storage resources (terabytes) for both ADW and OAC instances

LBAC (Location-Based Access Control) is a feature that restricts access to Fusion Applications based on IP addresses or ranges of IP addresses. If LBAC is enabled on your Fusion pod, you need to identify a user who will be used by FAW to connect to Fusion Applications using password-based authentication. This user must have access from All IP Addresses in order to allow FAW to extract data from any location.

Verified References: Securing Oracle Fusion Applications REST APIs with Location Based Access Control (LBAC), section “LBAC Configuration”.

 The best practice for upgrading a FAW instance to the latest version is to schedule the upgrade through the FAW console. You can use the Upgrade option on the Console page to select the available version and schedule a date and time for the upgrade. You can also view the status and history of your upgrades on the same page1. You do not need to open an SR with Oracle or wait until Oracle upgrades the instance for this purpose.

The steps that you would take to override the default data security for specific users are to create a custom data role and set up data filters that specify the values for specific dimensions. A custom data role allows you to define custom data security filters and apply them to dimensions, facts, or subject areas. You can then assign the custom data role to the users who need to have different data access than the default2. You do not need to create a custom duty role or create reports with filters to override the default data security.