Oracle 1Z0-533 Online Practice Questions and Exam Preparation

Oracle 1Z0-533 Online Questions & Answers

• Question 11:

  In the Workforce Planning module, an employee is terminated.

  What two activities do you perform in WFP, so that total salary numbers are correctly calculated?

  A. Run a business rule to change the employee's status.
  B. Change the employee's status on a data form using the Smart List drop down.
  C. Change the employee's status on a data form using the free form text measure.
  D. Change the employee status attribute association in the Employee dimension.
  E. Delete the employee from Workforce Planning.
  A. Run a business rule to change the employee's status.
  B. Change the employee's status on a data form using the Smart List drop down.

  ---

  You can change the status of the Employee through options from a Drop down/Smart List on a data form by running a Business Rule.

  

  Incorrect answer:

  Deleting the employee is a bad praxis. It would remove old salary entries.

  You do not access the attributes directly on the Employee dimension.

  Note: The Workforce Planning Module for Hyperion Planning provides a robust set of calculations and pre-defined web-forms that allows organizations to track and budget down to the benefit-level for each employee.

• Question 12:

  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
  C. Smart List

  ---

  Administrators use Smart Lists to create custom drop-down lists that users access from data form cells. When clicking into cells whose members are associated with a Smart List (as

  a member property), users select items from drop-down lists instead of entering data. Users cannot type in cells that contain Smart Lists. Smart Lists display in cells as down arrows that expand when users click into the cells.

• Question 13:

  You are designing a monthly projection Planning application. A starting point projection file is received with the current month data. Data forms, Business Rules, and Essbase data load rules, and reports should always focus on the current projection month.

  What is most efficient way to design the components to reduce maintenance each month?

  A. Manually update the forms each month and use a "CurMth" substitution variable for Business Rules, Essbase data load rules, and reports.
  B. Manually update the forms each month; Use "CurMo" Global variable for Business Rules and use a "CurMth" substitution variable for Essbase data load rules, and reports.
  C. Use the Planning data form utility to update data forms and use a "CurMth" substitution variable for Business Rules, Essbase data load rules, and reports.
  D. Use a "CurMth" substitution variable for data forms, Business Rules, Essbase data load rules, and reports.
  E. Use the Planning data form utility to update data forms; Use "CurMo" Global variable for Business Rules and use a "CurMth" substitution variable for Essbase data load rules, and reports.
  E. Use the Planning data form utility to update data forms; Use "CurMo" Global variable for Business Rules and use a "CurMth" substitution variable for Essbase data load rules, and reports.

  ---

  In Business Rules use a global variable. In Essbase, use a substitution variable.

• Question 14:

  What option contributes to making an Enhanced Calc Script more flexible than a native Essbase Calc Script?

  A. Run on Save
  B. @CALCMODE function
  C. Run time prompts
  D. Can be run over the web
  E. Substitution Variables
  F. Custom Defined Functions
  C. Run time prompts

  ---

  An Enhanced Calc Script is a calc script created with Business Rules that contains run-time prompts.

• Question 15:

  Identify the three true statements about attribute dimensions in Planning.

  A. Aliases are supported for attribute members.
  B. Consolidation properties are supported for attribute members.
  C. Hierarchies are supported for attribute dimensions.
  D. Only Text attributes are supported.
  E. Text, Boolean, Numeric, and Date attributes are supported.
  A. Aliases are supported for attribute members.
  C. Hierarchies are supported for attribute dimensions.
  E. Text, Boolean, Numeric, and Date attributes are supported.

  ---

  A: Open the Dimension Library and select File >

  New > Dimension. Enter a name and description, then select the Alias type.

  C: From planning 9 3 1 you can also create attribute hierarchy in planning.

  E: Attribute dimensions have a type setting--text, numeric, Boolean, or date. Text is the default setting.

• Question 16:

  A planning end user opens a data form and sees a long list of entities in the drop-down list in the Page section. She would like to shorten this list and use the search functionality instead.

  How can she change the number of members needed on a form to initiate a page dropdown search?

  A. Form Management>>Display tab
  B. Form Management>> Options tab
  C. Preferences>>Database Settings tab
  D. Preferences>> Display Options tab
  E. This change can only be made by the Planning Administrator.
  D. Preferences>> Display Options tab

  ---

  All users can set personal preferences in the current application.

  To set personal preferences:

  1 Select File, then Preferences.

  2 Click Planning, then perform an action:

  *

  Select Application Settings to set e-mail options, select an alias table, and set options for member selection and workflow.

  *

  Select Display Options to set options for number formatting, page selection, warnings for large data forms, and the number of dimensions to show on a page.

• Question 17:

  You are designing the storage properties for your Planning application.

  What two design principles should you follow related to the dynamic calc storage property?

  A. Dynamically calculated members should roll up to stored members.
  B. You cannot calculate and store dynamic calculated members in calc scripts and business rules.
  C. Consider dynamic calc members on sparse parents with 100 t children.
  D. Tagging upper-level members of sparse dimensions can reduce block size.
  E. If you use a large number of dynamic calcs, you should consider increasing the Dynamic Calculator Cache.
  F. Consider Dynamic Calc and Store over Dynamic Calc.
  B. You cannot calculate and store dynamic calculated members in calc scripts and business rules.
  E. If you use a large number of dynamic calcs, you should consider increasing the Dynamic Calculator Cache.

  ---

  B:

  "If you specify a Dynamic Calc or Dynamic Calc and Store member explicitly in a calculation script, the calculation script fails. You cannot do a calculation script calculation of a Dynamic Calc or Dynamic Calc and Store member. To use a

  calculation script to calculate a member explicitly, do not tag the member as Dynamic Calc.

  E: The dynamic calculator cache is a buffer in memory that Essbase uses to store all of the blocks needed for a calculation of a Dynamic Calc member in a dense dimension (for example, for a query).

  Incorrect answer:

  F: Storing the information is no advantage in this scenario.

• Question 18:

  As a Planning end user, you need to add additional commentary to your plan, documenting assumptions and other notes.

  What are the six available options to add this information?

  A. Supporting detail
  B. Planning unit annotations
  C. Cell text
  D. Free form text (if defined by your Planning administrator)
  E. Smart Lists (if defined by your Planning administrator)
  F. Attach a document to a data form from Workspace (if enabled by your Planning administrator)
  G. Financial Reporting Annotations in a Financial Reporting document (against the Planning application)
  A. Supporting detail
  B. Planning unit annotations
  C. Cell text
  D. Free form text (if defined by your Planning administrator)
  F. Attach a document to a data form from Workspace (if enabled by your Planning administrator)
  G. Financial Reporting Annotations in a Financial Reporting document (against the Planning application)

  ---

  Incorrect answer:

  With a smart list you can only select from pre-defined options in a list-

• Question 19:

  You have a measure in your Accounts dimension for "Price". Price Is Input by users (along with Units). Sales is calculated as Units * Price. Identify the correct property that should be assigned to Price to meet this requirement.

  A. Stored
  B. Dynamic Calc
  C. Dynamic Calc and Store
  A. Stored

  ---

  Stored should be used.

  

  Note: The accounts dimension is a dimension type that makes accounting intelligence available. Only one dimension can be defined as Accounts.

• Question 20:

  What are valid data types for the Accounts dimension? Select all that apply.

  A. Currency
  B. Non-currency
  C. Percentage
  D. Saved Assumption
  E. Text
  F. Smart List
  G. Date
  A. Currency
  B. Non-currency
  C. Percentage
  E. Text
  F. Smart List
  G. Date

  ---

  Data types:

  How values are stored and displayed:

  *Currency (A)

  *Non-Currency (B)

  *Percentage (C)

  *Smart List (F)

  *Date (G)

  *Text (E)

  *Unspecified

  F

  or accounts, if Data Type is set to any value except Currency, you must set Exchange Rate Type to None.

  Note:

  The accounts dimension is a dimension type that makes accounting intelligence available. Only one dimension can be defined as Accounts.All members in the accounts dimension inherit the accounts property. You can create an outline that does not have an accounts dimension.