Hyperion Essbase 6 (4H0-110)

1) A default calculation is performed on an outline with Two-Pass Account members.
Which data storage setting will ensure one pass through the database?
A. Accounts-Dense, Time-Dense,Scenario-Dense, Market-Sparse, Product-Sparse
B. Accounts-Dense, Time-Sparse,Scenario-Dense, Market-Sparse, Product-Sparse
C. Accounts-Sparse, Time-Dense,Scenario-Dense, Market-Sparse, Product-Sparse
D. Accounts-SPARSE, Time-SPARSE,Scenario-Dense, Market-Sparse, Product-Sparse
Answer: A
2) How can you optimize query retrieval of databases that contain Attribute dimensions? (Choose two)
A. Order Attribute dimensions from smallest to largest
B. Place Base dimensions before other Sparse dimensions
C. Place the most-queried Base dimension at the end of the Sparse dimensions
D. Place Attribute dimensions in the outline after all Dense and Sparse dimensions
Answer: B,D
3) Which development tool should be used to construct a complex read/write budgeting application that requires the capability to add members to the outline on the server?
A. Custom application using the Essbase API
B. Basic Spreadsheet Add-in with template files
C. Hyperion Wired for OLAP deployed over their internet
D. Basic Spreadsheet Add-In with template files and Extended Spreadsheet Macros
Answer: A
4) Which two statements about Attribute dimensions are true? (choose two)
A. Attribute dimensions can contain hierarchies
B. Attribute dimension can be based on Dense dimensions
C. Attribute dimensions are dynamically calculated at query time.
D. Attribute dimensions can be used by multiple base dimensions
Answer: A,C
5) When a Location Alias is defined it__________
A. Defines a subsituation variable reference
B. Allows for the user of the @XREF function in a database
C. Indicates where a database page and index files are stored
D. Allows defining of multiple alias tables to facilitate internationalization
Answer: Bhttp://www.aroopam.com/