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 is not a datastore type in SAP Data services?

A - Application datastore

B - Database datastore

C - Replication datastore

D - Adapter datastore

Answer : C

Explanation

Three types of datastore in Data Services −

Application
Database
Adapter

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 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 - Which of the following is used to create a local repository in Data services?

A - Data Services Server Manager

B - Data Services Workbench

C - Data Services Repository Manager

D - Data Services Locale selector

E - CMC

Answer : C

Explanation

Create a database Local_Repo and go to Data Services Repository Manager. Configure database as local repository.

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 transformation can be used for Column mapping from input to output schemas, assigning primary keys, etc.

A - Data Integration

B - Data Quality

C - Query Transformation

D - Merge Transformation

Answer : C

Explanation

Query transformation is most common transformation used in Data Services and you can perform the following functions −

Data filtering from sources
Joining data from multiple sources
Perform functions and transformations on data
Column mapping from input to output schemas
Assigning Primary keys
Add new columns, schemas and functions resulted to output schemas
As Query transformation is the most commonly used transformation, a shortcut is provided for this query in the tool palette.

Q 7 - A data flow data flow which is called from another data flow in the design is known as?

A - Single Data flow

B - Multiple data flow

C - Embedded data flow

D - None of the above

Answer : C

Explanation

Embedded data flow is known as data flows, which are called from another data flow in the design. The embedded data flow can contain multiple number of source and targets but only one input or output pass data to main 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?