1. When would you select Shared Member functionality, as opposed to Attribute dimension functionality? (Choose Three)
A. When creating crosstab reports
B. When desiring precalculated totals
C. When associating with a dense dimension
D. When using alternate consolidation properties (+, -, ~, etc…) for members
E. When increasing the amount of dimensionality without increasing the sparsity of the database.
2. Why should you create only one database per BSO application? (Choose Two)
A. There can be conflicts when writing data
B. If you have trouble with one database, other databases are not affected because they are in a different application
C. The application log is easier to read
D. You cannot have multiple databases per application
3. If you tag a dimension with the Accounts dimension type which of the following are true?(choose Two)
A. Expense reporting for use with @VAR and @VARPER calculation functions is enabled
B. The dimension name is automatically set to Label Only
C. Attribute dimensions are enabled if a Time dimension is present
D. Essbase will force the Accounts to be calculated first during a Calc All
4. Which of the following does NOT describe the qualities of a dense dimension?
A. Variances are typically calculated in these dimensions
B. They are calculation intensive, including models, formulas, mathematically driven data etc
C. They often have hundreds or thousands of members
D. Initial development is often manual
5. Which statement is true when describing member formulas?
A. Member formulas are only executed when using committed access
B. Member formulas can only be used on members tagged as Dynamic Calc
C. If the data storage type is Dynamic Calc the formulas are executed when a user retrieves the member in a spreadsheet
D. Member formulas are created in the Calc Script Editor
6. What are the benefits of having Attribute Dimensions? (Choose Two)
A. Attribute dimensions add no overhead in terms of database size
B. Attribute members can be associated with members of a dense dimension if it is tagged as an Accounts dimension type
C. Attribute dimensions can be of different types (Text, Numeric, Boolean and Date)
D. You cannot drill-down on an attribute dimension
7. Given the outline structure below, which of the following statements are true? (Choose Two)
A. Measures is Generation 1
B. Sales is Generation 0
C. Margin is Generation 3
D. Ratios is Generation 1
8. Given the same outline structure above, which of the following statements are true? (Choose Three)
A. Sales is Level 0
B. Margin % is Level 0
C. Profit is Level 2
D. Measures is Level 1
9. Which of the following would you NOT expect to find in a Scenario dimension?
A. Actual
B. Sales
C. Budget
D. Forecast
10. Which types of data source may be loaded with a rule file (Choose 3)?
A. Text files
B. Word document files
C. Spreadsheets
D. Essbase .pag files
E. Relational Databases
11. How should you add the Dynamic Calc property to a member using a rule?
(Choose 2)
A. Select Dynamic Calc under Field Properties | Dimension Building Properties
B. Select Dynamic Calc under Options | Dimension Build Settings | Dimension Build Settings
C. Add a column to the right of member column and assign D as an attribute
D. Add a column to the right of member column and assign X as an attribute
E. Set the field type as properties field under Field Properties
12. When would you choose a Level References Build Method?
(Choose 3)
A. Modify the properties of existing dimensions and members
B. Share non-leaf members
C. Create shared members that roll up into different generations
D. Add members to the attribute dimension and associate them with members of
the base dimension
E. Add each new member to a dimension with similar members
13. Which rules do you need to follow when you use Generation references build method? (Choose 3)
A. If GEN numbers don’t start at 2, the first member in the specified generation must exist in the outline.
B. Put attribute association fields before the base field with which they are associated
C. Select shared under Options | Dimension Build Settings | Dimension definition
D. Put DUPGEN fields immediately after GEN fields
E. GEN numbers must form a contiguous range. For example, if GEN 3 and GEN 5 exist, you must also define GEN 4.
14. How do you have Essbase assign a multiplication unary operator to members in
a dimension build?
A. Add “*“ as a prefix to each member in the source file
B. Add “*“ as a suffix to each member in the source file
C. Add a column to the left of member column and assign “*“ as a property
D. Add a column to the right of member column and assign “*“ as a property
15. Which code should be in your data source in order to specify that the Margin%
member does not roll up into its parent and is not be a shared member?
A. Margin% Margin% Sales +NS
B. Margin% Margin% Sales - NS
C. Margin% Margin% Sales N
D. Margin% Margin% Sales ~ N
E. Margin% Margin% Sales ~ NS
16. Which file delimiters are available for data file (Choose 4) ?
A. All white spaces
B. comma
C. column width
D. semi colon
E. tab
17. What kinds of field edit are allowed in the data prep editor? (Choose 4)?
A. Joined
B. Delete
C. Move
D. Split
E. Create
18. You can specify which records Essbase loads into the database or use to build dimensions by setting selection criteria which conditions must be met before Essbase loads the record. Which of the following are types of selection criteria? (Choose 2)
A. Date
B. Boolean
C. String
D. Number
19. Assuming there is a numeric value for the data field, which of the following statements are true for data loads? (Choose 2)
A. A single data column can be located any place in the data source
B. All mapped member names come first before the data field in the data source
C. You need to define the data column as a data field under Options | dataload settings | Data Value
D. You need to set ignore during dataload under Field Properties | Global Properties
E. You need to define the data column as a data field under Field Properties | Global Properties
20. Which ones of the following statements are true about Flashback? (Choose 3)
A. The Flashback command restores the previous database view.
B. The Flashback command uses the memory of your machine to store the current view before processing an Essbase retrieval request.
C. Flashback can undo multiple operations.
D. You can disable Flashback during normal operations to conserve memory on your local machine.
E. If you have styles applied to the worksheet and you execute the Flashback command, these styles are temporarily removed from the current view. The styles are re-applied whenever you initiate a retrieval.
21. Which ones of the following statements are true about the Navigate Without Data feature? (Choose 3)
A. With the Navigate Without Data feature, you do not need to be connected to Essbase.
B. By activating Navigate Without Data, you are effectively telling Essbase to only dynamically calculate values.
C. The Navigate Without Data feature is useful when you are creating report.
D. You can perform navigational operations, such as pivot, zoom in, zoom out, keep only, and remove only while Navigate Without Data feature is enabled.
E. With the Navigate Without Data feature, you can do retrievals without retrieving any data into the worksheet.
22. Which of the following statements are true about Linked Reporting Objects? (Choose 4)
A. You can link an external file to a data cell in Essbase Spreadsheet Add-in.
B. You can link objects to cells containing member names.
C. You can link individual cell notes that contain information on particular data cells.
D. You can link a URL to a data cell so that users who have access to the database can link directly to the specified URL.
E. Users can retrieve and edit the objects through the Spreadsheet Add-in and
Spreadsheet Services Linked Objects Browser feature.
23. Which of the following statements are true about the Retain on Retrieval feature? (Choose 4)
A. The Pivot command is not available when the Retain on Retrieval check box is selected.
B. When Retain on Retrieval is enabled, there is no possible slight delay in retrieval time.
C. Retain on Retrieval option enables you to define retrievals that do not overwrite formulas in any area of the worksheet.
D. During data retrievals, keep and remove only operations, and drill operations, Formula Preservation options enable you to retain formulas.
E. You can choose either Advanced Interpretation or Free-form Retrieval mode to enable Retain on Retrieval.
F. When you select the Retain on Retrieval check box, the Suppress #Missing Rows and Zero Rows options on the Display tab become disabled.
24. Which of the following statements are true about the Suppress Missing feature? (Choose 3)
A. You can suppress Missing values from the display in the worksheet.
B. You can not suppress Underscore characters that are in some member names.
C. The Suppress #Missing Rows and Zero Rows options are not available when any of the Formula Preservation options are selected.
D. After you enable the Suppress #Missing Rows feature, any missing values suppressed during a data retrieval are not retrieved again by simply disabling the feature.
E. Suppress #Missing Rows feature suppresses data cells that have 0 values.
25. Which of the following statements are true about Essbase Cascade feature? (Choose 4)
A. You cannot create multiple worksheet files based on a single database view.
B. You can specify at what level of detail you want to replicate the worksheets to tailor the information to each recipient’s needs.
C. The Cascade Information page contains the list of members that you selected and the options for specifying the level at which the selected members are retrieved into the cascaded worksheets.
D. The Cascade command can create more worksheets than can be stored in the memory of your computer.
E. The Open Created Files option is recommended when you are replicating large numbers of worksheets.
F. Cascade feature is frequently used by budgeting and planning applications to create worksheets for various functional areas of an organization.
26. Which of the following statements are true about Essbase Query Designer? (Choose 2)
A. You cannot select the attribute and display it in the worksheet with Essbase Query Designer.
B. If you do not select Use Sheet Options with Query Designer, even if you have selected Use Styles, they will not be applied to the initial query results.
C. You can only delete the query from within Hyperion Essbase Query Designer.
D. You cannot select a Dynamic Time Series member and a latest time period with Essbase Query Designer.
E. You can save your query to the server or to your own client machine. To save to the server, you must have a security level of database designer or higher.
27. Which of the following actions occur every time you do retrieval (Choose 3)
A. Essbase Spreadsheet Add-in requests data from the server.
B. The server processes the request and prepares the data.
C. Any dynamic calculations are calculated on the Essbase Spreadsheet client.
D. Essbase server transmits the data to Essbase Spreadsheet Add-in.
E. Spreadsheet Add-in receives the data from Essbase and organizes it in a worksheet.
28. Essbase provides you with various ways to customize the worksheet view.
Which formatting procedures can be done in the Essbase Spreadsheet Add-in?
(Choose 4)
A. Formatting text and cells
B. Displaying aliases for member names
C. Displaying both member names and aliases
D. Repeating member labels
E. Creating charts and diagrams
29. Which of the following actions would lock data values on a spreadsheet?
(Choose 3)
A. Performing a Lock command and then a Retrieve.
B. Performing a Retrieve & Lock command.
C. Performing a Lock command.
D. Enabling Update Mode in the Mode tab
E. Using the Send command.
30. When would you use a member formula in an outline?
(Choose 3)
A. To perform very complex calculations
B. When a member requires a Two-pass calculation
C. When a level 0 member is tagged as Dynamic Calc or Dynamic Calc & Store
D. To perform simple calculations
E. To reduce overall calculation time
31. Assuming the Accounts and Time dimensions are Dense, what would be the calculation order when performing a default (CALC ALL) calculation on a database?
A. Time, Accounts, remaining Dense dimensions, Sparse dimensions
B. Sparse dimensions, Time, Accounts, remaining Dense dimensions
C. Accounts, Time, Sparse dimensions, remaining Dense dimensions
D. Accounts, Time, remaining Dense dimensions, Sparse dimensions
E. Time, Sparse dimensions, Accounts, remaining Dense dimensions
32. Given the following outline what would be the correct Data Block Size?
Dimensions D/S Actual/Stored
Years Dense 17/10
Measures Dense 15/10
Product Sparse 20/20
Markets Sparse 250/250
Scenario Dense 5/2
A. 40000 bytes
B. 10200 bytes
C. 1600 bytes
D. 8000000 bytes
E. 51000000 bytes
33. Based on the same outline, if data were loaded into every member, how many blocks would exist?
A. 5000
B. 200
C. 1
D. 1000000
E. 6375000
34. In which file are the Data Blocks for the BSO database stored?
A. .otl
B. .csc
C. .pag
D. .ind
E. Flat file
35. Which of the following tags imply that a member will not store data? (Choose 2)
A. Label Only
B. Never Share
C. Dynamic Calc
D. Two-Pass Calc
36. What would be the correct Member Set function to return a list of all the members that exist below Product?
A. @CHILDREN (Product)
B. @DESCENDANTS (Product)
C. @PARENT (Product)
D. @SIBLINGS (Product)
E. @ANCESTOR (Product)
37. What are 3 methods for focusing a calculation? (Choose 3)
A. IF…ENDIF
B. @Range
C. FIX…ENDFIX
D. FOCUS….ENDFOCUS
E. Cross-Dimensional operators
38. Which type of member is more efficient to focus an IF statement on?
A. Dense
B. Sparse
C. Dynamic Calc
D. Locked
E. Unlocked
39. Which 3 statements are correct about the impact of Dynamic Calculations?
(Choose 3)
A. They reduce batch calculation times
B. They reduce disk storage
C. They increase batch calculation times
D. They increase retrieval times
E. They reduce system maintenance
40. Assuming the Accounts and Time dimensions are Dense, what is the calculation order for Dynamic Calc members?
A. Time, Accounts, remaining Dense dimensions, Sparse dimensions
B. Sparse dimensions, Accounts, Time, remaining Dense dimensions
C. Accounts, Time, Sparse dimensions, remaining Dense dimensions
D. Accounts, Time, remaining Dense dimensions, Sparse dimensions
E. Time, Sparse dimensions, Accounts, remaining Dense dimensions
41. What is a Substitution Variable in a calculation script used for?
A. To decrease overall system maintenance
B. To declare a temporary variable in a calculation script
C. To prompt the user for a parameter in a calculation script
D. To dynamically allocate the calculator cache during calculation script execution
E. To substitute one member name with another member name
42. Assuming we had created a Substitution Variable called CurrMth, what would be the correct syntax to reference this Substitution variable in a calculation script?
A. VAR CurrMth
B. &CurrMth
C. @CurrMth
D. “CurrMth”
E. (CurrMth)
43. Which of the following does not describe a benefit of ASO databases?
A. Large dimensionality
B. Direct write-back capability
C. Fast aggregation and query response time
D. Small disk footprints
44. Which two of the following statements is true of Hyperion Visual Explorer? (Choose 2)
A. Presents data in graphical formats
B. Is equivalent to the Essbase Spreadsheet Add-In
C. Performs complex calculations on ASO members
D. Allows users to derive patterns from highly complex data
45. What is the purpose of the WHERE clause in an MDX Query?
A. To state how your source cube's dimensions are laid out
B. To specify which database is being queried
C. To specify a network location of a database
D. To define the point of view of a query
46. Which of the following is true of Tuples and Sets?
A. Tuples consist of a sequence of Sets
B. Sets consist of duplicate Tuples
C. Sets consist of a sequence of Tuples
D. Tuples and Sets are relationship-based functions
47. Which of the following identifies the member New York in an MDX query?
A. %New York%
B. "New York"
C. $New York$
D. [New York]
48. Which of the following methods would you use to edit an MDX query?
A. Essbase Application Manager
B. MDX Script Editor
C. ESSCMD
D. Hyperion Visual Explorer
49. Where in an ASO database should data be loaded?
A. Generation 1
B. To either parent or child members
C. Level 0
D. Data cannot be loaded to ASO databases
50. What is the maximum number of axes supported by MDX in a result grid?
A. 24
B. 64
C. 99
D. No limit
51. What is the correct definition of a tip member with relation to MDX?
A. The top member of a dimension
B. Any Level 0 member in a dimension
C. Any virtual member in a dimension
D. A parent member of Level 0 child members
52. Which of the following statements is true regarding BSO and ASO databases?
A. Aggregate storage is a replacement for block storage
B. Both ASO and BSO database can have dense dimensions
C. ASO and BSO databases can run simultaneously on the same Essbase server
D. Essbase applications may contain both ASO and BSO databases
53. If you have a dense dimension named Measures and Year and a sparse dimension
named Market and Product and an attribute dimension named Market Size,
which dimensions comprise the index?
A. Measures and Year
B. Measures and Product
C. Market and Product
D. Market, Product and Market Size
54. While calculating the database, 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 creating and tracking data blocks during calculations
55. Which compression type would you use if you have a lot of repeating values and consecutive zero values in a dense dimension?
A. RLE
B. Bit Map
C. No Compression
56. The average Block density is between 10% and 90% and you have few repeating values or consecutive repeating values, which compression type is recommended?
A. RLE
B. Bit Map
C. No Compression
57. What happens upon execution of Maxl command
alter application Sample disable commands; ?
A. All logins to the server are disabled
B. Logins to a specific database are disabled
C. Prevents all users from making requests to the application
D. Any user logged on to a specific database are logged out.
58. In the Essbase.cfg file a customer has set NETDELAY 1000, what does this setting
represent?
A. The number of times the network will retry for a connection before reporting errors.
B. The amount of times in seconds a Named Pipe network allows before making a connection.
C. This is the amount of time in milliseconds an unsuccessful operation waits before Analytic Services retries the operation.
D. This is the amount of time in seconds an unsuccessful operation waits before Analytic Services retries the operation.
59. When a change is made to a database cache setting, what action activates the
change? (Choose 3)
A. Restart the Essbase server
B. Restart the Essbase database
C. Restart the Essbase application
D. Restart the EAS server
E. Restart the license server
60. On a Unix server, what document contains the environment setting that need to be
configured during an Essbase install?
A. hyperionenv.txt
B. hyperionenv.doc
C. essbaseenv.doc
D. essbaseset.txt
61. What command do you execute when install Essbase 6.x on Unix?
A. ./setup.sh
B. ./setup.bin
C. ./essinst
D. ./setup.exe
E. ./essinst.exe
62. What command do you execute when installing Essbase 7.x on Sun Solaris?
A. ./setup.sh -console
B. ./setup.bin -console
C. ./essinst -console
D. ./setup.exe -console
E. ./essinst.exe -console
63. What command do you type to verify active Essbase processes on UNIX?
A. awk > grep ESS
B. ls –al | grep ESS
C. ls –ef | grep ESS
D. ps -ef | grep ESS
64. What command do you type to start the Essbase agent in background , on Unix, when you are telnet to the server?
A. nohup ESSBASE-b &
B. essbase-b &
C. ESSBASE-b &
D. nohup ESSBASE-b
65. What is the recommended disk space for a database when you perform a dense
restructure?
A. No addition space is required
B. Four times the size of the database directory
C. Two times the size of the database directory
D. There is no such item as a dense restructure
66. How do I update my license key with Essbase 6.x?
A. Run the executable named REGISTER located in the bin directory.
B. Run the executable named LICENSE located in the bin directory.
C. Update the Essbase.cfg file in the bin directory with the new key.
67. How to I update my license file for Essbase 7.1.5?
A. Run the executable named REGISTER located in the bin directory.
B. Run the executable named LICENSE located in the bin directory.
C. Place the file ending in LIC in the License directory for the license server, do not run a RE-READ. Essbase server will not need to be restarted.
D. Place the file ending in LIC in the License directory for the license server, then RE-READ the license with the license server and restart Essbase.
68. What ports need to be opened if a client is outside a firewall?
A. Port 1425 and 37968 through 49725
B. Port 1423 and 32768 through 33768
C. Port 8080 and 1200 through 2600
69. To install Essbase as a Windows service, what command to you type at the command
prompt?
A. ESSBASE –install service
B. INSTALL –service ESSBASE
C. ESSBASE –service yes
D. ESSBASE –service install
ANSWERS:
--------
1: B, C, D
2: B, C
3: A, D
4: C
5: C
6: A, C
7: A,C
8: A, B,C
9: B
10. A, C, E
11. D, E
12. A, C, D
13. A. D, E
14. D
15. D
16. A, B, C, E
17. A, C, D, E
18. C, D
19. B, E
20. A, B, D
21. C, D, E
22. A, C, D, E
23. A, C, D, F
24. A, C, D
25. B, C, D, E
26. B, E
27. A, B, D
28, A, B,,C, D
29. B, C, D
30. B, C, D
31. D
32. C
33. A
34. C
35. A, C, D
36. B
37. A, C, E
38. A
39. A, B, D
40. B
41. A
42. B
43. B
44. A, D
45. D
46. C
47. D
48 B
49. C
50. B
51. A
52. C
53. C
54. D
55. A
56. B
57. C
58. C
59. A, B, C
60. B
61. C
62. B
63. D
64. A
65. C
66. A
67. D
68. B
69. D
A. When creating crosstab reports
B. When desiring precalculated totals
C. When associating with a dense dimension
D. When using alternate consolidation properties (+, -, ~, etc…) for members
E. When increasing the amount of dimensionality without increasing the sparsity of the database.
2. Why should you create only one database per BSO application? (Choose Two)
A. There can be conflicts when writing data
B. If you have trouble with one database, other databases are not affected because they are in a different application
C. The application log is easier to read
D. You cannot have multiple databases per application
3. If you tag a dimension with the Accounts dimension type which of the following are true?(choose Two)
A. Expense reporting for use with @VAR and @VARPER calculation functions is enabled
B. The dimension name is automatically set to Label Only
C. Attribute dimensions are enabled if a Time dimension is present
D. Essbase will force the Accounts to be calculated first during a Calc All
4. Which of the following does NOT describe the qualities of a dense dimension?
A. Variances are typically calculated in these dimensions
B. They are calculation intensive, including models, formulas, mathematically driven data etc
C. They often have hundreds or thousands of members
D. Initial development is often manual
5. Which statement is true when describing member formulas?
A. Member formulas are only executed when using committed access
B. Member formulas can only be used on members tagged as Dynamic Calc
C. If the data storage type is Dynamic Calc the formulas are executed when a user retrieves the member in a spreadsheet
D. Member formulas are created in the Calc Script Editor
6. What are the benefits of having Attribute Dimensions? (Choose Two)
A. Attribute dimensions add no overhead in terms of database size
B. Attribute members can be associated with members of a dense dimension if it is tagged as an Accounts dimension type
C. Attribute dimensions can be of different types (Text, Numeric, Boolean and Date)
D. You cannot drill-down on an attribute dimension
7. Given the outline structure below, which of the following statements are true? (Choose Two)
A. Measures is Generation 1
B. Sales is Generation 0
C. Margin is Generation 3
D. Ratios is Generation 1
8. Given the same outline structure above, which of the following statements are true? (Choose Three)
A. Sales is Level 0
B. Margin % is Level 0
C. Profit is Level 2
D. Measures is Level 1
9. Which of the following would you NOT expect to find in a Scenario dimension?
A. Actual
B. Sales
C. Budget
D. Forecast
10. Which types of data source may be loaded with a rule file (Choose 3)?
A. Text files
B. Word document files
C. Spreadsheets
D. Essbase .pag files
E. Relational Databases
11. How should you add the Dynamic Calc property to a member using a rule?
(Choose 2)
A. Select Dynamic Calc under Field Properties | Dimension Building Properties
B. Select Dynamic Calc under Options | Dimension Build Settings | Dimension Build Settings
C. Add a column to the right of member column and assign D as an attribute
D. Add a column to the right of member column and assign X as an attribute
E. Set the field type as properties field under Field Properties
12. When would you choose a Level References Build Method?
(Choose 3)
A. Modify the properties of existing dimensions and members
B. Share non-leaf members
C. Create shared members that roll up into different generations
D. Add members to the attribute dimension and associate them with members of
the base dimension
E. Add each new member to a dimension with similar members
13. Which rules do you need to follow when you use Generation references build method? (Choose 3)
A. If GEN numbers don’t start at 2, the first member in the specified generation must exist in the outline.
B. Put attribute association fields before the base field with which they are associated
C. Select shared under Options | Dimension Build Settings | Dimension definition
D. Put DUPGEN fields immediately after GEN fields
E. GEN numbers must form a contiguous range. For example, if GEN 3 and GEN 5 exist, you must also define GEN 4.
14. How do you have Essbase assign a multiplication unary operator to members in
a dimension build?
A. Add “*“ as a prefix to each member in the source file
B. Add “*“ as a suffix to each member in the source file
C. Add a column to the left of member column and assign “*“ as a property
D. Add a column to the right of member column and assign “*“ as a property
15. Which code should be in your data source in order to specify that the Margin%
member does not roll up into its parent and is not be a shared member?
A. Margin% Margin% Sales +NS
B. Margin% Margin% Sales - NS
C. Margin% Margin% Sales N
D. Margin% Margin% Sales ~ N
E. Margin% Margin% Sales ~ NS
16. Which file delimiters are available for data file (Choose 4) ?
A. All white spaces
B. comma
C. column width
D. semi colon
E. tab
17. What kinds of field edit are allowed in the data prep editor? (Choose 4)?
A. Joined
B. Delete
C. Move
D. Split
E. Create
18. You can specify which records Essbase loads into the database or use to build dimensions by setting selection criteria which conditions must be met before Essbase loads the record. Which of the following are types of selection criteria? (Choose 2)
A. Date
B. Boolean
C. String
D. Number
19. Assuming there is a numeric value for the data field, which of the following statements are true for data loads? (Choose 2)
A. A single data column can be located any place in the data source
B. All mapped member names come first before the data field in the data source
C. You need to define the data column as a data field under Options | dataload settings | Data Value
D. You need to set ignore during dataload under Field Properties | Global Properties
E. You need to define the data column as a data field under Field Properties | Global Properties
20. Which ones of the following statements are true about Flashback? (Choose 3)
A. The Flashback command restores the previous database view.
B. The Flashback command uses the memory of your machine to store the current view before processing an Essbase retrieval request.
C. Flashback can undo multiple operations.
D. You can disable Flashback during normal operations to conserve memory on your local machine.
E. If you have styles applied to the worksheet and you execute the Flashback command, these styles are temporarily removed from the current view. The styles are re-applied whenever you initiate a retrieval.
21. Which ones of the following statements are true about the Navigate Without Data feature? (Choose 3)
A. With the Navigate Without Data feature, you do not need to be connected to Essbase.
B. By activating Navigate Without Data, you are effectively telling Essbase to only dynamically calculate values.
C. The Navigate Without Data feature is useful when you are creating report.
D. You can perform navigational operations, such as pivot, zoom in, zoom out, keep only, and remove only while Navigate Without Data feature is enabled.
E. With the Navigate Without Data feature, you can do retrievals without retrieving any data into the worksheet.
22. Which of the following statements are true about Linked Reporting Objects? (Choose 4)
A. You can link an external file to a data cell in Essbase Spreadsheet Add-in.
B. You can link objects to cells containing member names.
C. You can link individual cell notes that contain information on particular data cells.
D. You can link a URL to a data cell so that users who have access to the database can link directly to the specified URL.
E. Users can retrieve and edit the objects through the Spreadsheet Add-in and
Spreadsheet Services Linked Objects Browser feature.
23. Which of the following statements are true about the Retain on Retrieval feature? (Choose 4)
A. The Pivot command is not available when the Retain on Retrieval check box is selected.
B. When Retain on Retrieval is enabled, there is no possible slight delay in retrieval time.
C. Retain on Retrieval option enables you to define retrievals that do not overwrite formulas in any area of the worksheet.
D. During data retrievals, keep and remove only operations, and drill operations, Formula Preservation options enable you to retain formulas.
E. You can choose either Advanced Interpretation or Free-form Retrieval mode to enable Retain on Retrieval.
F. When you select the Retain on Retrieval check box, the Suppress #Missing Rows and Zero Rows options on the Display tab become disabled.
24. Which of the following statements are true about the Suppress Missing feature? (Choose 3)
A. You can suppress Missing values from the display in the worksheet.
B. You can not suppress Underscore characters that are in some member names.
C. The Suppress #Missing Rows and Zero Rows options are not available when any of the Formula Preservation options are selected.
D. After you enable the Suppress #Missing Rows feature, any missing values suppressed during a data retrieval are not retrieved again by simply disabling the feature.
E. Suppress #Missing Rows feature suppresses data cells that have 0 values.
25. Which of the following statements are true about Essbase Cascade feature? (Choose 4)
A. You cannot create multiple worksheet files based on a single database view.
B. You can specify at what level of detail you want to replicate the worksheets to tailor the information to each recipient’s needs.
C. The Cascade Information page contains the list of members that you selected and the options for specifying the level at which the selected members are retrieved into the cascaded worksheets.
D. The Cascade command can create more worksheets than can be stored in the memory of your computer.
E. The Open Created Files option is recommended when you are replicating large numbers of worksheets.
F. Cascade feature is frequently used by budgeting and planning applications to create worksheets for various functional areas of an organization.
26. Which of the following statements are true about Essbase Query Designer? (Choose 2)
A. You cannot select the attribute and display it in the worksheet with Essbase Query Designer.
B. If you do not select Use Sheet Options with Query Designer, even if you have selected Use Styles, they will not be applied to the initial query results.
C. You can only delete the query from within Hyperion Essbase Query Designer.
D. You cannot select a Dynamic Time Series member and a latest time period with Essbase Query Designer.
E. You can save your query to the server or to your own client machine. To save to the server, you must have a security level of database designer or higher.
27. Which of the following actions occur every time you do retrieval (Choose 3)
A. Essbase Spreadsheet Add-in requests data from the server.
B. The server processes the request and prepares the data.
C. Any dynamic calculations are calculated on the Essbase Spreadsheet client.
D. Essbase server transmits the data to Essbase Spreadsheet Add-in.
E. Spreadsheet Add-in receives the data from Essbase and organizes it in a worksheet.
28. Essbase provides you with various ways to customize the worksheet view.
Which formatting procedures can be done in the Essbase Spreadsheet Add-in?
(Choose 4)
A. Formatting text and cells
B. Displaying aliases for member names
C. Displaying both member names and aliases
D. Repeating member labels
E. Creating charts and diagrams
29. Which of the following actions would lock data values on a spreadsheet?
(Choose 3)
A. Performing a Lock command and then a Retrieve.
B. Performing a Retrieve & Lock command.
C. Performing a Lock command.
D. Enabling Update Mode in the Mode tab
E. Using the Send command.
30. When would you use a member formula in an outline?
(Choose 3)
A. To perform very complex calculations
B. When a member requires a Two-pass calculation
C. When a level 0 member is tagged as Dynamic Calc or Dynamic Calc & Store
D. To perform simple calculations
E. To reduce overall calculation time
31. Assuming the Accounts and Time dimensions are Dense, what would be the calculation order when performing a default (CALC ALL) calculation on a database?
A. Time, Accounts, remaining Dense dimensions, Sparse dimensions
B. Sparse dimensions, Time, Accounts, remaining Dense dimensions
C. Accounts, Time, Sparse dimensions, remaining Dense dimensions
D. Accounts, Time, remaining Dense dimensions, Sparse dimensions
E. Time, Sparse dimensions, Accounts, remaining Dense dimensions
32. Given the following outline what would be the correct Data Block Size?
Dimensions D/S Actual/Stored
Years Dense 17/10
Measures Dense 15/10
Product Sparse 20/20
Markets Sparse 250/250
Scenario Dense 5/2
A. 40000 bytes
B. 10200 bytes
C. 1600 bytes
D. 8000000 bytes
E. 51000000 bytes
33. Based on the same outline, if data were loaded into every member, how many blocks would exist?
A. 5000
B. 200
C. 1
D. 1000000
E. 6375000
34. In which file are the Data Blocks for the BSO database stored?
A. .otl
B. .csc
C. .pag
D. .ind
E. Flat file
35. Which of the following tags imply that a member will not store data? (Choose 2)
A. Label Only
B. Never Share
C. Dynamic Calc
D. Two-Pass Calc
36. What would be the correct Member Set function to return a list of all the members that exist below Product?
A. @CHILDREN (Product)
B. @DESCENDANTS (Product)
C. @PARENT (Product)
D. @SIBLINGS (Product)
E. @ANCESTOR (Product)
37. What are 3 methods for focusing a calculation? (Choose 3)
A. IF…ENDIF
B. @Range
C. FIX…ENDFIX
D. FOCUS….ENDFOCUS
E. Cross-Dimensional operators
38. Which type of member is more efficient to focus an IF statement on?
A. Dense
B. Sparse
C. Dynamic Calc
D. Locked
E. Unlocked
39. Which 3 statements are correct about the impact of Dynamic Calculations?
(Choose 3)
A. They reduce batch calculation times
B. They reduce disk storage
C. They increase batch calculation times
D. They increase retrieval times
E. They reduce system maintenance
40. Assuming the Accounts and Time dimensions are Dense, what is the calculation order for Dynamic Calc members?
A. Time, Accounts, remaining Dense dimensions, Sparse dimensions
B. Sparse dimensions, Accounts, Time, remaining Dense dimensions
C. Accounts, Time, Sparse dimensions, remaining Dense dimensions
D. Accounts, Time, remaining Dense dimensions, Sparse dimensions
E. Time, Sparse dimensions, Accounts, remaining Dense dimensions
41. What is a Substitution Variable in a calculation script used for?
A. To decrease overall system maintenance
B. To declare a temporary variable in a calculation script
C. To prompt the user for a parameter in a calculation script
D. To dynamically allocate the calculator cache during calculation script execution
E. To substitute one member name with another member name
42. Assuming we had created a Substitution Variable called CurrMth, what would be the correct syntax to reference this Substitution variable in a calculation script?
A. VAR CurrMth
B. &CurrMth
C. @CurrMth
D. “CurrMth”
E. (CurrMth)
43. Which of the following does not describe a benefit of ASO databases?
A. Large dimensionality
B. Direct write-back capability
C. Fast aggregation and query response time
D. Small disk footprints
44. Which two of the following statements is true of Hyperion Visual Explorer? (Choose 2)
A. Presents data in graphical formats
B. Is equivalent to the Essbase Spreadsheet Add-In
C. Performs complex calculations on ASO members
D. Allows users to derive patterns from highly complex data
45. What is the purpose of the WHERE clause in an MDX Query?
A. To state how your source cube's dimensions are laid out
B. To specify which database is being queried
C. To specify a network location of a database
D. To define the point of view of a query
46. Which of the following is true of Tuples and Sets?
A. Tuples consist of a sequence of Sets
B. Sets consist of duplicate Tuples
C. Sets consist of a sequence of Tuples
D. Tuples and Sets are relationship-based functions
47. Which of the following identifies the member New York in an MDX query?
A. %New York%
B. "New York"
C. $New York$
D. [New York]
48. Which of the following methods would you use to edit an MDX query?
A. Essbase Application Manager
B. MDX Script Editor
C. ESSCMD
D. Hyperion Visual Explorer
49. Where in an ASO database should data be loaded?
A. Generation 1
B. To either parent or child members
C. Level 0
D. Data cannot be loaded to ASO databases
50. What is the maximum number of axes supported by MDX in a result grid?
A. 24
B. 64
C. 99
D. No limit
51. What is the correct definition of a tip member with relation to MDX?
A. The top member of a dimension
B. Any Level 0 member in a dimension
C. Any virtual member in a dimension
D. A parent member of Level 0 child members
52. Which of the following statements is true regarding BSO and ASO databases?
A. Aggregate storage is a replacement for block storage
B. Both ASO and BSO database can have dense dimensions
C. ASO and BSO databases can run simultaneously on the same Essbase server
D. Essbase applications may contain both ASO and BSO databases
53. If you have a dense dimension named Measures and Year and a sparse dimension
named Market and Product and an attribute dimension named Market Size,
which dimensions comprise the index?
A. Measures and Year
B. Measures and Product
C. Market and Product
D. Market, Product and Market Size
54. While calculating the database, 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 creating and tracking data blocks during calculations
55. Which compression type would you use if you have a lot of repeating values and consecutive zero values in a dense dimension?
A. RLE
B. Bit Map
C. No Compression
56. The average Block density is between 10% and 90% and you have few repeating values or consecutive repeating values, which compression type is recommended?
A. RLE
B. Bit Map
C. No Compression
57. What happens upon execution of Maxl command
alter application Sample disable commands; ?
A. All logins to the server are disabled
B. Logins to a specific database are disabled
C. Prevents all users from making requests to the application
D. Any user logged on to a specific database are logged out.
58. In the Essbase.cfg file a customer has set NETDELAY 1000, what does this setting
represent?
A. The number of times the network will retry for a connection before reporting errors.
B. The amount of times in seconds a Named Pipe network allows before making a connection.
C. This is the amount of time in milliseconds an unsuccessful operation waits before Analytic Services retries the operation.
D. This is the amount of time in seconds an unsuccessful operation waits before Analytic Services retries the operation.
59. When a change is made to a database cache setting, what action activates the
change? (Choose 3)
A. Restart the Essbase server
B. Restart the Essbase database
C. Restart the Essbase application
D. Restart the EAS server
E. Restart the license server
60. On a Unix server, what document contains the environment setting that need to be
configured during an Essbase install?
A. hyperionenv.txt
B. hyperionenv.doc
C. essbaseenv.doc
D. essbaseset.txt
61. What command do you execute when install Essbase 6.x on Unix?
A. ./setup.sh
B. ./setup.bin
C. ./essinst
D. ./setup.exe
E. ./essinst.exe
62. What command do you execute when installing Essbase 7.x on Sun Solaris?
A. ./setup.sh -console
B. ./setup.bin -console
C. ./essinst -console
D. ./setup.exe -console
E. ./essinst.exe -console
63. What command do you type to verify active Essbase processes on UNIX?
A. awk > grep ESS
B. ls –al | grep ESS
C. ls –ef | grep ESS
D. ps -ef | grep ESS
64. What command do you type to start the Essbase agent in background , on Unix, when you are telnet to the server?
A. nohup ESSBASE
B. essbase
C. ESSBASE
D. nohup ESSBASE
65. What is the recommended disk space for a database when you perform a dense
restructure?
A. No addition space is required
B. Four times the size of the database directory
C. Two times the size of the database directory
D. There is no such item as a dense restructure
66. How do I update my license key with Essbase 6.x?
A. Run the executable named REGISTER located in the bin directory.
B. Run the executable named LICENSE located in the bin directory.
C. Update the Essbase.cfg file in the bin directory with the new key.
67. How to I update my license file for Essbase 7.1.5?
A. Run the executable named REGISTER located in the bin directory.
B. Run the executable named LICENSE located in the bin directory.
C. Place the file ending in LIC in the License directory for the license server, do not run a RE-READ. Essbase server will not need to be restarted.
D. Place the file ending in LIC in the License directory for the license server, then RE-READ the license with the license server and restart Essbase.
68. What ports need to be opened if a client is outside a firewall?
A. Port 1425 and 37968 through 49725
B. Port 1423 and 32768 through 33768
C. Port 8080 and 1200 through 2600
69. To install Essbase as a Windows service, what command to you type at the command
prompt?
A. ESSBASE –install service
B. INSTALL –service ESSBASE
C. ESSBASE –service yes
D. ESSBASE –service install
ANSWERS:
--------
1: B, C, D
2: B, C
3: A, D
4: C
5: C
6: A, C
7: A,C
8: A, B,C
9: B
10. A, C, E
11. D, E
12. A, C, D
13. A. D, E
14. D
15. D
16. A, B, C, E
17. A, C, D, E
18. C, D
19. B, E
20. A, B, D
21. C, D, E
22. A, C, D, E
23. A, C, D, F
24. A, C, D
25. B, C, D, E
26. B, E
27. A, B, D
28, A, B,,C, D
29. B, C, D
30. B, C, D
31. D
32. C
33. A
34. C
35. A, C, D
36. B
37. A, C, E
38. A
39. A, B, D
40. B
41. A
42. B
43. B
44. A, D
45. D
46. C
47. D
48 B
49. C
50. B
51. A
52. C
53. C
54. D
55. A
56. B
57. C
58. C
59. A, B, C
60. B
61. C
62. B
63. D
64. A
65. C
66. A
67. D
68. B
69. D
No comments:
Post a Comment