Question 1.
Which statement is true about assigning members to plan types?

A. If you demote a member that is valid for Plan Type 1 and Plan Type 2 and the new parent of the member is valid for Plan Type 1, the member is valid for Plan Type 1.
B. Once a User-defined custom dimension has been assigned to a plan type in the application, you can assign which members are valid in that plan type.
C. If you demote a member that is valid for Plan Type 1 and the new parent of the member is valid for Plan Type 1 and Plan Type 2, the member is valid for both Plan Type 1 and Plan Type 2.
D. You can specify the source plan type for the members in User-defined custom dimensions.

Answer: A

Question 2.
What are three possible reasons for creating an alternate hierarchy instead of a Custom Attribute dimension? (Choose three.)

A. Client requests the base and non-base members have Parent members.
B. When the client requests the base member and non base member have security assigned to them.
C. Client requests the base and non-base members have an alias.
D. Client requests the base member to be on the row of a Hyperion Report and the non-base member to be on the column.

Answer: A, B, C

Question 3.
Which two actions can be performed using multiple alias tables? (Choose two.)

A. You can assign multiple aliases directly to a shared member.
B. Aliases can be assigned to planning units and User-defined custom dimensions.
C. You can have up to ten alias tables in an application.
D. Alias tables can be created only within Hyperion Planning.

Answer: C, D

Question 4.
What is the ideal data block size?

A. Greater than 500 kilobytes
B. Between eight and 100 kilobytes
C. Between 251 and 500 kilobytes
D. Between 101 and 250 kilobytes

Answer: B

Question 5.
Which statement is true about assigning members to plan types?

A. If you demote a member that is valid for Plan Type 1 and Plan Type 2 and the new parent of 
    the member is valid for Plan Type 1, the member is valid for Plan Type 1.
B. You can specify the source plan type for the members in User-defined custom dimensions.
C. If you demote a member that is valid for Plan Type 1 and the new parent of the member is valid for Plan Type 1 and Plan Type 2, the member is valid for both Plan Type 1 and Plan Type 2. 
D. Once a User-defined custom dimension has been assigned to a plan type in the application, you can assign which members are valid in that plan type.

Answer: A

Question 6.
In multi-currency applications, after running a Refresh from the Planning Desktop, where are the foreign currency exchange rates stored in the Essbase database?

A. "Entities" -- > "1st Draft" -- > "USD" -- > "Product" -- > "HSP_Average" -- > "HSP_Rate_USD"
B. "8110" -- > "Versions" -- > "Currencies" -- > "Product" -- > "HSP_Average" -- > 
    "HSP_Rate_USD"
C. "Entities" -- > "1st Draft" -- > "USD" -- > "Product" -- > "HSP_Average" -- > "HSP_InputValue"
D. "Entities" -- > "Versions" -- > "Currencies" -- > "Product" -- > "HSP_Average" -- > "HSP_Rate_USD"

Answer: D

Question 7.
Which two statements are true? (Choose two.)

A. You can assign only aggregation options to Entities dimension members.
B. You can assign plan types and aggregation options to User-defined custom dimension 
    members.
C. You can assign only aggregation options to User-defined custom dimension members.
D. You can assign plan types and aggregation options to Entities dimension members.

Answer: C, D

Question 8.
What must be done prior to using the Create Blocks action in a Hyperion Business Rule (HBR)?

A. Essbase configuration file (essbase.cfg) must have the Create Blocks option turned on.
B. Essbase Information must be validated for the potential number of blocks.
C. Essbase database settings Create Blocks on Equation must be selected.
D. Data must be loaded to the blocks prior to running the Hyperion Business Rule.

Answer: C

Question 9.
When would you create a Custom Attribute dimension instead of an alternate hierarchy?

A. when the client requests the base member and the non-base members have an alias.
B. when the client requests the base member to be on the row of a Hyperion Report and the non-base member to be on the column.
C. when the client requests the base member and the non-base members have parent members.
D. when the client requests the base member and the non-base members have security assigned to them.

Answer: B

Question 10.
In a multi-currency application using a Target Version, what calculation options should be used with the Aggregate Data component?

A. Aggregate Data up to Local Currency, Optimize the Calculation of Formulas on Sparse Dimensions, and Use Calculator Cache
B. Aggregate Data up to Local Currency, Aggregate Missing Values, and Use Calculator Cache
C. Aggregate Missing Values, Aggregate Data up to Local Currency, and Optimize the Calculation of Formulas on Sparse Dimensions
D. Aggregate Missing Values, Optimize the Calculation of Formulas on Sparse Dimensions, and Use Calculator Cache

Answer: A

	Web www.certsbraindumps.com