- SAP BODS Tutorial
- SAP BODS - Home
- SAP BO Data Services
- SAP BODS - Overview
- SAP BODS - Architecture
- SAP BODS - Data Services Designer
- SAP BODS Repository
- SAP BODS - Repository Overview
- Repository Creating & Updating
- Data Services Management Console
- SAP BODS - DSMC Modules
- SAP BODS - DS Designer Introduction
- SAP BODS - ETL Flow in DS Designer
- SAP BODS Datastores & Formats
- SAP BODS - Datastore Overview
- SAP BODS - Changing a Datastore
- SAP BODS - Memory Datastore
- SAP BODS - Linked Datastore
- SAP BODS - Adapter Datastore
- SAP BODS - File Formats
- COBOL Copybook File Format
- Extracting Data from DB Tables
- Data Extraction from Excel Workbook
- Data Flow & Work Flow
- SAP BODS - Dataflow Introduction
- BODS - Dataflow Changing Properties
- SAP BODS - Workflow Introduction
- SAP BODS - Creating Workflows
- SAP BODS Transforms
- SAP BODS - Transforms Types
- Adding Transform to a Dataflow
- SAP BODS - Query Transform
- SAP BODS Administration
- SAP BODS - Data Services Overview
- Creating Embedded Dataflow
- Debugging & Recovery Mechanism
- Data Assessment & Data Profiling
- SAP BODS - Tuning Techniques
- Multi-user Development
- BODS - Central vs Local Repository
- BODS - Central Repository Security
- Creating a Multi-user Environment
- SAP BODS Useful Resources
- SAP BODS - Questions Answers
- SAP BODS - Quick Guide
- SAP BODS - Useful Resources
- SAP BODS - Discussion
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 - When we create an ETL job in Data service designer, what is the correct hierarchy for the below objects?
A - Project, Data Flow, Work flow, Replication job
B - Project, Work flow, Data Flow, Replication job
Answer : D
Q 2 - Which of the following is not a component of web application layer in Data service architecture?
Answer : E
Q 3 - Which of the following repository is used to control version management of objects and is used for multiuser development?
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 - To use ECC system as data source, what is the data store type?
Answer : A
Q 5 - Which of the following is used to provide connectivity to other systems such as Salesforce.com or the JavaMessagingQueue?
Answer : C
Q 6 - Which of the following transformation can be used for Column mapping from input to output schemas, assigning primary keys, etc.
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?
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?
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?
Answer : B
Explanation
Q 10 - Why do we use checkpoints in an ETL process?
A - To provide markers for data has been processed in case error occurs.
B - To create multiple streams from a single stream in a data flow.
Answer : A
Explanation
Checkpoints are used to provide markers for data that has been processed in case error occurs during ETL process.
To Continue Learning Please Login