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 fun
- 21 thoughtfully crafted questions
- Evaluate your understanding of key concepts
- Perfect for both learning and assessment
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?
Clear the data in the database
Change an outline
Materialize an aggregation
Turn off
Stop the application
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: 18 Within which two directories can you set the location and file size in ASO?
Temp
Metadata
Default
Data
Log
Bin
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.
Slow retrievals
Slow calculations if referencing dynamic calc members in the source
Increased network load
Old data
Downtime required to sync data
Outline sync complexities
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: 30 Which four are the directories used for aggregate storage databases?
Temp
Data
Default
Log
Bin
Metadata
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: 49 Which two valid field headers could be assigned to the 5th column in this data file? Duplicate Member Names is not enabled.
Attribute
Generation 4
Alias
UDA
Property
Question: 53 Given the following, what is the declared block size?
1920 bytes
3840 bytes
480 bytes
12450 bytes
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
{"name":"Essbase", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"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 questionsEvaluate your understanding of key conceptsPerfect for both learning and assessment","img":"https:/images/course2.png"}