SAP DB Interview Questions and Answers
Question - 21 : - Mention what are the three stages of data mining?
Answer - 21 : -
Three stages of data mining include
- Initial Exploration
- Model building
- Deployment
Question - 22 : - Mention what the difference between OLAP and Data Mining is?
Answer - 22 : -
OLAP: OLAP stands for Online Analytical Processing it is a reporting tool configured to understand your database schema, dimensions, and composition facts
Data Mining: It is an analytic process to explore data in search of consistent patterns or systematic relationships between variables.
Question - 23 : - Mention where are t-code name and program values stored? Explain how can you find a list of all t-codes in the SAP system?
Answer - 23 : -
To view transaction table TSTC, you can use transaction code st11, and you can define a new t-code using transaction se93.
Question - 24 : - Mention some of the setbacks of SAP?
Answer - 24 : -
- It is expensive
- Demands highly trained staff
- Lengthy implementation time
- Interfaces are a little bit complex
- Does not determine where master data resides
Question - 25 : - Mention what the different types of variables are?
Answer - 25 : -
Variables are used in the different application are:
- Characteristics variable
- Hierarchies
- Hierarchy nodes
- Text
- Formulas
- Processing Types
- Replacement Path
- User entry/default type
Question - 26 : - What are the variables?
Answer - 26 : -
Variables are parameters of a query set in the parameter query definition and are not filled with values until the queries are entered into the workbooks.
Question - 27 : - Mention what do you mean by datasets?
Answer - 27 : -
The data sets are sequential files processed on the application server. They are used for file handling in SAP.
Question - 28 : - Can we run a business warehouse without SAP R/3 implementation?
Answer - 28 : -
Yes, you can run a business warehouse without R/3 implementation. You have to simply transfer structures associated with business warehouse data sources (ODS table, Infocube) to the inbound data files or use third-party tools to connect your flat files and other data sources.
Question - 29 : - Mention what is AWB?
Answer - 29 : -
AWB stands for Administrator Workbench. It is a tool for monitoring, controlling, and maintaining all the processes connected with data staging and processing in the business information warehousing.
Question - 30 : - Explain what is Bex?
Answer - 30 : -
Bex means Business Explorer. It allows the end-user to locate reports, analyze information, view reports, and can execute queries. The queries in the workbook can be saved to their respective roles in the Bex browser. It has the following components Bex analyzer, Bex Map, and Bex web.