- 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 component in Data services?
Answer : E
Explanation
Data Services component include −
- Job Server
- Adapters
- Real-time Services
- Address Server
- Management Console
- Designer
- Repository
- Engines
- Access Server
Answer : B
Explanation
File format defines the set of properties to define structure of a flat file.
Q 3 - Which of the following is used to pass information to a data flow, work flow or to a replication job when called using a function?
Answer : B
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 property of data flow can be used to improve the performance of operations such as joins, groups, sorts, filtering, lookups, and table comparisons?
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 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 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?
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 - To enable recovery in Data Services, when a job fails which of the following option can be used to enable this option?
Answer : A
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 - Which of the following represents data access methods?