4H0-100 Dumps
4H0-100 Braindumps 4H0-100 Real Questions 4H0-100 Practice Test
4H0-100 Actual Questions
killexams.com
Hyperion Seebase Bridge Certification
https://killexams.com/pass4sure/exam-detail/4H0-100
When should you use the CALCHASHTBL command?
To specify the size of the Calculator Cache
To optimize the calculation of a large, flat database outline
To optimize the calculation of the Sparse dimension formulas in a large database outline
To specify the maximum number of blocks that Essbase can lock concurrently when calculating a Sparse member formula
When should you select the Shared Member hierarchies functionality, as opposed
to the Attribute dimension functionality? (Choose three.)
When precalculating results
When creating crosstab reports
When associating with a Dense dimension
When utilizing alternate consolidation properties (=,-,~, etc...) for members
When increasing the amount of dimensionality without increasing the sparsity of the database
The Essbase.cfg setting DATAFILECACHESIZE can be used to-------------------
alter Data File Cache size for existing databases
optimize calculation performance on large, flat dimensions
manage Data File Cache sizes for specific applications and databases
define the initial Data File Cache size for all newly created databases
Given the following dense/sparse configuration:
Which calculation script minimizes the number of passes through the database?
Fix (Jan) Budget = Actual; Endfix;
Fix (Feb)
Budget = Actual*1.5; Endfix;
Budget (IF(@ISMBR (Jan))
Budget = Actual; ELSEIF (@ISMBR(Feb)
Budget = Actual * 1.5; ENDIF;)
DATACOPY Actual to Budget; Fix (Feb)
Budget = Actual* 1.5 Endfix;
What can be done to activate changes to cache settings? (Choose all that apply.)
Restart the Essbase Server
Restart the Essbase Application
Restart the Essbase Database
Which information is contained in the security file? (Choose three.)
Locked objects
Server IP address
User security and filter
Essbase license number
What optimizes a dataload? (Choose two.)
Adding to existing values
Using commas for field delimiters
Placing a Dense dimension across columns
Sorting data file in order by Dense dimensions
Sorting data file in order by Sparse dimensions
Which two statements about Committed access are true? (Choose two.)
It retains redundant data until a transaction commits.
It acquires and releases Write locks as needed during the transaction.
It retains Write locks on all affected blocks until the transaction commits.
It does not restrict Read/Write access on data blocks during the transaction.
Incremental restructuring is enabled. Product and Market are the only Sparse dimensions. If you reverse the order of these two Sparse dimensions, what is the incremental restructuring implication?
None
Restructure deferred
Overrides incremental restructuring and restructures data files only
Overrides incremental restructuring and restructures index files only
Overrides incremental restructuring and restructures both index and data files
If an Essbase database's isolation level is set to COMMITTED, which three statements are true? (Choose three.)
Roll back is possible.
Locks are held for the duration of the transaction.
Synchronization points for blocks or rows can be set.
Only one transaction at a time can update data blocks.
Defining a Location Alias---------------
defines a substitution variable reference
allows for the use of the @XREF function in a database
indicates where a database's page and index files are stored
allows the defining of multiple alias tables to facilitate internationalization