1Z0-1118-23

1.- You are required to join the Fusion Applications data extracted through FAW with external data. Which approach would meet your need?. You must join the two sets of data in the ADW schema. . External data and Fusion data cannot be joined. FAW Semantic Model Extensions provide the ability to join the tables.

2.- You have a table in your custom schema in ADW and would like to create a dimension using Semantic Model Extensions. Which Fact tables can you join your custom dimension to?. You can only join a custom dimension with a custom Fact table. Only degenerate dimensions are supported. You can join your custom dimension with custom Fact and out-of-the-box Fact tables.

3.- How many branches can you create to modify the semantic model?. Depends on the number of users in your instance with the proper privileges. Supports more than one branch. Supports only one branch at a time.

4.- You have created your customization using Semantic Model Extensions. Now, you want to test your customization to ensure it meets your requirements. What steps should you perform?. Publish the branch that contains your customization. The customization appears automatically in your subject areas. Publish all the branches.

5.- Your development team has created multiple steps in the semantic model. You want to review these steps and possibly roll them back. What is the rollback process?. You must review all the steps in the branch before merging. Once you merge the branch, there is no rollback. You must open a ticket with Oracle support for the steps that require rollback. Review all the steps that are merged inside the "User Extension" main area. To rollback, you can then disable the steps.

6.- You have created a fact, a dimension, and a new subject area using Data Augmentation. You want to extend the dimension m your newly created subject area by adding new attribute data source. What steps are required to achieve this?. Create a branch and add "Extend a Dimension''. The only available option is to modify your ADW custom schema and your Data Augmentation. The dimensions created in Data Augmentation are not available in Semantic Model Extensions.

7.- You need to create additional custom Subject Areas in your FAW instance. modify and extend the semantic model. Which feature(s) in FAW provides extensibility to the semantic model?. provides faculties to. Only Semantic Model Extensions. Report Configuration. Semantic Model Extensions and Data Augmentation.

8.- Which two capabilities are available through Semantic Model Extensions?. Add a new dimension. Create a union between two tables. Add additional data sources to the semantic model. Add a new fact.

9.- Your team has multiple developers, each dedicated to one functional area. How would you create an environment for multi-user customization of the semantic model?. Currently, there is no way to create a multi-user development environment. Each developer has to create their own branch and perform all modifications inside the branch. You have to use OAC tools, such as the data modeler, for this purpose.

10.- You have recently provisioned a new Fusion Analystics Warehouse (FAW) instance and want to enrich your Subject Areas with escriptive Flexfields (DFF). In your custom application, you have created a DFF page and added/selected all the required attributes. How would you activate them to enable data loading?. After selecting the required attributes in the DFF custom application, you need to refresh the functional areas or wait for the next incremental upload for the DFFs to be visible in Subject Areas. After selecting the required attributes in the DFF custom application, you need to build a semantic model extension and wait for the next incremental upload for the DFFs to be visible in Subject Areas. Activating is a two-step process: first, you need to generate the DFF custom application, and second, you need to deploy for the DFFs to be visible in Subject Areas.

11.- You are unable to locate some data elements in your FAW instance subject areas that exist in OTBI. Which feature in FAW supports both data movement and semantic model extensibility to provide the missing data elements?. Bundles. Data Augmentation. OAC Data Flow.

12.- Which data sources are available for Data Augmentation?. The Oracle Fusion Application transactional database. Fusion Applications and additional data connections available in FAW. The same data sources as OAC connectors.

13.- You want to move external data to the Oracle Autonomous Data Warehouse that comes with FAW. M4 Which facilities in FAW enable this?. You must use an ETL that connects to ADW as there are no such facilities in FAW. The only available option is to use OCI Data Integration to move data. Use ''Manage Connections" to create a connection to available sources. Data Augmentation can be used against the connections to bring data into AC.

14.- Data Augmentation provides two types of source tables for extraction from Fusion Applications: System Provided and Customer Provided. What are the benefits of using System Provided source tables?. System Provided source tables are prevalidated by Oracle Fusion Analytics Warehouse. As part of that validation, Oracle helps ensure the success of processing and mitigates performance impact. You get complete access to all transaction tables. Fusion Analytics Warehouse syncs data from System Provided tables in real time.

15.- You have created several Data Augmentations. What types of data refreshes are available for Data Augmentation?. Data Augmentations follow the incremental refresh frequency and can also be refreshed ad hoc. Only ad hoc refresh is available for Data Augmentation. If refresh is required, you need to update the ADW tables related to Data Augmentation.

16.- You have decided to use Data Augmentation to bring additional content from Fusion Applications What is the best way to identify the Fusion Applications object that you want to extract?. You must open an SR to identify the required Public View Object (PVO). The Public View Object (PVO) that contains the content you are looking for. You have to identify the physical database table in Fusion Applications that contains the contains the content you are looking for.

17.- You would like to avoid creating Fusion Applications users and their assigned job roles in FAW. What options are available in FAW for synchronizing users and job roles between FAW and Fusion Applications?. Use the FAW console security option to create and manage users and job roles. Implement SSO and synchronization of users and job roles between FAW and Fusion Applications, before provisioning the FAW instance. Use the Bulk Load option in FAW to do the synchronization.

18.- In the FAW Security framework, what purpose do the system groups (like FAW Licensed ERP Authorize and FAW Functional Administrator) help serve?. Duty and data rotes are mapped to system groups before they are assigned to users. They giant a user access to FAW based on the system groups to which they are assigned. They define job-specific roles for users.

19.- In the FAW Security framework, what purpose do the system groups (like FAW Licensed ERP Authorize and FAW Functional Administrator) help serve?. Duty and data roles are mapped to system groups before they are assigned to users. They giant a user access to FAW based on the system groups to which they are assigned. They define job-specific roles for users.

20.- You are performing data validation from the FAW console. What is the first thing you should ensure as a user undertaking the data validation activity?. Ensure that you have the same data security privileges in the FAW instance and the Oracle ynal Business Intelligence instance. Ensure that you have access to all data in the FAW instance. Ensure that you have the administrator privilege in the Oracle Transactional Business Intelligence (OTBl) instance.

21.- You would like to back up your extensions and alt custom artifacts in FAW. What allows you to back up FAW artifacts?. OAC built-in utilities. Snapshots. FAW Bundles.

22.- You plan on using single sign-on (SSO) to access Oracle Fusion Analytics Warehouse (FAW). Describe your setup sequence for implementing SSO. Set up single sign-on (SSO) before proceeding with the FAW instance creation. Create the FAW instance first, before proceeding with the setup of single sign-on (SSO). The setup sequence of single sign-on and FAW instance creation doesn't matter.

23.- Currently, you have set up SSO for Fusion Applications between Act.ve Directory and Fusion Applications is it possible to also set up SSO between Fusion Applications and FAW in this case?. No, this configuration is not supported. possible, and the configuration process to set up SSO between Fusion Applications and FAW stays the same. This is a complex configuration, and it is highly discouraged.

24.- person mentioned in the order document receives the welcome email for UCC and FAW activation Which security privilege is required by the person to activate UCC and FAW in your Oracle Cloud account?. The user receiving the welcome emails for activating UCC and FAW must be a Cloud Account Administrator in the Oracle Cloud account. The user receiving the welcome emails for activating UCC and FAW must be a BusinessAdministrator in the Oracle Cloud account. No special security privileges are required by the user to activate UCC and FAW in the Oracle Cloud account.

25.- Which FAW system role/group is required to grant a user the privilege to manage data augmentation?. Functional Administrator. Security Administrator. Modeler.

26.- Which is a prerequisite for creating a data pipeline for any functional area?. Configuring single sign-on. Setting up the Pipeline parameters. Completing data security assignments.

27.- You have terminated a FAW instance from the Oracle Cloud Infrastructure (OCI) console. You new want to reinstate that instance. Can you recover a terminated instance?. You cannot recover a terminated instance; you will have to re-create your instance and restore it. You can recover a terminated instance; just open a Service Request (SR) with Oracle support. You can recover a terminated instance with the click of a button from the OCl console.

28.- Your source Fusion Cloud Application instance has been refreshed with data from another environment. You are using password-based authentication to connect from FAW. What step would be required for the data pipeline to run without any issues'?. You are required to update the source application URL. You are required to update the applicable users credentials, if the passwords differ between environments. You need to update the notification email of the FAW instance with the email of the user identified to connect with the source Fusion Cloud Application.

29.- You want to edit global data pipeline parameters. How do you ensure that your changes are deployed and data is consistent?. You must reset the data warehouse and activate the functional areas to ensure changes are effective during the next pipeline run. Changes to the global pipeline parameter take effect immediately. Changes to the global pipeline parameter take effect at the next incremental upload.

30.- You want to do data validation for one of your critical metrics in FAW. However, you cannot metric as part of predefined data validation. How can you validate your metric?. This feature is not available yet. You must wait until FAW support that metric for data validation. You must open a ticket with Oracle support. You have to do it manually. You need to create a report in OTB1 for that metric and then compare it with the value in FAW.

31.- You are implementing Fusion ERP Analytics. You find two types of predefined Application Roles, e.g., General Ledger Access Set Data security and profitability Analysis Duty Role. You are implementing Fusion ERP Analytics. Which type of Application Role is used to secure access to the Subject Area?. The Duty Role secures access to the Subject Area. Any of the Application Role types can be used to secure access to the Subject Area. The Data Role secures access to the Subject Area.

32.- What is the typical use case of the Promote Objects feature?. To check the validity of your customization. To move your customization from one environment to another, such as from development to production to production. To replicate one instance to another.

33.- You have reviewed out-of-the-box data security through the configuration of context assignment. You need to create custom data security to meet your data security requirements. Which FAW settings provide this functionality?. The Security Configurations available in the Semantic Model Extensions through the FAW Console provide this functionality. You need to modify the Data Security Assignment file with the values you want for the users. A combination of steps in Security Console and the Security Configurations in the Semantic Model Extensions available at the FAW Console provides this functionality.

34.- You have reviewed the predefined security model for FAW. It meets most of your requirements, but you have specific business needs. How can you address your specific security business requirements within the FAW Application?. You must address those requirements in Fusion Applications and sync up those changes to FAW. Currently, only the out-of-the-box security model is supported. You can use the security customization in FAW for both data security and object security to meet your requirements.

35.- In FAW there are many Subject Areas, with their corresponding data, available for you to use when creating and editing analyses and reports. How are the Subject Areas secured?. There is no need to secure Subject Areas as the data security provides the necessary security access. Duty roles secure the access to FAW Subject Areas. Unlike Fusion Applications, the Subject Areas are not secured in FAW. Any FAW-licensed user can access them.

36.- FAW allows you to define custom data security to meet complex requirements. What steps would you take to override the default data security for specific users?. You need to create a custom duty role and set up data filters that specify the values for specific dimensions. You must create reports for your target users with filters that meet your security requirements. You need to create a custom data role and set up data filters that specify the values for specific dimensions.

37.- You are in the process of implementing complex data security. How would you secure your Fact table using data filters from different dimensions?. Use functional groups to combine the data filters using the OR and AND operators. Create multi-table data sets in OAC and create a custom report. Currently, this scenario is not supported.

38.- You have successfully implemented a security model in Fusion Applications that meets your security requirements. However, you have noticed that FAW does not move and replicate your entire security implementation What can address your requirements in FAW?. Set up SSO between FAW and Fusion Applications and synchronize user and Job roles. Evaluate your security requirements and utilize security customization features in FAW to meet your needs. Open a support ticket and report the issues that you are encountering.

39.- Oracle Fusion Analytics Warehouse (FAW) offers certain functionality as preview features for you to try. You want to enable the preview features in your environment. What would you do?. Ask your FAW Service Administrator to enable the preview features in your existing FAW instant. Open a Support Request (SR) with Oracle support. Provision a new FAW instance.

40.- You are aware that a new FAW version just became available. What is the best practice for upgrading a FAW instance to the latest version?. Open an SR with Oracle. Schedule the upgrade through the FAW console. Wait until Oracle upgrades the instance.

41.- Refreshing the data pipeline for a functional area allows you to bring in incremental data immediately Often, administrators execute this refresh option for ad hoc data uploads. Are there any issues you must consider while executing the refresh option?. No; executing an on-demand data refresh brings in incremental data. There are no issues/concerns to consider. Yes; executing an on-demand data fresh brings in all data from the initial extract date. Since it brings in all data, it takes longer to execute. Yes; executing an on-demand data refresh while working on the data may cause temporary inconsistencies.

42.- You noticed that the scheduled incremental data refresh has started. What operations are disabled during the refresh?. FAW subject areas are not accessible. Ad hoc data refresh for functional areas are not possible while a scheduled data load is ongoing. FAW decks are disabled.

43.- What is the smallest interval of incremental data load to the FAW data warehouse?. Hourly. Daily. Weekly.

44.- You want to create a custom report in FAW using OAC. You have access to the FAW subject areas and the data sets that you created using Data Augmentation. Which tool in OAC should you use to create your report?. Data Visualization. Weekly. Daily.

45.- You must specify parameter values during the HCM Analytics' Reporting Configuration process. Why are these parameters required as part of the implementation process?. The Reporting Configuration parameters are required to set the initial extract date for extracting the data from the source application. The Reporting Configuration parameters help schedule reports required to be run at a defined time. The Reporting Configuration parameters help specify how data is presented in KP1 decks, visualizations, analysis, dashboards, and reports in FAW.

46.- Fusion Analytics Warehouse (FAW) allows you to select the Descriptive Flexfields (DFFs) you want to move to your data warehouse. What setup must you ensure in your Fusion Application for FAW to perform this operation7. Ensure that the DFFs and their attributes are Bl-enabled in your Fusion Application. Ensure the DFFs are configured and validated in your Fusion Application. Create a BICC extract for DFFs and schedule the same in your Fusion Application.

47.- LBAC is enabled in your Fusion pod. You plan to provision your instance using password-based authentication to Fusion Application. What configuration does your Fusion Application require to achieve this?. You need to identify the user who will be connected to the Fusion Application for pipeline orchestration. This user must be enabled for access from All IP Addresses. Log an SR for your Fusion Application and mention the identified user to authenticate to Fusion Application. Oracle Support will disable LBAC for the identified user. Custom roles need to be created for the user identified to authenticate access to the Fusion Application. These roles must to be enabled for access from All IP addresses.

48.- In the FAW Security framework, which mapping paradigm best describes the mapping of Security Content to Data Roles?. Security Context to Data Role is one-to-one. Security Context to Data Role is many-to-many. Security Context to Data Role is one-to-many.

49.- In Fusion HCM Analytics, which job-specific role/group provides access to all HCM data without security restrictions on the HCM data set?. Human Resource Analyst. Human Resource Specialist. Human Resource Manager.

50.- Oracle Fusion Analytics Warehouse (FAW) is built on Oracle Cloud Infrastructure (OCI) and leverages/embeds Oracle PaaS Cloud services. Which PaaS Cloud services does it leverage/embed?. Oracle Analytics Cloud and Autonomous Data Warehouse. Oracle Analytics Cloud, NoSQL Database Cloud Service, and Golden Gate. Oracle Analytics Cloud and Exadata Database Service on Dedicated Infrastructure.

51.- During the creation of the FAW instance, you have to provide the Fusion Application connection details and authentication information. Which method of authentication is recommended by Oracle?. JSON Web Token. Password-based. Multi-factor authentication.

52.- How many instances of Oracle Fusion Analytics Warehouse (FAW) can you create based on a standard subscription?. Two instances: one for development/testing, and a second for production use. One instance for production use. Number of instances Is based on the number of Fusion Application instances.

53.- Oracle Fusion Analytics Warehouse (FAW) is built on Oracle Analytics Cloud (OAC). As a FAW Service Administrator, where do you manage the FAW application?. You have two consoles: the FAW console and an OAC console. The OAC console is similar m functionality to the standalone OAC platform service. You have two consoles: the FAW console and an OAC console. The OAC console has limited functionality as compared to the standalone OAC platform service. You have only one console to manage and administer FAW, the FAW console.

54.- You want to scale up your associated Oracle Autonomous Data Warehouse (ADW) and OAC as part of your FAW customization. Who can help upscale the ADW and OAC capacities?. Oracle Support. FAW - Functional Administrator. OCI Administrator with access to OCI pages for OAC and ADW instances.

55.- When choosing a Cloud Account for activating Fusion Analytics Warehouse (FAW), which recommendation does Oracle provide?. Activate FAW subscription into the same Oracle Cloud account as your Oracle Fusion Cloud Applications. Activate your FAW subscription in a separate Oracle Cloud account. The Oracle Cloud account for your Oracle Fusion Cloud Applications should be exclusively for use by the cloud applications. No recommendation is provided by Oracle on your choice of Cloud Account for the activation of FAW.

P56.- Oracle Fusion Analytics Warehouse (FAW) is a family of prebuilt, cloud native analytics applications for Oracle Cloud Applications. Who manages the FAW service?. Customer. Oracle. System Integrator who implements FAW is required to manage the service.

P57.- Oracle Fusion Analytics Warehouse (FAW) is a family of prebuilt, cloud native analytics applications for Oracle Cloud Applications. In which OCI Region can you provision FAW?. You can provision FAW in a specific Availability Domain where Regions have multiple Availability Domains. You can provision FAW in any of the OCI Regions. You can provision FAW in one of the OCI Regions where the product is available.

P58.- You must complete Single Sign-On (SSO) setup before you create your Oracle Fusion Analytics Warehouse instance. In which scenario does SSO require further configurations after creation of the FAW instance?. The FAW instance is created in a separate cloud account from Oracle Fusion Cloud Applications, and the FAW cloud account offers an identity domain. The FAW instance is created in the same cloud account as Oracle Fusion Cloud Applications. The FAW instance is created in a separate cloud account from Oracle Fusion Cloud Applications, and the FAW cloud account doesn't offer an identity domain.

P59.- You have completed the FAW instance creation process. The service status is yet to be ACTIVE. Can you start creating FAW data pipelines while the system initialization is in progress?. Prebuilt data pipeline requires provisioning on a separate OCI Compute; hence you can start the data pipeline activity in parallel to FAW instance creation. You must wait for the system initialization process to complete before creating FAW data pipelines. You can start creating FAW data pipelines; there is no need to wait for the system initialization process to complete.

P60.- Custom security configurations appear in the Security Configuration component of the Semantic Model Extension. Can you test your security configurations against your Customization Branches?. Custom security configurations can be done against Published branches. You can only create Custom security configurations on the main semantic model. You need to merge your Customization Branches to the main model before you can create your security customizations. Custom security configurations can be done against prebuilt Subject Areas only.

P61.- Oracle Fusion Analytics Warehouse (FAW) uses groups to manage user privileges. Which roles are defined as groups in FAW?. FAW Duty Roles. FAW Data Roles. Oracle Fusion Cloud Application Job Roles.

P62.- You can perform a manual Reset of data on a functional area. The next incremental run performs the Reset action. You want to reset the data immediately. What option do you have?. You have no option but to wait until the next incremental run. You cannot perform the Refresh Data action as it is used for adhoc incremental uploads. You need to raise a support ticket to reset the data immediately. You can perform the Refresh Data action; this will reset the data immediately.

P63.- You want to do a full data load into your FAW data warehouse. When should you plan this activity?. There is no recommended best practice for this activity. Oracle recommends running full warehouse loads during weeknights. Oracle recommends running full warehouse loads during weekends.

P64.- To create meaningful enterprise-wide analyses, you must use a common currency. Can you specify an Exchange Rate Type independent of the rates in Fusion Cloud Application?. Yes, as part of your Reporting Configurations you can set the Exchange Rate Type parameter. No, as part of your pipeline parameters you must use an appropriate Exchange Rate Type that you have set up in Fusion Cloud Application. Yes, FAW provides you with a feature where you can upload the Exchange Rate Type.

P65.- Data validation in Oracle Fusion Analytics Warehouse uses basic authentication. The identified user needs to be assigned to a Custom BI Abstract Role created in Fusion Application. What is the other necessary setup required?. Using the FAW Security Console, you must add the BI Impersonator role to the Integration Specialist Group. You must add the BI Impersonator role to the Custom BI Abstract Role. Using the FAW Security Console, you must add the BI Impersonator role to the user performing data validation.

P66.- What would be your first step in the FAW Semantic Model Extensions to start the process of semantic model customizations?. To begin customizing your semantic model, create a system extension of the main semantic model. To begin customizing your semantic model, create a branch of the main semantic model. To begin customizing your semantic model, create a replica of the main semantic model.

P67.- You have created a custom Subject Area with custom data. Can you secure access to the custom Subject Area and the data?. You cannot secure access to the custom Subject Area; all FAW users will have access to the custom Subject Area and its data. You can secure both the custom Subject Area access and the data access. You can secure access to the Subject Area; however, users having access to the Subject Area will have access to all data since you cannot customize data level security.

P68.- Data Augmentation and Semantic Model Extension are features of FAW that aid customization. Identify a key difference between the two. You cannot create a custom Subject Area using Data Augmentation, whereas you can create a custom Subject Area using FAW's Semantic Model Extension feature. Data Augmentation moves data into the data warehouse, whereas Semantic Model Extension does not have the ability to move data. You can modify a prebuilt Subject Area using Data Augmentation, whereas you cannot modify a prebuilt Subject Area using FAW's Semantic Model Extension feature.

P69.- You can manage your FAW instance to ensure you have the latest application updates. How are emergency patches applied?. The FAW administrator schedules emergency patches in a manner that causes the least interference with application usage. Emergency patches are applied automatically without the FAW administrator's influence. Emergency patches are released with an update deadline. FAW administrators need to apply them before the update deadline.

P70.- Bundles are snapshots of your application artifacts such as configurations and customizations at a certain point in time. What privileges do you need to manage bundles?. OCI Administrator. FAW Modeler Administrator. FAW Service Administrator.