Oracle 1Z0-531 Online Practice Questions and Exam Preparation

Oracle 1Z0-531 Online Questions & Answers

• Question 51:

  Fragmentation has a number of potential causes. Identify two.

  A. Deleting member from a sparse dim
  B. Deleting member from a dense dim
  C. Renaming a member
  D. Renaming an alias
  E. Submitting data/deleting data frequently (like in budget applications)
  B. Deleting member from a dense dim
  E. Submitting data/deleting data frequently (like in budget applications)

  ---

  Fragmentation is unused disk space. Fragmentation is created when Essbase writes a data block to a new location on disk and leaves unused space in the former location of the data block. Block size increases because data from a data load or calculation is appended to the blocks; the blocks must therefore be written to the end of a data file."

  Fragmentation is likely to occur with the following:

  Read/write databases that users are constantly updating with data (E) Databases that execute calculations around the clock Databases that frequently update and recalculate dense members (B) Data loads that are poorly designed Databases that contain a significant number of Dynamic Calc and Store members Databases that use an isolation level of uncommitted access with commit block set to zero

  You can prevent and remove fragmentation: To prevent fragmentation, optimize data loads by sorting load records based upon sparse dimension members Perform an export of the database, delete all data in the database with CLEARDATA, and reload the export file Force a dense restructure of the database

  Reference Improving Essbase Performance, Eliminating Fragmentation

• Question 52:

  Which statement related to Essbase design is true?

  A. Calc scripts are more efficient at performing calculations vs. member unary operators and member formulas
  B. One big application is better than three smaller focused applications.
  C. Attribute dimensions require less performance consideration in ASO databases because they are treated as alternate rollups
  D. Attribute dimensions require less performance consideration in BSO databases because they are dynamically calculated
  E. Bigger block sizes are better than smaller block sizes
  D. Attribute dimensions require less performance consideration in BSO databases because they are dynamically calculated

• Question 53:

  Identify the three invalid methods to back up ASO database.

  A. MaxL alter database commands
  B. Esscmd BEGINARCHIVE / ENDARCHIVE
  C. Backup and Recovery features introduced In version 11
  D. Operating System backup
  A. MaxL alter database commands
  C. Backup and Recovery features introduced In version 11
  D. Operating System backup

  ---

  A: the MaxL statement alter database begin archive do not support aggregate storage databases.

  D: Operating System backup cannot backup the ASO database.

• Question 54:

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

  A. Tablespaces are utilized to store data and metadata
  B. Page files and index files are utilized to store data and metadata
  C. Default - stores numeric data (.dat file)
  D. Bin - store numeric data (.dat file)
  E. Data - store numeric data (.dat file)
  F. Metadata - stores metadata information about the objects in the database
  G. Metadata - stores numeric data (.dat file)
  H. Temp - temporary working space for the Essbase kernel
  A. Tablespaces are utilized to store data and metadata
  C. Default - stores numeric data (.dat file)
  F. Metadata - stores metadata information about the objects in the database
  H. Temp - temporary working space for the Essbase kernel

• Question 55:

  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 - Scenario dimension

  When we say "correct," we mean that both dynamic totals will calculate and display correctly.

  A. Accounts 0, Profit Per Unit 0, Scenario 0, Variance 1
  B. Accounts 0, Profit Per Unit 1, Scenario 0, Variance 0
  C. Accounts 2, Profit Per Unit 0, Scenario 0, Variance 1
  D. Accounts 2, Profit Per Unit 1, Scenario 1, Variance 2
  C. Accounts 2, Profit Per Unit 0, Scenario 0, Variance 1
  D. Accounts 2, Profit Per Unit 1, Scenario 1, Variance 2

• Question 56:

  Identify the four true statements about attribute dimensions

  A. Attributes allow cross tab reports with other dims
  B. Attributes are assigned to dense dimensions
  C. Attributes are stored
  D. Attributes are dynamically calculated
  E. Security can be assigned by attribute dimension
  F. Even though ASO databases allow many dimensions, attribute dimensions are still available and used in aggregate storage option databases
  A. Attributes allow cross tab reports with other dims
  D. Attributes are dynamically calculated
  E. Security can be assigned by attribute dimension
  F. Even though ASO databases allow many dimensions, attribute dimensions are still available and used in aggregate storage option databases

  ---

  An attribute dimension is a special type of dimension that is associated with a standard dimensions. Use attribute dimensions to report and aggregate data based on characteristics of standard dimensions.

  Essbase does not allocate storage for attribute dimension member (not C). Instead, it dynamically calculates the members when the user requests data associated with them (D). Attribute dimensions are always sparse dimensions(not B).

  And you can associate attribute dimensions only with sparse standard dimensions

  A, D, F:

  

• Question 57:

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

  A. Read Filter
  B. Write Filter
  C. Metaread Filter
  D. Metadata Filter
  E. Not possible to secure dimensions; only data can be secured
  C. Metaread Filter

  ---

  Metaread Essbase filters will filter both dimensions and data for end users. Meta Read Filters provide data and member level security.

• Question 58:

  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?

  A. Separate Employee status dimension
  B. Text List
  C. Smart List
  D. Attribute dimension
  E. Varying attribute dimension
  F. Alternate hierarchy
  G. User defined attribute
  D. Attribute dimension

  ---

  D: An attribute dimension is a special type of dimension that is associated with a standard dimensions. Use attribute dimensions to report and aggregate data based on characteristics of standard dimensions. In the Sample.Basic database, for example, the Product dimension is associated with the Ounces attribute dimension. Members of the Ounces attribute dimension categorize products based on their size in ounces. Essbase does not allocate storage for attribute dimension member. Instead, it dynamically calculates the members when the user requests data associated with them. Attribute dimensions are always sparse dimensions. And you can associate attribute dimensions only with sparse standard dimensions

• Question 59:

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

  A. SET MSG INFO;
  B. SET MSG SUMMARY;
  C. SET MSG DETAIL;
  D. SET MSG WARNING;
  C. SET MSG DETAIL;

  ---

  The command SET MSG sets the level of messaging you want returned about calculations, and enables simulated calculations.

  Syntax

  SET MSG SUMMARY | DETAIL | ERROR | WARNS | INFO | NONE | ONLY;

  SET MSG DETAIL provides the same information as SUMMARY. In addition, it displays a detailed information message every time Analytic Services calculates a data block.

• Question 60:

  You need to display a text value based on variance data in an ASO database. If the variance percentage is less than 10, users should see "Low Priority," if the variance percentage is between 11 and 25, users should see "Medium Priority," and if the variance percentage is greater than 25, users should see High Priority." The Essbase feature that supports this capability is:

  A. Text List
  B. Format string
  C. Text data type of a measure
  D. Trigger
  E. Not possible in an ASO database
  B. Format string

  ---

  Using format strings, you can format the values (cell contents) of Essbase database members in numeric type measures so that they appear, for query purposes, as text, dates, or other types of predefined values. The resultant display value is the cell's formatted value (FORMATTED_VALUE property in MDX).The underlying real value is numeric, and this value is unaffected by the associated formatted value. Format strings enable you to display more meaningful values in place of raw numeric values. For example, using a text based formatted value, you might display data cells as "High," "Medium," and "Low."

  To use a format string you just have enable types measures on your outline, then in the member properties for "Associate format string" use the syntax :-MdxFormat ( string_value_expression )A simple example isMdxFormat(IIF(CellValue() < 0,"Negative","Positive"))