important questions on bw.doc

7/27/2019 Important Questions on BW.doc

http://slidepdf.com/reader/full/important-questions-on-bwdoc 1/8

1. The BI technical contect is not available for SAP BW statistics. You

need to import this as an add-on.

This statement is correct -

1> True2> False

ANS: False

2. If you do not have transformations that run sequentially, you can

model the data flow without InfoSources.

This statement is correct -1> True

2> False

ANS : TRUE

3. Do not use routines for VirtualProviders because inversion is not

allowed for them, use formulas in this case.


1> True

2> False

ANS: FALSE

4. If you have already created transformation rules, the system deletes

them once you have created an expert routine.


1> True

2> False

ANS: TRUE



5. For DataStore objects it is possible to execute the currency

tanslation by using predefined translation tyes.


1> True2> False

ANS : FALSE

6. Which of these uses tRFC as transfer log -

1>DataStore object

2> DTP

3> PSA

4> IdocANS:3,4

7. If you have already created transformation rules, the system deletes

them once you have created an expert routine.


1> True

2> False

ANS: TRUE

8. what statement is true for delta queue?

A.Delta queue is not used in Data Mart scenario

B. Delta Queue is a Service API function, which is only used in SAP or

BI source systems.

C. Master Data is stored in Delta Queue.

D. if delta queue is deleted, only any existing delta data records are

deleted.

ANS :A and B

9. When line-item Dimensions are used without containing the line-item

characteristic in the aggregate, which aggregate should be built

a) Flat aggregate

b) Useless aggregate



c) Basis aggregate

d) Time-dependent aggregates

ANS: C

10. T/F - With early delta initialization you can already write the data tothe delta queue while initialization is requested in the source

system.This statement is correct -

1> True

2> False

ANS: True

11. T/F - Static historical data can be transferred using the full update

function prior to initialize for delta update. This statement is correct

-1> True

2> False

ANS: TRUE

12. T/F - The record can be add in DSO and Infocube if a data record in

delta upgrage provides the Additive image

ANS: TRUE

13. T/F - The record can be add in Infocube if a data record in delta

upgrage provides the After image

ANS : FALSE

14. T/F - The record can be overwrite in DSO if a data record in delta

upgrage provides the Delete image

ANS : TRUE

15. T/F - The record can be add in DSO and Infocube if a data record in

delta upgrage provides the Before and After image

ANS: TRUE

16. Generic datasource supports Delta according to

a. TimeStamp,

b. Calendar Day,



c. Numerical Pointer(Document Number, counter).

d.All of the above

ANS : All of the above

17. For a DSO with real-time data acquisition, the data is written to the

following table

a. Active

b. Activation Queue

c. Change Log

d. Write-optimized

ANS: A - Active Table. Uses Write-optimized DSO (no change log exists)

18. Only one Info Package can be created for a Data Source for real-timedata acquisition

a. True

b.False

ANS :TRUE

19. Only one DTP can be created for a Data Source for real-time data

acquisition

a. True

b. False

ANS : FALSE

20. The process of loading master, transaction and metadata is

referred to as:

a. Data Load

a. Info Package Schedule

b. Data Staging

c. Data Transfer

ANS : DATA STAGING

21. After you have installed BI Content as an add-on component, it is

available to you in the following versions:

a. D (Delivered)

b. M (Managed)

c. A (Active)



d. D (Detailed)

e. M (Modified)

ANS : a,c,e

22. You should use the tools for generic data extraction to create a

DataSource.

a. If the BI content includes the DataSource for your application

f. If the BI content provided is not Application Specific

g. If the BI content does not include the DataSource for your

application

h. Business content requires additional enhancement not available ingeneric data extraction method.

i. If you use your own programs to fill your tables.

ANS : c,d.e

23. When you extract transaction data with the LO method, the

following update method allows you to write delta records to the

update table, and is kept there until the data is read with an update

collection run and processed.

a. Direct Delta

j. Queued Delta

k. Unserialised Delta Update

l. Unserialised Queued update

m. Unserialised V3 update

ANS: E

24.When you extract transaction data with the LO method, the following

update method requires scheduling.

n. Direct Deltam

o. Queued Delta

p. Unserialised Delta Update

q. Unserialised Queued update

r. Unserialised V3 update

ANS: b,e



2. What does the number in the 'Total' column in Transaction RSA7 mean?

b. No of Records

c. LUW’s in delta queued. Total of number of records transferred

e. None of the above

ANS: b

3. Indexing PSA helps is better Data Load TRUE or False

f. TRUE

g. FALSE

ANS: FALSE

4. Why is the delta queue not updated when you start the V3 update in

the logistics cockpit area

h. Delta initialization not successful

i. Only possible for Full load

j. Possible error in R/3

k. Setup table has to be deleted to reflect this.

Ans : a

5. When should you use the Generic Data Extractor tools to create a data

source?

l. When business content does not contain a data source for your

application

m. When you use customer written programs in R/3 to populate your

tables.

n. When data to be extracted is highly granular.

o. When the application does not feature its own generic data

extraction method.

p. If you want to use IDOCS instead of TRFCS.

ANS : a,b,d,e

6. Potential data sources for infoset queries include:



q. Database tables and Views

r. Logiccal databases.

s. Communication Structures

t. Table joins

u. Data Retrieval programs.Ans: a,b,d,e

7. What type of table does the PSA consist of?

v. Transparent table for sorting the detailed request in the format

of the transfer structure.

w. Relational

x. Binary

y. It depends on DBMS

z. None of the aboveANS: a

8. Which of the following is not true about PSA?

aa. it is created for each communication structure.

bb. Queries can be generated from the PSA.

cc. Transfer rules have been applied

dd. You can load from the PSA to an infocube.

ee. None of the above.

ANS: b,c

9. What is the recommended way to increase the speed of loading?

ff. Increase the size of number range buffer

gg. Delete secondary indexes.

hh. Laod Master data before transaction data.

ii. Create multiple jobs to run in parallel

jj. All of the above.

Ans: e.

important questions on bw.doc

Documents