- 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 III
Q 1 - In a Data flow to extract or load the data directly, which of the following method can be used for XML file?
Answer : A
Q 2 - Workflows can be created using the following methods −
Object Library
Tool Palette
Answer : A
Q 3 - What is the use of adding conditionals to workflow?
Answer : A
Explanation
You can add Conditionals to workflow. This allows you to implement the If/Else/Then logic on the workflows.
Q 4 - Which of the following is not a transformation type under data integration?
Answer : E
Explanation
Data Integration transforms are used for data extraction, transform and load to DW system. It ensures data integrity and improves developer productivity.
- Data_Generator
- Data_Transfer
- Effective_Date
- Hierarchy_flattening
- Table_Comparision, etc.
Data Cleanse- Data quality transformation.
Q 5 - Which of the following can be used to generate, map, and merge rows from two or more data sources?
Answer : A
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 - Data Quality Transformations cannot be directly connected to the upstream transform, which contains nested tables. To connect these transform you should add a query transform or XML pipeline transform between transformation from nested table and data quality transform?
Answer : A
Q 8 - 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 9 - Which of the following is a difference between TDP and data cleansing?
B - In TDP, input size is more than 5KB
C - In TDP, input type is unstructured data
D - In TDP, create annotations in form of entities, types, etc.
Answer : A
Explanation
In TDP, Create annotations in form of entities, type, etc. and Input is not changed.
Q 10 - A data flow data flow which is called from another data flow in the design is known as?
Answer : C
Explanation
Embedded data flow is known as data flows, which are called from another data flow in the design. The embedded data flow can contain multiple number of source and targets but only one input or output pass data to main data flow.
Q 11 - 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 12 - Which of the following recovery mechanism allows you to rerun the jobs without previous partial rerun?
Answer : B
Explanation
Automatic Recovery − This allows you to run unsuccessful jobs in recovery mode.
Manually Recovery − This allows you to rerun the jobs without considering partial rerun previous time.
Q 13 - To enable recovery in Data Services, when a job fails which of the following option can be used to enable this option?
Answer : A
Answer Sheet
Question Number | Answer Key |
---|---|
1 | A |
2 | A |
3 | A |
4 | E |
5 | A |
6 | C |
7 | A |
8 | B |
9 | A |
10 | C |
11 | D |
12 | B |
13 | A |
To Continue Learning Please Login
Login with Google