1Z0-525 - Oracle Business Intelligence Applications 7.9.6 for ERP Essentials Exam
Go back to Oracle
The parameter files generated by DAC are_____.
created for each workflow, using the combination of parameters specified in the parameterfileDW.txt and parameterfileOLTP.txt
Which two are mandatory pre-installation tasks for Informatica Power Center Client installation?
Creation of ODBC Database Connections
Pre-installation of Oracle Business Intelligence Enterprise Edition
The webcat structure, along with various other presentation parameters are stored in:
Which is not a customized fact or dimension table?
What are action links used for?
Direct navigation from BI record to transactional data source
Where is the appropriate JDBC Driver installed to enable DAC to connect to the database?
What is the default location where parameter files are created by DAC?
During what phase does DAC calculate the sequence of the tasks listed under the selected subject area?
when you "assemble" the subject area
Which three calendar types are supported by BI Applications 7.9.6 release?
13 Period, 4-4-5
Fiscal and Gregorian
Which statement is true about the safe path in SDE and SIL mappings when implementing a Type I customization?
The safe path defines a path through which all extension logic should be routed and is indicated in the mapping by a placeholder column named x_custom.
Which utility is used by the DAC server to issue commands to read information in the Informatica repository?
Which task level parameter(s) control(s) the granularity of data in Aggregate tables?
How does DAC know the source OLTP and target Data Warehouse connection Information?
This information is given in the Physical Data sources tab in DAC client.
Data Warehouse Administration Console (DAC) interacts with Informatica Server using what command?
Considering loading a fact named w_xxx_A, what is the exact sequence in which the mappings related fact are loaded?
PLP-> SIL -> SDE
How many Informatica Repository Servers can be configured with a single DAC server?
Web object security can be enforced at which three levels?
What is the significance of the Informatica parameter files: parameterfileOLTP and parameterfileDW?
They contain the standard parameters for each task that is to be configured in DAC
Which three variable types does the BI Applications data model support for specifying currencies?
Which statement is true?
SIL stands for Source Independent Load and is used to move the data from staging tables to Data Warehouse.
Which variable is changed for Target Warehouse in the OBIEE repository while promoting the code to the new environment?
Which utility reads the contents of the .ctl file and generates the SQL statements to create and alter tables?
The Out of the Box BI Applications reports that are included on the dashboards are role based. How do you support these roles specifically in workflows?
Roles can be supported in workflows by using session variables as filter in permission settings such as enabling access permissions for user groups and data security, defining workflows by guided navigation and column behavior, dashboard links and conditional guided navigation on dashboard sections.
A large insurance company ABC-Safe uses PeopleSoft and Hyperion Planning & Budgeting for Financial Analytics and a third-party software package for HR Compensation. ABC-Safe wants to have a consolidated picture of its finances and compensation packages. What would you advise?
Oracle BI applications cannot be enhanced by data from third-party software packages.
Which types of data level security are available in BI Applications? i) Operating Unit ii) Inventory Organization iii) Company Organization iv) Ledger v) Business Group vi) Primary Employee/Position Hierarchy-based
i, ii, iii, iv
The universal adapter in Informatica, is used to load data from what two sources?
Legacy OLTP Systems
Which module is not covered in BI Applications for EBS?
How does the DAC task instruct Informatica whether to run a full load or incremental load?
DAC issues additional parameters to Informatica.
Which combination of the following machines represents an appropriate architecture for an Oracle BI Applications implementation? i) Machine A running DAC Server and DAC Client ii) Machine B running DAC Server and Informatica Services iii) Machine C running Informatica Services and Informatica Client tools iv) Machine D running DAC Client and Informatica Client tools v) Machine E running DAC server and client, Informatica services and Client tools vi) Machine F running Oracle BI EE components vii) Machine G running an Oracle Database hosting the data warehouse viii) Machine H running the source system
Machines: A, C, F, G, H
Which two parameters are to be set while configuring BI Applications for Supply Chain Analytics?
Inventory Master Id
Category Master Id
During which phase of the Oracle BI Applications project flow are decision makers interviewed for the first time?
What is a DTM in Informatica?
Data Transmission Manager
Which two are considered Informatica Type II Customizations?
Addition of new Fact and Dimension tables to the data warehouse for packaged application datasource(s).
Addition of new rows (to existing tables) from the source systems for non-packaged application datasource(s).
Considering BIEE is seamlessly integrated with source application, identify three ways in which user credentials can be passed on to BIEE from the source application login.
http header / url
Which two Ports are checked while implementing Slowly Changing Dimension in Oracle BI Application?
Which Informatica Power Center component is used for configuration of domain, server grid and services?
By default how many aging buckets are configured for Accounts Payable/Receivables Aging reports?
In an Oracle BI Cluster Server environment which statement is true?
BI Scheduler can reside outside Local Area Network (LAN) whereas the other components (Clustered BI Servers, Master BI Server, BI Cluster Manager) of Oracle BI Cluster Server must reside on the same LAN.
To enable SSO integration of the Source EBS Application with BIEE which file do you need to configure?
Which item under DAC connection information will be modified while promoting the code to a new environment?
Which three attributes identify a single set of books?
Chart of accounts
What is a set of books? i) It is synonymous with a Ledger ii) A set of books identifies a company or fund that shares a common chart of accounts structure, calendar, and functional currency iii) List of parameters required for the ETL to run successfully
Some users need a new Critical Success Factor or Ratio based on a measure that is not available. How would you help them in a way that is the least time consuming?
Start looking in the source database(s) for base elements. Next step would be to check BTL if these are already mapped and available in the warehouse. If not, build new ETL, register ETL and new warehouse objects in DAC and model in BI repository. If available, build the new ratio in the Business Model and Mapping Layer, set available in the presentation layer and test in Answers.
Which csv file contains grouping information of natural accounts?
Data Warehouse Administration Console Is used for which three purposes?
Defining ETL subject areas and execution plans
Prioritizing and load balancing of the ETL workflow execution
Performing automatic index management
Upon which two entities can security be based when using PeopleSoft as source application?
How can you be sure that all ETL tasks are executed in the right ordering by Informatica?
Execute all ETL using DAC Subject Areas embedded in execution plans. DAC will calculate the ordered tasks.
How does Informatica know which source OLTP and target Datawarehouse connection information is to be used for task execution in BI Applications?
This information is given in the DAC Parameter file.
Which three tasks is DAC capable of handling Data Warehouse connection Information?
Managing an Informatica workflow.
Running a SQL file.
Performing a database Backup/Restore.
The Green Factory (a national agricultural organization with one office for IT support and consisting of 20 farmers, 2 dairy producing factories, and a vegetables and flowers Auction) wishes you to implement Sales Analytics and enable all members to benefit most from the Out of the Box materials. What would you advise?
As Answer A, but check and reuse existing user groups