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

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 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

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. 

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

 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 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 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. References: 5

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.

 You can create a dimension using Semantic Model Extensions and join it with any Fact table, whether it is a custom Fact table or an out-of-the-box Fact table. You can also join multiple dimensions with a single Fact table3

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 type of Application Role that is used to secure access to the Subject Area is the Data Role. The Data Role defines the data security context for a user, such as which business units, legal entities, or departments they can access2. The Duty Role defines the functional security for a user, such as which tasks they can perform or which objects they can view3. Any of the Application Role types cannot be used to secure access to the Subject Area, as they have different purposes. 

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

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.