- 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 II
Q 1 - Which of the following component of Data services is used to execute real time and batch jobs?
Answer : A
Q 2 - 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 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 - When you create a local repository in Data Services, which of the following can be used to configure the repository?
Answer : B
Explanation
Central Management Console (CMC) in SAP BI Platform is used for configuring a new repository.
Q 6 - Which of the following is used to check access server status and real time services at web application layer?
Answer : C
Q 7 - Which of the following can be used to check the status or to configure RFC server interface in Data Services management console?
Answer : C
Explanation
SAP Connections is used to check the status or to configure RFC server interface in Data Services Management Console.
To check the status of RFC server interface, go to RFC Server Interface Status tab.
Q 8 - To use ECC system as data source, what is the data store type?
Answer : A
Q 9 - Which of the following is used to provide connectivity to other systems such as Salesforce.com or the JavaMessagingQueue?
Answer : C
Q 10 - SAP Business Objects Data Services provides an option to connect to the Mainframe interfaces?
Answer : D
Explanation
SAP Business Objects Data Services provides an option to connect to the Mainframe interfaces using Attunity Connector. Using Attunity, connect the Datastore to the list of sources given below −
- DB2 UDB for OS/390
- DB2 UDB for OS/400
- IMS/DB
- VSAM
- Adabas
- Flat Files on OS/390 and OS/400
Q 11 - Which of the following is not an available mode in file format editor?
Answer : E
Q 12 - 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.
Answer Sheet
| Question Number | Answer Key |
|---|---|
| 1 | A |
| 2 | B |
| 3 | B |
| 4 | C |
| 5 | B |
| 6 | C |
| 7 | C |
| 8 | A |
| 9 | C |
| 10 | D |
| 11 | E |
| 12 | C |