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

Answer : D

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 - When you create a local repository in Data Services, which of the following can be used to configure the repository?

A - Repository Manager


C - Server Manager

D - Workbench

Answer : B


Central Management Console (CMC) in SAP BI Platform is used for configuring a new repository.

Q 5 - Which of the following is used to provide connectivity to other systems such as or the JavaMessagingQueue?

A - Database datastore

B - Application datastore

C - Adapters datastore

D - All of the above

Answer : C

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.

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 - Which of the following recovery mechanism allows you to rerun the jobs without previous partial rerun?

A - Automatic Recovery

B - Manual Recovery

C - Both

D - None

Answer : B


Automatic Recovery − This allows you to run unsuccessful jobs in recovery mode.

Manually Recovery − This allows you to rerun the jobs without considering partial rerun previous time.

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 represents data access methods?

A - Push and Pull

B - Union

C - Push method

D - Parallel Load

Answer : A