SAP BODS Online Quiz


Advertisements

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.

Questions and Answers

Q 1 - Which of the following is used to setup a connection to database in Data Services?

A - Data Store

B - Owner

C - Template table

D - Query transformation

Answer : A

Explanation

In Data services, data store is used to set up a connection to source and target database.

Q 2 - Which of the following is used to contain object definition in Data services?

A - Reusable Objects

B - Repository

C - Object Library

D - Engine

Answer : C

Explanation

An object library is used to contain object definition and when an object is dragged and dropped from library, a new reference to an existing object is created.

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

A - CMC

B - Job Server

C - Adapter

D - CMS Repository

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 - Workflows can be created using the following methods −

Object Library

Tool Palette

A - True

B - False

Answer : A

Q 7 - Data Quality Transformations cannot be directly connected to the upstream transform, which contains nested tables. To connect these transform you should add a query transform or XML pipeline transform between transformation from nested table and data quality transform?

A - True

B - False

Answer : A

Q 8 - To enable recovery in Data Services, when a job fails which of the following option can be used to enable this option?

A - Execution Options

B - Trace

C - Global Variable

D - Substitution parameter

Answer : A

Q 9 - Which of the following returns multiple values based on single or multiple conditions?

A - Lookup()

B - Lookup_ext()

C - Lookup_seq()

D - None of these

Answer : B

Explanation

lookup() : It returns single value based on single condition.

lookup_ext(): It returns multiple values based on single or multiple condition(s)

Q 10 - Which of the following option allows you to perform optimization in Data Services?

A - Data Cleansing

B - Data Integration

C - Optimized SQL

D - Validate

Answer : C

sap_bods_questions_answers.htm

Useful Video Courses


Video

SAPUI5 Online Training

25 Lectures 6 hours

Sanjo Thomas

Video

SAP Webi Online Training

Most Popular

26 Lectures 2 hours

Neha Gupta

Video

SAP Basis Online Training

30 Lectures 2.5 hours

Sumit Agarwal

Video

SAP C4C Online Training

30 Lectures 4 hours

Sumit Agarwal

Video

SAP MM Online Training

14 Lectures 1.5 hours

Neha Malik

Video

SAP WM Online Training

13 Lectures 1.5 hours

Neha Malik

Advertisements