The following questions have more than one answer.
1. Which of the following characterize Operational Environments (OLTP)?
a. Current data is essential
b. Detailed transaction data is
essential
c. Data is highly de-normalized
d. Users only require read access
to the data
e. Data is highly normalized
2. Which of the following are true regarding Info Objects?
a. Info Objects are a part of the
meta data repository
b. Info Objects are classified
into 2 groups: characteristics and data elements.
c. Info Objects contain technical
definitions as well as business logic
d. An InfoSource is a collection
of Info Objects
e. Info Objects are business evaluations
objects, such as customer, product, and revenue.
3. An Info Object definition includes which of the following?
a. Attributes
b. Hierarchies
c. Text information
d. Transaction codes
e. A scheduler
4. Which of the following are examples of key figures?
a. revenue
b. package number (request ID)
c. quantity
d. amount
e. calendar month
5. Which of the following actions can be done in the update rules?
a. Info objects can be updated 1:1
by a simple move.
b. Extract structures may be cleared.
c. Constants can be substituted
for the actual value from the infosource.
d. Datasouce creation.
e. Currency conversion for key
figures.
6. Datasourse replication can be performed according which of the following levels?
a. The hierarchies.
b. The datasource
c. The extract routines
d. The application component
e. The source system
7. Which of the following are correct regarding the Operation Data Store (ODS)?
a. Data from different data sources
can be merged in the ODS.
b. The ODS holds transaction data
only.
c. Reporting cannot be done from
the ODS
d. The ODS forms the in-bound layer
of the BW where data is written to directly from the source system.
e. Data in the ODS is compressed
and does not have a request id.
8. Dimension tables contain:
a. Pointers to a fact
b. Pointers to a text
c. SID’s
d. Display attributes
e. Update rules
9. Currency translations can be implemented in:
a. update rules
b. transfer rules
c. in the query definition
d. in the report result
e. all of the above
10. Where can data transformation can take place in BW?
a. Update rules
b. Transfer rules
c. Transfer routine
d. Extract routine
e. Extract structure
Answers:
1) a, b, e
2) a, c, d, e
3) a, b, c
4) a, c, d
5) a, c, e
6) b, d, e
7) a, b
8) a, c
9) e
10) a, b, c
