FDI 1128

1. During Data Augmentation implementation, you scheduled an incremental load with the FDI Connector at the same time as your prebuilt Fusion Application data pipelines. What precautions do you need to take?. Data Augmentation with FDI Connectors is of higher priority than the prebuilt Fusion Application pipelines. The prebuilt pipelines are executed after data augmentations with FDI connectors are completed. Data Augmentation with FDI Connectors and prebuilt Fusion Application pipelines require scaled up resources if they run in parallel. Scale up the ADW and OAC instances associated with FDI. Data Augmentation with FDI Connectors is of lower priority than the prebuilt Fusion Application pipelines and may get rejected if they overlap during the scheduled pipeline incremental runs.?.

you want to leverage Oracle Cloud Infrastructure (OCI) Vision to perform object detection on a dataset available in Oracle Analytics Cloud (OAC) embedded in FDI. Which OAC feature enables you to perform AI analysis on a dataset?. OCI Vision can’t be leveraged from within OAC embedded with FDI. It’s a feature available in standalone OAC. The Create Connection feature in OAC will allow authors to leverage the OCI Vision service to perform object detection on datasets available in OAC embedded with FDI. Data Flows in OAC allow authors to leverage OCI Vision to perform object detection on datasets available in OAC embedded with FDI.

3. You want to merge your external application into FDI. In this case, what's the purpose of exporting the Semantic Model Template?. You can take advantage of the exported template to create joins in your applications with conformed dimensions in the template. The template includes a copy of FDI's Base Semantic Model. You must modify this template to integrate your application and implement any other changes required in the Base Semantic Model. It is an optional step. Its purpose is to demonstrate best practices in the Base Semantic Model design so your application does not fail during the import.

4. Your development team has created multiple steps in the semantic model. You want to review steps and roll back. Review all steps that are merged inside the user Extension main area. To rollback you can disable the steps. You must review all steps in the branch before merging. Once you merge the branch there is no roll back. Open an SR for the step that require roll back.

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

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

7. Implication of deleting an activation for Functional area. It will permanently be removed from the existing data and the incremental data copies will also be discontinued. -.

22. What happens when you deactivate a functional area?. It stops the data pipeline process from pulling new data from the source application when incremental jobs are run. The functional area is permanently removed, along with the existing data available in the data warehouse. All future data copies to the warehouse are discontinued. Data reloads for the functional area during the next scheduled incremental data load.

9. Prerequisite for data pipeline creation. Configuring global parameters. -.

10. You want to perform data validation for one of your critical metrics in FDI, but you can't see that metric as part of the predefined data validation. How do you validate the metric?. This feature isn't available yet. You must wait until FDI supports that metric for data validation. You must calculate the metric within the database in both the Fusion Application and the FDI-embedded Autonomous Database. You must do it manually by creating a report in OTBI for that metric and then comparing it with the value in FDI.

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

12. You have edited the parameters for HCM Reporting Configuration. What must you do to ensure that the edits have taken effect?. Save the changes and then run the 'Refresh Data Security' process. -.

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

14. 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?. Yes, executing an on-demand data refresh while working on the data may cause temporary inconsistencies. No, executing an on-demand data refresh brings in incremental data. There aren't any issues or concerns to consider. Yes, executing an on-demand data refresh brings in all data from the initial extract date. Since it brings in all data, it takes longer to execute.

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

16. When upgrading FDI to the latest application update, how are your customizations impacted?. Only Data Augmentation must be checked after every update. You need to check all of your customizations after each update. In general, the updates are upward-compatible, unless otherwise documented.

17. FDI offers certain functionalities as preview features for you to explore. How do you utilize them?. The first step is to enable the preview feature you're interested in. Additional configuration is typically required. Preview features can only be utilized by customers enrolled in Oracle's Beta Program. Open a Support Request (SR) with Oracle Support.

18. 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 be enabled for access from All IP addresses.

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

20. 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?. Password-based. Multi-factor authentication. JSON Web Token.

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

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

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. It is 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. 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 branches.

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

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

28. 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?. Each developer has to create their own branch and perform all modifications inside the branch. Currently, there is no way to create a multi-user development environment. You have to use OAC tools, such as the data modeler, for this purpose.

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

30. 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 join your custom dimension with custom Fact and out-of-the-box Fact tables. Only degenerate dimensions are supported. You can only join a custom dimension with a custom Fact Table.

31. You want to move external data to the Oracle Autonomous Data Warehouse that comes with FAW. Which facilities in FAW enable this?. Use “Manage Connections” to create a connection to available sources. Data Augmentation can be used against the connections to bring data into AC. 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.

32. While there are no technical limitations to the number of data augmentations you can create in Fusion Analytics Warehouse (FAW), what is Oracle's recommendation?. Create only the necessary data augmentations to meet your business requirements and avoid excessive augmentations to maintain performance. -. -.

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

34. Oracle Fusion Data Intelligence (FDI) sources data from Oracle Fusion Cloud Applications. How many instances or environments of Fusion Cloud Applications can one instance of FDI connect to simultaneously?. two. one. unlimited.

35. You are implementing Oracle HCM Analytics. The source Oracle Fusion HCM Cloud application implemented Areas of Responsibility (AOR). The AOR implementation covers the security contexts available in FDI. You want to use these assignments for a quick implementation in FDI. Which configuration do you adopt during security implementation?. Automation for AOR isn't possible. You must implement security extensions from scratch. Ensure that users have the appropriate job-specific groups assigned to them before activating the Security Configuration Option functional area. Then, download the latest AOR data security assignment files, edit the format, and upload the assignments. Ensure that users have the appropriate job-specific groups assigned to them before activating the Security Configuration Option functional area.

36. You can use the Promote Objects and Bundles features to migrate objects from a test environment to production. Which statement best describes the difference between the features?. Promote Objects allows you to migrate from test to production instances across tenancies. Bundles enables you to migrate objects across instances in the same tenancy. Promote Objects allows you to migrate from test to production instances on the same tenancy. Bundles enables you to migrate objects across instances and across tenancies. To promote objects, you need OCI Administrator privileges. To use the Bundles feature, you need the Service Administrator role in FDI.

37. You are required to join the Fusion Applications data extracted through FDI with external data. Which approach meets your needs?. You must join the two sets of data in the ADW schema. Extensibility allows data from two external sources to be joined, but it doesn't allow joining of external data and Fusion data. FDI Semantic Model Extensions provide you the ability to join the tables.

38. You have created a fact, a dimension, and a new subject area using Data Augmentation. You want to extend the dimension in your newly created subject area by adding new attributes from another 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.

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

40. You have terminated a FAW instance from the Oracle Cloud Infrastructure (OCI) console. You now 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.

42. What is the most critical prerequisite before you activate your Oracle Fusion Warehouse (FAW) order?. Provisioning the necessary Oracle Cloud Infrastructure (OCI) resources and ensuring the required IAM (Identity and Access Management) roles and permissions are correctly configured. -.

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

44. 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. A combination of steps in Security Console and the Security Configurations in the Semantic Model Extensions available at the FAW Console provides this functionality. You need to modify the Data Security Assignment file with the values you want for the users.

45. You configure single sign-on (SSO) with your Fusion Application. You need a user to access FDI, but this user isn't available in the source Fusion Application.What are your options?. Create users with specific FDI access. You must create these users in the identity domain associated with your FDI instance. Your only option is to add the user in the Fusion Application for the user with FDI access. Your only option is to add the user in the Fusion Application and create the user in the underlying ADW associated with the FDI instance.

46. Data Augmentation provides multiple augmentation types for extraction from Fusion Applications.Which type only moves data from the source to the embedded Autonomous Database and which types can modify subject areas?. All types can move data and modify subject areas. Data Augmentation doesn't have capabilities to modify subject areas. Use Semantic Model Extensions to modify subject areas. The Dataset augmentation type only moves data. Other types can move the data and modify subject areas.

41. 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 applicable users credentials, if the passwords differ between environments. -.

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

48. Oracle recommends you don't keep changes in a sandbox for long periods as old sandboxes are deleted by the system. How many days are sandboxes retained for?. 180 days. 90 days. -.

49. Resetting the data warehouse deletes all data.What steps are required to repopulate your data in the data warehouse?. After you reset the data warehouse, you must activate each of your data pipelines for the functional areas. After you reset the data warehouse, you must reset all the functional areas. After you reset the data warehouse, you must delete and re-create each of your data pipelines for the functional areas.

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

51. Your business requirement mandates extending an existing dimension. You made the necessary extensions in the sandbox you created for this purpose. You want to test the subject area by creating a workbook. What steps are required before you create the workbook?. Apply and publish the sandbox before you create a workbook to test the subject area. Apply and merge the sandbox before you create a workbook to test the subject area. Apply the sandbox before you create a workbook to test the subject area.

52. Where can you create custom groups in FDI?. You can manually create groups in the appropriate domain from the OCI Console or use the Security Page Manage Groups feature in FDI. You must bulk upload the groups in FDI Admin Console. You can use the OAC Console to manually create groups in the OAC Admin Console available from FDI.

53. Data Augmentation allows you to move data. Which statement describes the Data Augmentation feature capabilities?. Use Data Augmentation for specific, targeted extracts. For larger scale, complex, enterprise-level projects, consider other ETL tools. Use Data Augmentation for specific, targeted extracts. For larger scale, complex, enterprise-level projects, consider buying an additional subscription for a full feature Data Augmentation. Data Augmentation replaces the need for any ETL tool for custom data extension. You can use it for large scale, complex, enterprise-level ETL projects.

54. 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 operation?. 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.

An Oracle Autonomous Data Warehouse (ADW) instance created by Oracle Fusion Data Intelligence (FDI) is primarily used by FDI. How much custom data can be pulled into ADW for free?. 1TB. 500TB. 50 TB.

56. You're implementing custom data security. You can create data filters at both the table and column levels. Is there a recommendation for optimum performance?. Yes, Oracle recommends you create the data filter at the table level. Yes, Oracle recommends you create the data filter at the column level. There's no recommendation. Create data filters at any level, table or column.

57. Oracle Fusion Data Intelligence (FDI) includes a family of prebuilt analytics applications. Which source applications does FDI use to generate ready-to-use insights?. Oracle Fusion Cloud Applications and Oracle Cloud Enterprise Performance Management Applications. Oracle Fusion Cloud Applications. Oracle E-Business Suite.

58. You're implementing Fusion ERP Analytics. You discover two types of predefined application role types: General Ledger Access Set Data Security and Profitability Analysis Duty. Which application role type do you use to secure access to the subject area?. You can use any application role type to secure access to the subject area. The duty role secures access to the subject area. The data role secures access to the subject area.

59. You're implementing custom data security. Is it necessary to create custom data roles to apply filters to the objects you want to secure?. Yes, you must first create a data filter, then create a custom data role to apply the filter. It's optional. You can choose out-of-the-box or custom data roles. Yes, you must first create custom data roles before you proceed with custom data security.

60. Which action is a prerequisite for creating a data pipeline for any functional area?. Set up pipeline parameters. Configure single sign-on. Complete data security assignments.

61. In the FAW Security framework, which mapping paradigm best describes the mapping of Security Context 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.

62. What happens when you deactivate a functional area?. The functional area is permanently removed, along with the existing data available in the data warehouse. All future data copies to the warehouse are discontinued. It stops the data pipeline process from pulling new data from the source application when incremental jobs are run. Data reloads for the functional area during the next scheduled incremental data load.

63. You want to customize or extend Oracle Fusion Data Intelligence (FDI) prebuilt offerings to meet your specific business requirements. Which statement describes FDI capabilities?. Customizations and extensions are available at all the layers of the FDI architecture components. They include FDI visualization, data, and semantic layers. Prebuilt FDI customizations and extensions are limited. You must work with Oracle Support to complete customizations and extensions. Customizations and extensions are only available in the FDI visualization layer. You can use Oracle Analytics Cloud features to create custom reports.

64. You can create your custom subject areas from a custom data model. Which two common data model issues impede performance?. Suboptimal indexing. Improper design of partition. Using advanced functions in the logical layer. Improper report design.

65. What's a limitation of the Promote Objects feature?. There are no known limitations. You can't choose what to migrate. It replicates one environment to another. You can't migrate Data Augmentation.

66. You have a security requirement to limit access to a particular folder in the subject area. How do you meet the requirement?. This feature isn't available yet. Anyone with access to the subject area can access all the folders. You can implement security at the report level and provide access to reports based on the required column set security. You can create a custom duty role and secure the folder in the subject area with it.

67. You successfully create your FDI instance with a private endpoint and you have the instance URL. Which scenario will you encounter if you try to access the URL?. You can access the URL immediately. You already implemented the required prerequisites for creating a private endpoint instance. You can't access the URL. Additional network configurations are required. You can access the URL after the FDI instance is active.

68. You create an FDI instance with a private endpoint, but you want to change it to a public endpoint. What option do you have?. You must terminate the existing instance and re-create the instance. Open an SR with Oracle Support. The DevOps team can convert the endpoint. You can convert the endpoint from the FDI Instance Management page in OCI. Simply select the available option to convert from private to public.

69. What is the default smallest interval of incremental data load for all functional area and supported data sources to the FDI data warehouse?. Weekly. Hourly. Daily.

70. Data validation in FDI uses basic authentication, and you must provide the credentials of a user with the appropriate privileges to validate the extracted data. Which prebuilt Fusion Application role must be assigned to the user for validating the source credentials?. ESS Admin. BI Administrator. BI Impersonator.

71. During Data Augmentation implementation, you scheduled an incremental load with the FDI Connector at the same time as your prebuilt Fusion Application data pipelines. What precautions do you need to take?. Data Augmentation with FDI Connectors is of higher priority than the prebuilt Fusion Application pipelines. The prebuilt pipelines are executed after data augmentations with FDI connectors are completed?. Data Augmentation with FDI Connectors and prebuilt Fusion Application pipelines require scaled up resources if they run in parallel. Scale up the ADW and OAC instances associated with FDI. Data Augmentation with FDI Connectors is of lower priority than the prebuilt Fusion Application pipelines and may get rejected if they overlap during the scheduled pipeline incremental runs.?.

72. You want to leverage Oracle Cloud Infrastructure (OCI) Vision to perform object detection on a dataset available in Oracle Analytics Cloud (OAC) embedded in FDI. Which OAC feature enables you to perform AI analysis on a dataset?. OCI Vision can't be leveraged from within OAC embedded with FDI. It's a feature available in standalone OAC. The Create Connection feature in OAC will allow authors to leverage the OCI Vision service to perform object detection on datasets available in OAC embedded with FDI. Data Flows in OAC allow authors to leverage OCI Vision to perform object detection on datasets available in OAC embedded with FDI.

73. You integrated your external application into FDI. Now, you want to create additional semantic model extensions for the external application. Can you use User Extensions in Semantic Model Extensions?. Depending on your requirements, you can either modify your application and re-import it, or use User Extensions in Semantic Model Extensions. The only option is to modify your external application and re-import it. The only option is to use Data Augmentation.

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

75. You activated your Universal Credits subscription in one tenancy, but you want to move the activation to another tenancy. What's the process?. You can reuse the Welcome email and follow the activation steps again, this time in the desired target tenancy. Adding a subscription to a tenancy can't be undone. The OCI Console provides a GUI to move the subscription from one tenancy to the other.

76. You identify a conformed dimension between your FDI and External Application. You intend to use the External Application feature to leverage the conformed dimension. Which statement is a prerequisite from a design perspective?. The column lengths shouldn't be longer than 24 characters. The columns must be of the numeric data type. The data types of the conforming columns must match.

77. When you create a Content bundle, all OAC objects such as workbooks, analyses, and datasets are included in the bundle. You simply deploy the bundle in the target and all objects appear in the target instance. Is this statement correct?. Yes, all objects are included in the Snapshot created as part of the Content bundle. Simply deploy the bundle and all objects are moved to the target instance. No, all objects aren't included in the Snapshot created as part of the Content bundle. Datasets aren't included. Yes, all objects are included in the Snapshot created as part of the Content bundle. You must select the All Objects option during the bundle creation process. Simply deploy the bundle and all objects are moved to the target instance.

78. You configured single sign-on (SSO) with your Fusion Application. What elements are synchronized from the Fusion Application?. Users and job-specific roles are synchronized in FDI from the Fusion Application. The job-specific roles are called Groups in FDI. The User to Group assignments are also synchronized. Users and out-of-the-box job-specific roles are synchronized in FDI from the Fusion Application. The job-specific roles are called Groups in FDI. Custom job-specific roles from the Fusion Application aren't synchronized. Users and job-specific roles are synchronized in FDI from the Fusion Application. The job-specific roles are called Groups in FDI. The data role and duty role mappings are also synchronized from the Fusion Application.

79. What's the frequency at which predictions are generated for the prebuilt AI/ML models available with FDI, for example, Collection Risk and Date Predictions?. The model calculates and generates predictions on future data daily. The model calculates and generates predictions on future data once every month. The model calculates and generates predictions on future data once a week.

you activate FDI in a cloud account containing an Oracle Fusion Application. Which configuration, from the given options, is critical to ensure a successful single sign-on (SSO) implementation?. Ensure synchronization between the Fusion Application's Internal Identity Service and cloud account identity domain. Ensure that users are copied from the Fusion Application's Internal Identity Service to the cloud account identity domain. Establish an ETL process to move user data from the Fusion Application's Internal Identity Service to the cloud account identity domain.

81. You already created a new custom subject area with a custom fact and custom dimension. You want to extend the dimension in your custom subject area by adding new attributes from another data source. What basic steps are required to achieve this in User Extensions of Semantic Model Extensions?. Create a sandbox and edit an existing logical star. After you edit the logical star, modify an existing subject area to expose the required customized elements. The only available option is to utilize OAC to integrate the new attributes with the custom subject area. Custom subject areas aren't extensible. You need to create a new custom subject area including the new attributes.

82. You want additional data without transformations from your Fusion source Public View Objects (PVO) and to extend your prebuilt subject area with the additional data What's the recommended approach to implement this use case?. Use Data Augmentation to move data and use the External Applications capability to extend the prebuilt subject area. Use Data Augmentation to move data and use the Semantic Model Extension capability to extend the prebuilt subject area. Data Augmentation can move data and extend semantics. Use Data Augmentation to move data and extend the prebuilt subject area.

83. There's a requirement to merge an existing OAC implementation with the out-of-the-box semantic model in FDI. Which feature in Semantic Model Extensions do you use?. Currently, there isn't a way to merge external applications into the FDI semantic model. Use External Applications in Semantic Model Extensions to implement this. You must reimplement the OAC semantic model into the FDI semantic model with User Extensions.

84. You want to specify an Enterprise Calendar parameter value to configure the reporting calendar used in FDI. Where do you set this parameter?. You can specify this parameter in Pipeline Settings while you configure reporting. You can specify this parameter while activating the functional areas. You can specify this parameter in Global Parameters while you configure reporting.

85. You are implementing Fusion ERP Analytics. Can you have different Financial Categories from your Fusion ERP Application?. No, you must leverage the financial categories defined in Fusion Applications. Yes, FDI allows you to use financial categories different from your Fusion ERP Application. Yes, Fusion Applications allows you to have two sets of financial categories, one for Fusion ERP Application and a different one for use in FDI.

86. You have created a custom duty role to grant object level security. Which statement describes the relationship between an analytical object and a custom duty role?. You can grant access to multiple analytical objects using one custom duty role. You can grant access only to a single analytical object using one custom duty role. You can grant access only to subject areas using the custom duty role.

87. You're aware of a preview feature that's critical for your implementation. What does Oracle recommend?. Open an SR with Oracle Support to enable preview features. Preview features aren't available by default, but administrators can turn individual preview features on or off at any time. Once enabled, use preview features for your development and production. Preview features allow your organization to explore and try new features before they rollout as generally available. Don't use preview features in production instances.

88. Your Fusion Application implementation is yet to begin. Can you proceed to create an FDI instance without a source Fusion Application URL?. Yes, you can create your FDI instance without specifying the Fusion Application data source. However, you must involve Oracle Support in the instance creation process. Yes, you can create your FDI instance without specifying the Fusion Application data source. There is no need to involve Oracle Support in the instance creation process. No, you can't create your FDI instance without specifying the Fusion Application data source.

89. You are implementing JWT authentication between FDI and a Fusion Application. Which is an important prerequisite configuration for successful authentication?. Upload both of the X509 key pairs in the source Fusion Application. Upload the private key in the source Fusion Application. Upload the public key certificate in the source Fusion Application.

90. You want to create an FDI instance directly in OCI Console. Which is an Oracle-recommended best practice during implementation?. Create all instances of FDI in the root compartment of your tenancy. Create separate compartments for each FDI instance type. For example, create a compartment for the test FDI instance and another for the production FDI instance. Create a single compartment for all FDI instance types. For example, create a compartment for the test and production FDI instances.

91. You want to add security assignments to a user, but you can't find the security context. What is your next step?. Ensure the user is assigned the appropriate group and that the group has the appropriate data role to assign security values. Ensure the user is assigned the appropriate FDI-specific system groups. Map the required data role to the user directly to assign security values.

92. You are implementing Oracle Fusion HCM Analytics. A non-administrator user in an analyst role requires access to all data in HCM. Can you provide the privilege to any user other than the FDI administrator?. Yes, the prebuilt HR Analyst group in HCM Analytics provides users access to all HCM data. You must assign this group to the non-administrative user. Yes, you must create a group and assign it to the required users. Ensure you grant access to all HCM data using OCI policy. No, you can't provide a user with unrestricted access to all HCM data. Only the FDI administrator has access to all HCM data.

93. You want to avoid creating Fusion Applications users and their assigned job roles in FDI. What options are available in FDI for synchronizing users and job roles between FDI and Fusion Applications?. The only option is to use the FDI Console Security option to create and manage users and job roles. Use the Bulk Load option in FDI to perform the synchronization. Implement SSO and the synchronization of users and job roles between FDI and Fusion Applications before provisioning the FDI instance.

94. As part of a detailed analysis requirement, you created a report that lists a large number of transactions. You need this data for further offline analysis. Is it advisable to download this data from workbook visualizations?. No, do not use workbook visualizations as a data extraction tool. Yes, you can use workbook visualizations for data extraction irrespective of the data size. O. Yes, however, workbook visualizations must be set up in a tabular format before you extract the data.

95. You notice that the scheduled incremental data refresh has started. What operations are disabled during the refresh?. Ad hoc data refresh for functional areas is not possible during a scheduled data load. FDI subject areas aren't accessible. Data Augmentation is disabled.

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

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

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

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

100. You have recently provisioned a new Fusion Analytics Warehouse (FAW) instance and want to enrich your Subject Areas with Descriptive 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.

101. 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 Business Administrator in the Oracle Cloud account. No special security privileges are required by the user to activate UCC and FAW in the Oracle Cloud account.

102. 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 and Exadata Database Service on Dedicated Infrastructure. Oracle Analytics Cloud, NoSQL Database Cloud Service, and Golden Gate.

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

104. 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 has similar 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.

You need to create additional custom subject areas in your FDI instance. FDI provides facilities to modify and extend the semantic model. Which two are recommended features in FDI that provide extensibility to the semantic model?. Semantic Model Extensions. Dimension Alias. External Applications. Report Configuration.

106. Your development team has performed multiple extensions in the semantic model. All extensions have been merged to the main sandbox. You want to review these extensions and possibly roll What is the rollback process?. Create a new sandbox and review all the merged extensions in the sandbox. To roll back, delete the extensions done to the logical star and subject areas,. You must review and validate all the actions in the sandbox before merging. Once you merge the sandbox, there's no rollback. Rollback can be done by updating the main sandbox directly.

107. The user extension that you validated and tested earlier is now failing. What could be a possible cause?. You executed an on-demand data refresh request on the related functional area pipeline. Your custom ETL process changed the structure of the target table in ADW due to changes in the data structure at the source. The FDI application went through a release update.

You plan to leverage the User Extension feature available in Semantic Model Extensions to create custom joins with the prebuilt logical star. Ensure the join columns are of compatible data types. You can't create a custom join with a prebuilt logical star. You must create a custom logical star from scratch. Ensure the table is populated with data.

You're implementing custom data security. You can create data filters at both the table and column levels. Is there a recommendation for optimum performance?. Yes, Oracle recommends you create the data filter at the table level. There's no recommendation. Create data filters at any level, table or column. Yes, Oracle recommends you create the data filter at the column level.

You have a security requirement to limit access to a particular folder in the subject area. How do you meet the requirement?. This feature isn't available yet. Anyone with access to the subject area can access all the folders. You can implement security at the report level and provide access to reports based on the required column set security. You can create a custom duty role and secure the folder in the subject area with it.

You successfully implemented a security model in Fusion Applications that meets your security requirements. What feature in FDI supports automatic synchronization of data security assignments from Fusion Applications to FDI?. Evaluate your security requirements and utilize security customization features in FDI to meet your needs. Create a pipeline for the Security Configuration Option functional area for each application you implement in FDI. Set up SSO between FDI and Fusion Applications.

What feature in FDI supports automatic synchronization of data security assignments from Fusion Applications to FDI?. Evaluate your security requirements and utilize security customization features in FDI to meet your needs. Create a pipeline for the Security Configuration Option functional area for each application you implement in FDI. Set up SSO between FDI and Fusion Applications.

116. You decided to use Data Augmented to additional content from Fusion Applications. What is the best way to identify PVO for the Fusion Applications object you want to extract?. You must review the data lineage documentation in Fusion Applications that provides mapping between OTBI subject areas and PVOs. You must review the data lineage documentation in FDI that provides mapping between OTBI subject areas and PVOS. You have to identify the physical database table in Fusion Applications that contains the content you 're looking for.

118. You used DFE Attribute Mapper to extend your prebuilt subject area. However, the extraction process is failing. What could be the possible reason?. You selected an attribute with a hierarchy that's not flattened. You selected an attribute that isn't BI-enabled. You selected an attribute that': already present in the prebuilt subit area.

119. Which prebuilt Fusion Application role must be assigned to the user for validating the source credentials?. BI Administrator. OESS Admin. OBI Impersonator.

120. As an administrator, you can enable preview and generally available features. Which statement best describes generally available features ?. The generally available features you enable require scaling up your ADW. Be sure you scale up the resources before enabling them,. The generally available features you enable require an additional subscription. Be sure to complete the ordering process before enabling them. The generally available features aren't available by default, but administrators can turn individual features on or off at any time. Once enabled, use it for your development and production.

121. You are implementing Oracle ERP Analytics. You want to synchronize data security assigned to users for business units and ledgers from the Fusion Application to FDL Which configuration do you adopt during security implementation ?. Ensure users have the appropriate job-specific groups assigned to them before activating the Security Configuration Option functional area. You must use the Data Augmentation feature to pull in assignment details from the Fusion Application. Once this data is available, download it to a text file and upload the assignments synchronize the security assignments for business units and ledgers. This automation isn't possible and you must maintain the security assignments for business units and ledgers offline.

You want to restore an FDI application. You have all the required bundles. Which bundles do you need to restore an application?. As part of the restore process, you need the Data Configuration and Environment bundles. As part of your restore process, you need the Content and Environment bundles. As part of the restore process, you need the Environment bundle.

You can use the Promote Objects and Bundles features to migrate objects from a test environment to production. Which statement best describes the difference between the features?. Promote Objects allows you to migrate from test to production instances across tenancies. Bundles enables you to migrate objects across instances in the same tenancy. To promote objects, you need OCI Administrator privileges. To use the Bundles feature, you need the Service Administrator role in FDL. Promote Objects allows you to migrate from test to production instances on the same tenancy. Bundles enables you to migrate objects across instances and across tenancies.

The X509 key pair is at the core of JWT creation and management. When you create a public key, you can specify an expiration for your public key certificate What's the recommended expiration period?. Oracle recommends a 180-day expiration period for a public key certificate. Oracle recommends a 90-day expiration period for a public key certificate. Oracle recommends a 365-day expiration period for a public key certificate.

126. Which statement best describes the security for OAC catalog objects available on the FDI home page?. Oracle recommends direct user-level security permissions for catalog objects. The content duty roles available within duty role types must be used to grant security to the catalog objects. All catalog objects are available to all users.

You activated your Universal Credits subscription in one tenancy, but you want to move the activation to another tenancy. What's the process?. The OCI Console provides a GUI to move the subscription from one tenancy to the other. Adding a subscription to a tenancy can't be undone. Creating a custom logical star using the prebuilt tables available in ADW associated with FDI.

10. How many environments are available, by default, for an Oracle Fusion Data Intelligence (FDI) subscription?. Your FDI subscription, by default, contains two environments: development/test and production. Your FDI subscription, by default, contains four environments: development, test, user acceptance test, and production. Your FDI subscription, by default, contains three environments: development, test, and production.

You are implementing Oracle Fusion HCM Analytics. A non-administrator user in an analyst role requires access to all data in HCM. Can you provide the privilege to any user other than the FDI administrator?. No, you can't provide a user with unrestricted access to all HCM data. Only the FDI administrator has access to all HCM data. Yes, the prebuilt HR Analyst group in HCM Analytics provides users access to all HCM data. You must assign this group to the non-administrative user. Yes, you must create a group and assign it to the required users. Ensure you grant access to all HCM data using OCI policy.

Your user that activates FDI can also create the FDI instance. However, your implementation plan states that a different non-administrative OCI user must create the instance. What steps do you follow for this user?. During the activation process, the user activating FDI must enter the non-administrative user name designated to create the FDI instance. Grant the Service Administrator privilege to the non-administrative user to enable them to create the FDI instance. Create a group, assign the identified non-administrative user to it, and grant the group with the necessary policies to manage the FDI resources within the planned compartment.

134. Your test Fusion Cloud Application instance was just refreshed with data from the production environment. You're using a password-based authentication to connect from FDI to a test Fusion Cloud Application instance. What step is required for the data pipeline to run without any issues?. You must update the source application URL. You must update the notification email address of the FDI instance with the email of the identified user to connect to the source Fusion Cloud Application. You must update the applicable user's credentials if the passwords aren't the same in all environments.

136. Fusion Analytics Warehouse (FAW) allows you to select the Descriptive Flex fields (DFFs) you want to move to your data warehouse. What setup must you ensure in your Fusion Application for FAW to perform this operation?. 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. Ensure that the DFFs and their attributes are BI-enabled in your Fusion Application.

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

138. What FDI components and artifacts can you migrate and back up with Bundles?. You can selectively choose what components you want to add to a Bundle for migration or backup. You can't add data to a Bundle. You can migrate and back up all your data in your custom schema, along with Semantic Model Extensions.

139. What is the recommended approach to schedule your incremental data load?. Your data refresh is typically completed daily. It doesn't matter when you schedule incremental upload. Schedule it at off-peak hours to ensure minimum impact. Schedule it at midnight local time of the region where FDl is provisioned.

140. You used the prebuilt subject area to create a custom workbook in FDI. Which recommendation optimizes the workbook's performance?. Enable the brushing feature for custom workbooks. It optimizes data queries and visualization response. Create your custom workbook with custom calculations and prompts that are dependent on each other. Use the recommended filters for the prebuilt workbook and keep the OAC brushing feature turned off.

141. You want to import and deploy a bundle on a target environment. In which given scenario will the deployment be successful?. The instance versions for source and target do not matter. Bundles from any source version will get deployed to any target instance. The source is at a higher version and the target is at a lower version. The source is at a lower version and the target is at a higher version.

142. As a Security Administrator, you can automate updating security assignments to manage regular organizational changes. To ensure that changes in security assignments are updated automatically, create a table for the OAX USER schema in the ADW associated with your FD instance. Regularly seed data into this table. When do these changes take effect?. FDI immediately applies the assignments. FDI applies the assignments after the scheduled incremental refresh is complete. FDI periodically scans the synonym once every two hours, picks up the values, processes the data, and applies the security assignments.

143. You successfully implemented a security model in Fusion Applications that meets your security requirements. What feature in FDI supports automatic synchronization of data security assignments from Fusion Applications to FDI?. Create a pipeline for the Security Configuration Option functional area for each application you implement in FDI. Evaluate your security requirements and utilize security customization features in FDI to meet your needs. Set up SSO between FDI and Fusion Applications.

144. In FDI, there are many subject areas with their corresponding data available for you to use to create and edit analyses and reports. How can you modify the security for subject areas?. Unlike Fusion Application, subject areas aren't secured in FDI. Any FDI licensed user can access them. Oracle secures FDI subject areas by using application duty roles. The security for subject areas can be modified using Security Configurations in Semantic Model Extensions. Oracle secures the FD subject areas by using application duty roles.The security for subject areas can't be changed.

145. You have an instance of Oracle ERP Analytics, and you also subscribed to Oracle CM Analytics. You want both to be part of the same FDI instance. What process do you follow?. You update the offerings from the instance page in OCl Console. Activate the new subscription and then link it to the required FDI instance during the activation process. You can simply start to create the CM functional areas in the existing FDI instance.

146. As part of your security implementation, you must implement data security for FDI users. In addition to the Security page in FDI Admin Console, what other options are available to implement the process?. Implement single sign-on to synchronize data security from Fusion Applications to FDI. Take advantage of the available OCI API. Use Upload Center in FDI Administration Console to bulk load security assignments.

147. How many extensions can you have in a sandbox to be able to modify the semantic model?. It supports more than one extension. It supports only one extension at a time. A maximum of five extensions per sandbox is allowed.

148. You want to take extra precautions to back up the data warehouse of your FDI instance. Raise an SR with Oracle Support. Use FDI Bundles. Use Oracle Data Pump.

149. You are assigned to the FAW Security Administrator system group in FDI. Do you need additional privileges to perform user-group management?. No, the FAW Security Administrator system group in FDI allows you to perform user-group management tasks. Yes, as a Security Administrator, you can perform user-group management if you are assigned with the Administrator privilege in OC| domains. Yes, as a Security Administrator, you can perform user-group management if you are assigned FDI Service Administrator privileges.

150. You want to scale up Oracle Autonomous Data Warehouse (ADW) and Oracle Analytics Cloud (OAC) as part of your FDI customization. Who can help you with upscaling capacities?. Oracle Support. An Oracle Cloud Infrastructure (OCI) administrator with access to OCl pages for OAC and ADW instances. A use with the FAW Functional Administrator (group and role) privileges.

151. You create an FDl instance with a public endpoint. Is it possible to allow access to the instance without network traffic going over the public internet?. It's not possible. Your only option is to terminate the instance and re-create it with a private endpoint. It's possible if you use the Instance Management page to convert the instance to a private endpoint. It's possible if you configure DRG and establish site-to-site VPN and other related network components.

152. You successful created your FDI instance with a private endpoint. Which statement is true for FDI with a private endpoint?. A private endpoint allows the use of multifactor authentication for additional security. The private endpoint provides a secure protocol, and the URL is HTTPS, whereas for FDI with public endpoint, the protocol is HTTP. An FDI instance with private endpoint is accessible through private network traffic, and direct public internet access is prohibited.

153. If you schedule data validation in the FDI Admin Console, where do you find the results generated by the system?. Results are emailed to the Functional Administrator. Results are available in a custom table in ADW created for this purpose. Results are available in a workbook in the OAC Catalog Common folder.

154. You recently provisioned a new FDI instance and you want to enrich the out-of-the-box subject areas with Descriptive Flexfields (DFF) from Fusion Applications. Which FDI feature enables you to implement this requirement?. If a new Descriptive Flexfield is added to your Fusion Application, simply reload the relevant functional area. You can utilize Custom Data Configurations and leverage the Descriptive Flexfields option. This requirement can be implemented using the External Application feature in Semantic Model Extension, which offers the flexibility to meet your specific needs.

155. Which of these statements highlight the need for Reporting Configuration?. Set up Reporting Configuration to specify how data is presented on the key metrics, workbooks, visualizations, dashboards, and reports in Oracle Fusion Data Intelligence. Set up Reporting Configuration to populate the data in the subject areas related to the specific pillars. Reporting Configuration is required to set the initial extract date for extracting the data from the source application.

156. How many environments are available, by default, for an Oracle Fusion Data Intelligence (FDI) subscription?. Your FDI subscription, by default, contains two environments: development/test and production. Your FDI subscription, by default, contains four environments: development, test, user acceptance test, and production. Your FDI subscription, by default, contains three environments: development, test, and production.

157. You implemented data security in Fusion Applications. You want to replicate this in your FDI implementation. What is required?. The combination of security configuration and custom data security should meet your data security requirements. You must exclusively use the security customization in FDI for data security to meet your requirements. The out-of-the-box data security configuration provides you with the required features to implement data security in FDI identical to Fusion Applications.

158. As part of your security automation, you activate the Security Configuration Option functional area. The new business requirements suggest that you must have a separate set of security assignments in FDI. What steps do you take to successfully meet this requirement?. You can download the current security assignments, edit assignments, and upload new assignments. You must manually update security assignments from the FDI Admin Console Security page. You can download the current security assignments, edit assignments, and upload new assignments. You must deactivate the Security Configuration Option functional area after upload.

159. What's the frequency at which the prebuilt Al/ML models train, for example, Collection Risk and Date Predictions?. The ML model trains or recalibrates itself weekly to improve predictions over time. The ML model trains or recalibrates itself daily to improve predictions over time. The ML model trains or recalibrates itself monthly to improve predictions over time.

160. You can use the DFF Attribute Mapper to extend your prebuilt subject areas with the DFFs configured in the source Fusion Application. What does Oracle recommend for your implementation?. Select all the attributes to improve performance. Use other extension techniques. DFF Attribute Mapper impedes performance. Select the attributes required for your implementation.

161. You want to leverage Oracle Fusion Data Intelligence (FDI) data to build Al-powered specific use cases and use Oracle Machine Learning (OML). Which approach do you adopt?. OML isn't available with the embedded ADW. Before you use OML, you must move FDI data into another ADW external to FDI. Build your use case with OML within FDI Oracle Autonomous Data Warehouse (ADW). All OML features are available with the ADW embedded in FDI. OML isn't available with the embedded ADW. Reach out to Oracle Support to enable this feature in the ADW associated with FDI.

162. You want to configure custom security, and you created a custom group for FDI. What is the next step after your users are assigned to this custom group?. Define a policy in OCI for the newly created custom group. Complete the security assignments for each of the users in the custom group. Map the required data, duty, and licensed roles to the newly created custom group.

163. What does Oracle recommend you do when you choose a cloud account to activate Fusion Data Intelligence (FDI)?. Oracle doesn't offer any recommendation on choosing a cloud account for FDI activation. Activate your FDI subscription in a separate cloud account. The cloud account for your Oracle Fusion Cloud Applications should be exclusively for use by the Oracle Cloud applications. Activate the FDI subscription in the same cloud account as your Oracle Fusion Cloud Applications.

27. Which two capabilities are available through Semantic Model Extensions?. Add a new fact. Add a new dimension.