1Z0-531 Exam Questions

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

Identify the two true statements about expense reporting tags.

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

Your current block storage option design includes two dimensions: Markets and Regions. The Market dimension looks like: Users need to be able to report by both regions and markets....

Given the following, what is the block size In bytes?

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

Given the following, what is the declared block size?

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

Identify the four true statements about ASO "under the covers".

Fragmentation has a number of potential causes. Identify two.

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

Identify the four true statements about attribute dimensions

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

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

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

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

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

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

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

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

In Essbase, security can be managed in_______.

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

You have the following customer dimensions; You need to create a % of total (by region) calculation by customer in you aggregate storage database for Net_Revenue. Select the best s...

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

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

You should back up the following three for ASO.

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

Identify four disadvantages / considerations when using a transparent partition.

Assuming Sales and Year are sparse and Actual is dense, what two actions will the following calc script perform? FIX (Actual, @CY, Sales) DATAEXPORT "BINFILE" "data.txt"; ENDFIX

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

Market size is an attribute dimension with the following members: Large, Medium, and Small. Which of the following options below represent valid syntax statements in a calc script?

Moving a stored entity member in a sparse dimension causes_________.

Given the following information, how many potential blocks?

The data block density for a particular BSO database is between 10% and 90%, and data values within the block do not consecutively repeat. Which type of compression would be most a...

With an average block density greater than 90%.

You are performing incremental loads to an ASO database during the day, providing near real time data to the SaleDtl ASO database. Before the incremental load, you need to clear a...

Identify the two true statements about materialization in ASO.

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

The following two members would be optimally tagged Label Only.

Which four are the directories used for aggregate storage databases?

What is the default calculation order for ASO database?

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.

What does DTS (Dynamic Time Series) do?

Which two are Essbase components?

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

What are the three rules for Shared Members in ASO?

Changing a dense dimension member from stored to dynamic causes________.

Which three statements are true about multiple hierarchies in ASO?

Identify the five true statements.

In an aggregate storage database, which two are the correct member solve orders for Profit per Unit and Variance given the following: Profit per Unit - Accounts dimension Variance...