Oracle Business Intelligence Applications 7 for ERP Essentials v6.1 (1z0-525)

Page:    1 / 5   
Total 75 questions

Which Informatica Power Center component is used for configuration of domain, server grid and services?

  • A. Repository Manager
  • B. Designer
  • C. Workflow Manager
  • D. Administration Console


Answer : D

How does Informatica know which source OLTP and target Datawarehouse connection information is to be used for task execution in BI Applications?

  • A. This information is given in the DAC Parameter file.
  • B. This information is given in Relational connections of Workflow manager.
  • C. This information is given in two flat files, fiie_source.csv and fiie_target.csv.
  • D. Informatica doesn't require knowing this information. However, it is required to give this information in DAC.


Answer : A

Which statement is true?

  • A. SIL stands for Source Independent Load and is used to move the data from staging tables to Data Warehouse.
  • B. SIL stands for Source Independent Load and is used to move the data from source to staging tables of Data Warehouse.
  • C. SIL stands for Source Intensive Load and is used to move the data from staging tables to Data Warehouse.
  • D. SIL stands for Source Intensive Load and is used to move the data from source to staging tables of Data Warehouse.


Answer : A

Data Warehouse Administration Console Is used for which three purposes?

  • A. Defining ETL subject areas and execution plans
  • B. Prioritizing and load balancing of the ETL workflow execution
  • C. Performing automatic index management
  • D. Managing access rights to the data warehouse
  • E. Defining custom dashboards queries


Answer : A,B,C

How can you be sure that all ETL tasks are executed in the right ordering by Informatica?

  • A. You can be sure after a successful batch run of the ETL in Informatica Powercenter.
  • B. You can never be really sure.
  • C. Execute all ETL using DAC Subject Areas embedded in execution plans. DAC will calculate the ordered tasks.
  • D. Execute single ETL mappings in parallel in Informatica Powercenter Workflow Manager.
  • E. Answers A or D.


Answer : C

How does the DAC task instruct Informatica whether to run a full load or incremental load?

  • A. DAC issues additional parameters to Informatica.
  • B. DAC does not handle such responsibilities.
  • C. Informatica intelligently decides whether to run a full load or not.
  • D. DAC issues separate commands for full load and incremental load.


Answer : A

Upon which two entities can security be based when using PeopleSoft as source application?

  • A. Position
  • B. HR Organization
  • C. Set Id
  • D. Business Unit


Answer : A,C

Before the implementation of a new BI Applications environment, you'll need to plan rapacity. How would you configure the initial setup of the Oracle Business Analytics

  • A. Capacity planning for A and B is the same and focused on non-frequent large ETL runs.
  • B. Capacity planning for A is focused on frequent, smaller ETL runs, including micro batches and iBot schedules and active cache management using scheduled cache purging and polling tables. For B, capacity planning is focused on less frequent bigger ETL runs and cache management using scheduled cache purging.
  • C. Capacity planning for A is focused on less frequent, bigger ETL runs and cache management using scheduled cache purging. Capacity planning for B is focused on frequent, smaller ETL runs, including micro batches and iBot schedules and active cache management using scheduled cache purging and polling tables.
  • D. Capacity planning for A and B is the same and focused on infrequent, small ETL runs.
  • E. Capacity planning for A and B is the same and focused on very frequent, small ETL runs
  • F. Capacity planning for A and B is the same and focused on very frequent, large ETL runs.


Answer : B

Which two parameters are to be set while configuring BI Applications for Supply Chain
Analytics?

  • A. Inventory Master Id
  • B. Category Master Id
  • C. Category Set ID
  • D. Inventory Category Set Id


Answer : A,B

A shipping company uses many standard forms that need to contain Customer name, address, contract information and a perfectly printable barcode for tracking orders. What functionality would you advise this organization to use from Oracle BI Applications?

  • A. Reuse as many Out-of-the-Box reports as possible.
  • B. Build requests, include these on dashboard pages and include PDF files to show the barcodes.
  • C. Schedule requests using Delivers, print these in PDF and then deliver to email addresses.
  • D. Build reports in BI Publisher based on existing BI requests or BI Presentation Layer columns.
  • E. Build reports using the Microsoft Office plug-in based on BI Presentation Layer columns.
  • F. Answer D and E are both valid possibilities.


Answer : F

After you configured object and data security the user group representatives also express their wish to change the workflow order in the Presentation Catalog available to them. How would you do that?

  • A. Add new reports or reuse existing reports in Answers and modify the column navigation behavior to define the workflow. Add the first report in the flow on a high-level dashboard page.
  • B. Add or modify guided navigation on a Dashboard page. The link should navigate to a report in the workflow.
  • C. Add or modify links on a Dashboard page. The link should navigate to a report in the workflow.
  • D. Answer A and B combined
  • E. Answer A and C combined
  • F. Answer A and E are both possibilities.


Answer : B

Your organizations management expresses the need for having specific Web content available for specific user groups, including rules that ensure data security. How would you make this work?

  • A. Run specified execution plans in DAC and enable data security in user groups in the BI repository.
  • B. Run specified execution plans in DAC, create session variable and enable data security on user groups in the BI repository.
  • C. Create session variable to define the user group, and then enable data and objects security in the BI repository.
  • D. Create specific dashboards including specific content and enable object security for the user groups in the Catalog Manager or Administration link in the web interface.
  • E. Answer A and D combined.
  • F. Answer A and D combined.


Answer : D

Which utility is used by the DAC server to issue commands to read information in the
Informatica repository?

  • A. Ddlimp
  • B. cryptotools
  • C. pmrep
  • D. pmcmd


Answer : D

Which three attributes identify a single set of books?

  • A. Chart of accounts
  • B. Currency
  • C. Calendar definition
  • D. Company name or identifier


Answer : A,B,C

Which statement is true about the safe path in SDE and SIL mappings when implementing a Type I customization?

  • A. The safe path is used by all lookup data and is used to populate variables.
  • B. The safe path columns in a mapping should not be duplicated or renamed.
  • C. 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.
  • D. 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 safePath.


Answer : C

Page:    1 / 5   
Total 75 questions