- 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 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 - When we create an ETL job in Data service designer, what is the correct hierarchy for the below objects?
A - Project, Data Flow, Work flow, Replication job
B - Project, Work flow, Data Flow, Replication job
Answer : D
Q 2 - Which of the following is not a repository type in Data Services architecture?
Answer : C
Explanation
There are three type of repositories in Data Services −
- Local
- Central
- Profiler
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 - To use ECC system as data source, what is the data store type?
Answer : A
Q 5 - Which of the following is not an available mode in file format editor?
Answer : E
Q 6 - 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 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 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 9 - As per recommendation for naming conventions, what should be prefix with data store?
Answer : A
Q 10 - 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 doesnt fit into memory.