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 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 - In SAP Data services, file format is a type of datastore?

A - True

B - False

Answer : B

Explanation

File format defines the set of properties to define structure of a flat file.

Q 3 - When a variable is used multiple times within a job, it is always suggested to use local variable?

A - True

B - False

Answer : B

Explanation

When the variable will need to be used multiple times within a job, global variable is used.

Q 4 - Which of the following can be used to check the status or to configure RFC server interface in Data Services management console?

A - Web Services

B - Server Groups

C - SAP Connections

D - Management

Answer : C

Explanation

SAP Connections is used to check the status or to configure RFC server interface in Data Services Management Console.

To check the status of RFC server interface, go to RFC Server Interface Status tab.

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 - 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 transformation allows you to produce a new row in your target rather than updating an existing row?

A - Query Transformation

B - Merge transformation

C - Data Integration

D - History Preserving

E - Map Operation

Answer : D

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