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

Answer : D

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 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 - 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 - SAP Business Objects Data Services provides an option to connect to the Mainframe interfaces?

A - Teradata

B - Informix

C - ODBC

D - Attunity connector

Answer : D

Explanation

SAP Business Objects Data Services provides an option to connect to the Mainframe interfaces using Attunity Connector. Using Attunity, connect the Datastore to the list of sources given below −

  • DB2 UDB for OS/390
  • DB2 UDB for OS/400
  • IMS/DB
  • VSAM
  • Adabas
  • Flat Files on OS/390 and OS/400

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 is used to migrate objects from one central repository to other central repository?

A - Central Repository

B - Local Repository

C - Embedded Data Flow

D - Data Profiling

Answer : B

Explanation

You cannot copy the content of one central repository to other central repository directly; you need to make use of local repository.

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 doesn’t fit into memory.

sap_bods_questions_answers.htm
Advertisements