FDI Certification

Which Oracle FDI Feature allows administrators to cuztomize data pipelines for specific fuctional areas?. Data Augmentation. Functional Area Managment. Security Framework. Backup and Restore Tools.

How does detailed data validation differ from standard data validation in Oracle FDI?. It applies to encrypted data only. It requieres manual configuration. It is faster but less accurate. It focuses on specific fields, records, and thresholds.

What does deploying and FDI instance with a private endpoint ensure?. High availability across OCI regions. Secure communication within a Virtual Cloud Network (VCN). Faster data validation. Automated backup and recovery.

Which Feature in Oralce FDI enables administrators to test new features before general availability?. Feature Previews. Beta Releases. Sandbox Mode. Previe and Generally Available Features.

What is the purspose of configurating detailed data validation?. To verify specific fields and values within the data. To automatically archive the data. To monitor users activities. To secure private endpoinds.

How ae configuration changes typically migrated between environments in Oracle FDI?. By recreating configurations manually. By automatin backups. By using bundles to export and import configurations. By enabling Preview Features.

Which component is typically customized to support specific reporing requiremets in Oracle FDI?. Semantic Model. IAM Roles. Private Endpoints. oci Comparments Settings.

Which Oracle Cloud Infraestructure (OCI) requirement must be fullfilled before creating an FDI instance?. Setting Up Autonomous Database. Installing Oracle APEX. Configuring the required networking and compartments in OCI. Deploying Oracle Database on-premises.

What is the primary goal of configuring user and group management in Oracle FDI?. Automating all databases backups. Controlling access to resources and features bases on roles. Migrating data across regions. Automating the deployment of private endpoints.

Why is it important to configure user roles in Fusion Applications before creating an FDI Instance?. To allow database backups. To create autonomous indexing. To enable role-based access to FDI resources and analytics. To deploy private endpoints.

You plan to utilize the external application feature of the semantic model extension. Using External Application results limits Data Augmentation usage. Which feature of Data Augmentation isn’t available for implementation?. You can’t use Data Augmentation Connectors. You can only use Data Augmentation with the source Fusion Application. You can’t use Data Augmentation Semantic Model Update feature if you use the External Application Feature. You can’t use Data Augmentation to bring external data into ADW associated with FDI if you use the External Application feature.

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

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

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

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

You have a table in your custom schema in ADW and you want to use semantic Model Extensions to create a dimension. Which fact tables can you join your custom dimension to?. You can only join a custom dimension with a fact table. Only degenerate dimensions are supported. You can join your custom dimension with a custom fact and out-of-the-box fact tables.

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

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

You are required to join the Fusion Applications data extracted through FDI with external data. Which approach meets your need?. You must join the two sets of data in the ADW Schema. Extensibility allows data from 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.

You plan to leverage the user Extension feature available in Semantic Model Extensions to create custom joins with the prebuilt logical star. What does Oracle recommend for creating custom joins?. 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 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?. The only option is to use data augmentation. The only option I to modify your external application and re import it. Depending on your requirements, you can either modify your application and re-import it, or use user extensions in semantic model extensions.

As a 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?. Take advantage of the available OCI API. Implement single sign-on to synchronize data security from Fusion Applications to FDI. Use upload Center in FDI Administration Console to bulk load security assignments.

You´re implementing custom data security. Is it necessary to create custom data roles to apply filters to the objects you want to secure?. 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. Yes, you must first create a date filter, then create a custom data role to apply the filter.

You implemented data security In Fusion Applications. You want to replicate this in your FDI Implementation. What is required?. You must exclusively use the security customization In FDI for data security to meet you requirements. The combination of security configuration and custom data security should meet your data security 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.

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?. 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. Unlike Fusion Applications, subject areas aren’t secured in FDI. Any FDI licensed user can access them. Oracle secures the FDI subject areas by using application duty roles. The security for subject areas can’t be changed.

What is the difference between the security page available from FDI admin console and the security configurations tab available in semantic model extensions?. The security page in FDI Admin Console allows you to implement out-of-the-box security. The other feature allows you to implement custom security. The security page in FDI Admin Console allows you to implement custom security. The other feature allows you to implement out-of-the-box security. There is no difference between them.

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

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

You terminated an FDI instance from the oracle cloud infrastructure (OCI) Console, but now you want to reinstate. Can you recover a terminated instance?. You can recover a terminated instance by clicking the restore button available in the OCI console. You can’t recover a terminated instance; you must re-create your instance and then restore it. You can recover a terminated instance with SR with Oracle support.

You’re implementing Fusion ERP Analytics. You discover two types of predefined applications role type: General Ledger Access Set Data Security and Profitability Analysis Duty. Which application role type do you use the 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.

You’re aware that a new FDI Application update just became available. What’s a best practice for upgrading an FDI Instance?. Review the documentation and prepare for the upgrade but allow Oracle to handle the actual upgrade process. Raise a SR with oracle for a safe upgrade. Review the documentation, prepare for the upgrade, and schedule it when you’re ready.

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

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 three environments: development, test, and production. Your FDI subscription, by default, contains four environments: development, test, user acceptance test, and production.

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

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 after the FDI instance is active. You can’t access the URL. Additional network configurations are required. You can access the URL immediately. You already implemented the required prerequisites for creating a private endpoint instance.

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

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 reset all the functional areas. After you reset the data warehouse, you must activate each of your data pipelines for the functional areas. After you rest the data warehouse, you must delete and recreate each of your data pipelines for the functional areas.

Refreshing the data pipeline for a functional area allows you to bring in incremental data immediately. Often, administrator execute the 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 aren’t any issue or concerns to consider. Yes, executing an on-demand data while working on the data may cause temporary inconsistencies. Yes, executing an on-demand data brings in all data from the initial extract date. Since it brings in all data, it takes longer to execute.

You notice that the scheduled incremental data refresh has started. What operations are disable during the refresh?. Ad hoc data refresh for functional area is not possible during a scheduled data load. FDI subject areas are not accessible. Data Argumentation is disabled.

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?. 50 GB. 500 GB. 1 TB.

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

You want to create an FDI instance directly in OCI Console. Which is an Oracle-recommended best practice during implementation?. Create a single compartment for al FDI instance types. For example, create a compartment for the test and production FDI instances. 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 all instance of FDI in the root compartment of your tenancy.

You want to move external data to the Oracle Autonomous Data Warehouse that comes with FDI. Which feature in FDI enables this?. The only available option is to use OCI Data Integration to move data. You must use an ETL that connects to ADW as there is no such feature in FDI. Use Manage connections to create a connection to available sources. Data augmentation can be used against connections to bring data into ADW.

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.

You want additional data without transformations from your fusion source public view objects (PVO) and the 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. Data augmentation can move data and extend semantics. Use data augmentation to move data and extend the prebuilt subject area. Use data augmentation to move data and use the semantic model Extension capability to extend the prebuilt subject area.

You used DDF attribute mapper to extend your prebuilt subject area. However, the extraction process is falling. What could be the possible reason?. You selected an attribute that’s already present in the prebuilt subject area. You selected an attribute with a hierarchy that’s not flattened. You selected an attribute that isn’t BI-enable.

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 the attributes required for your implementation. Use other extension techniques. DFF attribute mapper impedes performance. Select all the attributes to improve performance.

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, you must create a group and assign it to the required users. Ensure you grant access to all HCM data using OCI policy. Yes, the prebuilt HR Analyst group in HCM Analytics provides user access to all HCM data. You must assign this group to the non-administrative user. No, you can’t provide a user with unrestricted access to all HCM data. Only the FDI administrator has access to all HCM data.

39.- In the FDI security framework, which mapping paradigm best describes the mapping of security context to data roles?. Security context to data role is mapped as many-to-many. Security context to data role is mapped as one-to-many. Security context to data role is mapped as one-to-one.

Where can you create custom groups in FDI?. You can manually create groups in the appropriate domain from the OIC Console or the 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.

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.

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

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

Your developer team has created multiple steps in the semantic model. You want to rewiew these steps and possibly roll them back. What is the rollback process?. You must rewiew all de 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. Rewiew all the steps that are merged inside the "User Extension" main area. To rollback, you can then disable the steps.