Oracle 1Z0-531 Online Practice Questions and Exam Preparation

Oracle 1Z0-531 Online Questions & Answers

• Question 1:

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

  A. Essn.pag data
  B. Essn.ind index
  C. Essn.dat
  D. Temp.dat
  E. Dbname.esm - kernel file that contains control information for db recovery
  F. Dbname.tct - transaction control table
  G. Dbname.ind - free fragment file for data and index free fragments
  H. DBname.otl
  I. Metadata folder
  A. Essn.pag data
  B. Essn.ind index
  E. Dbname.esm - kernel file that contains control information for db recovery
  F. Dbname.tct - transaction control table
  G. Dbname.ind - free fragment file for data and index free fragments
  H. DBname.otl

  ---

  If there is a problem with any one of these essential database files, the entire database becomes corrupted and Essbase Server cannot start the database:

  *

  essn.pag (A)

  *

  essn.ind (B)

  *

  dbname.esm (E)

  *

  dbname.tct (F)

  *

  dbname.ind (G)

  *

  dbname.otl (for block storage databases) (H): Outline file, which stores all metadata for a database and defines how data is stored, but does not store data itself

  To restore the database, delete these file, restart the database, and reload from data files or from export files backed up before the corruption.

• Question 2:

  Changing a dense dimension member from stored to dynamic causes________.

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

  ---

  These types of restructure operations are listed from fastest to slowest:

  *

  Outline only (no index or data files)

  *

  Sparse (only index files)

  *

  Dense (index files and data files) as a result of adding, deleting, or moving members and other operations.

  *

  Dense (index and data files) as a result of changing a dense dimension to sparse or changing a sparse dimension to dense (A)

• Question 3:

  Given the following information, how many potential blocks?

  

  A. 100
  B. 70
  C. 560
  D. 350
  E. 400
  F. 50
  F. 50

  ---

  Potential number of blocks: Indicates the maximum possible number of blocks that can exist for the database. The number is derived by multiplying the number of stored members in each sparse dimension.

  In this scenario we get: 10 x 5 = 50

• Question 4:

  The following two members would be optimally tagged Label Only.

  A. "Profit"
  B. "Rations"
  C. "Scenario"
  D. "Q1"
  E. "January"
  B. "Rations"
  C. "Scenario"

  ---

  Label only is a tag that you can apply to a member to indicate that :

  *

  you don't want to store data.

  *

  the Members do not have data associated with them.

  Use Label Only for member like Scenarios, Ratios, or Drivers, members whose sole purpose in life is to organize the dimension and hierarchy.

  Note:

  Although a label only member has no data associated with it, it can display a value. The label only tag groups members and eases navigation and reporting. Typically, label only members are not calculated.

  For example, in the Measures dimension, the member Ratios has three children, Margin%, Profit%, and Profit per Ounce. The member Ratios defines a category of members. When consolidated, Margin%, Profit %, and Profit per Ounce do

  not roll up to a meaningful figure for Ratios. Hence, Ratios is tagged as label only.

• Question 5:

  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. Subtotals for Northeast and Southwest will display on some reports.

  A. Add another level to the market dimension for Northeast with North and East as children and Southwest with West and South as children
  B. Add an alternate hierarchy to the market dimension with the states as shared members, rolling up to Northeast and Southwest
  C. Create a UDA with members Northeast and Southwest (associated to states in the Market dimension)
  D. Create an attribute dimension with members Northeast and Southwest (associated to states in the Market dimension)
  E. Create a Text list with the values containing the members Northeast and Southwest.
  C. Create a UDA with members Northeast and Southwest (associated to states in the Market dimension)

  ---

  Essbase supports this concept called UDA's wherein one can assign the same attribute to multiple dimension members so that one can do cross dimensional attribute analysis. For example, if you take the default Sample-> Basic database you would notice that the Market Dimension members would have some UDA's assigned to it like Major Market, Small Market etc.

  

  Note: user-defined attributes (UDAs).

• Question 6:

  You should back up the following three for ASO.

  A. Hyperion_Home \common
  B. Essbaseinstallfolder\bin
  C. ARBORPATH \app\appname
  D. Essbaseinstallfolder \locale
  E. Essbase.sec
  F. Essbase.cfg
  C. ARBORPATH \app\appname
  E. Essbase.sec
  F. Essbase.cfg

  ---

  C: The application directory should be backup up. BAckups for ASO File system backups are the best method for aggregate storage databases. To backup an ASO database, 9.1. Stop the application. 9.2. Using the File system to back up the arborpath\app\appname

  E: essbase.sec* -- Essbase security file

  F: essbase.cfg -- Essbase Server configuration file

• Question 7:

  Block size is calculated by the following formula.

  A. Number of stored sparse dimension members multiplied together times 8 bytes
  B. Number of total sparse dimension members multiplied together times 8 bytes
  C. Number of stored dense dimension members multiplied together times 8 bytes
  D. Number of total dense dimension members multiplied together times 8 bytes
  C. Number of stored dense dimension members multiplied together times 8 bytes

  ---

  Data block size is determined by the amount of data in particular combination of dense dimensions. For ex: when you change the dense or sparse configuration of one or more dimensions in the database, the data block size changes. Data block size is 8n bytes, where n is the number of cells that exist (ie. Stored, not total) for that combination of dense dimensions.Note: Optimal range is 8 to 100 kb

  We need to multiple the stored (not the total) members of the dense dimensions with 8 to calculate the block size.

• Question 8:

  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.

  A. A separate MaxL script is required for each step
  B. The password must be hardcoded into the script when logging in.
  C. IFERROR can be used in MaxL to handle errors after each statement, when triggered will skip to a subsequent statement
  D. Variables for objects like server names, application names and database names can be used in a MaxL script to help with maintenance
  C. IFERROR can be used in MaxL to handle errors after each statement, when triggered will skip to a subsequent statement
  D. Variables for objects like server names, application names and database names can be used in a MaxL script to help with maintenance

  ---

  C: iferror instructs the MaxL Shell to respond to an error in the previous statement by skipping subsequent statements, up to a certain location in the script that is defined by a label name. Goto forces the MaxL Shell to branch to a certain location in the script defined by a label name; goto is not dependent on the occurence of an error. Syntaxiferror LABELNAMEgoto LABELNAMEdefine label LABELNAME

  D: In the MaxL Shell, you can use variables as placeholders for any data that is subject to change or that you refer to often; for example, the name of a computer, user names, and passwords. You can use variables in MaxL scripts as well as during interactive use of the shell. Using variables in MaxL scripts eliminates the need to create many customized scripts for each user, database, or host. Variables can be environment variables (for example, $ARBORPATH, which references the directory Essbase is installed to), positional parameters (for example, $1, $2, etc.), or locally defined shell variables. All variables must begin with a $ (dollar sign). Locally defined shell variables should be set without the dollar sign, but should be referenced with the dollar sign. Example: set A = val_1; echo $A; val_1

  Incorrect answer:

  A MaxL cannot contain several steps.

  Example:

  login $1 $2;

  import database sample.basic dimensions

  from data_file 'C:\\data\\dimensions.txt'

  using rules_file 'C:\\\\data\\rulesfile.rul'

  on error append to 'C:\\\\logs\\dimbuild.log';

  iferror 'dimbuildFailed';

  import database sample.basic data from data_file

  "$ARBORPATH\\app\\sample\\basic\\calcdat.txt"

  on error abort;

  define label 'dimbuildFailed';

  exit;

  B: It is recommend that you encrypt the MaxL scripts that includes user names and password, but it is not required.

  Note:

  MAXL is an script language that we could use to manipulate essbase, we could use it to

  *

  create or modify essbase applications or database or even outline

  *

  create or modify dimension (e.g. add new member to the dimension)

  *

  importing data into database

  *

  execute calculation scripts.

  *

  ...many more , actually most of the functionality that we use the graphic admin console to do could be done using maxl scripts.

  MAXL script is only simple text that we could edit or write using the simple notepad . although admin console do provide an more easy editor for editing MAXL scripts.

• Question 9:

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

  A. @Var(Actual, Budget);
  B. @Var([Actual],[Budget])
  C. [Actual] - [Budget]
  D. [Budget] -[ Actual]
  E. IIF (IsUda([Measures.currentmember], "Expense"), [Budget]-[Actual], [Actual]-[Budget])
  E. IIF (IsUda([Measures.currentmember], "Expense"), [Budget]-[Actual], [Actual]-[Budget])

  ---

  The following MDX formula is appropriate here:

  IIF ( IsUDA ([Measures].CurrentMember, "Expense"),([Budget] - [Actuals]),([Actuals] - [Budget]))

  Note #1: Member formula conversions for variance calculations can be accomplished with the help of User Defined Attributes (UDAs) that flag expense items. A combination of UDAs and conditional logic in ASO outlines provides the

  equivalent of the Expense Reporting functionality available in BSO outlines.

  Note #2: Note: The MultiDimensional eXpressions (MDX) language provides a specialized syntax for querying and manipulating the multidimensional data stored in OLAP cubes. While it is possible to translate some of these into traditional

  SQL, it would frequently require the synthesis of clumsy SQL expressions even for very simple MDX expressions. MDX has been embraced by a wide majority of OLAP vendors and has become the standard for OLAP systems.

• Question 10:

  Which three options will clear query tracking results in ASO?

  A. Materialize views
  B. Clear the data in the database
  C. Stop the application
  D. Turn off
  E. Change an outline
  A. Materialize views
  C. Stop the application
  D. Turn off

  ---

  Query tracking data is lost when you load additional cells, materialize any views, or shut down the application.