1z0-1118-23 Oracle Cloud Fusion Analytics Warehouse 2023 Implementation Professional Questions and Answers

The DFFs and their attributes must be BI-enabled in order to be extracted by the FAW data pipeline and loaded into the data warehouse. BI-enabling a DFF means that it is exposed as a column in a view object that is part of a subject area in Oracle Transactional Business Intelligence (OTBI). This allows FAW to access the DFF data through OTBI web services.

Verified References: Use Descriptive Flexfields, section 23.1; About Flexfields, section “Use Flexfields in Your Data Model”.

The FAW Security framework allows a flexible and extensible mapping of Security Content to Data Roles. A Security Content is a predefined attribute that defines the boundaries of data access for a given subject area, such as Business Unit, Country, Department, Job Family, Legal Entity, and Worker Type. A Data Role is a custom role that grants access to specific subsets of data in the data warehouse based on the Security Content. A Security Content can be mapped to multiple Data Roles, and a Data Role can have multiple Security Content associated with it. For example, a Security Content of Country = US can be mapped to a Data Role of US HR Manager, and a Data Role of US HR Manager can have multiple Security Content such as Country = US, Business Unit = Sales, and Department = Marketing.

Verified References: Reference for Fusion HCM Analytics, page 9-10.

Data Augmentations in FAW follow the incremental refresh frequency that is configured for the functional areas. You can also refresh the data augmentations manually by using the Refresh option on the Data Augmentation page1. You do not need to update the ADW tables related to Data Augmentation, as FAW handles the data loading automatically2

You can create multiple branches to customize the semantic model. You use a branch or version to publish your changes to the model. You can apply the model from the branch to a local service instance for testing. When the changes are correct, you can merge that branch with the main branch3

To perform data validation from the FAW console, you need to ensure that you have the same data security privileges in the FAW instance and the Oracle Transactional Business Intelligence (OTBI) instance. This will allow you to compare the metrics between the two instances and verify their accuracy2. You do not need to have access to all data in the FAW instance or have the administrator privilege in the OTBI instance to perform data validation.

The smallest interval of incremental data load to the FAW data warehouse is daily. You can configure the incremental refresh frequency for each functional area in the pipeline settings. The minimum frequency that you can set is daily, which means that the data pipeline will run once every 24 hours and bring in the latest data from your Fusion Applications4. You cannot set the frequency to be hourly or weekly, as these are not supported by FAW.

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

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

You cannot recover a terminated instance of FAW from the OCI console. When you terminate an instance, all the resources associated with it are permanently deleted, including the OAC instance, the ADW instance, and the data warehouse. You will have to re-create your instance and restore it from a snapshot if you have one7. You cannot recover a terminated instance by opening a Service Request (SR) with Oracle support or by clicking a button from the OCI console. 

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. 

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.

The way that you can enable the preview features in your environment is to ask your FAW Service Administrator to enable the preview features in your existing FAW instance. The FAW Service Administrator can use the Enable Features option on the Console page to turn on or off individual preview features at any time5. You do not need to open a Support Request (SR) with Oracle support or provision a new FAW instance for this purpose

The prerequisite for creating a data pipeline for any functional area is setting up the pipeline parameters. The pipeline parameters define the global settings for the data pipeline, such as the source application URL, credentials, notification email, incremental refresh frequency, and retention period4. Configuring single sign-on and completing data security assignments are not prerequisites for creating a data pipeline, but they are recommended for securing access to FAW and Fusion Applications5