Free Oracle 1Z0-531 Exam Dumps Questions & Answers

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

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

Which files will get restructured in a full BSO restructure?

• A.  Index file only
• B.  Data file only
• C.  No file
• D.  Data and index file

Market size is an attribute dimension with the following members: Large, Medium, and Small.
Which of the following options below represent valid syntax statements in a calc script?

• A.  FIX (@ATTRIBUTE(Large))
• B.  Calc Dim (Accounts, Markets, "Market Size");
• C.  FIX(Large)
• D.  Calc Dim (Accounts, Markets, Market Size);

Within which two directories can you set the location and file size in ASO?

• A.  Log
• B.  Default
• C.  Data
• D.  Bin
• E.  Metadata
• F.  Temp

Fragmentation has a number of potential causes. Identify two.

• A.  Deleting member from a dense dim
• B.  Submitting data/deleting data frequently (like in budget applications)
• C.  Renaming an alias
• D.  Renaming a member
• E.  Deleting member from a sparse dim