Exam Code: 1Z0-531
Exam Name: Oracle Essbase 11 Essentials
During a multidimensional analysis getting data from a supplemental data source is an example of________.
A. Drill across
B. Drill Through
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.
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?
A. Block Storage
C. Aggregate Storage
D. Virtual Cube
How are the ASO data files managed?
A. Page files
B. Index files
C. Table spaces
D. Bin files
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.
Given the following, what is the block size In bytes?
A. Block size = 40 * 17 * 2
B. Block size = 40 *17 * 2 * 8
C. Block size = 50 * 17 * 5
D. Block size = 50* 17*5 * 8
What is the correct variance formula for an ASO database that recognizes Expense and Non-expense accounts?
A. @Var(Actual, Budget);
C. [Actual] – [Budget]
D. [Budget] -[ Actual]
E. IIF (IsUda([Measures.currentmember], “Expense”), [Budget]-[Actual], [Actual]-[Budget])
Given the following, what is the declared block size?
A. 1920 bytes
B. 480 bytes
C. 3840 bytes
D. 12450 bytes
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 to correct the issue?
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
Free Download PDF Dumps For Exam 1Z0-531 To Pass Exam Quickly