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 - Which of the following component is responsible for extraction, transformation and load of data using Data Service designer?

Answer : B

Explanation

Data flows extract, transform, and load data. Everything having to do with data, including reading sources, transforming data, and loading targets, occurs inside a data flow.

Q 2 - Which of the following is not a component of web application layer in Data service architecture?

A - Data Service Management Console

B - Designer

C - CMC

D - Information steward

E - Job Server

Answer : E

Q 3 - Which of the following repository is used to control version management of objects and is used for multiuser development?

Answer : B

Explanation

Central Repository It is used to control the version management of the objects and is used for multiuse development. Central Repository stores all the versions of an application object. Hence, it allows you to move to previous versions.

Q 4 - Which of the following can be used to check the status or to configure RFC server interface in Data Services management console?

Answer : C

Explanation

SAP Connections is used to check the status or to configure RFC server interface in Data Services Management Console.

To check the status of RFC server interface, go to RFC Server Interface Status tab.

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 difference between TDP and data cleansing?

A - In TDP, Input is changed

B - In TDP, input size is more than 5KB

C - In TDP, input type is unstructured data

D - In TDP, create annotations in form of entities, types, etc.

Answer : A

Explanation

In TDP, Create annotations in form of entities, type, etc. and Input is not changed.

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?