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 not a repository type in Data Services architecture?

Answer : C

Explanation

There are three type of repositories in Data Services −

Local
Central
Profiler

Q 3 - Which of the following repository is used to control version management of objects and is used for multiuser development?

Answer : B

Explanation

Central Repository − It is used to control the version management of the objects and is used for multiuse development. Central Repository stores all the versions of an application object. Hence, it allows you to move to previous versions.

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 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 - What is the use of adding conditionals to workflow?

Answer : A

Explanation

You can add Conditionals to workflow. This allows you to implement the If/Else/Then logic on the workflows.

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