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.

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 not a component of web application layer in Data service architecture?

A - Data Service Management Console

B - Designer

C - CMC

D - Information steward

E - Job Server

Answer : E

Q 3 - Which of the following component of Data services is used to execute real time and batch jobs?

A - Job Server

B - Access Server

C - Management Console

D - Repository

Answer : A

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 - In a Data flow to extract or load the data directly, which of the following method can be used for XML file?

A - Direct

B - Through Adapter

C - Both

D - None of these

Answer : A

Q 6 - Which of the following is not a transformation type under data integration?

A - Data_Generator

B - Data_Transfer

C - Effective_Date

D - Hierarchy_flattening

E - Data Cleanse

Answer : E

Explanation

Data Integration transforms are used for data extraction, transform and load to DW system. It ensures data integrity and improves developer productivity.

  • Data_Generator
  • Data_Transfer
  • Effective_Date
  • Hierarchy_flattening
  • Table_Comparision, etc.

Data Cleanse- Data quality transformation.

Q 7 - A data flow data flow which is called from another data flow in the design is known as?

A - Single Data flow

B - Multiple data flow

C - Embedded data flow

D - None of the above

Answer : C

Explanation

Embedded data flow is known as data flows, which are called from another data flow in the design. The embedded data flow can contain multiple number of source and targets but only one input or output pass data to main data flow.

Q 8 - To enable recovery in Data Services, when a job fails which of the following option can be used to enable this option?

A - Execution Options

B - Trace

C - Global Variable

D - Substitution parameter

Answer : A

Q 9 - Which of the following tool is used for scheduling and to view error logs for replication job?

A - Designer

B - Management Console

C - Repository Manager

D - Workbench

Answer : B

Explanation

Q 10 - Which of the following is default cache type to increase the performance of data transformation occur in memory?

A - In Memory

B - Pageable

C - I/O Disk

D - None of these

Answer : B

Explanation

Pageable cache is default cache type. It should be used when data flow processes large amount of data that doesnt fit into memory.

sap_bods_questions_answers.htm
Advertisements