Q1. What is the primary purpose of Extended Analytics in FM?
A. Exports Financial Management metadata and data to an Essbase database
B. Exports Financial Management metadata and data to a relational database
C. Exports Financial Management metadata and data to an Excel pivot table
D. Provides analytic capabilities directly against the Financial Management application
Answer: A
Q2. What are two effects of deploying an EPMA application?
A. The EPMA metadata is extracted to a text file.
B. If enabled, it pushes the data to Essbase via Essbase Analytic Link for FM.
C. The EPMA application metadata is used to create an FM application on the FM server.
D. The application is sent out to a star schema for use by Essbase and other products.
E. When you redeploy an application, the application metadata is merged or replaced based on the changes made since the last deployment.
Answer: CE
Q3. Identify the dimensions that are built by using the application profile?
A. Year and period only
B. Value and view only
C. View, Period, and Year
D. Period, Value, and Year
E. Scenario, Period, and Year
Answer: C
Q4. Assuming you are using HFM Version 11.1.1.3, identify the three true statements about Calculation Manager.
A. FMRulesMigrator.exe will migrate VB scripts into business rules in Calculation Manager.
B. There is no utility to migrate VB script rules to Calculation Manager.
C. In Calculation Manager, you can toggle back and forth between the graphical and script mode.
D. In Calculation Manager, you can create one script that can execute against both a Financial Management application and Planning application.
E. To use a business rule, you must validate and deploy the business rule.
Answer: ACD
Q5. How does the FM administrator manage the Intercompany Partner dimension?
A. By selecting and deselecting the IsICP field on the entity member properties
B. By selecting and deselecting the IsICP field on the account member properties
C. It cannot be maintained by the administrator. FM automatically creates the ICP dimension to match all members in the Entity dimension.
D. It cannot be maintained by the administrator. FM automatically creates the ICP dimension to match all members in the Account dimension.
E. Using the Dimension editor in the same way as a custom dimension or Entity dimension
Answer: A
Q6. Identify the three true statements about ERP Integrator (ERPI).
A. ERPI supports PeopleSoft, Oracle E-Business Suite and SAP.
B. ERPI integrates metadata and data from ERP source system into an Oracle Hyperion EPM target application.
C. ERPI provides drill through from Financial Management data forms, Smart View, and Financial Reporting.
D. ERPI provides drill through to BI Dashboards.
E. ERPI under the covers is Oracle Data Integrator.
Answer: ABD
Q7. Identify the four processes through which Financial Management supports a virtual close.
A. A fully automated consolidation tool that combines financial data across many ledgers and consolidates to a corporate or business unit level
B. Automatic posting of eliminating entries, accrual entries, and allocations
C. Automated collection, mapping, verification, and movement of data
D. Automated intercompany processing
E. Analysis capabilities throughout close over the Web and in Excel
Answer: ACDE
Q8. Identify the three true statements about security classes.
A. Security classes are grouping mechanisms for assigning security access to sets of related members, documents, or other objects.
B. Access levels for security classes include metadata, read, promote, and none.
C. Security classes are assigned to FDM locations in addition to FM objects.
D. Security classes cannot be created in EPMA by creating a Security Class dimension and associating it.
E. Security classes are created in Classic FM under Load Tasks.
Answer: ABC
Q9. The Account dimension's Is ICP "R" property specifies________.
A. If ICP transactions, including self-ICP transactions, are enabled for the account
B. If ICP transactions are not enabled for the account
C. if ICP transactions can be drilled back to source activity
D. if ICP transactions are enabled for the account, but the account cannot have ICP transactions with itself
Answer: D
Q10. When designing for Planning and Financial Management, what are the design considerations for dimensions and member?
A. In FM, spaces are allowed in member names while in Planning, spaces are not allowed in member names.
B. In FM, spaces are not allowed in member names while in Planning, spaces are allowed in member names.
C. In FM, descriptions are not required to be unique while in Planning, aliases must be unique.
D. A and C
E. B and C
Answer: C
Q11. Identify the three true statements about Dimension Associations in EPMA.
A. Dimension associations are used when a property in one dimension is associated with the members in another dimension.
B. The Security Class dimension is associated with the Security Class property only in an Account and Entity.
C. The Alias dimension is associated with the Alias property for Account, Entity, and Scenario dimensions.
D. The Currency dimension is associated with the Currency property of the Account dimension.
E. A Plug Account from the Account dimension can be associated with the Account dimension.
Answer: ACD
Q12. For a classic application, what are the two valid methods to extract metadata to a text file?
A. You can extract metadata using the EPMA file generator.
B. Metadata can be extracted from within FM under extract tasks.
C. Metadata can be extracted from within EPMA Dimension Library.
D. Metadata can be extracted from the File > Export menu.
E. Metadata can be extracted from an FDM application.
Answer: AB
Q13. Identify the three true statements about the Financial Management architecture.
A. Hyperion Financial Management uses a multitier architecture that includes a client tier, application tier, and a data tier.
B. The client tier (user interface) communicates with the data tier.
C. The client tier (user interface) communicates with the application tier.
D. The application tier contains the application as well as the report and Web servers.
E. The data tier contains the Essbase database for all Hyperion Financial Management application data and source data.
Answer: ACD
Q14. The file format load journals to FM can include which four sections?
A. File Format
B. Scenario
C. Journal Group
D. Standard
Answer: ABCD
Q15. Given the following syntax in a business rule:
A. Calculate ()
B. strview
C. Hs.Exp
D. DIFFERENCE
E. Hs.Scenario.DEFAULTVIEW (“”)
Answer: A
Q16. To which dimension do custom dimensions provide additional detail?
A. Accounts
B. Entity
C. Value
D. ICP
E. Custom dimensions are independent of other dimensions.
Answer: A
Q17. Your source data file has values for 12 months across the columns. What is the best way to load this file into FM with native load functionality?
A. Split the file into 12 different files, each with a single month. Set the POV for the Period dimension = specific month.
B. Define a range for periods in the POV with the following syntax: !Period = January.. December.
C. Make sure the column header has the month label; FM will load the column to the correct month.
D. List the months in the POV with the following syntax:! Period = January-December.
E. List the months in the POV with the following syntax:! Period = January, December.
Answer: B
Q18. For metadata loads, you can import changes to metadata for which three application elements?
A. Periods
B. Accounts
C. Entities
D. Currencies E. Value
Answer: BCD
Q19. Identify the two true statements about property value inheritance for dimension members in EPMA.
A. Property values are always inherited from ancestors and cannot be changed.
B. Property values are inherited from the closest ancestor except when a property value has been specifically entered.
C. You must manually enter and store property values for all the dimension members.
D. Property value inheritance decreases maintenance requirements for dimensions.
E. Inheritance takes precedence over properties defined in metadata load files.
Answer: BD