Exam Code: 1Z0-525 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: Oracle Business Intelligence Applications 7.9.6 for ERP Essentials
Certification Provider: Oracle
Free Today! Guaranteed Training- Pass 1Z0-525 Exam.

2017 Jan 1Z0-525 exam

Q21. Which three variable types does the BI Applications data model support for specifying currencies? 

A. Document 

B. Local 

C. Global 

D. Override 

Answer: A,B,C 


Q22. How can you be sure to access a specific data source in a default Oracle BI Applications installation for users working from a client machine? Assume that log level 2 has been enabled. 

A. With log level 2 or higher enabled in the NQsConfig.ini, you can check the SQL from the query log of a specific Answers request. Read the SQL and check the connection pool(s) used and the data source name(s). 

B. The only data source in a standard BI Applications installation is the data warehouse. This source is defined in DAC in the Setup View under Physical Data Sources. You can also check the (native) connection credentials. 

C. Sources can range from data warehouse to OLTP systems. Their connections are named in connection pools in the BI repository. Using these connection names you can check the (native) connection credentials. 

D. All physical connections are defined in Informatica Powercenter Repository Manager. Log in and check all connection credentials. 

E. Users can log in to Answers, the BI repository, DAC or Informatica to check connection credentials and data source names. 

Answer:


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

A. i, ii 

B. ii, iii 

C. i, iii 

D. i, ii, iii 

Answer:


Q24. How many Informatica Repository Servers can be configured with a single DAC server? 

A. One 

B. Two 

C. Three 

D. Any number 

Answer:


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


Improved 1Z0-525 free draindumps:

Q26. 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 Warehouse in case of A. Sales order information of a Stock Broker or B. HR information of a small city? 

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:


Q27. Which variable is changed for Target Warehouse in the OBIEE repository while promoting the code to the new environment? 

A. TARGET_DB 

B. OLTP_DSN 

C. DW_CONNECTION 

D. OLAP_DSN 

Answer:


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

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


Q29. Which is the right sequence of a typical Informatica Type 1 Customization? 

i) Extend Staging and target Database table to accommodate new column. 

ii) Copy appropriate Informatica mapping and workflow to Informatica Custom folder. 

iii) Modify the existing Informatica mapping workflow to accommodate new columns. 

iv) Modify DAC with the necessary change. 

A. i, ii, in, iv 

B. i, iii, ii, iv 

C. iii, ii, i, iv 

D. ii, i, iii, iv 

Answer:


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

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

B. Start looking for base elements in the physical layer in the repository. If available you can directly build the ratio in the Business Model and Mapping Layer, set available for querying in the presentation layer and test results in Answers. If not available, check the warehouse tables and lastly the source tables. 

C. Directly start building SDE and SIL mappings to enhance the warehouse with extra columns. Register the mappings and new warehouse objects in the DAC, run the ETL and model in the BI repository. Test your work in Answers. 

D. Build a request in Answers based on the online BI Repository and create your new ratio as a new column based on other columns. 

E. Build a request in Answers directly on the source data available to you and create the new ratio as a new column in your report. 

Answer:

67. Which three tasks is DAC capable of handling Data Warehouse connection Information? 

A. Managing an Informatica workflow. 

B. Executive an external program. 

C. Running a SQL file. 

D. Performing a database Backup/Restore. 

Answer: A,C,D