Oracle 1z0-533 Exam Practice Questions (P. 2)
- Full Access (69 questions)
- Six months of Premium Access
- Access to one million comments
- Seamless ChatGPT Integration
- Ability to download PDF files
- Anki Flashcard files for revision
- No Captcha & No AdSense
- Advanced Exam Configuration
Question #6
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?
- AGrid Spread
- BPlanner
- CInteractive User
- DMass Allocate
- EOffline User
Correct Answer:
BC
Planner:
The majority of Hyperion Planning users are planners who are responsible for department or project budgets. They conveniently work over the Web or the
Spreadsheet Add-in to:
Enter, submit, and view data -
Use pre-defined policies, procedures, routines, reports, and worksheets to enter, analyze, and report on application data
Interactive User:
Examples of an interactive user include a department head, sales director, or unit manager who submits budget information and data for approval. Interactive users can enter and view data. They can also create, maintain, and initiate:
Data entry forms on the Web -
Spreadsheet Add-in worksheets -
Reports using Hyperion Reports -
Integrations using Hyperion Application Link
Business rules using Hyperion Business Rules
BC
Planner:
The majority of Hyperion Planning users are planners who are responsible for department or project budgets. They conveniently work over the Web or the
Spreadsheet Add-in to:
Enter, submit, and view data -
Use pre-defined policies, procedures, routines, reports, and worksheets to enter, analyze, and report on application data
Interactive User:
Examples of an interactive user include a department head, sales director, or unit manager who submits budget information and data for approval. Interactive users can enter and view data. They can also create, maintain, and initiate:
Data entry forms on the Web -
Spreadsheet Add-in worksheets -
Reports using Hyperion Reports -
Integrations using Hyperion Application Link
Business rules using Hyperion Business Rules
send
light_mode
delete
Question #7
You are designing the storage properties for your Planning application. What two design principles should you follow related to the dynamic calc storage property?
- ADynamically calculated members should roll up to stored members.
- BYou cannot calculate and store dynamic calculated members in calc scripts and business rules.
- CConsider dynamic calc members on sparse parents with 100 t children.
- DTagging upper-level members of sparse dimensions can reduce block size.
- EIf you use a large number of dynamic calcs, you should consider increasing the Dynamic Calculator Cache.
- FConsider Dynamic Calc and Store over Dynamic Calc.
Correct Answer:
BE
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.
BE
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.
send
light_mode
delete
Question #8
Identify the two true statements with regard to Versions and Scenarios.
- AVersions control data entry based on time periods set by the administrator.
- BThere is only one Version to one Scenario.
- CVersions allow several "what-if" Scenarios.
- DUsers must have the same security settings in the Version dimension as they have in the Scenario dimension.
- EVersions can be top down or bottom up.
Correct Answer:
CD
C: You use the Scenario and Version dimensions to create individual plans to be reviewed and approved. Each scenario/version combination contains its own set of data for the accounts and other dimensions of each entity. After users complete data entry for an entity for a specific scenario and version, they can submit or promote the data for the entity to another user for review and approval. The intersection of entity, scenario, and version is referred to as a planning unit. Planning tracks the status of each planning unit as it moves through the review process.
D: Seems likely.
CD
C: You use the Scenario and Version dimensions to create individual plans to be reviewed and approved. Each scenario/version combination contains its own set of data for the accounts and other dimensions of each entity. After users complete data entry for an entity for a specific scenario and version, they can submit or promote the data for the entity to another user for review and approval. The intersection of entity, scenario, and version is referred to as a planning unit. Planning tracks the status of each planning unit as it moves through the review process.
D: Seems likely.
send
light_mode
delete
Question #9
Identify two times when a security refresh needs to be performed.
- AMember access has been assigned to a group.
- BMember access has been assigned to a user.
- CNew group is created.
- DA new Member "East" has OnDESCENDANTSCREAD.access assigned.
- ENew business rule is created.
Correct Answer:
AB
After you establish or update user and group security, the Planning application needs to be refreshed to complete the update to Analytic Services security filters.
Incorrect:
D: This options badly worded. We here assume that the security of the member has not changed.
C, E: no security has changed.
References:
AB
After you establish or update user and group security, the Planning application needs to be refreshed to complete the update to Analytic Services security filters.
Incorrect:
D: This options badly worded. We here assume that the security of the member has not changed.
C, E: no security has changed.
References:
send
light_mode
delete
Question #10
Identify two ways that Essbase data load rules cannot manipulate source data files.
- ASelect or reject records based on certain criteria.
- BFlip the sign for records with a certain member tagged with a comment.
- CSplit or join columns in a source.
- DFind and replace manipulations on source records.
- EMap data based on an external table.
Correct Answer:
CD
C: Columns cannot be split or joined at runtime in the source.
D: Essbase reads the data values or members in the data source, changes them based on the rules in the rules file, and loads the changed data values into the database and the changed members into the outline. Essbase does not change the data source.
References:
CD
C: Columns cannot be split or joined at runtime in the source.
D: Essbase reads the data values or members in the data source, changes them based on the rules in the rules file, and loads the changed data values into the database and the changed members into the outline. Essbase does not change the data source.
References:
send
light_mode
delete
All Pages