BW Mock Questions - Certification

1. Choose the statements relating to “BW Star Schema”
1. In the BW, the distinction is made between Info cube & Master Data/SID Table’s
2. Master Data tables are connected to an Infocube by way of DIM ID’s
3. Dimension Historization is made possible
4. D.    Supports Multi Lingual Capability
5. All of the Above

2. The following are the AWB functions within the BW system
1. Translation
2. Business Content
3. Documents
4. BEx Maps
5. All of the Above

3. Choose the relative answers applicable to “Info Objects”
1. Time Characteristics
2. Characteristic
3. Key Figures
4. Technical Characteristics
5. All of the above

4. Validate & Choose the correct statements reflecting “Attributes”
1. Attributes are Info objects, which can be formed by Characteristics or Key figures or Time Characteristics.
2. Attributes are Info objects, which can be formed by Characteristics or Key figures
3. Both Display & Navigation Attributes can be time-dependent
4. Transitive Attributes can be used in BEx Query directly after infoobject is activated
5. All of the above

5. Choose the correct answers to the Tables

              A.    Master Data view Table is M

2. Time Independent Characteristic Navigation table is “Y”
3. Hierarchy Interval table “K
4. Naming convention of Customer created tables start with “/BIC/…”
5. All of the above

6. The necessary objects for Data Flow in BW are
1. Source Systems
2. Extract Structure & Transfer Structure
3. Communication Structure & Update Rules
4. Necessary RFC connections with Plug in’s
5. All of the above

7. Choose the Update Methods for Characteristics

             A.    ABAP Routine

2. Initial Value
3. Master Data
4. Formula Builder
5. Constants

8. One of the steps in using ETL tools to load data into BW is “Create Infopackage with selection as 3^rd Party”.

           TRUE

FALSE

9. Using “Manage” functions on a Info cube, the following tasks can be performed.
1. Display all requests which are aggregated or scheduled to be aggregated as well set with deletion & compressed requests.
2. Can perform repair index
3. Can perform to empty the E table and fill F table with request ID set to Null
4. Can reconstruct the data even if the data is not available at PSA
5. All of the above

10. Choose the correct statements with respect to Aggregates
1. Switch Off Aggregate , the data is still filled however the OLAP reporting is not possible
2. Deactivate Aggregate delete the data & definition.
3. All Aggregate properties are stored under table RSDDAGGRDIR
4. Aggregates levels can be for “inclusive”, “exclusive”, “fixed” & “hierarchy”
5. All of the above.
11. Choose the relevant aspects relating to Delta Methods
1. Delta Methods are source system & extractors dependent
2. Delta Method components are Delta types, Record mode and Serialization
3. Delta Methods are primary key in the table RODELTAM
4. Delta Methods are Not included in the table ROOSOURCE
5. All of the above

12. Select the correct statements with respect to Flat file Staging scenarios
1. Flat File Staging Scenario requires “Set update method for each Data source”.
2. The supported delta loads are FIL0, ODS, & FIL1
3. No requirement on Data Source replication for all Flat file source system
4. Has the ability to check & simulate the Data transfer both at Communication Structure level as well at Data Target level
5. All of the above

13. Choose the correct answers referring to DB Connect
1. One of the prerequisite on DB Connect is to have both DBSL & DB Clients are to be installed in all BW Application servers
2. You can extract from all kind of data within the database using DB Connect
3. Only tables & views from the Database systems can be extracted
4. One of the steps is to Map Database types against BW DDIC types
5. All of the above

14. You are implementing Open Hub for your company. Validate the correct statements relating to the Infospoke
1. Info Spoke is an alternative solution to Data Mart
2. All Master data & Transaction data available for extraction using Info cube, ODS & Infoobjects
3. Output file types supported are flat csv file or transparent tabl
4.  It supports both Full & Delta
5. Delta determination is based on request ID

15. Validate & choose the relevant statements on Ascential DataStage
1. Ascentail Data Stage is SAP’s product
2. Used to interface with BW using BAPI technology
3. Requires BW Info source definition to be imported in the ETL tool
4. Need to schedule the Extractor job from ETL
5. Ascential data stage is SAP’s recognized 3^rd party product

16. All xml data are transferred using SOAP RFC services & subsequently pushed into the BW Delta Queue using BW defined function module for later update into the BW

True

False

17. Validate & choose the relevant info on Data Mart scenarios.
1. Data Mart is a solution designed primarily for data transfers among BW systems
2. The types of data marts are Aggregated, Mixed, Myself and Replicating
3. You do not require to generate export data source for Infocube
4. Data Mart naming convention starts with “8”
5. All of the above

18. Choose the correct steps on CO-PA extraction scenarios
1. You need to generate data source in the Source SAP system only once for both Accounting & Costing based CO-PA
2. The data extracted from CO-PA into BW differs by 30 minutes
3. Both Accounting based & Costing based CO-PA supports Full and Delta load in BW
4. When realignment/changes updated in R/3, you need realignment run or set the DIRTY_FLAG as option
5. All of the above

19. Choose the correct answers relating to LO Cockpit & LIS functions
1. The LIS extraction require 2 additional tables such as SxxxBIW1/SxxxBIW2 & 1 view such as SxxxBIWS to accommodate and supply the necessary data to BW
2. Queued Delta option used in LO cockpit update the data directly into BW Delta Queue
3. Delete & fill Set-up table is one of the critical & safety aspects during LIS to LO Cockpit conversion
4. Setup Periodic V3 updates is common step used in all LO cockpit/LIS & LIS to LO Conversion jobs
5. Activating extract structure in LO Cockpit can be done immediately after replicating the Datasource.

20. Choose the correct steps in LIS Extraction
1. Maintain extract structure, Generate data source, maintain info source, Assign Datasource with Info source, Maintain Communication Structure/Transfer rules, Maintain Infocube/ODS with update rules, Generate update for LIS Info source, Delta upload in LIS, Info package for delta initialization, Activate update, Info package for delta
2. Set up LIS environment, Generate data source, maintain info source, Assign Datasource with Info source, Maintain Communication Structure/Transfer rules, Maintain Infocube/ODS with update rules, Generate update for LIS Info source, Delta upload in LIS, Info package for delta initialization, Activate update, Info package for delta
3. Set up LIS environment, Generate data source, maintain info source, Assign Datasource with Info source, Maintain Communication Structure/Transfer rules, Maintain Infocube/ODS with update rules, Generate update for LIS Info source, Info package for delta initialization, Activate update, Info package for delta
4. Set up LIS environment, Generate data source, maintain info source, Assign Datasource with Info source, Maintain Communication Structure/Transfer rules, Maintain Infocube/ODS with update rules, Delta upload in LIS, Info package for delta initialization, Info package for delta
5. None of the Above

21. Choose the Correct Steps for LO Cockpit extraction
1. Maintain Extract Structure, Generate data source, maintain info source, Assign Datasource with Info source, Maintain Communication Structure/Transfer rules, Maintain Infocube/ODS with update rules, Generate update for LIS Info source, Delta upload in LIS, Info package for delta initialization, Activate update, Info package for delta
2. Maintain extract structure, Maintain data source, Replicate Datasource in BW, Assign Datasource to Info source, Maintain Communication Structure/transfer rules, Maintain IC/ODS with update rules, Activate extract structure, delete/set-up tables & set-up table extraction, Info package for delta initialization, Info package for delta
3. Maintain extract structure, Maintain data source, Replicate Datasource in BW, Assign Datasource to Info source, Maintain Communication Structure/transfer rules, Maintain IC/ODS with update rules, Activate extract structure, delete/set-up tables & set-up table extraction, Info package for delta initialization, set-up periodic V3/Queued/Direct updates, Info package for delta
4. Maintain extract structure, Maintain data source, Activate extract structure, Assign Datasource to Info source, Maintain Communication Structure/transfer rules, Maintain IC/ODS with update rules, delete/set-up tables & set-up table extraction, Info package for delta initialization, set-up periodic V3/Queued/Direct updates, Info package for delta
5. None of the above

22. Choose the correct statements relating to the relevant subject
1. You have 4 types of Data sources defined in the Source system
2. The Business Contents are delivered focusing both on Role based as well Industry based.
3. SAPI, BAPI, File & SOAP are some of the Interfaces among BW with SAP & Non SAP Systems
4. Service API controls the Data transfer settings, delta queue & monitoring the data load
5. All of the above

23. Using SAP or User Exit during data push or using append structure along with function module, the SAP Standard Business Content can be enhanced

True

False

24. Choose the correct answers relating Generic Data sources
1. Generic Data sources can be used for Master data such as Texts, Attributes, Hierarchies as well for Transaction data
2. The generic data sources can be generated against Transparent tables/views, SAP Query, Infoset Query, Function Modules
3. After Image, Additive & Before Images are supported record modes for Generic Data sources with delta capability
4. Time stamps, Calendar day & numerical pointer are the Delta determining parameters
5. Safety interval is permitted

25. Choose the Update Modes used against all data targets.
1. Repeat Delta
2. Queued Delta
3. Direct Delta
4. Full update
5. Delta Initialization

Area	Qn No	Answers
BW310	1	A B D
	2	A B C
	3	A B C D E
	4	B C
	5	A D
	6	A B C D E
	7	A B C E
	8	TRUE
	9	A B
	10	A C D
BW340	11	A B C
	12	A C D
	13	A C D
	14	B C D E
	15	B C D E
	16	TRUE
	17	A B D
BW350	18	B C D
	19	A C D
	20	E
	21	C
	22	A B C D E
	23	TRUE
	24	B D E
	25	A D E