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 repository is used to control version management of objects and is used for multiuser development?

A - Local

B - Central

C - Profiler

D - Shared

Answer : B

Explanation

Central Repository − It is used to control the version management of the objects and is used for multiuse development. Central Repository stores all the versions of an application object. Hence, it allows you to move to previous versions.

Q 4 - Which of the following is used to check access server status and real time services at web application layer?

A - Job Server

B - Access Server

C - Management Console

D - Repository

Answer : C

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 - 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 - 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 - As per recommendation for naming conventions, what should be prefix with data store?

A - N/A

B - DF_

C - _DS

D - WF_

Answer : A

Q 10 - Which of the following option allows you to perform optimization in Data Services?

A - Data Cleansing

B - Data Integration

C - Optimized SQL

D - Validate

Answer : C

sap_bods_questions_answers.htm
Advertisements