Preguntas D01-D17

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 FDI instance. Regularly seed data in this table. When do these changes take effect?. 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. FDI immediately applies the assignments.

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 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 is no rollback. Rollback can be done by updating the main sandbox directly.

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. 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. No, executing an on-demand data refresh brings in incremental data. There are no issues or concerns to consider.

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

You want to leverage Oracle Fusion Data Intelligence (FDI) data to build AI-powered specific use cases and use Oracle Machine Learning (OML). Which approach do you adopt?. OML is not available with the embedded ADW. Reach out to Oracle Support to enable this feature. OML is not available with the embedded ADW. 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.

You want to edit global data pipeline parameters. How do you ensure that your changes are deployed and the data is consistent?. 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 during the next incremental upload. Global pipeline parameter changes take effect immediately.

You configure single sign-on (SSO) with your Fusion Application. You need a user to access FDI, but this user is not 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 and create the user in the underlying ADW associated with the FDI instance. Your only option is to add the user in the Fusion Application for the user with FDI access.

You want to customize or extend Oracle Fusion Data Intelligence (FDI) prebuilt offerings to meet your specific business requirements. Which statement describes FDI capabilities?. 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. Customizations and extensions are available at all the layers of the FDI architecture components. They include FDI visualization, data, and semantic layers.

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?. 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. Grant the Service Administrator privilege to the non-administrative user to enable them to create the FDI instance. During the activation process, the user activating FDI must enter the non-administrative user name designated to create the FDI instance.

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.

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

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

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 table is populated with data. Ensure the join columns are of compatible data types. You cannot create a custom join with a prebuilt logical star. You must create a custom logical star from scratch.

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 modify your external application and re-import it. The only option is to use Data Augmentation. Depending on your requirements, you can either modify your application and re-import it, or use User Extensions in Semantic Model Extensions.

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 are not extensible. You need to create a new custom subject area including the new attributes.

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 join your custom dimension with a 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.

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 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. You need to create a custom duty role and set up data filters that specify values for specific dimensions.