"A script enabled browser is required for this page to function properly"

Oracle Certification

Hyperion Financial Management 9.3 Administrator I & II

Sample Questions

View answers below

Sample questions are provided solely to familiarize candidates with the multiple-choice format and writing style of questions that will be found on the exam.  Sample questions may not cover the full spectrum of difficulty that is covered by the exam questions. Success on the sample questions does not predict success on the exam.

1. How are users provisioned in Hyperion System 9 Financial Management?
  1. LDAP server
  2. Authentication directory
  3. Microsoft User Manager
  4. Shared Services User Management
2. What can you do with a Workspace? (SELECT ALL THAT APPLY) 
  1. Nest workspaces within workspaces.
  2. Assign security classes to workspaces to limit access.
  3. Copy workspaces to other applications.
3. Which Function is used to assign values to accounts? 
  1. Input
  2. Calc Status
  3. Alloc
  4. Exp
4. Application Profiles are used to define the application _____. (SELECT TWO). 
  1. calendar.
  2. dimensions.
  3. account attributes.
  4. frequencies.
5. What are the characteristics of a Sub EnumMemberLists()? (SELECT THREE)
  1. Specify the number of lists for each dimension.
  2. Used to add members to a list.
  3. Names each member list in each dimension.
  4. Used to create both static and dynamic lists.
  5. Specifies which dimensions have member lists.
6. Which standard dimension provides an audit trail of the transformations applied to Hyperion System 9 Financial Management data? 
  1. Period dimension
  2. Entity dimension
  3. Value dimension
  4. Account dimension
7. What is the first thing that must be done before using Smart View in Excel? 
  1. Connect to a Financial Management application.
  2. Set the Point of View.
  3. Create a function to retrieve the data
  4. Connect to the Web server.
8. Where are Plug accounts set up, and where are the results of the plug accounts seen? 
  1. Metadata Manager, Parent Current Total value dimension.
  2. Metadata Manager, Elimination value dimension.
  3. Grid Settings, Contribution value dimension.
  4. Application Profile settings, Entity Currency Adjust value dimension.
9. Given the following hierarchy, a report designer creates a book and sets the Member Selection for the Entity dimension to Book Point of View and Children of HQ. The report designer then adds the book to a batch. The batch Point of View for the Entity dimension is set to HQ.
For what entity/entities will the batch be run?
  1. HQ
  2. A, B, and C
  3. HQ, A, B, and C
  4. Entity, HQ, A, B, and C
10. When defining the Dimension Layout of a grid, the report designer may move dimensions into all of the following areas EXCEPT for:
  1. Cells
  2. Rows
  3. Columns
  4. Pages
11. To create reports in Financial Reporting Studio, a user must have the ____________ role. 
  1. Report Designer
  2. Report Editor
  3. Analyst
  4. Manager
12. When creating a row and column template, which item is NOT saved with the template? 
  1. Related content
  2. Expansions
  3. Cell formatting
  4. Dimension and member selections


  1. D
  2. AB
  3. D
  4. AD
  5. ACE
  6. C
  7. A
  8. B
  9. C
  10. A
  11. A
  12. A