1Z0-531 | Download Oracle 1Z0-531 exam dumps
Q21. Which files will get restructured in a full BSO restructure?
A. Data file only
B. Index file only
C. Data and index file
D. No file
Answer: C
Q22. Moving a stored entity member in a sparse dimension causes_________.
A. a Full restructure
B. an Index restructure
C. an Outline restructure
D. No restructure
Answer: B
Q23. Given the following, what is the declared block size?
A. 1920 bytes
B. 480 bytes
C. 3840 bytes
D. 12450 bytes
Answer: C
Q24. Which two are Essbase components?
A. Essbase server
B. Administration services
C. C API
D. Web Analysis
E. Financial reporting
Answer: AB
Q25. You are performing incremental loads to an ASO database during the day, providing near real time data to the SaleDtl ASO database. Before the incremental load, you need to clear a specific set of data in the fastest amount of time possible.
What is the best solution?
A. Partial clears are supported for ASO
B. Perform a logical clear, using MDX to specify the region to be cleared
C. Perform a physical clear, using MDX to specify the region to be cleared
D. Run a calc script containing the CLEARDATA command and a set of FIX statements that isolate the desired data set
E. Run a calc script containing the CLEARBLOCK command and a set of FIX statements that isolate the desired data set
Answer: AB
Q26. 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
Answer: ACFH
Q27. Which four of the following activities can be performed by the administrator in Shared Services?
A. Creates users and groups
B. Accesses external users and groups for provisioning
C. Migrates applications using Life Cycle Management
D. Creates cube schemas from a relational database
E. Provisions Essbase roles for users and groups like Read, Write, and Filter
F. Creates Essbase filters
Answer: ABEF
Q28. What is the default calculation order for ASO database?
A. Accounts, Time, all remaining dimensions in ascending order of member count
B. Time, Accounts, all remaining dimensions in ascending order of member count
C. Accounts, Time, all remaining dimensions in descending order of member count
D. Time, Accounts, all remaining dimensions in descending order of member count
E. Dynamic hierarchies, Stored hierarchies
F. Stored hierarchies, Dynamic hierarchies
Answer: F
Q29. You need to display a text value based on variance data in an ASO database. If the variance percentage is less than 10, users should see "Low Priority," if the variance percentage is between 11 and 25, users should see "Medium Priority," and if the variance percentage is greater than 25, users should see High Priority." The Essbase feature that supports this capability is:
A. Text List
B. Format string
C. Text data type of a measure
D. Trigger
E. Not possible in an ASO database
Answer: B
Q30. Given the following information, what is the block size?
A. 400 KB
B. 400 Bytes
C. 1056 KB
D. 50 Bytes
E. 1056 Bytes
F. 50 KB
G. 70 KB
Answer: B