Cisco IBM Oracle HP Certification Exams In Microsoft forums

　
　
Exam : Hyperion Solutions 4H0-020
Title : Hyperion Certified Design Lead Hyperion System9 Planning 4.1

1. What methods are available to move data between different applications? (SELECT ALL THAT APPLY)
A. Shared Services
B. Shared Members
C. Data export/import
D. Copy Versions
E. Partitioning
Answer: ACE

2. A custom Dimension called "Sales" has Sales Person at level 0. Sales Persons are each associated with a single Sales Channel and a single Geography. Your client would like to see a report showing Sales Channel in the columns and Geography in the rows. How can this reporting need be best satisfied?
A. Sales dimension hierarchy for geography and attribute dimension for sales channel
B. Sales dimension hierarchy for geography and alternate hierarchy for sales channel
C. Sales dimension hierarchy for geography and dimension for sales channel
D. Sales dimension hierarchy for sales channel and alternate rollup for geography
Answer: A

3. Which point(s) are applicable when determining whether to include more than one plan type within an application? (SELECT ALL THAT APPLY)
A. The ESSSVR process will share resources across multiple plan types
B. Including multiple plan types in one application requires less maintenance than multiple applications with a single plan type in each
C. Having multiple plan types in multiple applications requires additional licensing
Answer: ABC

4. The Entity dimension is organized by regions, with locations rolling to regions. "Projects" is added as a custom dimension. Which option will impact application performance most adversely?
A. Add an attribute dimension to the Project dimension to assign projects as "New" or "Existing".
B. Add a custom dimension called Project Type with the members "New" and "Existing".
C. Create shared rollups in the project dimension based on new and existing projects.
D. Add projects to the project dimension under the parents "New" and "Existing".
Answer: B

5. It is more appropriate to use versions over scenarios when: (SELECT ALL THAT APPLY) NOTE: If there is no difference in functionality, do NOT select the member.
A. data must be input at an upper level member.
B. a smart list tag must be applied.
C. different exchange rates must be utilized for a currency application.
D. access must be restricted across different time periods and years
E. When Read Only vs Read/Write security must be applied.
Answer: A

6. It is more appropriate to use scenarios over versions when: (SELECT ALL THAT APPLY) NOTE: If there is no difference in functionality, do NOT select the member.
A. data must be input at an upper level member.
B. a smart list tag must be applied.
C. different exchange rates must be utilized for a currency application.
D. access must be restricted across different time periods and years
E. Read Only vs Read/Write security must be applied.
Answer: CD

7. Which methods are available to move data between databases within a single application? (SELECT ALL THAT APPLY)
A. Partitioning
B. Xref in calc script
C. Hyperion Application Link
D. Visual Basic
E. Report Scripts and Data Load Rules
F. SQL Query
G. Essbase Retrieve and Lock and Send
H. Hyperion Master Data Manager
I. Essbase Integration Server
Answer: ABCDEG

8. Which statement(s) is/are correct regarding the administrative Copy Data feature available in the Planning Web? (SELECT ALL THAT APPLY)
A. Data can be copied between versions only, for select scenarios
B. Data can be copied between scenarios only, for selected versions
C. Data can be copied between any dimensional intersection, assuming all dimensions and members are present in the selected plan types
D. Cell Text is copied
E. Account Annotations are copied
F. Supporting detail is copied
G. Planning Unit Annotations are copied
H. You are prevented from copying to Planning Units that have been approved
Answer: CDEF

9. A client would like the page member selection on a web form for one dimension to determine the page members available for a second dimension. How could this be accomplished?
A. Define the page member relationship in the web form definition
B. Through java script customizations
C. Assign UDA’s to the dimension in the second page drop down
D. (can not be done)
Answer: B

10. FNV Company allocates actual G&A expenses to specific lines of business based on planned headcount in their annual strategic plan. Indicate the most appropriate calculation order to arrive at a consolidated income statement. (SELECT THE BEST STATEMENT)
A. Aggregate/Consolidate database
B. Run allocation process
C. Calculate Salary & Benefits
D. Calculate Total Assets
E. Calculate Total Expenses
A. A,C,E,D,B
B. C,E,D,A,B
C. E,C,A,B
D. C,E,B,A
E. C,D,E,B,A
Answer: D

11. When using Shared Services for data integration, a dimension is eligible to be moved to the dynamic POV when which condition(s) are met? (SELECT ALL THAT APPLY)
A. The dimension is sparse.
B. The dimension is dense.
C. No other dimensions exist in the dynamic POV.
D. The members in the dimension are selected explicitly.
E. The members in the dimension are selected by function.
F. The dimension has a large number of members and must be updated often.
Answer: ACD

12. Which of the following statements are true regarding currencies? (SELECT ALL THAT APPLY)
A. Base currencies are assigned to entities
B. One entity can have input in multiple currencies
C. Base currencies are assigned to accounts
D. One account can have input in multiple currencies
Answer: ABD

13. SCENARIO: A company wants to do custom salary planning application in addition to their standard Expense and Revenue Planning in Hyperion Planning. The company has 1000 employees spread across 250 cost centers. Detailed planning is done at the employee level for Salaries & Wages and Benefits accounts, but not for any other expense accounts. HR department requires that all new hires and transfers occur in PeopleSoft, therefore you can assume that no data will exist for a single employee across multiple cost centers. Cost center managers may only view and edit salary data for their own existing employees in Hyperion Planning.
What is the optimal application design to achieve the best possible system performance? (SELECT ONE OPTION FROM THE TABLE)
A. Option 1
B. Option 2
C. Option 3
D. Option 4
E. Option 5
F. Option 6
Answer: C

14. The user takes a form offline on Friday. The administrator updates the web form over the weekend and deletes several accounts from the form. What happens when the user synchronizes the form on Monday?
A. A synchronization error will occur with no update to the data.
B. The synchronization message will be generated with no update to the data.
C. The synchronization will occur to existing cells with a message that some cells may not be saved.
D. (none of the above)
Answer: C

Free 4h0-020 Demo Download

Examsoon offers free demo for Hyperion Solutions Certifications 4h0-020 exam (Hyperion Certified Design Lead Hyperion System9 Planning 4.1). You can check out the interface, question quality and usability of our practice exams before you decide to get it. We are the only one site can offer demo for almost all products.

Free Download 4h0-020 PDF Braindumps Trainning Materials