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.

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 responsible for holding user defined objects, metadata and transformation rules in Data services?

Answer : B

Explanation

Data Service repository stores all the user defined objects, meta data and transformation rules.

Q 3 - Which of the following tool of Data Services is used to manage user access and security feature?

Answer : A

Explanation

BODS depends on Central Management console (CMC) for user access and security feature. This is applicable to the 4.x version. In the previous version, it was done in Management Console.

Q 4 - When you create a local repository in Data Services, which of the following can be used to configure the repository?

A - Repository Manager

B - CMC

C - Server Manager

D - Workbench

Answer : B

Explanation

Central Management Console (CMC) in SAP BI Platform is used for configuring a new repository.

Q 5 - Which of the following is not an available mode in file format editor?

E - Data Preview Mode

Answer : E

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 - Data Quality Transformations cannot be directly connected to the upstream transform, which contains nested tables. To connect these transform you should add a query transform or XML pipeline transform between transformation from nested table and data quality transform?

A - True

B - False

Answer : A

Q 8 - Data Services allow multiple user with local repositories to connect to the central repository at the same time and all the users can check out and make changes to a specific object?

A - True

B - False

Answer : B

Explanation

Data Services allow multiple user with local repositories to connect to the central repository at the same time but only one user can check out and make changes to a specific object.

Q 9 - As per recommendation for naming conventions, what should be prefix with data store?