Oracle 1Z0-533 Actual Tests : Oracle Hyperion Planning 11 Essentials

Identify the three true statements about weekly distribution.

• A. For Weekly Distribution options 445, 454, 544, the quarterly values are treated as if they are divided into 13 weeks and the weeks are distributed via a pattern you specify.
• B. The only valid weekly distribution options are 445, 454, and 544.
• C. If you choose weekly distribution for Custom-based time periods. Planning will not distribute the data values across base periods.
• D. Weekly distribution determines how data entered into summary periods should spread to its base periods.
• E. If you select the 4-5-4 Weekly distribution option, Planning treats the first month in the quarter as if it has 4 weeks, the second month as If it has 5 weeks, and the third month as if it has 4 weeks.

Planning utilizes which type of database to store data (for example, "the numbers")?

• A. Aggregate Storage Option Essbase database
• B. Relational database
• C. Proprietary database
• D. XOLAP database
• E. Block Storage Option Essbase database

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 = 100 * 500 * 8
• C. Block size = 100 * 500
• D. Block size = 40 * 17 * 2 * 8
• E. Block size = 50 * 17 * 5 * 8
• F. Block size = 50 * 17 * 5

Identify two true statements about the DATAEXPORT calc script command.

• A. DATAEXPORT only exports entire data blocks.
• B. DATAEXPORT only exports to flat files.
• C. DATAEXPORT is faster than Essbase Report.
• D. Using DATAEXPORT within the FIX statement of a calc script allows you to export specific data sets from an Essbase database.
• E. DATAEXPORT only exports level zero data.

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 (@LEVMBRS (Market, 0) )
  "Marketing expense" = "Marketing expense"~>Corporate * ("Marketing expense"
  Actual ->FY10 / "Marketing expense" -> Actual ->FY10 TotalMarket);
  ENDFIX
• C. FIX (Budget, (@LEVMBRS (Market, 0) ) )
  "Marketing expense" = "Marketing expense"->Corporate * ("Marketing expense"/"Marketing
  expense" -> TotalMarket) ; ENDFIX
• D. FIX (Budget, (@LEVMBRS (Market, 0) )
  --- "Marketing expense" = "Marketing expense"->Corporate * ("Marketing expense"
  Actual ->FY10 / "Marketing expense" -> Actual ->FY10 TotalMarket);
  ENDFIX