1Z0-525 | Latest Oracle 1Z0-525 dumps
Q21. 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
Q22. 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: A
Q23. 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
Q24. By default for a session in Informica, which properly is used to configure the minimum number of errors to be encountered, to mark the session as failed?
A. Error limit
B. Minimum Errors
C. Stop on Errors
D. Error Benchmark
Answer: D
Q25. Which is not a customized fact or dimension table?
A. wc_xxx_f
B. w_xxx_f
C. wc_xxx_fs
D. wc_xxx_a
Answer: B
Explanation:
WC—this denotes as warehouse custom.
Q26. What is a DTM in Informatica?
A. Data Transmission Manager
B. Data Transmission Mode
C. Data Transformation Manager
D. Data Transformation Mode
Answer: C
Explanation: DTM is Data Transformation Manager
Q27. 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: C
Q28. Which two statements are true?
A. It is recommended to co-locate the DAC Client with the Power Center Client Tool on the same machine.
B. It is recommended to co-locate the DAC Server and Power Center Server on the same machine.
C. It is recommended to co-locate DAC Server, Informatica Server, and the Database Server on the same machine.
D. It is recommended to co-locate the DAC Server, Informatica Server, and BI Server on the same machine.
Answer: A,B
Q29. Which module is not covered in BI Applications for EBS?
A. Financial Analytics
B. HR Analytics
C. Procurement and Spend Analytics
D. Marketing Analytics
Answer: D
Q30. What is the purpose of csv files under the SrcFiles folder in Informatica server home?
A. They are used to store Informatica parameters.
B. They are the source for enterprise-dependent data, required for loading certain dimensions.
C. They are used to hold data extracted during ETL processes.
D. They are used for customization.
Answer: A