Essbase Certification

Bob Costas
Quiz by Bob Costas, updated more than 1 year ago
Bob Costas
Created by Bob Costas almost 5 years ago
791
0

Description

a
Tags

Resource summary

Question 1

Question
Which six files are involved in data base recovery for block storage option after a database crash?
Answer
  • Essn.pag - data
  • Essn.ind - index
  • Essn.dat
  • Temp.dat
  • Dbname.esm - kernel file that contains control information for db recovery
  • Dbname.tct - transaction control table
  • Dbname.ind - free fragment file for data and index free fragments
  • Dbname.otl
  • Metadata folder

Question 2

Question
Which two options would provide a better design for the following accounts and metrics?
Answer
  • If there are a small number of accounts that require FTE and Expense dollars, split Accounts and Metrics into 2 dimensions
  • If there are a large number of accounts that require FTE and Expense dollars, split Accounts and Metrics into 2 dimensions
  • If repointing dictates FTE and dollars in the columns and accounts in the rows, split Accounts and Metrics into 2 dimensions
  • If block size is large, then keep Accounts and Metrics as one dimension with a dense dimension setting

Question 3

Question
Identify the two true statements about incremental loading.
Answer
  • Allows for real time data access for end users
  • Creates “subcubes” along the main slice in the database
  • Materialization of slices is required to provide users the correct query results
  • Different materalized views may exist within a slice as compared to the main slice of the database

Question 4

Question
You should back up the following three for ASO.
Answer
  • Hyperion_Home \common
  • Essbaseinstallfolder\bin
  • Essbaseinstallfolder\app\appname
  • Essbaseinstallfolder \locale
  • Essbase.sec
  • Essbase.cfg

Question 5

Question
You have the following analysis requirement. Products roll up to Product Family which rolls up to Product Category. You also need to group Products by Product Manager. Product Managers may manage one or more Products across product families. You do not need to create reports with Product Manager by Product Family. You need to secure products by Product Manager for planning submissions. You consider Shared members as a solution because of which two options?
Answer
  • Shared members provide cross tab reporting (Product Manager in the rows and Product Family across the column)
  • Share members provide additional categorization but results in a smaller database then if you were to add Product Manager as a separate dimension
  • You can assign security to shared members
  • Share members can be assigned to spares members only

Question 6

Question
Identify four disadvantages / considerations when using a transparent partition.
Answer
  • Old data
  • Slow retrievals
  • Slow calculations if referencing dynamic calc members in the source
  • Outline sync complexities
  • Increased network load
  • Downtime required to sync data

Question 7

Question
Assuming Scenario and Year are sparse and Accounts is dense, what two actions will following calc script perform? FIX (Actual, &CY, Sales) DATAEXPORT”BINFILE” “data. txt”; ENDFIX
Answer
  • Export the data for actual, current year, sales into a text file called data.txt
  • Export the data for actual, current year into a taxt file called data.txt
  • Export data blocks in a compressed encrypted format
  • Create a text file that can be imported using the DATAIMPORTBIN calc command in another database that has different dimensionality

Question 8

Question
A calculation script is performed on a database for which Create Block on Equation is OFF. The command SET CREATEBLOCKONEQ ON is issued immediately before an equation in the script. Which statement accurately describes when blocks will be created?
Answer
  • Blocks will be created ONLY when the equation assigns non-constant values to members of a sparse dimension
  • Blocks will be created ONLY when the equation assigns constant values to members of a sparse dimension
  • Blocks will be created when the equation assigns either constant or non-constant values to members of a spare dimension.
  • No blocks will be created.

Question 9

Question
Market size is an attribute dimension with the following members: Large, Medium, Small. Which of the following option below represent valid syntax statements in a calc script?
Answer
  • FIX (@ATTRIBUTE(Large))
  • Calc Dim (Accounts, Markets, “Market Size”);
  • Calc Dim (Accounts, Markets, Market Size);
  • FIX(Large)

Question 10

Question
Moving a stored entity member in a sparse dimension causes ________.
Answer
  • a Full restructure
  • an Index restructure
  • an Outline restructure
  • No restructure

Question 11

Question
During a multidimensional analysis, getting data from a supplemental data source is an example of____________.
Answer
  • Drill across
  • Drill Through
  • Trending
  • Pivoting

Question 12

Question
Identify the two true statements about expense reporting tags.
Answer
  • Provide accurate time balance calculations
  • Provide accurate variance reporting on revenue and expense accounts
  • Are assigned to the dimension tagged Time
  • Are assigned to the dimension tagged Accounts
  • Are assigned to the dimension containing variance members

Question 13

Question
Block size is calculated by the following formula.
Answer
  • Number of stored sparse dimension members multiplied together times 8 bytes
  • Number of total sparse dimension members multiplied together times 8 bytes
  • Number of dense sparse dimension members multiplied together times 8 bytes
  • Number of total dense dimension members multiplied together times 8 bytes

Question 14

Question
Given the following information, what is the block size? Markets: Sparse, 10 stored members, 10 total members Product: Sparse, 5 stored members, 7 total members Accounts: Dense, 10 stored members, 11 total members Time: Dense, 5 stored members, 12 total members
Answer
  • 400 KB
  • 400 Bytes
  • 1056 KB
  • 50 Bytes
  • 1056 Bytes
  • 50 KB
  • 70 KB

Question 15

Question
Which three options will clear query tracking results in ASO?
Answer
  • Materialize an aggregation
  • Clear the data in the database
  • Stop the application
  • Turn off
  • Change an outline

Question 16

Question
Identify the four true statements about ASO “under the covers”
Answer
  • Tablespaces are utilized to store data and metadata
  • Page files and index files are utilized to store data store data and metadata
  • Default - stores numeric data (.dat file)
  • Bin - store numeric data (.dat file)
  • Data - store numeric data (.dat file)
  • Metadata - store numeric information about the objects in the database
  • Metadata - store numeric data (.dat file)
  • Temp - temporary working space for the Essbase kernel

Question 17

Question
Fragmentation has a number of potential causes. Identify two.
Answer
  • Deleting member from a sparse dim
  • Deleting member from a dense dim
  • Renaming a member
  • Renaming an alias
  • Submitting data/deleting data frequently (like in budget applications)

Question 18

Question
Within which two directories can you set the location and file size in ASO?
Answer
  • Default
  • Metadata
  • Log
  • Temp
  • Bin
  • Data

Question 19

Question
Which three statements are true about multiple hierarchies in ASO?
Answer
  • First hierarchy must be stored.
  • Multiple hierarchies must be enabled by dimension.
  • First hierarchy must be dynamic
  • All alternate hierarchies must be dynamic.
  • Alternate hierarchies may be either dynamic or stored.

Question 20

Question
Identify the five true statements.
Answer
  • CALC DIM is faster than AGG on Sparse dimensions
  • AGG is faster than CALC DIM on Sparse dimensions
  • CALC DIM calculates member formulas
  • AGG calculates member formulas
  • CALC DIM calculates Sparse dimensions
  • AGG calculates Sparse dimensions
  • CALC DIM calculates Dense dimensions
  • AGG calculates Dense dimensions

Question 21

Question
In an aggregate storage database, which two are the correct member solve orders for Profit per Unit and Variance given the following: Profit Unit - Accounts dimension Variance - Scenario dimension When we say “correct,” we mean that both dynamic totals will calculate and display correctly.
Answer
  • Accounts 0, Profit Per Unit 0, Scenario 0, Variance 1
  • Accounts 0, Profit Per Unit 1, Scenario 0, Variance 0
  • Accounts 2, Profit Per Unit 0, Scenario 0, Variance 1
  • Accounts 2, Profit Per Unit 1, Scenario 1, Variance 2

Question 22

Question
Identify the true statement about the data cache.
Answer
  • Data cache contains compressed data blocks
  • Data cache contains uncompressed data blocks
  • Data cache contains compressed index entries
  • Data cache contains uncompressed data index entries

Question 23

Question
What is the extension for the file containing data for ASO applications?
Answer
  • .pag
  • .dat
  • .txt
  • .aso
  • .fil

Question 24

Question
In Smart View, when zooming in and out of dimensions in Essbase, if you need to go back to a previous step, you can:
Answer
  • Undo one time
  • Flashback one time
  • Undo up to specified number of times
  • Use Microsoft Excel Undo

Question 25

Question
You need to display a text value based on variance data in an ASO database. If the variance percentage is less the 10, users should see “Low Priority,” if the variance percentage is between 11 and 25, users should see “Medium Priority,” and if variance percentage is greater than 25, users should see “High Priority.;” The Essbase feature that supports this capability is:
Answer
  • Text List
  • Formatstring
  • Text data type of a measure
  • Trigger
  • Not possible in an ASO database

Question 26

Question
Identify the three true statements about the Administration Services console.
Answer
  • You can create custom views in EAS; Custom views help administrators focus those apps, databases or servers that apply to them
  • Server can be added to a custom view
  • Applications and databases can be added to a custom view
  • Calc scripts can be added to a custom view
  • Rules files can be added to a custom view

Question 27

Question
You need to track and report the Store Close Date for all of the stores in your company in your block storage option database. Store close will vary by over time. Which three solutions would allow you to do this?
Answer
  • Attribute dimension based on Store
  • Varying attribute dimension with an Independent dimension of Time where Time contains both the Years and Months in the same dimension
  • Varying attribute with 2 Independent dimensions, Periods and Fiscal Year
  • Measure called Store Close Date with a data type of date
  • User Defined attribute Store Close Data assigned to each stone

Question 28

Question
Given the following, what is the block size in bytes? Measures (Dense): 40 stored members, 50 total members Time (Dense): 17 stored members, 17 total members Scenario ((Dense): 2 stored members, 5 total members Market (Sparse): 100 stored members, 100 total members Product (Sparse): 500 stored members, 550 total members
Answer
  • Block size = 40 * 17 * 2
  • Block size = 40 * 17 * 2 * 8
  • Block size = 50 * 17 * 5
  • Block size = 50 * 17 * 5 * 8

Question 29

Question
Which two statements are true (assuming data is loaded to a BSO database and to the members noted below)?
Answer
  • If you delete a sparse shared member, the outline file shrinks
  • If you delete a sparse shared member, the page file shrinks
  • If you delete a sparse shared member, the index file shrinks
  • If you delete a sparse shared member, the block density shrinks
  • If you delete a sparse shared member, the block size shrinks
  • If you delete a sparse shared member, the number of blocks shrinks

Question 30

Question
Which four are the directories used for aggregate storage databases?
Answer
  • Default
  • Log
  • Metadata
  • Data
  • Bin
  • Temp

Question 31

Question
What is the default calculation order for ASO database?
Answer
  • Accounts, Time, all remaining dimensions in ascending order of member count
  • Time, Accounts, all remaining dimensions in ascending order of member count
  • Accounts, Time, all remaining dimensions in descending order of member count
  • Time, Accounts, all remaining dimensions in descending order of member count
  • Dynamic hierarchies, Stored hierarchies
  • Stored hierarchies. Dynamic hierarchies

Question 32

Question
You are creating a MaxL script to log into the database, update a dimension, load data, and run a calculation. Identify the two true statements about creating this MaxL script.
Answer
  • A separate MaxL script is required for each step
  • The password must be hardcoded into the script when logging in
  • IFERROR can be used in MaxL to handle errors after each statement, when triggered will skip to a subsequent statement
  • Variables for objects like server names, application names and database names can be used in a MaxL script to help with maintenance

Question 33

Question
What does DTS (Dynamic Time Series) do?
Answer
  • Calculates to date values for Essbase block storage databases
  • Dynamically calculates the Time dimension
  • Enable Time Balance functionality for accounts
  • Calculates to date values for Essbase aggregate storage databases

Question 34

Question
Which three are Essbase components?
Answer
  • Essbase server
  • Administration services
  • C API
  • Web Analysis
  • Financial Reporting

Question 35

Question
Which setting will give information about when a data block is calculated?
Answer
  • SET MSG INFO;
  • SET MSG SUMMARY;
  • SET MSG DETAIL;
  • SET MSG WARNING;

Question 36

Question
What are the three rules for Shared Members in ASO?
Answer
  • A Multiple Hierarchy Enabled dimension can have shared members
  • When a hierarchy is tagged Multiple Hierarchies Enabled, it must be store
  • The alternate hierarchy has shared members that refer to nonshared members of previous hierarchies in the outline
  • The shared members roll up according to a different hierarchy from the nonshared members to which they refer

Question 37

Question
Changing a dense dimension member from stored to dynamic causes _______.
Answer
  • a Full restructure
  • an Index restructure
  • an Outline restructure
  • No restructure

Question 38

Question
You are building a sales analysis model. In this model there is no requirement for calculation. The user needs to aggregate data across all dimensions and wants to archive many year of data. Archived data will be analyzed once in while. What types of cube would you build using Essbase for this kind of requirement?
Answer
  • Block Storage
  • XOLAP
  • Aggregate Join
  • Virtual Cube

Question 39

Question
Where are the ASO data files managed?
Answer
  • Page files
  • Index files
  • Tablespaces
  • Bin files

Question 40

Question
Given the following information, how many potential blocks? Markets: Spare, 10 stored members, 10 total members Product: Sparse, 5 stored members, 7 total members Accounts: Dense, 10 stored members, 11 total members Time: Dense, 5 stored members, 12 total members
Answer
  • 100
  • 70
  • 560
  • 350
  • 400
  • 50

Question 41

Question
The data block density for a particular BSO database is between 10% and 90%, and data values within the clock do not consecutively repeat. Which type of compression would be most appropriate to use?
Answer
  • Bitmap
  • RLE
  • ZLIB
  • No Compression Required

Question 42

Question
You need to calculate average units sold by the customer dimension within an ASO database. The member formula should calculate correctly regardless of level within the customer dimension. Identify the correct syntax for the member formula.
Answer
  • @AVG (SKIPBOTH, "Units_Sold");
  • Avg(Customer.CurrentMember.Children, [Units_Sold])
  • Avg(Customer.Children, [Units_Sold])
  • Avg(Customer.CurrentMember.Children, [Units_Sold]);
  • Avg(Customer.Children, [Units_Sold]);

Question 43

Question
With an average block density greater than 90%,
Answer
  • You should reconsider the dense and sparse settings
  • You should consider no compression
  • You should set Commit blocks to 0
  • You should reconsider the outline order of dimensions

Question 44

Question
You are performing incremental loads to an ASO database during the day, providing near realtime data to the SaleDtl ASO database. Before the incremental load, you need to clear a specific set of data in the fastest amount of time possible. What is the best solution?
Answer
  • Partial clears are not supported for ASO
  • Perform a logical clear, using MDX to specify the region to be cleared
  • Perform a physical clear, using MDX to specify the region to be cleared
  • Run a calc script containing the CLEARDATA command and a set of FIX statements that isolate the desired data set
  • Run a calc script containing the CLEARBLOCK command and a set of FIX statements that isolate the desired data set

Question 45

Question
Identify the two true statements about materialization in ASO.
Answer
  • When performing an incremental data load, aggregate views are updated.
  • The database is not available during materialization
  • Materialization can be tuned via query hints and hard restrictions defined at the database level
  • Materialization scripts can be saved for future reuse

Question 46

Question
You need to tune a block storage option database for calculations on a 32bit Essbase server. Identify the two starting point tuning steps that you might take (assuming no direct I/O).
Answer
  • Set Index Cache the size of the index file
  • Set Data Cache to the size of .025 * data file
  • Set Data File Cache to the size of .025 * data file
  • Reset sparse and dense dimensions to achieve a block size greater than 100KB

Question 47

Question
The following two members would be optimally tagged Label Only.
Answer
  • "Profit"
  • "Ratios"
  • "Scenario"
  • "Q1"
  • "January"

Question 48

Question
Your current block storage option design includes two dimensions: Markets and Regions. The Market dimension looks like: Market East NY CN NJ North MN ND South TX LA West CA NM Region Northeast Southwest Users need to be able to report by both regions and markets. Subtotals for Northeast and Southwest will display on some reports.
Answer
  • Add another level to the market dimension for Northeast with North and East as children and Southwest with West and South as children.
  • Add an alternate hierarchy to the market dimension with the states as shared members, rolling up to Northeast and Southwest.
  • Create a UDA with members Northeast and Southwest (associated to states in the Market dimension)
  • Create an attribute dimension with members Northeast and Southwest (associated to states in the Market dimension)
  • Create a Text list with the values containing the members Northeast and Southwest.

Question 49

Question
Which two valid field headers could be assigned to the 5th column in this data file? Duplicate Member Names is not enabled.
Answer
  • Alias
  • Attribute
  • Generation 4
  • UDA
  • Property

Question 50

Question
Which files will get restructured in a full BSO restructure?
Answer
  • Data file only
  • Index file only
  • Data and index file
  • No file

Question 51

Question
What are five reasons to use Attributes over a Shared Members dimension?
Answer
  • To create crosstab reports
  • To describe a dense dimension
  • To describe a sparse dimension
  • To perform comparisons based on certain type of data
  • To perform calculations based on characteristics
  • To add dimensionality to the database without increasing database size

Question 52

Question
What is the correct variance formula for an ASO database that recognizes Expense and Non-expense accounts?
Answer
  • @Var(Actual, Budget);
  • @Var([Actual], [Budget])
  • [Actual] - [Budget]
  • [Budget] - [Actual]
  • IIF (IsUda([Measures.currentmember], "Expense"), [Budget] - [Actual], [Actual] - [Budget])

Question 53

Question
Given the following, what is the declared block size? (Multiply dense stored members together and multiply by 8 bytes)
Answer
  • 1920 bytes
  • 480 bytes
  • 3840 bytes
  • 12450 bytes

Question 54

Question
You receive the following error: Error: 1042017: Network error: The client or server timed out waiting to receive data. Which two settings in the Essbase.CFG are most commonly used to correct the issue?
Answer
  • DISPLAYMESSAGELEVEL
  • NETDELAY
  • NETRETRYCOUNT
  • MAX_REQUEST_GRID_SIZE
  • MAX_RESPONSE_GRID_SIZE

Question 55

Question
Which statement related to Essbase design is true?
Answer
  • Calc scripts are nore efficient at performing calculations vs. member unary operators and member formulas
  • One big application is better than three smaller focused applications.
  • Attribute dimensions require less performance consideration in ASO databases because they are treated as alternate rollups
  • Attribute dimensions require less performance consideration in BSO databases because they are dynamically calculated
  • Bigger block sizes are better than smaller block sizes

Question 56

Question
Which four of the following activities can be performed by the administrator in Shared Services?
Answer
  • Creates users and groups
  • Accesses external users and groups for provisioning
  • Migrates applications using Life Cycle Management
  • Creates cube schemas from a relational database
  • Provisions Essbase roles for users and groups like Read, Write, and Filter
  • Creates Essbase filters

Question 57

Question
Identify the three invalid methods to back up ASO databases.
Answer
  • MaxL alter database commands
  • Esscmd BEGINARCHIVE / ENDARCHIVE
  • Backup and Recovery features introduced in version 11
  • Operating System backup

Question 58

Question
Identify the four true statements about attribute dimensions
Answer
  • Attributes allow cross tab reports with other dims
  • Attributes are assigned to dense dimensions
  • Attributes are stored
  • Attributes are dynamically calculated
  • Security can be assigned by attribute dimension
  • Even though ASO databases allow many dimensions, attribute dimensions are still available and used in aggregate storage option databases

Question 59

Question
You notice that your reports are running slower than before and realized that nothing in terms of data volume or dimension members has changed. You also checked the log file and found that no one ran any calculation. Which two would you look for to diagnose the cause of this slower response time?
Answer
  • Run a MaxL comment to see if the database is fragmented
  • Check when was the last time the application was stopped
  • Check the data cache setting
  • Check the commit-level setting

Question 60

Question
You have a reporting requirement to track and report the employee status for employees in your workforce ASO Essbase database. Employee status can change over time. One report requires employees down the rows and employee status across the columns. What is the best solution to meet the all of the requirements?
Answer
  • Separate Employee status dimension
  • Text List
  • Smart List
  • Attribute dimension
  • Varying attribute dimension
  • Alternate hierarchy
  • User defined attribute

Question 61

Question
Identify the two true statements about compression for block storage databases.
Answer
  • Index value pair compression works well for consecutive zero values or repeating values within a database.
  • RLE compression works well for consecutive zero values or repeating values within a database.
  • Bitmap compression is the default compression method.
  • The Accounts dimension is tagged the compression dimension by default.
  • Do not set compression for a dimension that has many members.

Question 62

Question
Identify the two true statements about block density for a Block Storage (BSO) database.
Answer
  • Block density is the percentage of blocks that exist compared to the total number of blocks.
  • Block density is the percentage of data that exists within a block compared to what can be stored in the total block.
  • Ideally block density will be high
  • You can view the block density on the Application Properties tab in the Administration Services console.

Question 63

Question
The following objects are considered metadata elements in Essbase Studio except for which two?
Answer
  • Dimensional element
  • Hierarchy
  • Cube Schema
  • Metaoutline
  • Essbase Model
  • Metamodel

Question 64

Question
In Essbase 11.1.1, what are two possible ways to calculate Period to Date values in ASO?
Answer
  • Enable Dynamic Time Series
  • Analytic dimension with member formulas to calculate period to date values
  • Alternate hierarchy in Time dimension to rollup period to date values
  • Create a Date Time dimension

Question 65

Question
You are trying to create a multidimensional model for Essbase and learn that your user wants to track commission for his sales persons, in addition to tracking sale by regions. When designing a multidimensional model, which two elements will serve as facts (measures)?
Answer
  • Sales person
  • Commission
  • New York
  • Sales
  • Year to Date

Question 66

Question
What security filter will assign security to a hierarchy, filtering the members displayed to end users?
Answer
  • Read Filter
  • Write Filter
  • Metaread Filter
  • Metadate Filter
  • Not possible to secure dimensions; Only data can be secured

Question 67

Question
In Essbase, security can be managed in _______.
Answer
  • Shared Services
  • Administration Services
  • Essbase Studio
  • Shared Services or Administration Services
  • All of the above

Question 68

Question
Identify the two true statements about data loads to ASO and BSO databases.
Answer
  • Data can only be loaded to level 0 members in ASO databases where BSO allows data loads to upper level members.
  • Cells at all levels can be loaded (except Dynamic Calc members) for both ASO and BSO.
  • After an ASO data load, no further calculation is required.
  • Concurrent loads are supported for both ASO and BSO.

Question 69

Question
You have the following customer dimension: You need to create a % of Total (by region) calculation by customer in your aggregate storage database for Net_Revenue. Select the best syntax for the member formula so that the % Total calculation works at all levels of customer dimension.
Answer
  • (Net_Revenue]) / (Parent, [Net_Revenne])
  • (Customer.CurrentMember, [Net_Revenue]) / (Customer.CurrentMember.Parent, [Net_Revenue]);
  • (Customer.CurrentMember, [Net_Revenue]) / (Customer.CurrentMember.Parent, [Net_Revenue])
  • (Customer.CurrentMember, [Net_Revenue]) / (Customer, [Net_Revenue]);
  • (Customer.CurrentMember, [Net_Revenue]) / (Customer, [Net_Revenue], Products, YearTotal);
Show full summary Hide full summary

Similar

The main reason knowledge is produced is to solve problems.
Darrel Hong
LMC questions
sbadger
Skull Bones
Justin Jimmy
Ratio and Proportion
sk.ks205
Proyectos
Rocio Anderson
Haruki Murakami
Fernando Lopez O
Harrys Hannibal Quiz
hmasterson16
Foreign Exchange Market Graph
Teresa Nadal
Vertebral Column
Justin Jimmy
Naming Muscles
Justin Jimmy