1) Which of the following statements are correct regarding InfoSources?
a. An InfoSource is a summarized
quantity of information that logically belongs together as a unit.
b. InfoSources are physically located
on the source system.
c. InfoSources can encompass both
transaction data and master data.
d. InfoSouces include extract structures.
e. Multiple souce systems can be
assigned to an InfoSource.
2) Which of the following are true regarding transfer rules?
a. Transfer rules are stored in
dimension tables.
b. Transfer rules facilitate the
loading of data into the SID tables.
c. After transfer rules are created,
they must be activated in order to take effect.
d. Transfer rules determine which
transfer structure fields should be transferred to which communication
structure fields.
e. Transfer rules are business
evaluations objects, such as customer, product, and revenue.
3) Which of the following are data transfer options for BW?
a. SID
b. TRFC
c. IDOC
d. OLTP
e. OLAP
4) Which of the following are correct regarding the ODS?
a. Data from multiple InfoSources
can be consolidated in the ODS object.
b. Reporting on ODS data must be
done with InfoSet queries.
c. One ODS object consists of 3
transparent tables.
d. Updating InfoCubes with data
from the ODS requires TRFC.
e. ODS data must be activated before
it can be available for reporting.
5) Which of the following are included in Business Content?
a. R/3 extractor programs.
b. ASAP excelerators.
c. InfoPackage groups.
d. Workbooks.
e. Queries.
6) Which of the following is true regarding BW Statistics?
a. The volume of data in the BW
statistics is dependent on the granularity of the incoming
data from the R/3 extractors.
b. BW Statistics reporting is done
through a MultCube approach.
c. BW Statistics is delivered in
Business Content.
d. Data loaded into BW statistics
must initially be stored in the PSA.
e. BW statistics InfoObjects do
not include key figures.
7) Which of the following are correct regarding the Data Changes Aggregate Update program?
a. The Data Changes Aggregate Update
program is a part of the DataSource replication process.
b. The Data Changes Aggregate Update
program recognizes changes in attribute / hierarchy data and the effect
these changes have on aggregates.
c. Navigation attribute data value
changes will not be seen until the Data Changes Aggregate Update program
is performed.
d. The Data Changes Aggregate Update
program performs a roll-up.
e. The Data Changes Aggregate Update
program must be executed on the source system prior to delta updates.
8) Pointer tables that provide the technical link to the master data outside of the info cube are:
a. Dimension tables.
b. Text tables.
c. M tables
d. SID tables
e. ODS transparent tables.
9) Which of the following is used to support the the analytical process by inventing artificial attributes that classify a characteristic?
a. Degenerate dimensions
b. E fact table
c. Categorical dimensions
d. SID tables
e. Navigational attributes.
10) Which of the following is true regarding multi-cubes?
a. Multicubes can incorporate ODS
transparent tables.
b. Each multicube has only one
consolidated fact table.
c. Multi cubes do not enhance query
performance.
d. Aggregates may be created on
multi cubes
e. Multi cubes do not contain any
data.
---
Answers
1) a, c, e
2) c, d
3) b, c
4) a, c, e
5) a, d, e
6) b, c
7) b, c
8) d
9) c
10) e
