Quiz
Essbase Certification
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (69)
1Which six files are involved in data base recovery for block storage option after a database crash?
- AEssn.pag - data
- BEssn.ind - index
- CEssn.dat
- DTemp.dat
- EDbname.esm - kernel file that contains control information for db recovery
- FDbname.tct - transaction control table
- GDbname.ind - free fragment file for data and index free fragments
- HDbname.otl
- IMetadata folder
2Which two options would provide a better design for the following accounts and metrics?
- AIf there are a small number of accounts that require FTE and Expense dollars, split
Accounts and Metrics into 2 dimensions - BIf there are a large number of accounts that require FTE and Expense dollars, split Accounts and Metrics into 2 dimensions
- CIf repointing dictates FTE and dollars in the columns and accounts in the rows, split
Accounts and Metrics into 2 dimensions - DIf block size is large, then keep Accounts and Metrics as one dimension with a dense dimension setting
- AIf there are a small number of accounts that require FTE and Expense dollars, split
3Identify the two true statements about incremental loading.
- AAllows for real time data access for end users
- BCreates “subcubes” along the main slice in the database
- CMaterialization of slices is required to provide users the correct query results
- DDifferent materalized views may exist within a slice as compared to the main slice of the database
4You should back up the following three for ASO.
- AHyperion_Home \common
- BEssbaseinstallfolder\bin
- CEssbaseinstallfolder\app\appname
- DEssbaseinstallfolder \locale
- E Essbase.sec
- FEssbase.cfg
5You 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?
- AShared members provide cross tab reporting (Product Manager in the rows and Product
Family across the column) - BShare members provide additional categorization but results in a smaller database then if you were to add Product Manager as a separate dimension
- CYou can assign security to shared members
- DShare members can be assigned to spares members only
- AShared members provide cross tab reporting (Product Manager in the rows and Product
6Identify four disadvantages / considerations when using a transparent partition.
- AOld data
- BSlow retrievals
- CSlow calculations if referencing dynamic calc members in the source
- DOutline sync complexities
- EIncreased network load
- FDowntime required to sync data
7Assuming 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- AExport the data for actual, current year, sales into a text file called data.txt
- BExport the data for actual, current year into a taxt file called data.txt
- C Export data blocks in a compressed encrypted format
- DCreate a text file that can be imported using the DATAIMPORTBIN calc command in another database that has different dimensionality
8A calculation script is performed on a database for which Create Block on Equation is OFF. The command SET CREATEBLOCKONEQ ON is issued immediately before an equation in the script. Which statement accurately describes when blocks will be created?
- ABlocks will be created ONLY when the equation assigns non-constant values to members of a sparse dimension
- B Blocks will be created ONLY when the equation assigns constant values to members of a sparse dimension
- CBlocks will be created when the equation assigns either constant or non-constant values to members of a spare dimension.
- DNo blocks will be created.
9Market size is an attribute dimension with the following members: Large, Medium, Small. Which of the following option below represent valid syntax statements in a calc script?
- AFIX (@ATTRIBUTE(Large))
- BCalc Dim (Accounts, Markets, “Market Size”);
- CCalc Dim (Accounts, Markets, Market Size);
- DFIX(Large)
10Moving a stored entity member in a sparse dimension causes ________.
- Aa Full restructure
- Ban Index restructure
- Can Outline restructure
- D No restructure
11During a multidimensional analysis, getting data from a supplemental data source is an example of____________.
- ADrill across
- BDrill Through
- CTrending
- DPivoting
12Identify the two true statements about expense reporting tags.
- AProvide accurate time balance calculations
- BProvide accurate variance reporting on revenue and expense accounts
- CAre assigned to the dimension tagged Time
- DAre assigned to the dimension tagged Accounts
- EAre assigned to the dimension containing variance members
13Block size is calculated by the following formula.
- ANumber of stored sparse dimension members multiplied together times 8 bytes
- BNumber of total sparse dimension members multiplied together times 8 bytes
- CNumber of dense sparse dimension members multiplied together times 8 bytes
- DNumber of total dense dimension members multiplied together times 8 bytes
14Given the following information, what is the block size?
Markets: Sparse, 10 stored members, 10 total members
Product: Sparse, 5 stored members, 7 total members
Accounts: Dense, 10 stored members, 11 total members
Time: Dense, 5 stored members, 12 total members- A400 KB
- B400 Bytes
- C1056 KB
- D50 Bytes
- E1056 Bytes
- F50 KB
- G70 KB
15Which three options will clear query tracking results in ASO?
- AMaterialize an aggregation
- BClear the data in the database
- CStop the application
- DTurn off
- EChange an outline
16Identify the four true statements about ASO “under the covers”
- ATablespaces are utilized to store data and metadata
- BPage files and index files are utilized to store data store data and metadata
- CDefault - stores numeric data (.dat file)
- DBin - store numeric data (.dat file)
- EData - store numeric data (.dat file)
- FMetadata - store numeric information about the objects in the database
- GMetadata - store numeric data (.dat file)
- HTemp - temporary working space for the Essbase kernel
17Fragmentation has a number of potential causes. Identify two.
- ADeleting member from a sparse dim
- BDeleting member from a dense dim
- CRenaming a member
- DRenaming an alias
- ESubmitting data/deleting data frequently (like in budget applications)
18Within which two directories can you set the location and file size in ASO?
- A Default
- BMetadata
- CLog
- DTemp
- EBin
- FData
19Which three statements are true about multiple hierarchies in ASO?
- AFirst hierarchy must be stored.
- BMultiple hierarchies must be enabled by dimension.
- CFirst hierarchy must be dynamic
- DAll alternate hierarchies must be dynamic.
- EAlternate hierarchies may be either dynamic or stored.
20Identify the five true statements.
- ACALC DIM is faster than AGG on Sparse dimensions
- BAGG is faster than CALC DIM on Sparse dimensions
- CCALC DIM calculates member formulas
- DAGG calculates member formulas
- ECALC DIM calculates Sparse dimensions
- FAGG calculates Sparse dimensions
- GCALC DIM calculates Dense dimensions
- HAGG calculates Dense dimensions
21In an aggregate storage database, which two are the correct member solve orders for Profit per Unit and Variance given the following:
Profit Unit - Accounts dimension
Variance - Scenario dimension
When we say “correct,” we mean that both dynamic totals will calculate and display correctly.- AAccounts 0, Profit Per Unit 0, Scenario 0, Variance 1
- BAccounts 0, Profit Per Unit 1, Scenario 0, Variance 0
- CAccounts 2, Profit Per Unit 0, Scenario 0, Variance 1
- DAccounts 2, Profit Per Unit 1, Scenario 1, Variance 2
22Identify the true statement about the data cache.
- AData cache contains compressed data blocks
- BData cache contains uncompressed data blocks
- CData cache contains compressed index entries
- DData cache contains uncompressed data index entries
23What is the extension for the file containing data for ASO applications?
- A.pag
- B .dat
- C.txt
- D.aso
- E.fil
24In Smart View, when zooming in and out of dimensions in Essbase, if you need to go back to a previous step, you can:
- AUndo one time
- BFlashback one time
- CUndo up to specified number of times
- DUse Microsoft Excel Undo
25You need to display a text value based on variance data in an ASO database. If the variance percentage is less the 10, users should see “Low Priority,” if the variance percentage is between 11 and 25, users should see “Medium Priority,” and if variance percentage is greater than 25, users should see “High Priority.;” The Essbase feature that supports this capability is:
- AText List
- BFormatstring
- CText data type of a measure
- DTrigger
- ENot possible in an ASO database
26Identify the three true statements about the Administration Services console.
- AYou can create custom views in EAS; Custom views help administrators focus those apps, databases or servers that apply to them
- BServer can be added to a custom view
- CApplications and databases can be added to a custom view
- DCalc scripts can be added to a custom view
- ERules files can be added to a custom view
27You need to track and report the Store Close Date for all of the stores in your company in your block storage option database. Store close will vary by over time. Which three solutions would allow you to do this?
- AAttribute dimension based on Store
- BVarying attribute dimension with an Independent dimension of Time where Time contains both the Years and Months in the same dimension
- CVarying attribute with 2 Independent dimensions, Periods and Fiscal Year
- DMeasure called Store Close Date with a data type of date
- EUser Defined attribute Store Close Data assigned to each stone
28Given the following, what is the block size in bytes?
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- ABlock size = 40 * 17 * 2
- BBlock size = 40 * 17 * 2 * 8
- CBlock size = 50 * 17 * 5
- DBlock size = 50 * 17 * 5 * 8
29Which two statements are true (assuming data is loaded to a BSO database and to the members noted below)?
- AIf you delete a sparse shared member, the outline file shrinks
- B If you delete a sparse shared member, the page file shrinks
- CIf you delete a sparse shared member, the index file shrinks
- DIf you delete a sparse shared member, the block density shrinks
- EIf you delete a sparse shared member, the block size shrinks
- F If you delete a sparse shared member, the number of blocks shrinks
30Which four are the directories used for aggregate storage databases?
- A Default
- B Log
- CMetadata
- DData
- EBin
- FTemp
31What is the default calculation order for ASO database?
- AAccounts, Time, all remaining dimensions in ascending order of member count
- BTime, Accounts, all remaining dimensions in ascending order of member count
- CAccounts, Time, all remaining dimensions in descending order of member count
- DTime, Accounts, all remaining dimensions in descending order of member count
- EDynamic hierarchies, Stored hierarchies
- FStored hierarchies. Dynamic hierarchies
32You 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.
- AA separate MaxL script is required for each step
- BThe password must be hardcoded into the script when logging in
- CIFERROR can be used in MaxL to handle errors after each statement, when triggered will skip to a subsequent statement
- DVariables for objects like server names, application names and database names can be used in a MaxL script to help with maintenance
33What does DTS (Dynamic Time Series) do?
- ACalculates to date values for Essbase block storage databases
- BDynamically calculates the Time dimension
- CEnable Time Balance functionality for accounts
- DCalculates to date values for Essbase aggregate storage databases
34Which three are Essbase components?
- A Essbase server
- BAdministration services
- CC API
- DWeb Analysis
- EFinancial Reporting
35Which setting will give information about when a data block is calculated?
- ASET MSG INFO;
- BSET MSG SUMMARY;
- CSET MSG DETAIL;
- DSET MSG WARNING;
36What are the three rules for Shared Members in ASO?
- AA Multiple Hierarchy Enabled dimension can have shared members
- BWhen a hierarchy is tagged Multiple Hierarchies Enabled, it must be store
- CThe alternate hierarchy has shared members that refer to nonshared members of previous hierarchies in the outline
- DThe shared members roll up according to a different hierarchy from the nonshared members to which they refer
37Changing a dense dimension member from stored to dynamic causes _______.
- Aa Full restructure
- Ban Index restructure
- Can Outline restructure
- DNo restructure
38You are building a sales analysis model. In this model there is no requirement for calculation. The user needs to aggregate data across all dimensions and wants to archive many year of data. Archived data will be analyzed once in while. What types of cube would you build using Essbase for this kind of requirement?
- ABlock Storage
- BXOLAP
- CAggregate Join
- DVirtual Cube
39Where are the ASO data files managed?
- APage files
- BIndex files
- CTablespaces
- DBin files
40Given the following information, how many potential blocks?
Markets: Spare, 10 stored members, 10 total members Product:
Sparse, 5 stored members, 7 total members Accounts:
Dense, 10 stored members, 11 total members Time:
Dense, 5 stored members, 12 total members- A100
- B70
- C560
- D350
- E400
- F50
41The data block density for a particular BSO database is between 10% and 90%, and data values within the clock do not consecutively repeat. Which type of compression would be most appropriate to use?
- ABitmap
- BRLE
- CZLIB
- DNo Compression Required
42You need to calculate average units sold by the customer dimension within an ASO database. The member formula should calculate correctly regardless of level within the customer dimension. Identify the correct syntax for the member formula.
- A@AVG (SKIPBOTH, "Units_Sold");
- BAvg(Customer.CurrentMember.Children, [Units_Sold])
- CAvg(Customer.Children, [Units_Sold])
- DAvg(Customer.CurrentMember.Children, [Units_Sold]);
- EAvg(Customer.Children, [Units_Sold]);
43With an average block density greater than 90%,
- AYou should reconsider the dense and sparse settings
- BYou should consider no compression
- CYou should set Commit blocks to 0
- DYou should reconsider the outline order of dimensions
44You are performing incremental loads to an ASO database during the day, providing near realtime data to the SaleDtl ASO database. Before the incremental load, you need to clear a specific set of data in the fastest amount of time possible. What is the best solution?
- APartial clears are not supported for ASO
- BPerform a logical clear, using MDX to specify the region to be cleared
- CPerform a physical clear, using MDX to specify the region to be cleared
- DRun a calc script containing the CLEARDATA command and a set of FIX statements that isolate the desired data set
- ERun a calc script containing the CLEARBLOCK command and a set of FIX statements that isolate the desired data set
45Identify the two true statements about materialization in ASO.
- AWhen performing an incremental data load, aggregate views are updated.
- BThe database is not available during materialization
- CMaterialization can be tuned via query hints and hard restrictions defined at the database level
- DMaterialization scripts can be saved for future reuse
46You 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).
- ASet Index Cache the size of the index file
- BSet Data Cache to the size of .025 * data file
- CSet Data File Cache to the size of .025 * data file
- DReset sparse and dense dimensions to achieve a block size greater than 100KB
47The following two members would be optimally tagged Label Only.
- A"Profit"
- B"Ratios"
- C"Scenario"
- D"Q1"
- E"January"
48Your 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.- AAdd another level to the market dimension for Northeast with North and East as children and Southwest with West and South as children.
- BAdd an alternate hierarchy to the market dimension with the states as shared members, rolling up to Northeast and Southwest.
- CCreate a UDA with members Northeast and Southwest (associated to states in the Market dimension)
- DCreate an attribute dimension with members Northeast and Southwest (associated to states in the Market dimension)
- ECreate a Text list with the values containing the members Northeast and Southwest.
49Which two valid field headers could be assigned to the 5th column in this data file? Duplicate
Member Names is not enabled.
- AAlias
- BAttribute
- CGeneration 4
- DUDA
- EProperty
50Which files will get restructured in a full BSO restructure?
- AData file only
- BIndex file only
- CData and index file
- D No file
51What are five reasons to use Attributes over a Shared Members dimension?
- ATo create crosstab reports
- BTo describe a dense dimension
- CTo describe a sparse dimension
- DTo perform comparisons based on certain type of data
- ETo perform calculations based on characteristics
- FTo add dimensionality to the database without increasing database size
52What is the correct variance formula for an ASO database that recognizes Expense and
Non-expense accounts?- A@Var(Actual, Budget);
- B@Var([Actual], [Budget])
- C[Actual] - [Budget]
- D[Budget] - [Actual]
- EIIF (IsUda([Measures.currentmember], "Expense"), [Budget] - [Actual], [Actual] - [Budget])
53Given the following, what is the declared block size?
(Multiply dense stored members together and multiply by 8 bytes)
- A1920 bytes
- B480 bytes
- C3840 bytes
- D12450 bytes
54You receive the following error: Error: 1042017: Network error: The client or server timed out waiting to receive data. Which two settings in the Essbase.CFG are most commonly used to correct the issue?
- ADISPLAYMESSAGELEVEL
- BNETDELAY
- CNETRETRYCOUNT
- DMAX_REQUEST_GRID_SIZE
- EMAX_RESPONSE_GRID_SIZE
55Which statement related to Essbase design is true?
- ACalc scripts are nore efficient at performing calculations vs. member unary operators and member formulas
- BOne big application is better than three smaller focused applications.
- CAttribute dimensions require less performance consideration in ASO databases because they are treated as alternate rollups
- DAttribute dimensions require less performance consideration in BSO databases because they are dynamically calculated
- EBigger block sizes are better than smaller block sizes
56Which four of the following activities can be performed by the administrator in Shared
Services?- ACreates users and groups
- BAccesses external users and groups for provisioning
- CMigrates applications using Life Cycle Management
- DCreates cube schemas from a relational database
- EProvisions Essbase roles for users and groups like Read, Write, and Filter
- FCreates Essbase filters
57Identify the three invalid methods to back up ASO databases.
- AMaxL alter database commands
- B Esscmd BEGINARCHIVE / ENDARCHIVE
- CBackup and Recovery features introduced in version 11
- DOperating System backup
58Identify the four true statements about attribute dimensions
- AAttributes allow cross tab reports with other dims
- BAttributes are assigned to dense dimensions
- CAttributes are stored
- DAttributes are dynamically calculated
- ESecurity can be assigned by attribute dimension
- FEven though ASO databases allow many dimensions, attribute dimensions are still available and used in aggregate storage option databases
59You 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?
- ARun a MaxL comment to see if the database is fragmented
- BCheck when was the last time the application was stopped
- CCheck the data cache setting
- DCheck the commit-level setting
60You have a reporting requirement to track and report the employee status for employees in your workforce ASO Essbase database. Employee status can change over time. One report requires employees down the rows and employee status across the columns. What is the best solution to meet the all of the requirements?
- ASeparate Employee status dimension
- BText List
- CSmart List
- DAttribute dimension
- EVarying attribute dimension
- FAlternate hierarchy
- GUser defined attribute
61Identify the two true statements about compression for block storage databases.
- AIndex value pair compression works well for consecutive zero values or repeating values within a database.
- BRLE compression works well for consecutive zero values or repeating values within a database.
- CBitmap compression is the default compression method.
- DThe Accounts dimension is tagged the compression dimension by default.
- EDo not set compression for a dimension that has many members.
62Identify the two true statements about block density for a Block Storage (BSO) database.
- ABlock density is the percentage of blocks that exist compared to the total number of blocks.
- BBlock density is the percentage of data that exists within a block compared to what can be stored in the total block.
- CIdeally block density will be high
- DYou can view the block density on the Application Properties tab in the Administration
Services console.
63The following objects are considered metadata elements in Essbase Studio except for which two?
- ADimensional element
- BHierarchy
- CCube Schema
- DMetaoutline
- EEssbase Model
- FMetamodel
64In Essbase 11.1.1, what are two possible ways to calculate Period to Date values in ASO?
- AEnable Dynamic Time Series
- BAnalytic dimension with member formulas to calculate period to date values
- CAlternate hierarchy in Time dimension to rollup period to date values
- DCreate a Date Time dimension
65You are trying to create a multidimensional model for Essbase and learn that your user wants to track commission for his sales persons, in addition to tracking sale by regions. When designing a multidimensional model, which two elements will serve as facts (measures)?
- ASales person
- BCommission
- CNew York
- DSales
- EYear to Date
66What security filter will assign security to a hierarchy, filtering the members displayed to end users?
- ARead Filter
- BWrite Filter
- CMetaread Filter
- DMetadate Filter
- ENot possible to secure dimensions; Only data can be secured
67In Essbase, security can be managed in _______.
- AShared Services
- BAdministration Services
- CEssbase Studio
- DShared Services or Administration Services
- EAll of the above
68Identify the two true statements about data loads to ASO and BSO databases.
- AData can only be loaded to level 0 members in ASO databases where BSO allows data loads to upper level members.
- BCells at all levels can be loaded (except Dynamic Calc members) for both ASO and BSO.
- CAfter an ASO data load, no further calculation is required.
- D Concurrent loads are supported for both ASO and BSO.
69You have the following customer dimension:
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.
- A(Net_Revenue]) / (Parent, [Net_Revenne])
- B(Customer.CurrentMember, [Net_Revenue]) / (Customer.CurrentMember.Parent, [Net_Revenue]);
- C(Customer.CurrentMember, [Net_Revenue]) / (Customer.CurrentMember.Parent, [Net_Revenue])
- D(Customer.CurrentMember, [Net_Revenue]) / (Customer, [Net_Revenue]);
- E(Customer.CurrentMember, [Net_Revenue]) / (Customer, [Net_Revenue], Products, YearTotal);
Information
- Description
- a
- Author
- Bob Costas
- Language
- English
- Views
- 967
- Tags
- Rating
- 5.0 out of 5 · 1 rating Rate this quiz