Essbase Cert - 1

Front 1

6 files involved in database recovery

Back 1

Essn.pag - data

Essn.ind - index

Dbname.esm

Dbname.tct

Dbname.ind

Dbname.otl

Essn.dat

Temp.dat

Metadata folder

Front 2

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

Back 2

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

Front 3

Identify the two true statements about incremental loading.

Back 3

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

Front 4

You should back up the following three for ASO.

Back 4

C. Essbaseinstallfolder \app\appname

E. Essbase.sec

F. Essbase.cfg

A. Hyperion_Home \common

B. Essbaseinstallfolder\bin

D. Essbaseinstallfolder \locale

Front 5

You have the following analysis requirement... You consider Shared members as a solution because of which two options?

Back 5

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

Front 6

Identify four disadvantages / considerations when using a transparent partition.

Back 6

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

Front 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

Back 7

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

Front 8

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?

Back 8

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.

Front 9

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?

Back 9

Right:

A. FIX (@ATTRIBUTE(Large))

Wrong:

B. Calc Dim (Accounts, Markets, “Market Size”); C. Calc Dim (Accounts, Markets, Market Size); D. FIX(Large)

Front 10

Moving a stored entity member in a sparse dimension causes .

Back 10

Right:

B. an Index restructure

Wrong:

A. a Full restructure

C. an Outline restructure

D. No restructure

Front 11

During a multidimensional analysis getting data from a supplemental data source is an example of .

Back 11

Right:

B. Drill Through

Wrong:

A. Drill across

C. Trending

D. Pivoting

Front 12

Identify the two true statements about expense reporting tags.

Back 12

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

Front 13

Block size is calculated by the following formula.

Back 13

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

Front 14

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

Back 14

Right:

B. 400 Bytes

Wrong:

A. 400 KB

C. 1056 KB

D. 50 Bytes

E. 1056 Bytes

F. 50 KB G. 70 KB

Front 15

Which three options will clear query tracking results in ASO?

Back 15

Right:

A. Materialize an aggregation

B. Clear the data in the database

D. Turn off

Wrong:

C. Stop the application

E. Change an outline

Front 16

Identify the four true statements about ASO “under the covers”

Back 16

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)

Front 17

Fragmentation has a number of potential causes. Identify two.

Back 17

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

Front 18

Within which two directories can you set the location and file size in ASO?

Back 18

Right:

A. Default

D. Temp

Wrong:

B. Metadata

C. Log

E. Bin

F. Data

Front 19

Which three statements are true about multiple hierarchies in ASO?

Back 19

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.

Front 20

Identify the five true statements.

Back 20

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