1Z0-533 | The Up to date Guide To 1Z0-533 exam question
Q31. 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
Answer: C
Q32. Name the valid ways to create blocks in an underlying Essbase database. Select all that apply
A. Copy data
B. Load data
C. Create block on Equation
D. Aggregate data
Answer: ABC
Q33. What are the two possible effects on the database when the data storage property of a parent member in the sparse Entity dimension is set to Dynamic Calc?
A. Essbase data block size decrease.
B. The member is not available for process management.
C. Retrieval performance could be slower when referencing the parent entity member.
D. Data cannot be input to the parent in target versions.
Answer: AC
Q34. 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
Q35. Identify two true statements about the DATAEXPORT calc script command.
A. Using DATAEXPORT within the FIX statement of a calc script allows you to export specific data sets from an Essbase database.
B. DATAEXPORT only exports level zero data.
C. DATAEXPORT only exports to flat files.
D. DATAEXPORT only exports entire data blocks.
E. DATAEXPORT is faster than Essbase Report.
Answer: AE
Q36. You need to calculate benefit expense in your Planning application using the following logic: Benefit expense is equal to the Total Salary of the Organization multiplied by a factor data loaded to each cost center.
Given the following components, what is the correct order of calculation:
1-Custom calculation (Total Salary * Factor)
2-Aggregate benefits
3-Aggregate salaries
A. 1, 2, 3
B. 3, 2, 1
C. 2, 3, 1
D. 3, 1, 2
Answer: D
Q37. 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.
Answer: ACE
Q38. A Business Rule is launched from a data form. What will Planning utilize to provide a valid list of members for a run-time prompt?
A. Members defined on the data form
B. Planning Metadata security
C. Business Rules security access privileges
D. Essbase security filters
E. Business Rules Basic User Role
Answer: A
Q39. Identify the three true statements about the CapEx Planning module.
A. Is a prebuilt plan type focused on capital expense related planning
B. Provides complete out-of-the-box functionality for capex planning including dimensions, data forms, business rules and security
C. Can be initialized within an existing Planning application
D. Can be created as a stand-alone application
E. Because planning limits an application to three plan types, Capex Planning must be the third plan type.
Answer: ABC
Q40. 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