Introducing The New!
Surepassexam Collection
Get Unlimited Access to all
Surepassexam's PREMIUM files
Q1. Identify the two true statements about Enterprise performance Management Architect.
A. If you decide to implement EPMA, all Planning applications must be EPMA-deployed applications.
B. EPMA-deployed applications may either use EAS Business Rules or Calculation Manager in
11.1.1.3.
C. You can create Planning, TM, Essbase, and FDM applications in EPMA.
D. Data can be shared from a Planning application to an FM application within EPMA.
E. EPMA can be used by end users to manage and update member properties such as hierarchies and aliases.
F. In the Dimension Library, you can maintain one full dimension (for example. Account) but filter portions of the dimension for different applications (for example, Revenue accounts. Balance Sheet)
Answer: BD
Q2. Identify the two true statements about a sparse Entity dimension In Hyperion Planning.
A. You cannot build alternate rollups or assign custom attributes.
B. Base currencies are assigned to entity members.
C. Exchange rates are assigned to entity members.
D. Entity along with Scenario and Period make up a planning unit.
E. Entity along with Scenario and Version make up a planning unit.
Answer: BE
Q3. Assuming you have a Period dimension with calendar months rolling to quarters to total years. If you assign the property Time Balance Last to the "Headcount" account member, what will user see for Q1?
A. January's value
B. March's value
C. The total of January+February +March
D. The average of January + February + March
Answer: B
Q4. You have the following design requirement: You need to track customer status For a sales planning application. Valid options for customer status include: Active, Inactive, Out of Business. Customer status can change on a month-by-month basis.
What is the best way to build Customer Status into the Planning application?
A. Attribute dimension
B. Varying attribute dimension
C. Smart List
D. Free Form Text
E. Alternate hierarchy
Answer: C
Q5. Identify two times when a security refresh needs to be performed.
A. Member access has been assigned to a group.
B. Member access has been assigned to a user.
C. New group is created.
D. A new Member "East" has OnDESCENDANTSCREAD.access assigned.
E. New business rule is created.
Answer: AB
Q6. Identify the correct set of required dimensions for Planning.
A. Account
B. Entity
C. Version
D. Years and Periods combined into one dimension
E. Scenario
F. Minimum one user-defined dimension
Answer: ABCDE
Q7. Identify the one Planning component that is not accessible over the Web.
A. Dimension Editor for Planning
B. Shared Services
C. Exchange Rates Definition
D. Planning Utilities
E. Create and Manage Database Options
F. Create Data Sources
Answer: D
Q8. Planning utilizes which type of database to store data (for example, "the numbers")?
A. Block Storage Option Essbase database
B. Aggregate Storage Option Essbase database
C. Relational database
D. XOLAP database
E. Proprietary database
Answer: A
Q9. Given the following:
Measures (Dense): 40 stored members, 50 total members
Time (Dense): 17 stored members, 17 total members
Scenario (Dense): 2 stored members, 5 total members
Market (Sparse): 100 stored members, 100 total members
Product(Sparse): 500 stored members, 550 total members
What is the block size in bytes?
A. Block size = 40 * 17 * 2
B. Block size = 40 * 17 * 2 * 8
C. Block size = 50 * 17 * 5 * 8
D. Block size = 50 * 17 * 5
E. Block size = 100 * 500 * 8
F. Block size = 100 * 500
Answer: B
Q10. What are the two possible effects on the database when the data storage property of a parent member in the sparse Entity dimension is set to Dynamic Calc?
A. Essbase data block size decrease.
B. The member is not available for process management.
C. Retrieval performance could be slower when referencing the parent entity member.
D. Data cannot be input to the parent in target versions.
Answer: AC
Q11. The Hyperion Planning administrator needs to run several calculations in a specific order against two different databases within the application. Identify the two options that are not valid.
A. Esscmd
B. Calc Script
C. Business Rule Sequence
D. MaxL
E. Business Rule Macro
Answer: AD
Q12. What four prebuilt actions are available In EAS Business Rules?
A. Aggregate
B. Copy Data
C. Clear Block
D. Clear Data
E. Create Block
F. Allocate
Answer: ABDE
Q13. You need to create an allocation Business Rule that allocates marketing expense from corporate down to each region based on FY10 actuals for the Budget scenario. What is the correct formula assuming this syntax is used in an enhanced calc script?
A. FIX (Budget, @LEVMBRS (Market,0))
"Marketing expense" = "Marketing expense "->Corporate * ("Marketing expense"
Actual / "Marketing expense" -> Actual —> TotalMarket);
ENDFIX
B. FIX (Budget, (@LEVMBRS (Market, 0) ) )
"Marketing expense" = "Marketing expense"->Corporate * ("Marketing expense"/"Marketing
expense" —> TotalMarket) ;
ENDFIX
C. FIX (Budget, (@LEVMBRS (Market, 0) )
--- "Marketing expense" = "Marketing expense"->Corporate * ("Marketing expense”
Actual ->FY10 / "Marketing expense" -> Actual ->FY10 TotalMarket);
ENDFIX
D. FIX (@LEVMBRS (Market, 0) )
"Marketing expense" = "Marketing expense"~>Corporate * (“Marketing expense”
Actual ->FY10 / "Marketing expense" -> Actual ->FY10 TotalMarket);
ENDFIX
Answer: B
Q14. Identify the two true statements with regard to Versions and Scenarios.
A. Versions control data entry based on time periods set by the administrator.
B. There is only one Version to one Scenario.
C. Versions allow several "what-if" Scenarios.
D. Users must have the same security settings in the Version dimension as they have in the Scenario dimension.
E. Versions can be top down or bottom up.
Answer: CD
Q15. Identify the three true statements about attribute dimensions.
A. Planning supports hierarchies and aliases for attribute dimensions.
B. Planning supports all attribute types (for example. Boolean, Date, Text).
C. Planning supports varying attributes (where an attribute can vary over one or more other dimensions).
D. Attribute dimensions can be assigned to dense dimensions.
E. Attribute dimensions may only be assigned to one base dimension.
Answer: ABE
Q16. Identify three key benefits of the Planning solution.
A. Standardized data forms for plan data entry available both for the Web and in Excel
B. One tool to budget and forecast as well as provide reporting for very detailed Actuals Information
C. Central repository of business rules that can be run by end users to calculate plan data
D. Detailed security down to the cell level
E. Flexible solution customizable for almost any kind of budgeting and forecasting process
Answer: ACE
Q17. You need to calculate benefit expense in your Planning application using the following logic: Benefit expense is equal to the Total Salary of the Organization multiplied by a factor data loaded to each cost center.
Given the following components, what is the correct order of calculation:
1-Custom calculation (Total Salary * Factor)
2-Aggregate benefits
3-Aggregate salaries
A. 1, 2, 3
B. 3, 2, 1
C. 2, 3, 1
D. 3, 1, 2
Answer: D
Q18. In a non-multicurrency Planning application, what three things happen if all options are checked for Refresh Database?
A. Dimension and member changes are pushed to Essbase.
B. Cell text and supporting detail changes are pushed to Essbase.
C. Security filters for dimensions and members are pushed to Essbase.
D. Security filters for shared members are pushed to Essbase.
E. Data changes are pushed to Essbase.
Answer: ACD
Q19. Which three tasks can be performed using the Smart View Planning Provider in Microsoft Excel?
A. Open a data form and submit data.
B. enter supporting detail and cell text.
C. Run business rules.
D. enter planning unit annotations.
E. Perform workflow tasks.
Answer: ABC
Q20. You've created an EAS business rule and assigned it to the data form but an end user can't see it. What are two valid reasons?
A. The user doesn't have the Launch Business Rules role in Shared Services.
B. The user hasn't been assigned Validate or Launch Privileges in EAS.
C. The location for the Business Rule hasn't been defined.
D. The user hasn't been assigned access to the Business Rule in the Planning Web client.
Answer: AB