InterviewSolution
Saved Bookmarks
InterviewSolution
This section includes InterviewSolutions, each offering curated multiple-choice questions to sharpen your knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
What is UD connect in SAP BW system? How does it allow reporting in BI system? |
| Answer» | |
| 2. |
What is the use of DB connection in SAP BW data acquisition? |
| Answer» | |
| 3. |
How data is stored in PSA? |
| Answer» | |
| 4. |
In SAP BW, is it possible to have multiple data sources have one InfoSource? |
| Answer» | |
| 5. |
To load the data from a file source system, what is requirement in BI system? |
| Answer» | |
| 6. |
While loading data from flat files, when separators are used inconstantly. How this will read in BI load? |
| Answer» | |
| 7. |
What is the use of Navigational attributes? |
| Answer» | |
| 8. |
Explain the difference between InfoCube and ODS? |
| Answer» | |
| 9. |
What is Partition of an InfoCube? |
| Answer» | |
| 10. |
How can you achieve performance optimization in SAP Data Warehouse? |
| Answer» | |
| 11. |
What is the use of Rollup? |
| Answer» | |
| 12. |
What do you understand by Start and update routine? |
| Answer» | |
| 13. |
Explain the different between Operation Data store, InfoCube and MultiProvider? |
| Answer» | |
| 14. |
To perform a Union operation on InfoProviders, which InfoProvider is uses? |
| Answer» | |
| 15. |
Can you setup InfoObjects as Virtual Providers? |
| Answer» | |
| 16. |
When you define aggregates, what are the available options? |
| Answer» | |
| 17. |
Can you convert an InfoPackage group into a Process chain? |
| Answer» | |
| 18. |
Is it possible to convert a standard InfoCube to real time InfoCube? |
| Answer» | |
| 19. |
Can you make an InfoObject as info provider and why? |
| Answer» | |
| 20. |
How do you create a real time InfoCube in administrator workbench? |
| Answer» | |
| 21. |
What is the use of real time InfoCube? How do you enter data in real time InfoCubes? |
| Answer» | |
| 22. |
What is the structure of InfoCube? |
| Answer» | |
| 23. |
What is the use of InfoCube in BW system? |
| Answer» | |
| 24. |
What are the different type of InfoSet joins? |
| Answer» | |
| 25. |
Where do we use InfoSet in BI system? |
| Answer» | |
| 26. |
What is a temporal join? |
| Answer» | |
| 27. |
To perform a Join on dataset, what type of InfoProviders should be used? |
| Answer» | |
| 28. |
Explain the structure of Write optimized DSO’s? How it is different from Standard DSO’s? |
| Answer» | |
| 29. |
Where do we use Write optimized DSO’s? |
| Answer» | |
| 30. |
What is write optimized DSO’s? |
| Answer» | |
| 31. |
Can we perform Delta uploads in direct update DSO’s? |
| Answer» | |
| 32. |
Explain the structure of direct update DSO’s? |
| Answer» | |
| 33. |
To access data for reporting and analysis immediately after it is loaded, which Data store object is used? |
| Answer» | |
| 34. |
What are the different components in DSO architecture? |
| Answer» | |
| 35. |
What is the use DSO in BW system? What kind of data is stored in DSO’s |
| Answer» | |
| 36. |
What is InfoObject catalog? |
| Answer» | |
| 37. |
How do perform real time data acquisition in BW system? |
| Answer» | |
| 38. |
What is the use of Transformation and how the mapping is done in BW? |
| Answer» | |
| 39. |
Which Virtual Providers are used in which scenario of data extraction? |
| Answer» | |
| 40. |
What are different types on Virtual providers? |
| Answer» | |
| 41. |
How do you access to source system data in BI without extraction? |
| Answer» | |
| 42. |
What is the use of Infoarea in SAP BW system? |
| Answer» | |
| 43. |
What are the different categories of InfoObjects in BW system? |
| Answer» | |
| 44. |
What is an InfoObject and why it is used in SAP BI? |
| Answer» | |
| 45. |
How extended Star schema is different from Star schema? |
| Answer» | |
| 46. |
What is extended Star schema? Which of the tables are inside and outside cube in an extended star schema? |
| Answer» | |
| 47. |
What is an InfoPackage? |
| Answer» | |
| 48. |
When you are using SAP BI7.x, you can load the data to which component? |
| Answer» | |
| 49. |
What all data sources you have used to acquire data in SAP BW system? |
| Answer» | |
| 50. |
Explain the architecture of SAP BW system and its components? |
| Answer» | |