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 used to setup a connection to database in Data Services?

A - Data Store

B - Owner

C - Template table

D - Query transformation

Answer : A

Explanation

In Data services, data store is used to set up a connection to source and target database.

Q 2 - Which of the following is not a repository type in Data Services architecture?

A - Local

B - Central

C - Shared

D - Profiler

Answer : C

Explanation

There are three type of repositories in Data Services −

  • Local
  • Central
  • Profiler

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 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 transformation is used to analyze and process large volume of text data, searching entities, assigning them to appropriate type and presenting metadata in standard format?

A - Text Data Processing

B - Entity Extraction

C - Data Cleansing

D - Query transformation

Answer : B

Explanation

In Data Services, text data processing is done with the help of Entity Extraction, which extracts entities and facts from unstructured data.

This involves analyzing and processing large volume of text data, searching entities, assigning them to appropriate type and presenting metadata in standard format.

Q 8 - Which of the following parameter allows you to maintain the history of all the changes made to an object. You can check all the previous versions and revert to the older versions?

A - Authentication

B - Authorization

C - Auditing

D - Recovery

Answer : C

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)

Answer : A

Explanation

Checkpoints are used to provide markers for data that has been processed in case error occurs during ETL process.


sap_bods_questions_answers.htm

Advertisements