We provide real 1Z0-533 exam questions and answers braindumps in two formats. Download PDF & Practice Tests. Pass Oracle 1Z0-533 Exam quickly & easily. The 1Z0-533 PDF type is available for reading and printing. You can print more and practice many times. With the help of our Oracle 1Z0-533 dumps pdf and vce product and material, you can easily pass the 1Z0-533 exam.
Q1. Identify three key benefits of the Planning solution.
A. Standardized data forms for plan data entry available both for the Web and in Excel
B. One tool to budget and forecast as well as provide reporting for very detailed Actuals Information
C. Central repository of business rules that can be run by end users to calculate plan data
D. Detailed security down to the cell level
E. Flexible solution customizable for almost any kind of budgeting and forecasting process
Answer: ACE
Q2. Identify the two true statements assuming you are working with a single application with multiple plan types.
A. A user-defined custom dimension may exist in one plan type but not the other plan types.
B. A user-defined custom dimension may have members in one plan type but not the remaining plan types.
C. All members in the entity dimension must exist in all plan types.
D. All members in the accounts dimension must exist in all plan types.
E. All periods must exist in all plan types.
Answer: AE
Q3. Identify the three differences between Grid Spreader and Mass Allocate.
A. Grid Spreader processes on the client whereas Mass Allocate processes on the server.
B. Mass Allocate generates and runs a business rule behind the scenes, allowing members not displayed on the form to be updated.
C. Both M-3CG Allocate and Grid Spreader require special roles in Shared Services.
D. Grid Spreader gives users a "preview" to the spread result before saving whereas Mass Allocate will automatically save results to the server.
E. Both Mass Allocate and Grid Spreader support relational spread.
Answer: ABD
Q4. A planning unit is the basic unit______.
A. for preparing, reviewing, and approving data.
B. for calculating and storing currency plan data.
C. for assigning security to plan data.
D. for reporting and analyzing plan data.
E. made up of Scenario, Entity, and Account.
Answer: A
Q5. Product status is a data element you need to include in your Planning application. Each product will have a product status that can vary over time. You will use product status in calculations and will need to report sales by product status and across products in a cross tab format.
What is the best way to meet all of these requirements?
A. Define Product Status as a Smart List.
B. Define Product Status as a Separate Dimension.
C. Define Product Status as an Attribute.
D. Define Product Status as a Varying Attribute.
E. Define Product Status as an alternate hierarchy in the Product dimension.
Answer: C
Q6. 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.
Answer: AB
Q7. Assuming the following dimensions and members:
Scenario - Actual, Budget and Year - 2010, 2011, you need to create a data form with two columns. One column should list Actual for 2010 and the second column should list Budget 2011. You do not want to show data for Actual 2011 even though the first three months of the year have been loaded from the GL.
What is the best way to only show the 2 columns in the data form?
A. You cannot build a data form with these two columns, hour columns will display: Actual >2010, Actual >2011, Budget->2010 and Budget >2011
B. Use Segments on the data form to create the asymmetric columns.
C. Use User Variables on the data form to create the asymmetric columns.
D. Use a composite data form to meet this requirement.
E. Use data suppression on the data form.
Answer: B
Q8. You have a new Planning administrator to manage the Capital Expenditure application. He will assign security for the application as well as maintain dimensions in EPMA, Business Rules in Calculation Manager, and load data via Essbase rules files. He will not need access to other applications. Choose the two valid roles that will address part or this entire requirement.
A. Administrator for the CapEx application
B. Administrator for the Planning Server
C. Provisioning Manager for the CapEx application
D. Planning Calculation Manager for the CapEx application
E. Dimension Editor for the CapEx dimensions
F. Application Manager in Essbase for the CapEx dimensions
Answer: DE
Q9. What four prebuilt actions are available In EAS Business Rules?
A. Aggregate
B. Copy Data
C. Clear Block
D. Clear Data
E. Create Block
F. Allocate
Answer: ABDE
Q10. When opening a data form, the user experiences slow performance. What three steps could you do to improve the time it takes to open the data form?
A. Reduce the number of rows and columns displayed in the data form.
B. Upgrade the client machine's operating system processing speed and RAM.
C. In the data form definition, remove the option to display alias.
D. Reduce the number of page dimensions used on the Web form
E. Tune the index and data caches in Essbase.
Answer: ABE
Q11. 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
Q12. 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)
Answer: ABCDFG
Q13. Fragmentation in an underlying Planning Essbase database that is caused by what two actions?
A. Delete member from a sparse dimension.
B. Delete member from a dense dimension.
C. Renaming a member.
D. Renaming an alias.
E. Submitting data / deleting data frequently.
Answer: BE
Q14. 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
Q15. Identify two times when a security refresh needs to be performed.
A. Member access has been assigned to a group.
B. Member access has been assigned to a user.
C. New group is created.
D. A new Member "East" has OnDESCENDANTSCREAD.access assigned.
E. New business rule is created.
Answer: AB
Q16. 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
Q17. 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 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.
D. If you choose weekly distribution for Custom-based time periods. Planning will not distribute the data values across base periods.
E. Weekly distribution determines how data entered into summary periods should spread to its base periods.
Answer: ACE
Q18. 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
Q19. Which three tasks can be performed using the Smart View Planning Provider in Microsoft Excel?
A. Open a data form and submit data.
B. enter supporting detail and cell text.
C. Run business rules.
D. enter planning unit annotations.
E. Perform workflow tasks.
Answer: ABC
Q20. Identify two ways that Essbase data load rules cannot manipulate source data files.
A. Select or reject records based on certain criteria.
B. Flip the sign for records with a certain member tagged with a comment.
C. Split or join columns in a source.
D. Find and replace manipulations on source records.
E. Map data based on an external table.
Answer: CE