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

A - Work Flow

B - Data Flow

C - Replication job

D - Error Flow

Answer : B


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 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 - When a variable is used multiple times within a job, it is always suggested to use local variable?

A - True

B - False

Answer : B


When the variable will need to be used multiple times within a job, global variable is used.

Q 4 - Which of the following is used to check access server status and real time services at web application layer?

A - Job Server

B - Access Server

C - Management Console

D - Repository

Answer : C

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.

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


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 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

Answer : A


Checkpoints are used to provide markers for data that has been processed in case error occurs during ETL process.