Question 1.
What is the most efficient development tool to use for rapid deployment of formatted reports without requiring coding?

A. Essbase Objects application
B. basic Spreadsheet Add-In with template files
C. Essbase Web Gateway deployed over their Intranet
D. basic Spreadsheet Add-In with template files and Extended Spreadsheet Macros

Answer: B

Question 2.
Input data exhibit;
 

Outline Exhibit:
 

Given the Input data and the Outline in the exhibits, if Product and market are sparse, which is an input level data block?

A. East->Root beer
B. New York->Colas
C. New York->Diet Cola
D. New York->Root Beer

Answer: A, B, D

Question 3.
Given that product and Market are the only sparse dimensions, which file(s) would be restructured if a new member were added to the Product dimension?

A. none
B. data files only
C. index files only
D. both index and data files

Answer: C

Question 4.
Exhibit:
 

Given the outline in the exhibit, if Incremental Restructuring is enabled and Product and Market are the only sparse dimensions,what is the incremental restructing implication if the Product dimension is moved after the Market dimesion?

A. none
B. restructure deferred
C. overrides incremental restructuring and restructures data files only
D. overrides incremental restructing and restructures index files only
E. overrides incremental restructuring and restructures both index and data files

Answer: D

Question 5.
If the average block density is between 10% and 90% and there are few consecutive repeating values or zeros, which data compression type is recommended?

A. RLE
B. Bit-Map
C. No Compression

Answer: B

Question 6.
When would disabling data compression be recommended?

A. when the average block density is very low (<3%)
B. when the average block density is very high (>95%) and few consecutive repeating values 
    exist
C. When the database contains many consecutive zero values or other consecutive repeating 
    values

Answer: B

Question 7.
Exhibit
 
In the outline in the exhibit, Year and Measure are dense dimensions. Data is loaded for every month, Measure, Market and Scenario. After a CALC ALL is run, how many blocks are there?

A. 12
B. 18
C. 24
D. 30

Answer: A

Question 8.
During calculation,what is the calculator cache used for?

A. for storing blocks
B. for tracking index page usage
C. for storing dynamically calculated values
D. for tracking calculation progress through the blocks

Answer: D

Question 9.
Exhibit:
 

Given the following database statistics, what is the block size?

A. 192 bytes
B. 1536 bytes
C. 1600 bytes
D. 12800 bytes

Answer: B

Question 10.
If committed Access is being used, which statements are true?

A. It retains redundant data until a transaction commits
B. It acquires and releases Write locks as needed during the transaction
C. It retain Write locks on all afected blocks until the transaction commits
D. It does not restrict Read/Write access on data blocks during the transaction

Answer: A, C

	Web www.certsbraindumps.com