Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
20 Cards in this Set
- Front
- Back
6 files involved in database recovery |
Essn.pag - data Essn.ind - index Dbname.esm Dbname.tct Dbname.ind Dbname.otl
Essn.dat Temp.dat Metadata folder
|
|
Which two options would provide a better design for the following accounts and metrics? |
B. If there are a large number of accounts that require FTE and Expense dollars, split Accounts and Metrics into 2 dimensions C. If repointing dictates FTE and doolars in the columns and accounts in the rows, splitAccounts and Metrics into 2 dimensions
A. If there are a small number of accounts that require FTE and Expense dollars, splitAccounts and Metrics into 2 dimensions D. If block size is large, then keep Accounts and Metrics as one dimension with a dense dimension setting
|
|
Identify the two true statements about incremental loading.
|
A. Allows for real time data access for end users B. Creates “subcubes” along the main slice in the database
C. Materialization of slices is required to provide users the correct query results D. Different materalized views may exist within a slice as compared to the main slice of the database
|
|
You should back up the following three for ASO.
|
C. Essbaseinstallfolder \app\appname E. Essbase.sec F. Essbase.cfg
A. Hyperion_Home \common B. Essbaseinstallfolder\bin D. Essbaseinstallfolder \locale |
|
You have the following analysis requirement... You consider Shared members as a solution because of which two options? |
B. Share members provide additional categorization but results in a smaller database then if you were to add Product Manager as a separate dimension C. You can assign security to shared members
A. Shared members provide cross tab reporting D. Share members can be assigned to spares members only
|
|
Identify four disadvantages / considerations when using a transparent partition. |
Right: B. Slow retrievals C. Slow calculations if referencing dynamic calc members in the source D. Outline sync complexities E. Increased network load
Wrong: A. Old data F. Downtime required to sync data |
|
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 |
Right: A. Export the data for actual, current year, sales into a text file called data.txt C. Export data blocks in a compressed encrypted format
Wrong: B. Export the data for actual, current year into a taxt file called data.txt D. Create a text file that can be imported using the DATAIMPORTBIN calc command in another database that has different dimensionality
|
|
A calculation script is performend on a databased 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? |
Right: A. Blocks will be created ONLY when the equation assigns non-constant values to members of a spatse dimension
Wrong: B. Blocks will be created ONLY when the equation assigns constant values to members of a spatse dimension C. Blocks will be created when the equation assigns either constant or non-constant values to members of a spare dimension. D. No blocks will be created. |
|
Market 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? |
Right: A. FIX (@ATTRIBUTE(Large))
Wrong: B. Calc Dim (Accounts, Markets, “Market Size”); C. Calc Dim (Accounts, Markets, Market Size); D. FIX(Large) |
|
Moving a stored entity member in a sparse dimension causes . |
Right: B. an Index restructure
Wrong: A. a Full restructure C. an Outline restructure D. No restructure |
|
During a multidimensional analysis getting data from a supplemental data source is an example of . |
Right: B. Drill Through
Wrong: A. Drill across C. Trending D. Pivoting |
|
Identify the two true statements about expense reporting tags. |
Right: B. Provide accurate variance reporting on revenue and expense accunts D. Are assigned to the dimension tagged Accounts
Wrong: A. Provide accurate time balance calculations C. Are assigned to the dimension tagged Time E. Are assigned to the dimension containing variance members |
|
Block size is calculated by the following formula. |
Right: D. Number of total dense dimension members multiplied together times 8 bytes
Wrong: A. Number of stored spase dimension members multiplied together times 8 bytes B. Number of total spase dimension members multiplied together times 8 bytes C. Number of dense spase dimension members multiplied together times 8 bytes
|
|
Given 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 |
Right: B. 400 Bytes
Wrong: A. 400 KB C. 1056 KB D. 50 Bytes E. 1056 Bytes
F. 50 KB G. 70 KB |
|
Which three options will clear query tracking results in ASO? |
Right: A. Materialize an aggregation B. Clear the data in the database D. Turn off
Wrong: C. Stop the application E. Change an outline |
|
Identify the four true statements about ASO “under the covers” |
Right: A. Tablespaces are utiliaed to store data and metadata C. Default - stores numeric data (.dat file) F. Metadata - store numeric information about the objects in the database H. Temp - temporary working space for the Essbase kernel
Wrong: B. Page files and index files are utilized to store data store data and metadata D. Bin - store numeric data (.dat file) E. Data - store numeric data (.dat file) G. Metadata - store numeric data (.dat file)
|
|
Fragmentation has a number of potential causes. Identify two. |
Right: A. Deleting member from a sparse dim E. Submitting data/deleting data frequently (like in budget applications)
Wrong: B. Deleting member from a dense dim C. Renaming a member D. Renaming an alias |
|
Within which two directories can you set the location and file size in ASO? |
Right: A. Default D. Temp
Wrong: B. Metadata C. Log E. Bin
F. Data |
|
Which three statements are true about multiple hierarchies in ASO? |
Right: A. First hierarchy must be stored. B. Multiple hierarchies must be enabled by dimension. E. Alternate jierarchies may be either dynamic or stored.
Wrong: C. First hierarchy must be dynamic. D. All alternate hierarchies must be dynamic. |
|
Identify the five true statements. |
Right: B. AGG is faster than CALC DIM on Sparse dimensions C. CALC DIM caloulates mumber formulas E. CALC DIM caloulates Sparse dimensions F. AGG calculates Sparse dimensions G. CALC DIM caluulates Dense dimensions
Wrong: A. CALC DIM is faster than AGG on Sparse dimensions D. AGG calculates member formulas H. AGG calculates Dense dimensions |