Essbase

Essbase Mastery Quiz

Test your knowledge of Essbase with this comprehensive quiz designed for professionals and enthusiasts alike. Whether you are looking to sharpen your skills or challenge yourself, this quiz offers in-depth questions covering various aspects of Essbase functionality and best practices.

21 thoughtfully crafted questions
Evaluate your understanding of key concepts
Perfect for both learning and assessment

21 Questions5 MinutesCreated by AnalyzingTree479

Question: 17 Fragmentation has a number of potential causes. Identify two.

Deleting member from a sparse dim

Submitting data/deleting data frequently (like in budget applications)

Renaming an alias

Deleting member from a dense dim

Renaming a member

Question: 15 Which three options will clear query tracking results in ASO?

Question: 16 Identify the four true statements about ASO “under the covers”

Tablespaces are utilized to store data and metadata

Bin - store numeric data (.dat file)

Page files and index files are utilized to store data store data and metadata

Default - stores numeric data (.dat file)

Data - store numeric data (.dat file)

Metadata - store numeric information about the objects in the database

Temp - temporary working space for the Essbase kernel

Metadata - store numeric data (.dat file)

Question: 45 Identify the two true statements about materialization in ASO.

Materialization scripts can be saved for future reuse

Materialization can be tuned via query hints and hard restrictions defined at the database

When performing an incremental data load, aggregate views are updated.

The database is not available during materialization

Question: 29 Which two statements are true (assuming data is loaded to a BSO database and to the members noted below)?

If you delete a sparse shared member, the page file shrinks

If you delete a sparse shared member, the index file shrinks

If you delete a sparse shared member, the block size shrinks

If you delete a sparse shared member, the outline file shrinks

If you delete a sparse shared member, the number of blocks shrinks

If you delete a sparse shared member, the block density shrinks

Question: 6 Identify four disadvantages / considerations when using a transparent partition.

Question: 59 You notice that your reports are running slower than before and realized that nothing in terms of data volume or dimension members has changed. You also checked the log file and found that no one ran any calculation. Which two would you look for to diagnose the cause of this slower response time?

Check when was the last time the application was stopped

Run a MaxL comment to see if the database is fragmented

Check the commit-level setting

Check the data cache setting

Question: 46 You need to tune a block storage option database for calculations on a 32bit Essbase server. Identify the two starting point tuning steps that you might take (assuming no direct I/O).

Set Index Cache the size of the index file

Reset sparse and dense dimensions to achieve a block size greater than 100KB

Set Data File Cache to the size of .025 * data file

Set Data Cache to the size of .025 * data file

Question: 56 Which four of the following activities can be performed by the administrator in Shared Services?

Accesses external users and groups for provisioning

Migrates applications using Life Cycle Management

Provisions Essbase roles for users and groups like Read, Write, and Filter

Creates cube schemas from a relational database

Creates Essbase filters

Creates users and groups

Question: 7 Assuming Scenario and Year are sparse and Accounts is dense, what two actions will following calc script perform? FIX (Actual, &CY, Sales) DATAEXPORT”BINFILE” “data. txt”; ENDFIX

A. Export the data for actual, current year, sales into a text file called data.txt

Create a text file that can be imported using the DATAIMPORTBIN calc command in another database that has different dimensionality

Export data blocks in a compressed encrypted format

Export the data for actual, current year into a taxt file called data.txt

Question: 2 Which two options would provide a better design for the following accounts and metrics?

If repointing dictates FTE and dollars in the columns and accounts in the rows, split Accounts and Metrics into 2 dimensions

If there are a large number of accounts that require FTE and Expense dollars, split Accounts and Metrics into 2 dimensions

If block size is large, then keep Accounts and Metrics as one dimension with a dense dimension setting

If there are a small number of accounts that require FTE and Expense dollars, split Accounts and Metrics into 2 dimensions

Question: 5 You have the following analysis requirement. Products roll up to Product Family which rolls up to Product Category. You also need to group Products by Product Manager. Product Managers may manage one or more Products across product families. You do not need to create reports with Product Manager by Product Family. You need to secure products by Product Manager for planning submissions. You consider Shared members as a solution because of which two options?

Share members provide additional categorization but results in a smaller database then if you were to add Product Manager as a separate dimension

Shared members provide cross tab reporting (Product Manager in the rows and Product Family across the column)

You can assign security to shared members

Share members can be assigned to sparse members only

Question: 13 Block size is calculated by the following formula.

Number of total dense dimension members multiplied together times 8 bytes

Number of dense sparse dimension members multiplied together times 8 bytes

Number of total sparse dimension members multiplied together times 8 bytes

Number of stored sparse dimension members multiplied together times 8 bytes

Question: 48 Your current block storage option design includes two dimensions: Markets and Regions. The Market dimension looks like: Market East NY CN NJ North MN ND South TX LA West CA NM Region Northeast Southwest Users need to be able to report by both regions and markets. Subtotals for Northeast and Southwest will display on some reports.

Add another level to the market dimension for Northeast with North and East as children and Southwest with West and South as children.

Create an attribute dimension with members Northeast and Southwest (associated to states in the Market dimension)

Add an alternate hierarchy to the market dimension with the states as shared members, rolling up to Northeast and Southwest.

Create a Text list with the values containing the members Northeast and Southwest.

Create a UDA with members Northeast and Southwest (associated to states in the Market dimension)

Question: 58 Identify the four true statements about attribute dimensions

Attributes allow cross tab reports with other dims

Attributes are assigned to dense dimensions

Attributes are dynamically calculated

Even though ASO databases allow many dimensions, attribute dimensions are still available and used in aggregate storage option databases

Security can be assigned by attribute dimension

Attributes are stored

You need to create a % of Total (by region) calculation by customer in your aggregate storage database for Net_Revenue. Select the best syntax for the member formula so that the % Total calculation works at all levels of customer dimension.

(Net_Revenue]) / (Parent, [Net_Revenne])

(Customer.CurrentMember, [Net_Revenue]) / (Customer.CurrentMember.Parent, [Net_Revenue])

(Customer.CurrentMember, [Net_Revenue]) / (Customer.CurrentMember.Parent, [Net_Revenue]);

(Customer.CurrentMember, [Net_Revenue]) / (Customer, [Net_Revenue]);

(Customer.CurrentMember, [Net_Revenue]) / (Customer, [Net_Revenue], Products, YearTotal);

Question: 3 Identify the two true statements about incremental loading.

Different materalized views may exist within a slice as compared to the main slice of the database

Allows for real time data access for end users

Materialization of slices is required to provide users the correct query results

Creates “subcubes” along the main slice in the database

Unlock and Upgrade

Remove all limits from your Quizzes

Essbase

Essbase Mastery Quiz

More Quizzes