1Z0-531 | Renew 1Z0-531 Exam Study Guides With New Update Exam Questions
Q11. In Essbase 11.1.1, what are two possible ways to calculate Period to Date values in ASO?
A. Enable Dynamic Time Series
B. Analytic dimension with member formulas to calculate period to date values
C. Alternate hierarchy in Time dimension to rollup period to date values
D. Create a Date Time dimension
Answer: BC
Q12. Which setting will give information about when a data block is calculated?
A. SET MSG INFO;
B. SET MSG SUMMARY;
C. SET MSG DETAIL;
D. SET MSG WARNING;
Answer: C
Q13. Identify the three true statements about the Administration Services console.
A. You can create custom views in EAS; Custom views help administrators focus on those apps, databases or servers that apply to them
B. Administration Servers can be added to a custom view
C. Applications and databases can be added to a custom view
D. Calculation scripts can be added to a custom view
E. Users and Groups can be added to a custom view
Answer: ACD
Q14. What are the three rules for Shared Members in ASO?
A. A Multiple Hierarchy Enabled dimension can have shared members.
B. When a hierarchy is tagged Multiple Hierarchies Enabled, it must be store.
C. The alternate hierarchy has shared members that refer to nonshared members of previous hierarchies in the outline.
D. The shared members roll up according to a different hierarchy from the nonshared members to which they refer.
Answer: ACD
Q15. Which two statements are true (assuming data is loaded to a BSO database and to the members noted below)?
A. If you delete a sparse shared member, the outline file shrinks.
B. If you delete a sparse shared member, the page file shrinks.
C. If you delete a sparse stored member, the index file shrinks.
D. If you delete a sparse stored member, the block density shrinks.
E. If you delete a dense shared member, the block size shrinks.
F. If you delete a dense stored member, the number of blocks shrinks
Answer: CF
Q16. You are creating a MaxL script to log into the database, update a dimension, load data, and run a calculation. Identify the two true statements about creating this MaxL script.
A. A separate MaxL script is required for each step
B. The password must be hardcoded into the script when logging in.
C. IFERROR can be used in MaxL to handle errors after each statement, when triggered will skip to a subsequent statement
D. Variables for objects like server names, application names and database names can be used in a MaxL script to help with maintenance
Answer: CD
Q17. What are five reasons to use Attributes over a Shared Members dimension?
A. To create crosstab reports
B. To describe a dense dimension
C. To describe a sparse dimension
D. To perform comparisons based on certain type of data
E. To perform calculations based on characteristics
F. To add dimensionality to the database without increasing database size
Answer: ACDEF
Q18. Identify the two true statements about expense reporting tags.
A. Provide accurate time balance calculations
B. Provide accurate variance reporting on revenue and expense accounts
C. Are assigned to the dimension tagged Time
D. Are assigned to the dimension tagged Accounts
E. Are assigned to the Dimension containing variance members.
Answer: BD
Q19. The following two members would be optimally tagged Label Only.
A. "Profit"
B. "Rations"
C. "Scenario"
D. "Q1"
E. "January"
Answer: BC
Q20. Market size is an attribute dimension with the following members: Large, Medium, and Small.
Which of the following options below represent valid syntax statements in a calc script?
A. FIX (@ATTRIBUTE(Large))
B. Calc Dim (Accounts, Markets, "Market Size");
C. Calc Dim (Accounts, Markets, Market Size);
D. FIX(Large)
Answer: AC