- 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
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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 not a datastore type in SAP Data services?
Answer : C
Explanation
Three types of datastore in Data Services −
- Application
- Database
- Adapter
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?
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 is used to create a local repository in Data services?
A - Data Services Server Manager
C - Data Services Repository Manager
Answer : C
Explanation
Create a database Local_Repo and go to Data Services Repository Manager. Configure database as local repository.
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 - Workflows can be created using the following methods −
Object Library
Tool Palette
Answer : A
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 - 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?
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 - Which of the following returns multiple values based on single or multiple conditions?
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)
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.