Oracle 1Z0-531 Online Practice Questions and Exam Preparation

Oracle 1Z0-531 Online Questions & Answers

• Question 21:

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

  A. Undo one time
  B. Flashback one time
  C. Undo up to specified number of times
  D. Use Microsoft Excel Undo
  A. Undo one time

• Question 22:

  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 describe when blocks will be created?

  A. Blocks will be created ONLY when the equation assigns non-constant values to members of a sparse dimension
  B. Blocks will be created ONLY when the equation assigns constant values to members of a sparse dimension
  C. Blocks will be created when the equation assigns either constant or non-constant values to members of a sparse dimension.
  D. No blocks will be created.
  C. Blocks will be created when the equation assigns either constant or non-constant values to members of a sparse dimension.

  ---

  C: Blocks are always (whether or not CREATEBLOCKONEQ is ON or OFF) created when a constant value is assigned to a member of a sparse dimension (for which a block does not exist). When SET CREATEBLOCKONEQ ON blocks will also be created when an non-constant value is assigned to a member of a sparse dimension (for which a block does not exist) in a new block.

  Note: If this would be a select two alternative question, the alternatives would have to be reworded slightly differently.

  Note #1:

  The SET CREATEBLOCKONEQ command controls, within a calculation script, whether or not new blocks are created when a calculation formula assigns anything other than a constant to a member of a sparse dimension. SET

  CREATEBLOCKONEQ overrides the Create Block on Equation setting for the database.

  Syntax: SET CREATEBLOCKONEQ ON|OFF;

  ON: When a calculation formula assigns a non-constant value to a member of a sparse dimension for which a block does not exist, Analytic Services creates a new block.

  Note #2: The Create Blocks on Equation setting is a database property. The initial value for the Create Blocks on Equation setting is OFF; no new blocks are created when something other than a constant is assigned to a sparse dimension

  member. You can use Administration Services or MaxL to set the Create Blocks on Equation setting to ON at the database-level. For more information about enabling the Create Blocks on Equation property for a database, see MaxL

  documentation in the Technical Reference or Administration Services online help.

  For more specific control, you can use the SET CREATEBLOCKONEQ calculation command within a calculation script to control creation of new blocks at the time the command is encountered in the script. Use of the SET

  CREATEBLOCKONEQ calculation command has the following characteristics:

  *

  When Analytic Services encounters a SET CREATEBLOCKONEQ command within a calculation script, Analytic Services ignores the database-level setting.

  *

  Where needed in the calculation script, you can use multiple SET CREATEBLOCKONEQ commands to define the Create Blocks on Equation setting value for the calculations that follow each command.

  *

  The value set by the SET CREATEBLOCKONEQ command stays in affect until the next SET CREATEBLOCKONEQ command is processed or the calculation script is finished.

• Question 23:

  Identify the three true statements about the Administration Services console.

  A. You can create custom views in EAS; Custom views help administrators focus on those apps, databases or servers that apply to them
  B. Administration Servers can be added to a custom view
  C. Applications and databases can be added to a custom view
  D. Calculation scripts can be added to a custom view
  E. Users and Groups can be added to a custom view
  A. You can create custom views in EAS; Custom views help administrators focus on those apps, databases or servers that apply to them
  C. Applications and databases can be added to a custom view
  D. Calculation scripts can be added to a custom view

  ---

  A: Enterprise View can contain multiple Essbase Servers, applications, and databases. You can create custom views of the Enterprise View tree in separate tabs in the navigation pane. Custom views can help reduce the number of mouse clicks it takes to navigate to an object in Enterprise View.

  You can add the following Essbase objects to a custom view: Essbase Servers, applications, databases (C), calculation scripts (D), report scripts, filters, and rules files. You cannot add Essbase users and groups, Essbase Administration Servers (not B), or Essbase Administration Server users (not E) to a custom view.

• Question 24:

  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 date will vary by store over time. Which three solutions would allow you to do this?

  A. Attribute dimension based on Store
  B. Varying attribute dimension with an Independent dimension of Time where Time contains both the Years and Months in the same dimension
  C. Varying attribute with 2 Independent dimensions, Periods and Fiscal Year
  D. Measure called Store Close Date with a data type of date
  E. User Defined attribute Store Close Date assigned to each store
  A. Attribute dimension based on Store
  C. Varying attribute with 2 Independent dimensions, Periods and Fiscal Year
  E. User Defined attribute Store Close Date assigned to each store

• Question 25:

  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. Export the data for actual, current year, sales into a text file called data.txt
  B. Export the data for actual, current year into a text file called data.txt
  C. Export data blocks in a compressed encrypted format
  D. Create a text file that can be imported using the DATAIMPORTBIN calc command in another database that has different dimensionality
  A. Export the data for actual, current year, sales into a text file called data.txt
  C. Export data blocks in a compressed encrypted format

  ---

  The FIX...ENDFIX command block restricts database calculations to a subset of the database. All commands nested between the FIX and ENDFIX statements are restricted to the specified database subset.

  Syntax:

  FIX (fixMbrs)COMMANDS ;ENDFIX

  fixMbrs: A member name or list of members from any number of database dimensions.

  DATAEXPORT writes data to a text file, binary file, or as direct input to a relational file using ODBC. The data blocks will be saved in a compressed encrypted format to a text file. For a binary output file:DATAEXPORT "Binfile" "fileName"

• Question 26:

  Identify the five true statements.

  A. CALC DIM is faster than AGG on Sparse dimensions
  B. AGG is faster than CALC DIM on Sparse dimensions
  C. CALC DIM calculates member formulas
  D. AGG calculates member formulas
  E. CALC DIM calculates Sparse dimensions
  F. AGG calculates Sparse dimensions
  G. CALC DIM calculates Dense dimensions
  H. AGG calculates Dense dimensions
  B. AGG is faster than CALC DIM on Sparse dimensions
  C. CALC DIM calculates member formulas
  E. CALC DIM calculates Sparse dimensions
  F. AGG calculates Sparse dimensions
  G. CALC DIM calculates Dense dimensions

  ---

  Differences bettewen CALC DIM and AGG.

  CALC DIM (Product);

  This line calculates the Product dimension doing both outline aggregation (such as rolling all the Colas up into the parent value) and member formulas (C), if they exist for members in that dimension. If we want to calculate multiple dimensions

  using this command (say, Market and Product), just separate them with commas:

  CALC DIM (Market, Product);

  Remember how we said that "CALC DIM" not only does

  aggregation but also member formulas? Well, how many member formulas are there in the Market and Product dimensions? That's right: none, so "CALC DIM" is wasting time looking for formulas that you know aren't there. For sparse

  dimensions that don't have formulas, there's a command that only does aggregation and as such, is usually faster:

  AGG (Market, Product) (B, F)

  Note: The CALC DIM command calculates the formulas and aggregations associated with each member of all the specified dimensions. This command calculates the formulas and aggregations associated with each member of all of the

  specified dimensions. The order in which dimensions are calculated depends on whether they are dense (G) or sparse (E). All of the dense dimensions are calculated first, in the order that the dense dimensions appear in dimList. The sparse

  dimensions are then calculated in a similar order.

• Question 27:

  Moving a stored entity member in a sparse dimension causes_________.

  A. a Full restructure
  B. an Index restructure
  C. an Outline restructure
  D. No restructure
  B. an Index restructure

  ---

  If a member of a sparse dimension is moved, deleted, or added, Essbase restructures the index and creates new index files. Restructuring the index is relatively fast; the time required depends on the index size.

• Question 28:

  Identify the two true statements about expense reporting tags.

  A. Provide accurate time balance calculations
  B. Provide accurate variance reporting on revenue and expense accounts
  C. Are assigned to the dimension tagged Time
  D. Are assigned to the dimension tagged Accounts
  E. Are assigned to the Dimension containing variance members.
  B. Provide accurate variance reporting on revenue and expense accounts
  D. Are assigned to the dimension tagged Accounts

  ---

  B: The variance reporting calculation requires that any item that represents an expense to the company must have an expense reporting tag.

  Essbase provides two variance reporting properties: expense and non-expense. The default is non- expense.

  Variance reporting properties define how Essbase calculates the difference between actual and budget data in members with the @VAR or @VARPER function in their member formulas.

  D: Expense reporting is tagged to the accounts dimension such that variance, profit etc. Member will not show the negative value when we calculate it. Note: The first, last, average, and expense tags are available exclusively for use with accounts dimension members.

• Question 29:

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

  A. Block density is the percentage of blocks that exist compared to the total number of blocks.
  B. Block density is the percentage of data that exists within a block compared to what can be stored in the total block.
  C. Ideally block density will be high.
  D. You can view the block density on the Application Properties tab in the Administration Services console.
  B. Block density is the percentage of data that exists within a block compared to what can be stored in the total block.
  D. You can view the block density on the Application Properties tab in the Administration Services console.

  ---

  B: The spread across the dense dimensions will determine the block density (basically, how full the block is).

  Incorrect answer:

  A: This is just false.

  Block density should not be high. An around 25% block density is fine, for example.

• Question 30:

  Which three statements are true about multiple hierarchies in ASO?

  A. First hierarchy must be stored.
  B. Multiple hierarchies must be enabled by dimension.
  C. First hierarchy must be dynamic.
  D. All alternate hierarchies must be dynamic.
  E. Alternate hierarchies may be either dynamic or stored.
  A. First hierarchy must be stored.
  B. Multiple hierarchies must be enabled by dimension.
  E. Alternate hierarchies may be either dynamic or stored.

  ---

  A: The member representing the first hierarchy (top level member of the hierarchy) in a dimension that has multiple hierarchies must be tagged as a stored hierarchy. Analytic Services requires such a hierarchy to be a stored hierarchy.

  B: To use multiple hierarchies in a dimension, you must enable multiple hierarchies for that dimension.

  E: Alternate hierarchies may be either dynamic or stored.