Free Oracle 1Z0-531 Exam Dumps Questions & Answers

How are the ASO data files managed?

• A.Bin files
• B.Table spaces
• C.Index files
• D.Page files

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.[Budget] -[ Actual]
• D.[Actual] - [Budget]
• E.IIF (IsUda([Measures.currentmember], "Expense"), [Budget]-[Actual], [Actual]-[Budget])

In Essbase 11.1.1, what are two possible ways to calculate Period to Date values in ASO?

• A.Enable Dynamic Time Series
• B.Analytic dimension with member formulas to calculate period to date values
• C.Create a Date Time dimension
• D.Alternate hierarchy in Time dimension to rollup period to date values

Which two options would provide a better design for the following accounts and metrics?

• A.If reporting dictates FTE and dollars in the columns and accounts in the rows, split Accounts and Metrics into 2 dimensions
• B.If there are a small number of accounts that require FTE and Expense dollars, split Accounts and Metrics into 2 dimensions
• C.If block size is large, then keep Accounts and Metrics as one dimension with a dense dimension
• D.If there are a large number of accounts that require FTE and Expense dollars, split Accounts and Metrics into 2 dimensions

Given the following information, what is the block size?

• A.400 KB
• B.50 Bytes
• C.70 KB
• D.400 Bytes
• E.1056 KB
• F.1056 Bytes
• G.50 KB