1Z0-531 | The Leading Guide To 1Z0-531 practice test
Q1. 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
Answer: ABEFGH
Q2. 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.
Answer: BD
Q3. 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])
Answer: E
Q4. You should back up the following three for ASO.
A. Hyperion_Home common
B. Essbaseinstallfolderbin
C. ARBORPATH appappname
D. Essbaseinstallfolder locale
E. Essbase.sec
F. Essbase.cfg
Answer: CEF
Q5. 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
Answer: ADEF
Q6. Which four are the directories used for aggregate storage databases?
A. Default
B. Log
C. Metadata
D. Data
E. Bin
F. Temp
Answer: ABCF
Q7. Given the following information, how many potential blocks?
A. 100
B. 70
C. 560
D. 350
E. 400
F. 50
Answer: F
Q8. You have the following analysis requirement. Products roll up to Product Family which rolls up to Product Category. You also need to group Products by Product Manager. Product Managers may manage one or more Products across product families. You do not need to create reports with Product Manager by Product Family. You need to secure products by Product Manager for planning submissions.
You consider Shared members as a solution because of which two options?
A. Shared members provide cross tab reporting (Product Manager in the rows and Product Family across the column)
B. Shared members provide additional categorization but results in a smaller database then if you were to add Product Manager as a separate dimension
C. You can assign security to shared members
D. Shared members can be assigned to sparse members only
Answer: BC
Q9. In Essbase, security can be managed in_______.
A. Shared Services
B. Administration Services
C. Essbase Studio
D. Shared Services or Administration Services
E. All of the above
Answer: D
Q10. 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
Answer: D