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 component is responsible for extraction, transformation and load of data using Data Service designer?
Answer : B
Explanation
Data flows extract, transform, and load data. Everything having to do with data, including reading sources, transforming data, and loading targets, occurs inside a data flow.
Answer : B
Explanation
File format defines the set of properties to define structure of a flat file.
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 check access server status and real time services at web application layer?
Answer : C
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 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 - 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 8 - 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 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 doesn’t fit into memory.