- 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 Mock Test
This section presents you various set of Mock Tests related to SAP BODS. You can download these sample mock tests at your local machine and solve offline at your convenience. Every mock test is supplied with a mock test key to let you verify the final score and grade yourself.
SAP BODS Mock Test IV
Q 1 - 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 2 - 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?
Answer : C
Q 3 - 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 4 - Which of the following transformation allows you to produce a new row in your target rather than updating an existing row?
Answer : D
Q 5 - 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 6 - As per recommendation for naming conventions, what should be prefix with data store?
Answer : A
Q 7 - Which of the following tool is used for scheduling and to view error logs for replication job?
Answer : B
Explanation
Q 8 - To create a datastore for SAP HANA, which of the following datastore type should be selected?
Answer : B
Explanation
To connect to HANA database, select datastore type as Database.
Q 9 - Which of the following represents data access methods?
Answer : A
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.
Q 11 - Which of the following feature in ETL allows you to create multiple streams from a single stream?
Answer : B
Q 12 - Which of the following option allows you to perform optimization in Data Services?
Answer : C
Q 13 - Which of the following is default cache type to increase the performance of data transformation occur in memory?
Answer : B
Explanation
Pageable cache is default cache type. It should be used when data flow processes large amount of data that doesn’t fit into memory.
Answer Sheet
| Question Number | Answer Key |
|---|---|
| 1 | B |
| 2 | C |
| 3 | B |
| 4 | D |
| 5 | B |
| 6 | A |
| 7 | B |
| 8 | B |
| 9 | A |
| 10 | A |
| 11 | B |
| 12 | C |
| 13 | B |