A Review Of Refined 1Z0-533 pdf

Q1. 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. 

View Answer

Q2. 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 

View Answer

Q3. 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. 

View Answer

Q4. Given the following: 

Measures (Dense): 40 stored members, 50 total members 

Time (Dense): 17 stored members, 17 total members 

Scenario (Dense): 2 stored members, 5 total members 

Market (Sparse): 100 stored members, 100 total members 

Product (Sparse): 500 stored members, 550 total members 

How many potential blocks could be created? 

A. Potential Blocks = 40 * 17*2 

B. Potential Blocks = 40* 17*2*8 

C. Potential Blocks = 100 * 500 

D. Potential Blocks = 100 * 500 * 8 

E. Potential Blocks = 100 * 550 

F. Potential Blocks = 100 * 550 * 8 

View Answer

Q5. Identify the true statements regarding Supporting Detail. Select all that apply. 

A. Importing Supporting Detail from Excel is supported. 

B. Supporting Detail must be entered cell by cell; entry for multiple columns at once is not possible 

C. Supporting Detail can contain a hierarchy with an aggregation of values for that hierarchy. 

D. Supporting Detail can be viewed using the Smart View Add-in Essbase Provider. 

E. Supporting Detail is stored in Essbase. 

View Answer

Q6. 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. 

View Answer

Q7. What are valid data types for the Accounts dimension? Select all that apply. 

A. Currency 

B. Non-currency 

C. Percentage 

D. Saved Assumption 

E. Text 

F. Smart List G. Date 

View Answer

Q8. 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. 

View Answer

Q9. Identify the correct set of required dimensions for Planning. 

A. Account 

B. Entity 

C. Version 

D. Years and Periods combined into one dimension 

E. Scenario 

F. Minimum one user-defined dimension 

View Answer

Q10. 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. 

View Answer