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 - When we create an ETL job in Data service designer, what is the correct hierarchy for the below objects?

A - Project, Data Flow, Work flow, Replication job

B - Project, Work flow, Data Flow, Replication job

C - Replication job, project, data flow, work flow

D - Project, Replication job, Work flow, Data flow

Answer : D

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

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

A - True

B - False

Answer : B

Explanation

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 - Which of the following is not an available mode in file format editor?

E - Data Preview Mode

Answer : E

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