01. What are security filters used for in Hyperion Planning?
a) Restricting data access based on user roles and responsibilities
b) Protecting the physical servers hosting the application
c) Automating currency conversion processes
d) Creating and managing business rules for data validations
02. How can end users perform financial reporting in Hyperion Planning?
(Choose two.)
a) By using Smart View to create custom financial reports in Microsoft Excel
b) By accessing financial reports through the web interface
c) By writing custom scripts in Calculation Manager
d) By creating and managing business rules in Planning End User features
03. Assuming the following dimensions and members: Scenario - Actual, Budget and Year - 2010, 2011, you need to create a data form with two columns.
One column should list Actual for 2010 and the second column should list Budget 2011. You do not want to show data for Actual 2011 even though the first three months of the year have been loaded from the GL.
What is the best way to only show the 2 columns in the data form?
a) You cannot build a data form with these two columns; the columns will display Actual > 2010, Actual > 2011, Budget > 2010 and Budget > 2011.
b) Use Segments on the data form to create the asymmetric columns.
c) Use User Variables on the data form to create the asymmetric columns.
d) Use a composite data form to meet this requirement.
e) Use data suppression on the data form.
04. Which module in Hyperion Planning is used for workforce planning and managing personnel-related expenses?
a) Capital Expense Planning
b) Financial Reporting
c) Workforce Planning
d) Data Forms Designer
05. Management dictates a major reorganization of the company structure, meaning you need to rebuild the Entity dimension from the beginning. You need to delete members in the Entity dimension.
Identify the three true statements about deleting members from a Planning application.
(Choose three.)
a) You must delete members one by one.
b) You must delete a reference to a member from all data forms before deleting it from the dimension.
c) In a data form definition, you selected @IDescendants(IT) for the entity dimension in the page section. The IT member will remain but 2 of its 10 cost centers are being removed. You must remove the reference to "IT" in this data form.
d) You should back up all data for the deleted entity members; after a member is deleted, the data is not retained.
e) A database refresh is required after deleting members from the Entity dimension.
06. Identify the correct set of required dimensions for Planning.
1. Account
2. Entity
3. Version
4. Years and Periods combined into one dimension
5. Scenario
6. Minimum one user-defined dimension
a) 1, 2, 3, 4, 5, 6
b) 1, 2, 3, 5
c) 1, 2, 3, 5, 6
d) 1, 2, 3, 4, 5
07. What are the three supported methods to create and update a member and its properties (assuming Classic or non-Classic Planning applications)?
(Choose three.)
a) Planning Web Client
b) EAS
c) EPMA
d) DRM
e) Outline Load Utility
08. Given the following:
1. Measures (Dense): 40 stored members, 50 total members
2. Time (Dense): 17 stored members, 17 total members
3. Scenario (Dense): 2 stored members, 5 total members
4. Market (Sparse): 100 stored members, 100 total members
5. Product (Sparse): 500 stored members, 550 total members
How many potential blocks could be created?
a) Potential Blocks = 40 * 17 * 2
b) Potential Blocks = 40 * 17 * 2 * 8
c) Potential Blocks = 100 * 550
d) Potential Blocks = 100 * 500 * 8
e) Potential Blocks = 100 * 500
f) Potential Blocks = 100 * 550 * 8
09. In Hyperion Planning's Dimension Editor, which action can you perform with access rights?
a) Define custom hierarchies for dimension members
b) Assign read and write permissions to specific users and groups
c) Create and manage business rules for calculations
d) Set up security filters for data access restrictions
10. When designing a data form in Forms Designer, which option can be used to control cell-level security?
a) Using Smart Lists to limit the available choices in data cells
b) Defining data validation rules for cells
c) Assigning read and write permissions to specific users
d) Creating custom menus for cell-level actions
The Oracle Hyperion Planning Essentials (1Z0-533) Sample Question Set is designed to help you prepare for the Oracle Hyperion Planning 11 Certified Implementation Specialist certification exam. To become familiar with the actual Oracle Certification exam environment, we suggest you try our Sample Oracle 1Z0-533 Certification Practice Exam.
