SAP BODS Online Quiz


Advertisements


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

Explanation

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 used to contain object definition in Data services?

A - Reusable Objects

B - Repository

C - Object Library

D - Engine

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 - Which of the following is used to pass information to a data flow, work flow or to a replication job when called using a function?

A - Variable

B - Parameter

C - Both of these

D - None

Answer : B

Q 4 - Which of the following is used to create a local repository in Data services?

A - Data Services Server Manager

B - Data Services Workbench

C - Data Services Repository Manager

D - Data Services Locale selector

E - CMC

Answer : C

Explanation

Create a database Local_Repo and go to Data Services Repository Manager. Configure database as local 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 - What is the use of adding conditionals to workflow?

A - IF Then Else

B - IF Then

C - For Loop

D - All of the above

Answer : A

Explanation

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

Answer : A

Explanation

In TDP, Create annotations in form of entities, type, etc. and Input is not changed.

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

Explanation

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 - Which of the following returns multiple values based on single or multiple conditions?

A - Lookup()

B - Lookup_ext()

C - Lookup_seq()

D - None of these

Answer : B

Explanation

lookup() : It returns single value based on single condition.

lookup_ext(): It returns multiple values based on single or multiple condition(s)

Q 10 - Which of the following represents data access methods?

A - Push and Pull

B - Union

C - Push method

D - Parallel Load

Answer : A


sap_bods_questions_answers.htm

Advertisements