Identify the four true statements about ASO “under the covers”.
A.
Table spaces 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
Explanation:
http://www.mi-oaug.org/Presentations09/Internal%20Workings%20of%20EssbaseASO%20&%20BSO%20Secrets%20Revealed%20MIOAUG.pdf
A, C ,F ,H
default—Contains database data structure and database values (After data is loaded, the
tablespace location cannot be changed.)
●log —Contains a binary transactional log of default tablespace updates
●metadata—Contains a binary transactional log of default tablespace updates
●temp—Provides a temporary workspace to be used during operations such as data loads,
aggregations, and retrievals
Tablespace Manager controls data retrieval and storage, using
tablespace definitions to manage data storage and work areas on the disk