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 - Which of the following is not a component in Data services?

A - Management console

Answer : E

Explanation

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 responsible for holding user defined objects, metadata and transformation rules in Data services?

Answer : B

Explanation

Data Service repository stores all the user defined objects, meta data and transformation rules.

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 - To use ECC system as data source, what is the data store type?

A - SAP Applications

B - SAP BW Source

C - Oracle Applications

D - Web Service SOAP

Answer : A

Q 5 - Which of the following property of data flow can be used to improve the performance of operations such as joins, groups, sorts, filtering, lookups, and table comparisons?

A - Degree of parallelism

B - Use Database links

C - Cache Type

D - Execute only once

Answer : C

Explanation

You can cache data to improve performance of operations such as joins, groups, sorts, filtering, lookups, and table comparisons. You can select one of the following values for the Cache type option on your data flow Properties window −

In-memory − Choose this value if your data flow processes a small amount of data that can fit in the available memory.

Pageable − This value is the default.

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 - Data Services allow multiple user with local repositories to connect to the central repository at the same time and all the users can check out and make changes to a specific object?

A - True

B - False

Answer : B

Explanation

Data Services allow multiple user with local repositories to connect to the central repository at the same time but only one user can check out and make changes to a specific object.

Q 9 - As per recommendation for naming conventions, what should be prefix with data store?

Answer : A

Q 10 - Which of the following feature in ETL allows you to create multiple streams from a single stream?

A - Checkpoint

B - Conditional Split

C - Push and Pull

D - Data Profiler

Answer : B

sap_bods_questions_answers.htm