Certification Questions

Hi All,
please find some sample questions, which can help you to get certified in Essbase.

1. Development tool used to build application which can add or delete dimensions.
2. essbase quick start when is it used
3. multiple fix – dense or sparse
4. multiple if – dense or sparse
5. Member selection wizard in excel. Placement
6. When are hash tables used
7. Number of passes through database (two pass calc) – 2questions
8. Query designer – what cannot be assigned to filter access
9. Sequence of cache files to be optimized based on their priority
10. What causes fragmentation?
11. Which compression type to use based on the statistics information of the database
    is incremental restructuring deferred when u add, move or delete a member of a sparse dimension
12. What command do you use to optimize data export
13. Max .pag file size
14. Given a load file identify what field or load method should be used.
15. Attribute dimensions
16. What cannot be linked to a cell with an LRO
17. When would you select Shared Member functionality, as opposed to Attribute dimension functionality?
18. Proper use of substitution variables in the cal scripts
19. Variance calculation – when is it used. Result
20. Given an exhibit identify the improper use of label only tag
21. What are the minimum security settings for LRO’s
22. Accept and reject records based on rules
23. Data source 3 partitions, data target updated. How many .CHG files are updated
24. Given settings, what is the optimal outline
25. Which partition uses less synchronization
26. Given 2 exhibits from excel, which exhibit will be retrieved
27. hashtbl theory
28. Set commands – 3 questions
29. Dynamic calc and dynamic cal and store properties interchanged what kind of restructuring happens
30. Attribute calc dimensions
31. Use of attribute dimensions in partitions
32. Identify how many blocks are created given database statistics
33. How many index files will be restructures
34. Validate command
35. Which access a filter can have
36. Fix command and number of passes
37. Fix with datacopy
38. Fix with cross-dimensional operator
39. frmbottom up command
40. Given an outline which dimension is tagged as label only
41. Can u load data into attribute dimension
42. Datacopy syntax
43. beginarchive and endarchive commands
44. net delay command
45. query designer filter access issues
46. Which file holds uncompressed data blocks
47. Fragmentation, causes prevention and resolution
48. Essbase member selection placement in query designer of spread sheet