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.

Questions and Answers

Q 1 - Which of the following is not a component in Data services?

A - Management console

B - Designer

C - Adapters

D - Job Servers

E - BI Launchpad

Answer : E


Data Services component include −

  • Job Server
  • Adapters
  • Real-time Services
  • Address Server
  • Management Console
  • Designer
  • Repository
  • Engines
  • Access Server

Q 2 - Which of the following is not a repository type in Data Services architecture?

A - Local

B - Central

C - Shared

D - Profiler

Answer : C


There are three type of repositories in Data Services −

  • Local
  • Central
  • Profiler

Q 3 - Which of the following is used to pass information to a data flow, work flow or to a replication job when called using a function?

A - Variable

B - Parameter

C - Both of these

D - None

Answer : B

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


Answer : C


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

Q 5 - In a Data flow to extract or load the data directly, which of the following method can be used for XML file?

A - Direct

B - Through Adapter

C - Both

D - None of these

Answer : A

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


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.

Answer : A


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

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 - As per recommendation for naming conventions, what should be prefix with data store?

A - N/A

B - DF_

C - _DS

D - WF_

Answer : A

Q 10 - Which of the following is default cache type to increase the performance of data transformation occur in memory?

A - In Memory

B - Pageable

C - I/O Disk

D - None of these

Answer : B


Pageable cache is default cache type. It should be used when data flow processes large amount of data that doesn’t fit into memory.