Online Comptia Certification Exam Braindumps–Pass4side

Pass4side Hyperion Essbase 7.1.2 Cnsultant 1z0-255 demo free download

Exam Number: 1Z0-255 
Associated Certifications: Hyperion Essbase 7.1.2 Consultant Certified Expert 
Exam Price: $125 US
Exam Registration: Register
   
 
Duration: 180 minutes
Number of Questions: 129
Passing Score: 68%

Sample Questions - 1Z0-255 Hyperion Essbase 7.1.2 Consultant

Answers below

1. Given Uncommitted access, which settings would ensure rollback?
   1. Pre-image Access enabled
   2. Pre-image Access disabled
   3. Commit Block = 0; Commit Row = 0
   4. Commit Block = 10; Commit Row = 10
2. What are substitution variables in a calculation script used for?
   1. To decrease overall system maintenance
   2. To declare a temporary variable in a calculation script
   3. To prompt the user for a parameter in a calculation script
   4. To dynamically allocate the calculator cache during calculation script execution
3. Which statement is true about partitioned databases assuming default settings?
   1. Updating source data from the target of a transparent partition is possible
   2. Updating target data in the target of a replicated partition is never possible
   3. When data is replicated, the changes from the target will be copied to the source
   4. Data updated at the target of a replicated partition can be viewed from the source
4. The character X is used to assign the Dynamic Calc tag to members in a source file during a dimension build
   Which step accomplishes this? 
   1. Add X as a prefix to each member in the source file
   2. Add X as a suffix to each member in the source file
   3. Add a column to the left of member column and assign X as an attribute
   4. Add a column to the right of member column and assign X as an attribute
5. The ESS00001.IND is 70 MB and the ESS00001.PAG is 600 MB Given these choices
   what is the optimal Index Cache setting? 
   1. 50 MB
   2. 140 MB
   3. 500 MB
   4. 600 MB
6. What cannot be linked to a cell with Linked Reporting Objects (LRO)?
   1. A text note
   2. A sound file
   3. An Excel file
   4. A link to www.hyperion.com
   5. A link to another cell in the same database
7. Given the following settings, what is the optimal outline order?
   Dimensions D/S Actual/Stored Dimension Type
   Time Period Dense 17/12 Time
   Measures Dense 35/30 Accounts
   Years Dense 5/4 None
   Products Sparse 2000/1000 None
   Clients Sparse 600/600 None 
   1. Measures, Time Period, Years, Clients, Products
   2. Measures, Time Period, Years, Products, Clients
   3. Years, Time Period, Clients, Measures, Products
   4. Years, Time Period, Measures, Products, Clients
8. Which partition method could significantly increase disk usage?
   1. Linked
   2. Joined
   3. Shared
   4. Replicated
   5. Transparent
9. When would you select Shared Member functionality, as opposed to Attribute dimension functionality? (Choose Three)
   1. When creating crosstab reports
   2. When desiring precalculated a totals
   3. When associating with a Dense dimension
   4. When using alternate consolidation properties (=, -, ~, etc…) for members
   5. When increasing the amount of dimensionality without increasing the sparsity of the database.
10. How should you have Essbase assign a multiplication unary operator to members in a dimension build?
    1. Add “*“ as a prefix to each member in the source file
    2. Add “*“ as a suffix to each member in the source file
    3. Add a column to the left of member column and assign “*“ as a property
    4. Add a column to the right of member column and assign “*“ as a property
11. Which type of member is associated with the most efficient use of multiple IF commands in a calculation script?
    1. Dense
    2. Sparse
    3. Locked
    4. Unlocked
12. In the Member Selection Dialog available in the Essbase Spreadsheet add-in, what should you use to select members based on User Defined Attributes and Attribute dimensions?
    1. Find
    2. Subset
    3. Level Name
    4. Member Information
13. Given the fact that “Personal Electronics is a level 2 member, which MDX function returns level 0 descendants of the members “Personal Electronics” (in the Product dimension)?
    1. [Personal Electronics].Level(0)
    2. Descendants ([Personal Electronics], 2)
    3. Descendants ([Personal Electronics], LEAVES)
    4. CrossJoin (Descendants ([Personal Electronics], [Products].Levels(0))
14. Which two of the following statements is true regarding aggregate storage databases? (Choose two).
    1. You can change the location and size of all tablespaces.
    2. Incremental data loads are supporte
    3. It is recommended that you export all data during backup processes.
    4. Stored dimensions can have dynamic hierarchies.
    5. Dynamic hierarchies are required for the use of shared members
15. Which partitioning scenario is supported for an aggregate storage database?
    1. Block storage source replicated to an aggregate storage target.
    2. Aggregate storage source linked to an aggregate storage target.
    3. Aggregate storage source replication to a block storage target.
    4. Aggregate storage source transparent to a block storage target.
16. Which of the following statements is true regarding an aggregate storage database?
    1. Query tracking results replace existing view selections.
    2. Aggregation scripts can be stored in the database directory, as .CSC file.
    3. You can specify a specific hierarchy to be aggregate by tagging it as stored in the database outline.
    4. The aggregate storage cache determines the amount of memory available for storing Aggregated views.
17. Which of the following statements is true regarding conversion from block to aggregate storage?
    1. A database partition between the block and aggregate storage databases can be created during the conversion process.
    2. Member formulas are converted to MDX during the conversion process.
    3. Shared members are always removed during the conversion process.
    4. You can create of a new database containing the converted outline during the conversion process.

•  
  1. C
  2. A
  3. A
  4. D
  5. A
  6. E
  7. A
  8. D
  9. BCD
  10. D
  11. A
  12. B
  13. B
  14. BD
  15. D
  16. B
  17. D

  ANSWERS

Powered by MightyAdsense