Essbase Certification

Pregunta 1 de 69

1

Which six files are involved in data base recovery for block storage option after a database crash?

Selecciona una o más de las siguientes respuestas posibles:

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

Explicación

Pregunta 2 de 69

1

Which two options would provide a better design for the following accounts and metrics?

Selecciona una o más de las siguientes respuestas posibles:

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

Explicación

Pregunta 3 de 69

1

Identify the two true statements about incremental loading.

Selecciona una o más de las siguientes respuestas posibles:

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

Explicación

Pregunta 4 de 69

1

You should back up the following three for ASO.

Selecciona una o más de las siguientes respuestas posibles:

Hyperion_Home \common
Essbaseinstallfolder\bin
Essbaseinstallfolder\app\appname
Essbaseinstallfolder \locale
Essbase.sec
Essbase.cfg

Explicación

Pregunta 5 de 69

1

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?

Selecciona una o más de las siguientes respuestas posibles:

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

Explicación

Pregunta 6 de 69

1

Identify four disadvantages / considerations when using a transparent partition.

Selecciona una o más de las siguientes respuestas posibles:

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

Explicación

Pregunta 7 de 69

1

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

Selecciona una o más de las siguientes respuestas posibles:

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

Explicación

Pregunta 8 de 69

1

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?

Selecciona una o más de las siguientes respuestas posibles:

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.

Explicación

Pregunta 9 de 69

1

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?

Selecciona una o más de las siguientes respuestas posibles:

FIX (@ATTRIBUTE(Large))
Calc Dim (Accounts, Markets, “Market Size”);
Calc Dim (Accounts, Markets, Market Size);
FIX(Large)

Explicación

Pregunta 10 de 69

1

Moving a stored entity member in a sparse dimension causes ________.

Selecciona una o más de las siguientes respuestas posibles:

a Full restructure
an Index restructure
an Outline restructure
No restructure

Explicación

Pregunta 11 de 69

1

During a multidimensional analysis, getting data from a supplemental data source is an example of____________.

Selecciona una o más de las siguientes respuestas posibles:

Drill across
Drill Through
Trending
Pivoting

Explicación

Pregunta 12 de 69

1

Identify the two true statements about expense reporting tags.

Selecciona una o más de las siguientes respuestas posibles:

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

Explicación

Pregunta 13 de 69

1

Block size is calculated by the following formula.

Selecciona una o más de las siguientes respuestas posibles:

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

Explicación

Pregunta 14 de 69

1

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

Selecciona una o más de las siguientes respuestas posibles:

400 KB
400 Bytes
1056 KB
50 Bytes
1056 Bytes
50 KB
70 KB

Explicación

Pregunta 15 de 69

1

Which three options will clear query tracking results in ASO?

Selecciona una o más de las siguientes respuestas posibles:

Materialize an aggregation
Clear the data in the database
Stop the application
Turn off
Change an outline

Explicación

Pregunta 16 de 69

1

Identify the four true statements about ASO “under the covers”

Selecciona una o más de las siguientes respuestas posibles:

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

Explicación

Pregunta 17 de 69

1

Fragmentation has a number of potential causes. Identify two.

Selecciona una o más de las siguientes respuestas posibles:

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)

Explicación

Pregunta 18 de 69

1

Within which two directories can you set the location and file size in ASO?

Selecciona una o más de las siguientes respuestas posibles:

Default
Metadata
Log
Temp
Bin
Data

Explicación

Pregunta 19 de 69

1

Which three statements are true about multiple hierarchies in ASO?

Selecciona una o más de las siguientes respuestas posibles:

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.

Explicación

Pregunta 20 de 69

1

Identify the five true statements.

Selecciona una o más de las siguientes respuestas posibles:

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

Explicación

Pregunta 21 de 69

1

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.

Selecciona una o más de las siguientes respuestas posibles:

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

Explicación

Pregunta 22 de 69

1

Identify the true statement about the data cache.

Selecciona una o más de las siguientes respuestas posibles:

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

Explicación

Pregunta 23 de 69

1

What is the extension for the file containing data for ASO applications?

Selecciona una o más de las siguientes respuestas posibles:

.pag
.dat
.txt
.aso
.fil

Explicación

Pregunta 24 de 69

1

In Smart View, when zooming in and out of dimensions in Essbase, if you need to go back to a previous step, you can:

Selecciona una o más de las siguientes respuestas posibles:

Undo one time
Flashback one time
Undo up to specified number of times
Use Microsoft Excel Undo

Explicación

Pregunta 25 de 69

1

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:

Selecciona una o más de las siguientes respuestas posibles:

Text List
Formatstring
Text data type of a measure
Trigger
Not possible in an ASO database

Explicación

Pregunta 26 de 69

1

Identify the three true statements about the Administration Services console.

Selecciona una o más de las siguientes respuestas posibles:

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

Explicación

Pregunta 27 de 69

1

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?

Selecciona una o más de las siguientes respuestas posibles:

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

Explicación

Pregunta 28 de 69

1

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

Selecciona una o más de las siguientes respuestas posibles:

Block size = 40 * 17 * 2
Block size = 40 * 17 * 2 * 8
Block size = 50 * 17 * 5
Block size = 50 * 17 * 5 * 8

Explicación

Pregunta 29 de 69

1

Which two statements are true (assuming data is loaded to a BSO database and to the members noted below)?

Selecciona una o más de las siguientes respuestas posibles:

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

Explicación

Pregunta 30 de 69

1

Which four are the directories used for aggregate storage databases?

Selecciona una o más de las siguientes respuestas posibles:

Default
Log
Metadata
Data
Bin
Temp

Explicación

Pregunta 31 de 69

1

What is the default calculation order for ASO database?

Selecciona una o más de las siguientes respuestas posibles:

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

Explicación

Pregunta 32 de 69

1

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.

Selecciona una o más de las siguientes respuestas posibles:

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

Explicación

Pregunta 33 de 69

1

What does DTS (Dynamic Time Series) do?

Selecciona una o más de las siguientes respuestas posibles:

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

Explicación

Pregunta 34 de 69

1

Which three are Essbase components?

Selecciona una o más de las siguientes respuestas posibles:

Essbase server
Administration services
C API
Web Analysis
Financial Reporting

Explicación

Pregunta 35 de 69

1

Which setting will give information about when a data block is calculated?

Selecciona una o más de las siguientes respuestas posibles:

SET MSG INFO;
SET MSG SUMMARY;
SET MSG DETAIL;
SET MSG WARNING;

Explicación

Pregunta 36 de 69

1

What are the three rules for Shared Members in ASO?

Selecciona una o más de las siguientes respuestas posibles:

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

Explicación

Pregunta 37 de 69

1

Changing a dense dimension member from stored to dynamic causes _______.

Selecciona una o más de las siguientes respuestas posibles:

a Full restructure
an Index restructure
an Outline restructure
No restructure

Explicación

Pregunta 38 de 69

1

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?

Selecciona una o más de las siguientes respuestas posibles:

Block Storage
XOLAP
Aggregate Join
Virtual Cube

Explicación

Pregunta 39 de 69

1

Where are the ASO data files managed?

Selecciona una o más de las siguientes respuestas posibles:

Page files
Index files
Tablespaces
Bin files

Explicación

Pregunta 40 de 69

1

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

Selecciona una o más de las siguientes respuestas posibles:

100
70
560
350
400
50

Explicación

Pregunta 41 de 69

1

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?

Selecciona una o más de las siguientes respuestas posibles:

Bitmap
RLE
ZLIB
No Compression Required

Explicación

Pregunta 42 de 69

1

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.

Selecciona una o más de las siguientes respuestas posibles:

@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]);

Explicación

Pregunta 43 de 69

1

With an average block density greater than 90%,

Selecciona una o más de las siguientes respuestas posibles:

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

Explicación

Pregunta 44 de 69

1

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?

Selecciona una o más de las siguientes respuestas posibles:

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

Explicación

Pregunta 45 de 69

1

Identify the two true statements about materialization in ASO.

Selecciona una o más de las siguientes respuestas posibles:

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

Explicación

Pregunta 46 de 69

1

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).

Selecciona una o más de las siguientes respuestas posibles:

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

Explicación

Pregunta 47 de 69

1

The following two members would be optimally tagged Label Only.

Selecciona una o más de las siguientes respuestas posibles:

"Profit"
"Ratios"
"Scenario"
"Q1"
"January"

Explicación

Pregunta 48 de 69

1

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.

Selecciona una o más de las siguientes respuestas posibles:

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.

Explicación

Pregunta 49 de 69

1

Which two valid field headers could be assigned to the 5th column in this data file? Duplicate
Member Names is not enabled.

Selecciona una o más de las siguientes respuestas posibles:

Alias
Attribute
Generation 4
UDA
Property

Explicación

Pregunta 50 de 69

1

Which files will get restructured in a full BSO restructure?

Selecciona una o más de las siguientes respuestas posibles:

Data file only
Index file only
Data and index file
No file

Explicación

Pregunta 51 de 69

1

What are five reasons to use Attributes over a Shared Members dimension?

Selecciona una o más de las siguientes respuestas posibles:

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

Explicación

Pregunta 52 de 69

1

What is the correct variance formula for an ASO database that recognizes Expense and
Non-expense accounts?

Selecciona una o más de las siguientes respuestas posibles:

@Var(Actual, Budget);
@Var([Actual], [Budget])
[Actual] - [Budget]
[Budget] - [Actual]
IIF (IsUda([Measures.currentmember], "Expense"), [Budget] - [Actual], [Actual] - [Budget])

Explicación

Pregunta 53 de 69

1

Given the following, what is the declared block size?
(Multiply dense stored members together and multiply by 8 bytes)

Selecciona una o más de las siguientes respuestas posibles:

1920 bytes
480 bytes
3840 bytes
12450 bytes

Explicación

Pregunta 54 de 69

1

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?

Selecciona una o más de las siguientes respuestas posibles:

DISPLAYMESSAGELEVEL
NETDELAY
NETRETRYCOUNT
MAX_REQUEST_GRID_SIZE
MAX_RESPONSE_GRID_SIZE

Explicación

Pregunta 55 de 69

1

Which statement related to Essbase design is true?

Selecciona una o más de las siguientes respuestas posibles:

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

Explicación

Pregunta 56 de 69

1

Which four of the following activities can be performed by the administrator in Shared
Services?

Selecciona una o más de las siguientes respuestas posibles:

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

Explicación

Pregunta 57 de 69

1

Identify the three invalid methods to back up ASO databases.

Selecciona una o más de las siguientes respuestas posibles:

MaxL alter database commands
Esscmd BEGINARCHIVE / ENDARCHIVE
Backup and Recovery features introduced in version 11
Operating System backup

Explicación

Pregunta 58 de 69

1

Identify the four true statements about attribute dimensions

Selecciona una o más de las siguientes respuestas posibles:

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

Explicación

Pregunta 59 de 69

1

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?

Selecciona una o más de las siguientes respuestas posibles:

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

Explicación

Pregunta 60 de 69

1

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?

Selecciona una o más de las siguientes respuestas posibles:

Separate Employee status dimension
Text List
Smart List
Attribute dimension
Varying attribute dimension
Alternate hierarchy
User defined attribute

Explicación

Pregunta 61 de 69

1

Identify the two true statements about compression for block storage databases.

Selecciona una o más de las siguientes respuestas posibles:

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.

Explicación

Pregunta 62 de 69

1

Identify the two true statements about block density for a Block Storage (BSO) database.

Selecciona una o más de las siguientes respuestas posibles:

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.

Explicación

Pregunta 63 de 69

1

The following objects are considered metadata elements in Essbase Studio except for which two?

Selecciona una o más de las siguientes respuestas posibles:

Dimensional element
Hierarchy
Cube Schema
Metaoutline
Essbase Model
Metamodel

Explicación

Pregunta 64 de 69

1

In Essbase 11.1.1, what are two possible ways to calculate Period to Date values in ASO?

Selecciona una o más de las siguientes respuestas posibles:

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

Explicación

Pregunta 65 de 69

1

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)?

Selecciona una o más de las siguientes respuestas posibles:

Sales person
Commission
New York
Sales
Year to Date

Explicación

Pregunta 66 de 69

1

What security filter will assign security to a hierarchy, filtering the members displayed to end users?

Selecciona una o más de las siguientes respuestas posibles:

Read Filter
Write Filter
Metaread Filter
Metadate Filter
Not possible to secure dimensions; Only data can be secured

Explicación

Pregunta 67 de 69

1

In Essbase, security can be managed in _______.

Selecciona una o más de las siguientes respuestas posibles:

Shared Services
Administration Services
Essbase Studio
Shared Services or Administration Services
All of the above

Explicación

Pregunta 68 de 69

1

Identify the two true statements about data loads to ASO and BSO databases.

Selecciona una o más de las siguientes respuestas posibles:

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.

Explicación

Pregunta 69 de 69

1

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.

Selecciona una o más de las siguientes respuestas posibles:

(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);

	Creado por Bob Costas hace más de 9 años

a

Essbase Certification

Pregunta 1 de 69

Which six files are involved in data base recovery for block storage option after a database crash?

Selecciona una o más de las siguientes respuestas posibles:

Explicación

Pregunta 2 de 69

Which two options would provide a better design for the following accounts and metrics?

Selecciona una o más de las siguientes respuestas posibles:

Explicación

Pregunta 3 de 69

Identify the two true statements about incremental loading.

Selecciona una o más de las siguientes respuestas posibles:

Explicación

Pregunta 4 de 69

You should back up the following three for ASO.

Selecciona una o más de las siguientes respuestas posibles:

Explicación

Pregunta 5 de 69

Selecciona una o más de las siguientes respuestas posibles:

Explicación

Pregunta 6 de 69

Identify four disadvantages / considerations when using a transparent partition.

Selecciona una o más de las siguientes respuestas posibles:

Explicación

Pregunta 7 de 69

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

Selecciona una o más de las siguientes respuestas posibles:

Explicación

Pregunta 8 de 69

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?

Selecciona una o más de las siguientes respuestas posibles:

Explicación

Pregunta 9 de 69

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?

Selecciona una o más de las siguientes respuestas posibles:

Explicación

Pregunta 10 de 69

Moving a stored entity member in a sparse dimension causes ________.

Selecciona una o más de las siguientes respuestas posibles:

Explicación

Pregunta 11 de 69

During a multidimensional analysis, getting data from a supplemental data source is an example of____________.

Selecciona una o más de las siguientes respuestas posibles:

Explicación

Pregunta 12 de 69

Identify the two true statements about expense reporting tags.

Selecciona una o más de las siguientes respuestas posibles:

Explicación

Pregunta 13 de 69

Block size is calculated by the following formula.

Selecciona una o más de las siguientes respuestas posibles:

Explicación

Pregunta 14 de 69

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

Selecciona una o más de las siguientes respuestas posibles:

Explicación

Pregunta 15 de 69

Which three options will clear query tracking results in ASO?

Selecciona una o más de las siguientes respuestas posibles:

Explicación

Pregunta 16 de 69

Identify the four true statements about ASO “under the covers”

Selecciona una o más de las siguientes respuestas posibles:

Explicación

Pregunta 17 de 69

Fragmentation has a number of potential causes. Identify two.

Selecciona una o más de las siguientes respuestas posibles:

Explicación

Pregunta 18 de 69

Within which two directories can you set the location and file size in ASO?

Selecciona una o más de las siguientes respuestas posibles:

Explicación

Pregunta 19 de 69

Which three statements are true about multiple hierarchies in ASO?

Selecciona una o más de las siguientes respuestas posibles:

Explicación

Pregunta 20 de 69

Identify the five true statements.

Selecciona una o más de las siguientes respuestas posibles:

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

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

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.