Tuesday, November 12, 2013

Teste Yourself Quiz - DataStore Objects



Post your answers in comments

1.    ______ object is used to store transaction level (granular  level) data e.g. billing documents in Data Warehouse.
2.     Data targets are objects that physically _____ data.
3.    DSO is a data target. (T/F)
4.    DSO can be used as a staging layer to replicate transactional data from source system into DW. (T/F)
5.    Select types of DSO fields:
a.       Key Fields
b.      Data Fields
c.       Transactional Fields
6.    A DSO can detect the changes in records of DataSources that send data sets every time a change is made. (T/F)   
7.    Standard DSO consists of table(s):
a.       Activation Queue (New Data) Table
b.      Change Log Table
c.       Active Data Table
d.      Transparent Table
8.    Write-Optimized and Direct-Update DSOs consists of table:
a.       Transparent Table
b.      Change Log Table
c.       Active Data Table
9.    In-Memory DSO is also known as SAP HANA-Optimized DSO. (T/F)
10.The key fields (technical) of Activation Queue (New Data) table comprises of:
a.       Request SID
b.      Package ID
c.       Record Number
d.      PKID
e.      RDID
11.Active data table can be used for reporting. (T/F)
12.The key field (semantic) of Active Data table is chosen by system/developer?
13.When a data from standard DSO is updated to other data targets, the delta load is supplied from the ______ table.
14.The key field (technical) of Change Log table is comprises of:
a.       GUID
b.      Package ID
c.       Record Number
d.      PKID
15.SAP BW adds _____ InfoObject to the definition of standard DSO.
16.DSOs can be used for the following  scenarios in Data Warehousing:
a.       Data Staging
b.      Temporary Storage Area
c.       APD (Analysis Process Designer)
d.      Delta for changes in field value
e.      Transformation
17.Data from standard DSO can be loaded to another DSO or to an InfoCube. (T/F)
18.Data can be loaded to standard DSO using standard data staging process. (T/F)
19.Standard data staging process involves:
a.       Extraction
b.      Transformation
c.       Data Transfer processes
d.      APD (Analysis Process Designer)
e.      Direct Input Functions
20.Direct-Update DSO is used as a data target for the ____ processes.