SAP BODS - Home

SAP BODS Online Quiz

Following quiz provides Multiple Choice Questions (MCQs) related to SAP BODS. You will have to read all the given answers and click over the correct answer. If you are not sure about the answer then you can check the answer using Show Answer button. You can use Next Quiz button to check new set of questions in the quiz.

Q 1 - When we create an ETL job in Data service designer, what is the correct hierarchy for the below objects?

A - Project, Data Flow, Work flow, Replication job

B - Project, Work flow, Data Flow, Replication job

C - Replication job, project, data flow, work flow

D - Project, Replication job, Work flow, Data flow

Answer : D

Q 2 - Which of the following is responsible for holding user defined objects, metadata and transformation rules in Data services?

Answer : B

Explanation

Data Service repository stores all the user defined objects, meta data and transformation rules.

Q 3 - Which of the following tool of Data Services is used to manage user access and security feature?

Answer : A

Explanation

BODS depends on Central Management console (CMC) for user access and security feature. This is applicable to the 4.x version. In the previous version, it was done in Management Console.

Q 4 - To use ECC system as data source, what is the data store type?

A - SAP Applications

B - SAP BW Source

C - Oracle Applications

D - Web Service SOAP

Answer : A

Q 5 - SAP Business Objects Data Services provides an option to connect to the Mainframe interfaces?

A - Teradata

B - Informix

C - ODBC

D - Attunity connector

Answer : D

Explanation

SAP Business Objects Data Services provides an option to connect to the Mainframe interfaces using Attunity Connector. Using Attunity, connect the Datastore to the list of sources given below −

DB2 UDB for OS/390
DB2 UDB for OS/400
IMS/DB
VSAM
Adabas
Flat Files on OS/390 and OS/400

Q 6 - Which of the following is not a transformation type under data integration?

A - Data_Generator

B - Data_Transfer

C - Effective_Date

D - Hierarchy_flattening

E - Data Cleanse

Answer : E

Explanation

Data Integration transforms are used for data extraction, transform and load to DW system. It ensures data integrity and improves developer productivity.

Data_Generator
Data_Transfer
Effective_Date
Hierarchy_flattening
Table_Comparision, etc.

Data Cleanse- Data quality transformation.

Q 7 - Which of the following is a type of embedded data flow?

A - One Input

B - One Output

C - No input or output

D - All of the above

Answer : D

Explanation

The following types of embedded data flows can be used −

One Input Embedded data flow is added at the end of dataflow.

One Output Embedded data flow is added at the beginning of a data flow.

No input or output Replicate an existing data flow.

Q 8 - Which of the following parameter allows you to maintain the history of all the changes made to an object. You can check all the previous versions and revert to the older versions?