Free 1z0-531: Oracle Essbase 11 Essentials Exam Questions and Answers

You are working in a Smart View ad hoc grid connected to Sample.Basic. The grid shows the members Jan, Feb, Mar and Qtr1 across the columns. You select the Jan and Feb column headers and want the grid to display only those two members, with Mar and Qtr1 removed. Which Smart View action should you use?

• AA. Keep Only
• BB. Remove Only
• CC. Pivot
• DD. Zoom Out

You are building an outline in which the Measures dimension is tagged Accounts and the Year dimension is tagged Time. For the member Opening Inventory, the value for Qtr1 must equal the value stored for Jan, and the value for Year must equal the value stored for the first month of the year. Which setting should you apply to Opening Inventory?

• AA. Time Balance Average
• BB. Two-Pass calculation
• CC. Time Balance First
• DD. Time Balance Last

In the Measures dimension, the parent member Ratios has the children Margin %, Profit % and Inventory Turnover. Each child holds its own calculated value. When the database is consolidated, none of these children may contribute to the value of Ratios. Which consolidation operator should you assign to each child?

• AA. + (Add)
• BB. - (Subtract)
• CC. ~ (Ignore)
• DD. % (Percent)

You are an Essbase administrator. You edit the essbase.cfg file in a text editor to add a new server-level configuration setting. You save the file, but the setting is not in effect. What must you do for the setting to take effect?

• AA. Restart Essbase Server
• BB. Restructure the database that uses the setting
• CC. Reload the outline in Administration Services Console
• DD. Restart the application that uses the database

A user is provisioned with the Write role on Sample.Basic. The user must run the calculation scripts that you assign to her, and must continue to update data. She must not be able to edit the outline or change database settings, and she must not receive access to other databases. What should you do?

• AA. Assign the Calc role on Sample.Basic to the user
• BB. Assign a filter with Write access to all members on Sample.Basic to the user
• CC. Assign the Database Manager role on Sample.Basic to the user
• DD. Assign the Application Manager role on Sample to the user

You are writing a calculation script for a block storage database. After a partial data load, you want the script to calculate only the data blocks that are marked as dirty, rather than every block. Which command should you place at the start of the script?

• AA. SET CALCPARALLEL 3;
• BB. SET AGGMISSG ON;
• CC. SET UPDATECALC ON;
• DD. SET CREATEBLOCKONEQ ON;

A block storage database has five dimensions. Measures (15 members) and Year (17 members) are dense. Product (30 members), Market (8 members) and Scenario (3 members) are sparse. All members in all dimensions are stored members. What is the maximum number of potential data blocks in the database?

• AA. 41
• BB. 255
• CC. 720
• DD. 12,240

Which file extension identifies the index files of a block storage database?

• AA. .otl
• BB. .pag
• CC. .ind
• DD. .esm

You are using Essbase Studio with a relational data source. You have created dimension elements for the Region and State columns of a Market table. You need to define the parent-child relationship between Region and State so that Market can later be added to a cube schema. What should you create?

• AA. A dimension element
• BB. An Essbase model
• CC. A mini schema
• DD. A hierarchy

You have loaded sales data into the ASOsamp.Sample aggregate storage database. Users report that queries at upper levels of the Products and Geography dimensions are slow. What should you do to improve retrieval performance?

• AA. Tag the upper-level members as Dynamic Calc and Store
• BB. Increase the data cache size with the MaxL alter database statement
• CC. Run the MaxL execute aggregate process statement on the database
• DD. Run a calculation script that contains CALC ALL after each data load