Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home Oracle 1z0-531

Oracle 1z0-531 Exam Practice Questions (P. 3)

  • Full Access (69 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #11
During a multidimensional analysis getting data from a supplemental data source is an example of________.
  1. A
    Drill across
  2. B
    Drill Through
  3. C
    Trending
  4. D
    Pivoting

Correct Answer:
A

Question #12
Identify the two true statements about expense reporting tags.
  1. A
    Provide accurate time balance calculations
  2. B
    Provide accurate variance reporting on revenue and expense accounts
  3. C
    Are assigned to the dimension tagged Time
  4. D
    Are assigned to the dimension tagged Accounts
  5. E
    Are assigned to the Dimension containing variance members.

Correct Answer:
BD
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 #13
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 years of data. Archived data will be analyzed once in while.
What types of cube would you build using Essbase for this kind of requirement?
  1. A
    Block Storage
  2. B
    XOLAP
  3. C
    Aggregate Storage
  4. D
    Virtual Cube

Correct Answer:
C
Consider using the aggregate storage storage model if the following is true for your database:
*The database is sparse and has many dimensions, and/or the dimensions have many levels of members.
*The database is used primarily for read-only purposes, with few or no data updates. (C)
*The outline contains no formulas except in the dimension tagged as Accounts.
*Calculation of the database is frequent, is based mainly on summation of the data, and does not rely on calculation scripts.

Question #14
How are the ASO data files managed?
  1. A
    Page files
  2. B
    Index files
  3. C
    Table spaces
  4. D
    Bin files

Correct Answer:
C
With regard to ASO, table spaces are comparable to page and index files
For ASO - the data is stored in table spaces in a .dat file in the \App\Appname\default folder. Again the format is some type of binary and you cannot open the file and do anything with the contents.
Note:
For BSO - the data is stored in the page files (*.pag) in the \App\Appname\DBname folder. The format is proprietary or some kind of binary, point being you can't open a .pag file and do anything with it.

Question #15
Given the following information, how many potential blocks?

  1. A
    100
  2. B
    70
  3. C
    560
  4. D
    350
  5. E
    400
  6. F
    50

Correct Answer:
F
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
Incorrect answers:
We should not use the total numbers (10 x 7).

Previous Questions Next Questions

All Pages