Hyperion Essbase 5 Certification (4H0-002) Practice Test Set 1

The stored members in the dense dimension Scenario are Actual and Budget. Database A has Actual and Budget data loaded for all products in all markets. Database B has only the Budget data loaded. Which statement is true about Database B?


Options are :

  • The index would be half as large as Database A.
  • Half the number of blocks exist as in Database A.
  • Block density is reduced by 50% from Database A.
  • Fifty percent fewer blocks would fit in the Data Cache as in Database A.

Answer : Block density is reduced by 50% from Database A.

4H0-533 Hyperion PlanningV.3.3.1 Certification Practice Test Set 5

Which statements are true about how IFERROR operates in ESSCMD?


Options are :

  • IFERROR may be used only once in a batch script
  • None of the Above
  • IFERROR may be used after every statement in a batch script.
  • If an executed command after the IFERROR statement fails, IFERROR skips to a predefined label where it resumes execution.

Answer : IFERROR may be used after every statement in a batch script.

Which level of access can limit a user to a subsection of a database?


Options are :

  • Calculate
  • Read
  • Database Designer
  • Filter
  • Read/Write

Answer : Filter

Which statements are true about substitution variables?


Options are :

  • They are not stored in the database page file.
  • None of the Above
  • They are stored in the database page file.
  • They can be set as global server settings.

Answer : They can be set as global server settings.

Hyperion Essbase 5 Certification (4H0-002) Practice Test Set 3

Which function generates a list of all members with a common User-Defined Attribute?


Options are :

  • @UDAMBR
  • @ISIUDA
  • @ISUDA
  • @UDA

Answer : @UDA

What would cause fragmentation in a database?


Options are :

  • redefining a Stored dense dimension member as Dynamic Calc (Non-Store)
  • deleting a sparse member from the outline
  • deleting a dense member from the outline
  • changing a member formula in the outline

Answer : deleting a sparse member from the outline

What would defragment defrag a fragmented database?


Options are :

  • redefining a Stored dense dimension member as Dynamic Calc and Store
  • changing a member formula in the outline
  • adding a sparse member to the outline
  • adding a dense member to the outline

Answer : adding a dense member to the outline

Hyperion Essbase 5 Certification (4H0-002) Practice Test Set 2

What is the minimum level of security that allows the administration of Linked Reporting Objects?


Options are :

  • Database Designer
  • Application Designer
  • Supervisor
  • Read/Write
  • Calculate

Answer : Database Designer

Which file descriptions are correct?


Options are :

  • basic.mdb is a partition definition file
  • ess00001.ind stores data blocks
  • ess00001.pag stores the database index
  • basic.otl contains the outline

Answer : basic.otl contains the outline

Which is a feature of Dynamic Time Series?


Options are :

  • It allows for Dynamic Time dimension builds.
  • It performs stored consolidations
  • It creates alternate Alias Table(s) based on Time dimension
  • It provides to-date functionality.

Answer : It provides to-date functionality.

4H0-712 Hyperion Ess Base 7x Certification Practice Exam Set 1

Which type of member can NOT have a User-Defined Attribute?


Options are :

  • Time
  • Shared
  • Account
  • Dynamic Calc

Answer : Shared

What is maximum size for each database page file?


Options are :

  • 256 GB
  • 3.99 GB
  • 2 GB
  • 64 GB

Answer : 2 GB

If you have a production database named Sales, which files should be backed up to perform a complete system backup?


Options are :

  • essbase.sec
  • ess00001.ind
  • sales.db
  • All of Above

Answer : All of Above

4H0-435 Hyperion Financial Management V3.51 Practice Exam Set 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?


Options are :

  • No Compression
  • RLE
  • None of the Above
  • Bit-Map

Answer : Bit-Map

What is the result of enabling the Aggregate Missing Values setting?


Options are :

  • It will permit a dataload to delete existing values.
  • It will not overwrite upper level data during calculation.
  • It will require data to be input at upper levels.
  • It will overwrite upper level data during calculation.

Answer : It will overwrite upper level data during calculation.

Within Database | Statistics, what does block density indicate?


Options are :

  • the maximum possible number of blocks that could exist for this database
  • the actual number of blocks existing within the database
  • the average percentage of data cells within each block that contain data
  • the percentage of blocks that exist compared to the total potential number of blocks

Answer : the average percentage of data cells within each block that contain data

Hyperion Essbase 5 Certification (4H0-002) Practice Test Set 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?


Options are :

  • both index and data files
  • None of the Above
  • index files only
  • data files only

Answer : index files only

If Committed Access is being used, which statements are true?


Options are :

  • It does not restrict Read/Write access on data blocks during the transaction
  • It retains redundant data until a transaction commits
  • It retains Write unlocks on all affected blocks until the transaction commits
  • It acquires and releases Write locks as needed during the transaction.

Answer : It retains redundant data until a transaction commits

Given the Filter in the exhibit, which statement is true?


Options are :

  • Read access is granted to the Scenario Budget only
  • Read access is granted to the Scenario Actual only
  • Write access is granted to the Scenario Actual and the market East
  • Write access is granted to the Scenario Budget and the market West
  • Read access is granted to the Scenario Budget and the market East

Answer : Read access is granted to the Scenario Budget and the market East

4H0-533 Hyperion PlanningV.3.3.1 Certification Practice Test Set 7

What does the setting NETDELAY 500 represent?


Options are :

  • the amount of time in milliseconds an unsuccessful operation waits before Essbase retries the operation
  • the amount of time in seconds allowed to a Named Pipes network to establish a connection to your server
  • the number of seconds an Agent thread waits for a resource to become available so it can perform a specific action
  • the number of times the network will retry a connection before failing and reporting an error

Answer : the amount of time in milliseconds an unsuccessful operation waits before Essbase retries the operation

When would disabling data compression be recommended?


Options are :

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

Answer : when the average block density is very high (>95%) and few consecutive repeating values exist.

What effects do tagging outline members as dynamic calc generally have?


Options are :

  • It decreases Batch calculation time.
  • It increases database restructure time.
  • It decreases client data retrieval times.
  • None of the Above

Answer : It decreases Batch calculation time.

4H0-533 Hyperion PlanningV.3.3.1 Certification Practice Test Set 4

During calculation, what is the calculator cache used for?


Options are :

  • for storing dynamically calculated values
  • for storing blocks
  • for tracking calculation progress through the blocks
  • for tracking index page usage

Answer : for tracking calculation progress through the blocks

The following Expense tag is used to identify outline members utilized in?


Options are :

  • Financial Consolidation
  • Currency Conversion
  • Variance Reporting
  • Profit & Loss Analysis

Answer : Variance Reporting

What optimizes a Dataload?


Options are :

  • Sort data file in order by dense dimensions.
  • Sort data file in order by sparse dimensions
  • Add to existing values.
  • Use commas for field delimiters.

Answer : Sort data file in order by sparse dimensions

4H0-712 Hyperion Ess Base 7x Certification Practice Exam Set 1

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


Options are :

  • basic Spreadsheet Add-In with template files and Extended Spreadsheet Macros
  • Essbase Objects application
  • Essbase Web Gateway deployed over their Intranet
  • Basic Spreadsheet Add-In with template files

Answer : Basic Spreadsheet Add-In with template files

An application on a test server is ready to be put into production. The production server already has three applications. What should you do to move the application from development to production?


Options are :

  • Export data from the development application
  • Copy the Essbase.sec file from development to production
  • Use the Application | Copy command
  • Copy the application directories from development to production

Answer : Export data from the development application

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

Dimension Name         Dense/Sparse          Number of Members         Number of Stored Members
Year                                 Dense                             20                                           12
Measures                        Dense                             16                                            8
Product                           Sparse                             22                                           19
Market                            Sparse                             25                                            25
Scenario                         Dense                              5                                              2


Options are :

  • 192 bytes
  • 1600 bytes
  • 12800 bytes
  • 1536 bytes

Answer : 1536 bytes

Hyperion Essbase 5 Certification (4H0-002) Practice Test Set 3

What occurs upon execution of DISABLELOGIN in ESSCMD?


Options are :

  • Logins to a specific database are disabled.
  • Logins to a specific application are disabled.
  • All server logins are disabled.
  • It logs out any users currently on a specific database

Answer : Logins to a specific application are disabled.

The Begin Archive and End Archive commands are used for which procedure?


Options are :

  • Shutting down Essbase and making a complete backup of the current database.
  • Backing up Essbase files after Essbase has been shut down
  • Exporting only a partial area of a database.
  • Backing up Essbase files while Essbase is still running.

Answer : Backing up Essbase files while Essbase is still running.

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions