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 datastore type in SAP Data services?

A - Application datastore

B - Database datastore

C - Replication datastore

D - Adapter datastore

Answer : C

Explanation

Three types of datastore in Data Services −

Application
Database
Adapter

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 - Which of the following tool of Data Services is used to manage user access and security feature?

Answer : A

Explanation

BODS depends on Central Management console (CMC) for user access and security feature. This is applicable to the 4.x version. In the previous version, it was done in Management Console.

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

B - CMC

C - Server Manager

D - Workbench

Answer : B

Explanation

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

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 - Which of the following is a type of embedded data flow?

A - One Input

B - One Output

C - No input or output

D - All of the above

Answer : D

Explanation

The following types of embedded data flows can be used −

One Input − Embedded data flow is added at the end of dataflow.

One Output − Embedded data flow is added at the beginning of a data flow.

No input or output − Replicate an existing data flow.

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?