1Z0-533 | 10 Tips For Updated 1Z0-533 exam
Q11. The budget office analyst needs to enter and plan data, use the Planning spreading feature that allow users to spread budget data based on last year's actuals, and modify data forms. What two roles should be provisioned for this user?
A. Grid Spread
B. Planner
C. Interactive User
D. Mass Allocate
E. Offline User
Answer: BC
Q12. Assuming EAS Business rules, a user cannot see a business rule on a data Form. What are three possible causes?
A. The business rule has not been assigned to the data form.
B. The business rule was created for another plan type.
C. The valid locations have not been defined for the business rule.
D. The valid locations have not been defined for the data form.
E. The Validate and Launch privileges have not been granted for the business rule.
F. The Validate and Launch privileges have not been granted for the data form.
Answer: ACE
Q13. Identify the three characteristics of the Scenarios dimension.
A. Security can be assigned to members of the Scenario dimension.
B. It allows the administrator to assign valid periods for data entry
C. It allows bottoms up or target planning
D. Exchange rate tables are tied to the Scenario dimension.
E. One member in the scenario dimension may be valid for Plan Type.
Answer: ABD
Q14. Identify the two statements about the Planning Import security utility.
A. Imports Planning application access for users and groups
B. Imports users and groups into Planning
C. Requires the source text file to be named PLANSECFILE.txt
D. Can be scheduled to run nightly using an encrypted password
E. Clears existing security definitions by default before the import takes place
Answer: AD
Q15. Management dictates a major reorganization of the company structure, meaning you need to rebuild the Entity dimension from the beginning. You need to delete members in the Entity dimension. Identify the three true statements about deleting members from a Planning application.
A. You must delete members one by one.
B. You must delete a reference to a member from all data forms before deleting it from the dimension.
C. In a data form definition, you selected @IDescendants(IT) for the entity dimension in the page section. The IT member will remain but 2 of its 10 cost centers are being removed. You must remove the reference to "IT" in this data form.
D. You should back up all data for the deleted entity members; after a member is deleted, the data is not retained.
E. A database refresh is required after deleting members from the Entity dimension.
Answer: BDE
Q16. A Planning Unit has a status of First Pass; what two user types can input data?
A. Anyone with write access to the planning unit
B. Anyone with write access to the planning application
C. Anyone with read or write access to the planning unit
D. The owner of the planning unit
E. The administrator
Answer: AE
Q17. Based on the following design:
Plan type 1: Summary Plan type with all Accounts by Entity
Plan type 2: Sales Plan type with Sales by Product by Entity
Plan type 3: Salary Plan type with Salary Expense by Employee by Entity
You need to get Sales data to the Summary plan type. Identify the two true statements about sharing revenue data between the sales plan type and the summary plan type.
A. Planning will build in @XREF calculations in a calc script by default to share data between plan types.
B. A replicated partition could be created to replicate data from the sales plan type to the summary plan type and this would be done if we wanted to store the sales data in the summary plan type.
C. A transparent partition and @XREF calculations could have performance issues for retrievals because data is not stored; it is dynamically calculated.
D. A calc export script on the source database with the DATAEXPORT command could be used to export data out of the revenue plan type and calc import script on the target database with the DATAIMPORT command could be used to import the data file to the summary plan type.
E. To disable the building of @XREF, update the HSPProperties file for the application before you click Create during the application creation process.
Answer: BC
Q18. 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 (Budget, (@LEVMBRS (Market, 0) ) )
"Marketing expense" = "Marketing expense"->Corporate * ("Marketing expense"/"Marketing
expense" —> TotalMarket) ;
ENDFIX
C. FIX (Budget, (@LEVMBRS (Market, 0) )
--- "Marketing expense" = "Marketing expense"->Corporate * ("Marketing expense”
Actual ->FY10 / "Marketing expense" -> Actual ->FY10 TotalMarket);
ENDFIX
D. FIX (@LEVMBRS (Market, 0) )
"Marketing expense" = "Marketing expense"~>Corporate * (“Marketing expense”
Actual ->FY10 / "Marketing expense" -> Actual ->FY10 TotalMarket);
ENDFIX
Answer: B
Q19. What are two user interfaces to Planning data forms?
A. EPM Workspace
B. Excel Add-in
C. Smart View Essbase Provider
D. Smart View Planning Provider
E. Planning ADM Driver for FR
Answer: AD
Q20. Planning utilizes which type of database to store data (for example, "the numbers")?
A. Block Storage Option Essbase database
B. Aggregate Storage Option Essbase database
C. Relational database
D. XOLAP database
E. Proprietary database
Answer: A