TABW10 Study guide

T ABW1 0

Study guide

Multiple Choice

The following questions have more than one answer.

1. Which of the following characterize Operational Environments (OL TP)?

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 10)

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 substitued 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

TABW]O System Configuration Jan 200] ]
.

Multiple Choice

The following questions have more than one answer.

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 transation 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

11. 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.

12. 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.

T ABW I 0 System Configuration lan 200 I 2
.

Multiple Choice

The following questions have more than one answer.

13. Which of the following are data transfer options for BW ?

a. SID

b. TRFC

c. IDOC

d. OL TP

e. OLAP

14. 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.

15.Which of the following are included in Business Content?

a. R/3 extractor programs.

b. ASAP excelerators.

c. InfoPackage groups.

d. Workbooks.

e. Queries.

16. 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.

17. 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.

18. What is the role of the app components section?

a. Organizes the InfoSource,

b. Organizes the Source System

c. Organizes the InfoCubes

d. Organizes the DataSources

T ABW I 0 System Configuration Jan 2001 3
.

Multiple Choice

The following questions have more than one answer.

19. What are the prerequisites for loading data?

a Active communication structure

b Active Transfer rules

c. Active infoCube

20. What methods can you use to update metadata?

a Replicate from a R/3 system to a BW

b Use an ABAP exit routine

c Correction and Transport to another BW

d Replicate from a BW system to a BW

21 Names types of Info Cube

a Aggregate

b Remote

c Basic

d Temp

e All of the above

22. Which attributes of the Keyfigure are true?

a. The keyfigure can retains the last value

b. The keyfigure can serve as an attribute of an characteristic

c. When the keyfigure is define as an amount, a unit of measure is associated

23. Copying update rules, which are true statements?

a. Update rules can be copied by creating new update rules, if there already

exits rules for the same infosource.

b. All parts of the update rule are copied if the infocubes are equal are equal to

each other.

~. If they are not equal, update rules are copied for the infoobjects that exit in

both infocube.
.

Multiple Choice

The following questions have only one answer:

1. A conceptual description of data objects, their attributes, and the relationship between

them is:

a. A data warehouse

b. A data model

c. An InfoCatalog

d. An Infoset

e. An Infosource

2. Which of the following are true statements?

a. Calculated fields are stored in the infocube.

b. Calculated fields are stored in the query.

c. Formulas are saved in both the query and the infocube.

d. Formulas are reusable.

e. Calculated fields are stoed in the PSA.

3. Which of the following is used to stage retrieved data temporarily in the Source

,system?

a. Update rules

b. Communication structure

c. Extract Structure

d. Transfer rules

e. Infosource

4. Which of the following is correct regarding granularity?

a. Highly granular data is highly summarized data.

b. Granularity has little impact on query performance.

c. Granularity has little impact on data load performance.

d. Granularity describes the detail of a database in a data warehouse.

e. Increasing granularity means decreasing information.

5. In which contains data that is based on the transfer structure and is not transformed by

transfer rules?

a. Operational data store.

b. Persistant Staging Area.

c. Communication structure.

d. Datasource

e. Infosource.

6. A parameterized extraction job with an infosource, source system and multiple section

criteria including variables is a:

a. infoobject

b. infocube

c. Infocatalog

d. infopackage

e. Infosource.

TABWIO System Configuration lan 2001 5
'"

7. Groupings of related characteristics in an infocube are:

a. fact tables

b. dimension tables

c. extract structures

d. SID tables

e. Infosource.

8. Which of the following statements is correct regarding SAP remote cubes?

a. Remote cubes are defined and based on the extract structures of the OL TP

system for transaction data.

b. Remote cubes are very beneficial for accessing large amounts of data on a

daily routine basis.

c. Remote cubes facilitate query reporting since large numbers of users may

execute queries from the same remote cube simutaneously with no impact

on performance.

d. Remote cubes copy the characteristics and key figures of the InfoSource.

e. Remote cubes support the inversion of customer exits (SAPI).

9. BWALEREMOTE is

a. An IDOC.

b. A dialog user.

c. A batch job on the OL TP system used to trigger updates.

d. An RFC user id.

e. A tRFC.

10. What are the types of attributes?

a. Navigational and text

b. Display and navigational

c. Display and calculated

d. Text and display

e. Calculated and navigational

11. Which of the following is a combination of the time dependent master data table and

the time independent master data table?

a. SID table

b. Dimension table

c. M view

d. Stable

e. X table

12. Fact tables may be partitioned by which of following?

a. OCALDAY

b. OCALMONTH

c. OCAL YEAR

d. OCALPERIOD.

e. OCALWEEK.

TABW]O System Configuration Jan 200] 6
.

13. 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.

14.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.

15.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.

16. Before I can load data using an InfoPackage, what are the prerequisites

a. Active communication structure

b. Active Transfer rules

C Active InfoCube

17. Which of the following is true about the communication structure?

a. Communication structure is created for an info Source and represent part of

an application

b Total number of Info Objects in the communication structure and extract

structure can be deferent

c The communication structure can reflects several Data Sources

d All above

18. What is true about the monitor query?

a It works only with TRFC transfer methods

b Tracks and display status of data loads

c Tries to indicate the error and suggest how to fix it

d Change the read mode for a query

TABWI0 System Configuration Jan 2001 7
--~-

.. , .

Multiple Choice

The following questions have only one answer:

19. What info package load options comes with the TRFC?

a. To PSA and Data Targets

b. To PSA then the Data Targets

c. To PSA only

d. To InfoCube

e. All of the above

20. In data modeling, where would you define the characteristic in order display historical

truth

a. The characteristic is an attribute and it must be time dependent

b. The characteristic values forms a hierarchy and it must be time dependent

c. The characteristic must be define in the Dim Table

21. To affect only one query, where should you use currency conversion?

a. In the update rules linking the infosource to the infocube

b. In the transfer rules of the infosource

c. In the query definition

22. Select the methods that 1?--.!lQ! used for meta data uploads

a. Replicate from a source sytsem

b. Use correction and transport from an Dev to Production BW

c. Schedule an infosource upload from a source system

23 Where would the character transformation rule needs to be define to be affective

across all inforsource.

a. Place the rule into each inforsource which will use the infobject

b. Place the rule in the update rules for each infocube using the infobject

c. Place the rule within the infoobject defination.

24 A important characteristic values changes frequently. What would be the best design?

a. Place the character in its own dimension table.

b. Define the character as an attribute of another character

c. Use the character's values to form an hierarchy

25. Which of the following statements about Aggregate are true?

a. Aggregate cube can be deactivated with loss of data in the aggregate

b. Aggregate cube are useful for key figures with aggregation Sum, Average,

Min or Max

c. When hierarchy associated with an aggregate cube changes, realignment of

aggregate cube is need in order to see the hierarchy.

TABWIO System Configuration Jan 2001 8

Multiple Choice

The following questions have only one answer:

26. Which is not a good method to reduce the size of an info cube

a Combine characteristic into as few dimension tables as possible

b Characteristic with many values are given their own dimension table

c Change the time granularity to the highest level consistence with the

reporting requirements.

27. Which statement is not true about the infosource?

a. An Infosource is set of logically associated data.

b. Inofosource describes all the data available for a business transaction or_type of

business.

c. The infosource consists of a communication structure, transfer structure and

transfer rules.

d. Infosource can encompass transaction data and master data.

28.. Creating update rules, can the following rules be applied?

a. Read the attributes from a master data table and put them into the cube.

b. Convert the keyfigures unit of measurement using an ABAP program

c. Return multi keyfigures for each keyfigure processed

d. All of the above rules can be applied.

29. Select the methods of meta data update.

a. Select the infosource's Source System and replicate

b. Replicate from the Source System's Data Source Overview

c. Update to a production BW using Correction and Transport request

d. Schedule an infosource upload from the R/3 system