SAP BI Questions

SAP BI QuestionsHere you will find sample SAP BI questions and mock tests for SAP BI certification that are relatively similar to the original exam. You should definitely use them during preparation for the certification, because it will help you to familiarize yourself with the exam format, test your knowledge, identify areas that require additional attention, and sometimes these sample questions are just a little bit similar to what you might encounter at the real exam.

SAP BI Certification Questions

Before you read these sample questions, it is necessary to make one thing crystal clear: there is absolutely no way to get SAP BI questions that will appear at the actual certification. There are several reasons why it is not possible. First, no one has access to the bank of the certification questions because they are kept in the utmost secrecy. Second, the pool of questions that SAP has is so large that, even if someone could extract some questions from the secret database, the probability of getting these SAP BI questions at the exam is extremely low because the questions are randomly selected by a computer. Therefore, do not believe the people who try to sell you SAP BI questions and promise that after studying them you will definitely pass SAP BI certification.

During SAP BI certification you will be required to answer 80 multiple choice questions. There is no negative marking for incorrect answers. It means that you should try to answer as many questions as possible even if you are not sure what is the correct answer. You will be given 180 minutes to complete the certification. The current passing score for SAP BI certification is around 60%.

Official SAP BI Certification Questions

SAP Education provides official practice questions for SAP BI Certification: SAP BI Certification Official Sample Questions. If the link does not work, try our mirror of SAP BI Certification Official Sample Questions.

Free SAP BI Certification Questions

Below are 80 sample questions for SAP BI certification. If you are preparing for the exam, try to answer these SAP BI questions and see how many questions you could answer correctly. Here we also posted answers to these SAP BI questions and brief explanations for each of the questions.

Disclaimer: These sample SAP BI questions are for self-evaluation purposes only and do not appear on the actual certification exams. Answering the sample questions correctly is no guarantee that you will pass the certification exam. However, it is a great way to prepare for the actual certification exams and helped many people to become certified SAP consultants.

In every SAP BI question, except ‘true or false’ questions, at least one or more answers can be correct.

Data Flow

1. Pivoting can be easily implemented using which of the following?

Only one answer is correct

a. Start Routine; b. End Routine; c. Expert Routine; d. None of the above

2. Which of the following statements is true?

More than one answer is correct.

a. InfoSources are used to run two (or more) sequential transformations in the data flow without storing the data again; b. An InfoSource can be used a target of the data transfer process; c. In contrast to 3.x InfoSources, as of Release SAP NetWeaver BI 7.0, an InfoSource behaves like an InfoSource with flexible update.

InfoObjects

3. Which of the following statements is true about versioning of master data?

More than one answer is correct.

a. Texts are not active immediately after they have been loaded; b. Time-independent attributes are stored in the P table; c. Time-dependent attributes are stored in the P table; d. Texts are active immediately after they have been loaded.

4. Which of the following values does not have 0RECORDMODE InfoObject in a DataStore object?

Only one answer is correct.

a. X; b. D; c. S; d. R

5. Which of the following conversion routine is registered automatically when a characteristic is created?

Only one answer is correct.

a. PERI6 Conversion Routine; b. ISOLA Conversion Routine; c. ALPHA Conversion Routine; d. GJAHR Conversion Routine

InfoProvider

6. There is no change-log and activation queue for which of the following DataStore objects?

Only one answer is correct.

a. Write-optimized; b. Direct update; c. Both; d. None

7. Which of the following statements is true about Virtual Providers?

More than one answer is correct.

a. Virtual Providers only allow read access to data; b. Virtual Providers allow both read and write access to data; c. InfoObjects can be used as Virtual Providers; d. Using a Virtual Provider analysis on data in external systems can be carried out without having to physically store transaction data in the BI system.

8. Which of the following is a drawback of real-time InfoCubes?

Only one answer is correct.

a. Read-only performance; b. Write performance; c. Both

9. Which of the following statements are true about write-optimized DataStore objects?

There are two correct answers to this question.

a. The system generates SIDs for write-optimized DataStore objects; b. Write-optimized DataStore object is used as a temporary storage area for large sets of data; c. The loaded data to a write-optimized DataStore is aggregated and the history of the data is not retained; d. The system generates a unique technical key for the write-optimized DataStore object.

10. Which of the following statements is true about Direct Update DataStore object?

Only one answer is correct.

a. Direct Update DataStore object can be used for transformation of upload scenarios; b. It is possible to include Direct Update DataStore object into a MultiProvider; c. Direct Update DataStore object is perfect for using it with external data; d. Direct Update DataStore object cannot be used for analysis processes.

11. Which of the following statements is true about InfoCubes in InfoSets?

More than one answer is correct.

a. An InfoCube can be a right operand of a left outer join; b. An InfoCube cannot be a right operand of a left outer join; c. There are only 2 InfoCubes allowed within 1 InfoSet; d. More than 2 InfoCubes are allowed within 1 InfoSet.

12. The quality of an InfoCube is generally measured with respect to which of the following?

Only one answer is correct.

a. Query efficiency; b. Load efficiency; c. Manageability; d. Query efficiency & load efficiency; e. All of the above

13. Which of the following must be avoided in a MultiProvider?

More than one answer is correct.

a. Using more than one non-cumulative InfoCube; b. Using calculations before aggregation on MultiProvider; c. Combining basic InfoProviders having homogeneous data models in a MultiProvider; d. Using only parts of compound characteristics in the constituent basic InfoProvider of a MultiProvider

14. BI reporting always reads the active version of the master data. Which of the following is an exception to this rule?

Only one answer is correct.

a. InfoCubes; b. DataStore objects; c. InfoSets; d. MultiProviders

BEx Analyzer

15. Which of the following statements are true about BEx Analyzer?

More than one answer is correct.

a. In the BEx Analyzer, it is not possible to display an exception in a cell other than the cell that contains the threshold values; b. In the BEx Analyzer, it is not possible to apply the selected condition on the last characteristic of a specific axis only; c. In the BEx Analyzer, it is possible to display an exception in a cell other than the cell that contains the threshold values; d. In the BEx Analyzer, it is possible to apply the selected condition on the last characteristic of a specific axis only.

16. Which of the following statements are true about display and navigation attributes in reporting?

More than one answer is correct.

a. Display attributes can be shown in a report in the drilldown; b. Navigation attributes never result in a slight loss in performance in comparison with using characteristics; c. Navigation attributes result in a slight loss in performance in comparison with using characteristics; d. Display attributes cannot be shown in a report in the drilldown.

BEx Query Designer

17. Calculated key figures consist of formula definitions containing which of the following?

More than one answer is correct.

a. Basic key figures; b. Restricted key figures; c. Pre-calculated key figures

18. Which of the following objects are always re-usable in a BEx Query?

More than one answer is correct.

a. Variables; b. Filters; c. Structures; d. Restricted Key Figures; e. Calculated Key Figures

19. Which of the following can be jump targets in a Report to Report interface?

More than one answer is correct.

a. Web Addresses; b. Queries; c. Reports; d. Transactions

20. From which of the following objects characteristics in the filter, in the rows, in the columns or the free characteristics can derive properties?

Only one answer is correct.

a. Characteristic in InfoProvider; b. Characteristic in reusable filter; c. Both ‘a’ and ‘b’; d. None

21. Which of the following statements are true about percentage functions?

More than one answer is correct.

a. When Percentage Share of the Overall Result (%GT) is used, dynamic filters play a role in calculating the overall result; b. When Percentage Share of the Overall Result (%GT) is used, dynamic filters do not play a role in calculating the overall result; c. When Percentage Share of the Query Result (%CT) is used, dynamic filters play a role in calculating the query result; d. When Percentage Share of the Query Result (%CT) is used, dynamic filters do not play a role in calculating the query result.

22. Which of the following variable types can be processed using the authorization processing type?

More than one answer is correct.

a. Characteristic value variables; b. Hierarchy variables; c. Hierarchy node variables; d. Text variables; e. Formula variables

23. Which of the following statements are true?

More than one answer is correct.

a. You can select cell editor if the query definition contains two structures; b. You can select cell editor if the query definition contains more than two structures; c. You can define cells that have no direct relationship to the corresponding structure parts; d. Cells are displayed, and never serve as containers for auxiliary selections or formulas.

24. Which of the following variable types cannot be processed using the replacement path processing type?

More than one answer is correct.

a. Characteristic value variables; b. Hierarchy Variables; c. Hierarchy Node Variables; d. Text Variables; e. Formula Variables

25. Selecting variable offsets is only available for which of the following?

More than one answer is correct.

a. Characteristic value variables of the type selection option; b. Characteristic value variables of the type single value; c. Characteristic value variables of the type interval; d. Characteristic value variables of the type multiple single values.

Source Systems

26. “UD Connect does not transfer data as flat data”. Is this statement true?

Only one answer is correct.

a. Yes; b. No; c. Not always. Depends on certain conditions.

27. The data source for a generic DataSource can be which of the following?

Only one answer is correct.

a. Transparent tables; b. Database views; c. InfoSet query; d. All of the above; e. None of the above

28. Which of the following statements are true about DB Connect DataSources?

More than one answer is correct.

a. DB Connect DataSources support delta processes; b. DB Connect DataSources do not support delta processes; c. DB Connect DataSources support only the PSA transfer method; d. DB Connect DataSources support many other transfer methods in addition to the PSA transfer method.

29. Which of the following restrictions do not apply when using InfoObjects with UD Connect?

Only one answer is correct.

a. Alpha conversion is not supported; b. The use of conversion routines is not supported; c. Upper and lower case must be enabled; d. All of the above; e. Only answers ‘a’ and ‘b’.

30. Which of the following statements is not true about delta processes for SAP source systems?

Only one answer is correct.

a. ABR (After, Before and Reverse images) delta process supports an update in a DataStore object as well as an InfoCube; b. ADD (Additive Deltas) delta process is used by LIS DataSources; c. AIM (After image) delta process supports the direct update of data in an InfoCube.

31. Which of the following are delta management options for files?

Only one answer is correct.

a. Delta only with status “new”; b. Additive delta; c. Pseudo delta; d. Only answers ‘a’ and ‘b’; e. All of the above.

32. Which of the following can be source objects of UD Connect?

Only one answer is correct.

a. Only relational data stores; b. Only multi-dimensional data stores; c. Both relational and multi-dimensional data stores

33. Restoring 3.x DataSources from DataSources that were migrated in the standard way is not possible for which of the following objects?

Only one answer is correct.

a. SAP source system; b. File; c. UD Connect; d. DB Connect

Integrated Planning

34. Which of the following objects can be an InfoProvider for an IP (Integrated Planning) layout?

More than one answer is correct.

a. InfoCube; b. MultiProviders; c. DataStore object; d. InfoObjects

35. Which of the following statements are true about the standard key date in planning functions?

More than one answer is correct.

a. The key date is used in the entire planning model; b. Fixed date and “from” variable are the only 2 options to set the key date; c. It can be set for every real-time InfoCube in the characteristic relationships; d. If the aggregation level was created directly on a real-time InfoCube, the standard key date is the current system date.

36. Which of the following statements are true regarding aggregation levels in BI Integrated Planning?

More than one answer is correct.

a. Multiple aggregation levels cannot be created for an InfoProvider; b. Aggregation levels cannot be created on MultiProviders; c. An aggregation level is set using a set of characteristics and key figures from the underlying InfoProvider; d. Aggregation levels are used as InfoProviders for planning.

37. In which of the following cases InfoProviders cannot be used as the basis for an input-ready query?

Only one answer is correct.

a. The InfoProvider is an aggregation level that is defined on a real-time-enabled InfoCube (simple aggregation level); b. The InfoProvider is an aggregation level that is defined on a MultiProvider (complex aggregation level) and the MultiProviders includes at least one real-time InfoCube and at least one simple aggregation level; c. The InfoProvider is an aggregation level that is defined on a MultiProvider (complex aggregation level) and the MultiProviders includes at least one real-time InfoCube and no simple aggregation level; d. The InfoProvider is a MultiProvider that contains at least one simple aggregation level.

38. Which of the following statements are NOT true about lock characteristics in Integrated Planning?

Only one answer is correct.

a. In the default settings, all the characteristics and the artificial characteristic 1KYFNM for a real-time InfoCube are relevant for the lock check; b. To reduce the size of the lock table, you can exclude characteristics from the lock check that do not serve to divide lock selections c. If no characteristics are selected as being relevant, the whole InfoCube is locked; d. In the default settings, navigation attributes are not always completely locked.

39. Which of the lock modes are NOT available in Lock concept of Integrated Planning?

Only one answer is correct.

a. E (Exclusive); b. S (Shared); c. M (Mutual)

40. Which of the following objects are written to the BEx transport request, even if standard transport system is switched on?

More than one answer is correct.

a. Planning function type; b. Data slices; c. Queries; d. Characteristic relationships; e. Workbooks

41. Which of the following statements is NOT true about planning sequences?

Only one answer is correct.

a. Planning sequences cannot be linked to a variant of variable values; b. Planning sequences are used to group planning functions; c. One of the step types of a planning sequence is Input template.

Analysis Process Designer

42. Which of the following statements are true?

More than one answer is correct.

a. Analysis Process Designer is an application environment for the SAP data mining solution; b. Analysis Process Designer makes it possible to identify hidden relationships between data in a simple way; c. Analysis Process Designer does not make it possible to identify hidden relationships between data in a simple way; d. Analysis processes are not integrated into the versioning concept; e. Analysis processes are integrated into the versioning concept.

43. Which of the following can be data sources for data transfer from SAP BW to SAP CRM in an analysis process?

More than one answer is correct.

a. InfoObject’s attributes; b. Database table; c. Queries; d. InfoProviders

Meta Data

44. Remodeling is applicable for which of the data models listed below?

Only one answer is correct.

a. DataStore object (DSO); b. InfoCubes; c. Both DataStore object (DSO) and InfoCubes; d. None of the above

45. Is transporting remodeling possible?

Only one answer is correct.

a. Yes; b. No; c. Depends on certain conditions

46. Which of the following statements are NOT true?

Only one answer is correct.

a. An upgrade of business content does not affect the objects that are in productive use; b. Roles have D-versions (delivered versions); c. Business content or activated objects within a BI system can be viewed online in the Metadata Repository.

BEx Web

47. Which of the following objects can be converted to PDF and printed?

More than one answer is correct.

a. BEx Web query; b. BEx Report; c. BEx Web Application

48. Which of the following tool is used for ad-hoc analysis?

Only one answer is correct.

a. BEx Analyzer; b. BEx Report Designer; c. BEx Web Analyzer; d. Visual Composer

49. Which of the following tool is used for creation of Enterprise Reports?

Only one answer is correct.

a. BEx Analyzer; b. BEx Report Designer; c. BEx Web Analyzer; d. Visual Composer

50. Which of the following statements are true about BEx Map?

More than one answer is correct.

a. BEx Map is a part of the BEx Analyzer; b. The size of the BEx Map corresponds to the initial size of the workbook; c. BEx Map is not a part of the BEx Analyzer; d. The size of the BEX Map does not correspond to the initial size of the workbook.

51. For each geo-relevant characteristic, a geographical type has to be specified. Which of the following are the options to choose from?

Only one answer is correct.

a. Static geo-characteristic; b. Dynamic geo-characteristic; c. Only answers ‘a’ and ‘b’; d. There are other options to choose from in addition to answers ‘a’ and ‘b’

52. Which of the following statements are true about BEx Web Analyzer?

More than one answer is correct.

a. BEx Web Analyzer is a standalone web application; b. BEx Web Analyzer is not a standalone web application; c. BEx Web Analyzer can be called as an iView in the Enterprise Portal; d. BEx Web Analyzer cannot be called as an iView in the Enterprise Portal.

53. Exceptions can be defined in which of the following areas of the Business Explorer?

Only one answer is correct.

a. BEx Query Designer; b. Web Applications; c. BEx Web Analyzer; d. BEx Query Designer and BEx Web Analyzer; e. BEx Query Designer, Web Applications and BEx Web Analyzer

Documents

54. A document class is created for which of the following categories of BI objects?

Only one answer is correct.

a. Metadata; b. Master data; c. InfoProvider data; d. Master data and Metadata; e. Metadata, Master data and InfoProvider data

55. Migrated documents are not available in BEx Analyzer. Is this statement correct?

Only one answer is correct.

a. Yes; b. No; c. Depends on certain conditions

Development Interfaces

56. Simple Object Access Protocol (SOAP) based transfer of data is possible for which of the below?

Only one answer is correct.

a. Flat structures; b. Hierarchy data; c. Both answers ‘a’ and ‘b’; d. None

57. Which of the following statements is not true?

Only one answer is correct.

a. OLAP BAPI (Business Application Programming interface) requires an SAP platform; b. OLE DB for OLAP requires MS Windows platform; c. XML for Analysis is platform dependent.

Performance Tuning

58. Can the system access BI accelerator indexes within an InfoSet?

Only one answer is correct.

a. Yes; b. No; c. Depends on certain conditions

59. Which of the following statements are true about aggregates?

More than one answer is correct.

a. Aggregates can be created only for InfoCubes; b. Aggregates can be created for DataStore Objects and InfoCubes; c. Aggregates can be automatically proposed by the BI system; d. Aggregates cannot be automatically proposed by the BI system.

60. Which of the following statements are true about aggregates?

More than one answer is correct.

a. Aggregates use the same Start Schema design that InfoCubes use; b. Aggregates contain all data from InfoCubes; c. Aggregates are not completely transparent to users; d. Aggregates are for InfoCubes what indexes are for database tables.

61. Which of the following will happen when a BI Accelerator is used?

More than one answer is correct.

a. Fast query response time; b. High scalability; c. Aggregates maintenance; d. Frequent roll-up/change run

62. The relational aggregate/caching approach is suitable for which of the following scenarios?

More than one answer is correct.

a. Higher data volumes; b. Predictable query patterns; c. Relaxed response time constraints; d. To reduce potential high load on the BI Accelerator

63. Between using a navigational attribute versus a characteristic, which option is better to increase query performance?

Only one answer is correct.

a. Navigational attribute is better; b. Characteristic is better; c. Either navigational attribute or characteristic has the same effect; d. None of the above

Scheduling & Monitoring

64. Which of the following statement is true about InfoPackages for real-time data acquisition (SAPI and Web Service)?

Only one answer is correct.

a. Requests that are instantiated using an InfoPackage for real-time data acquisition doesn’t remain open across several load processes; b. For real-time data acquisition (SAPI and Web service), the daemon processes the InfoPackage; c. In the InfoPackage for real-time data acquisition, the size and time limits for requests cannot be specified.

65. Which of the following statements is not true about real-time data acquisition?

Only one answer is correct.

a. Real-time data acquisition can only be used to fill DataStore objects; b. DataSources that are used for real-time data acquisition can be used in the delta process for standard data transfer; c. If you load data into a DataStore object with real-time data acquisition, you cannot load data into this DataStore object simultaneously with an additional DTP.

66. Which of the following statements are true about the start process of a process chain?

More than one answer is correct.

a. Using API the start of the process chain can be triggered; b. A start process can only be used in a single process chain; c. Using a Meta chain the start of a process chain cannot be triggered; d. Using API the start of the process chain cannot be triggered; e. Using a Meta chain the start of a process chain can be triggered.

67. Collector processes that are NOT available in process chain are:

Only one answer is correct.

a. AND; b. OR; c. NOR; d. EXOR

Data Warehousing

68. Conversion types can be used for unit conversion within which of the following objects?

More than one answer is correct.

a. Transformation Rules; b. BEx Analyzer; c. Data Transfer Process; d. InfoPackage; e. Planning Functions

69. Which of the following statements are true?

More than one answer is correct.

a. By default, the type of the index on the dimension and fact tables is Bitmap; b. By default, the type of the index on the dimension and fact tables is B-Tree; c. For high cardinality dimensions, the system will use Bitmap index; d. For high cardinality dimensions, the system will use B-Tree index.

70. Partitioning of InfoProviders is possible only if which of the following conditions are true?

Only one answer is correct.

a. Calendar Month (0CALMONTH) must be contained in the InfoProvider; b. Fiscal year/period (0FISCPER) must be contained in the InfoProvider; c. Both 0CALMONTH and 0FISCPER must be contained in the InfoProvider; d. At least 0CALMONTH or 0FISCPER must be contained in the InfoProvider.

71. Which of the following objects cannot be migrated?

More than one answer is correct.

a. Hierarchy DataSources; b. DataSources that use IDoc transfer method; c. DataSources from BAPI source systems; d. Export DataSources used by the data mart interface

Data Modeling

72. Which of the following objects can operate as open hub data sources?

More than one answer is correct.

a. InfoCubes; b. DSO; c. MultiProviders; d. InfoObjects (attributes, texts)

73. The maximum number of key fields that you can have in a DataStore object is:

Only one answer is correct.

a. 12; b. 15; c. 16; d. 32

74. The maximum number of hierarchy levels that can be created for a characteristic InfoObject is:

Only one answer is correct.

a. 95; b. 96; c. 97; d. 98

75. Which ones of the following statements are NOT true?

More than one answer is correct.

a. An InfoCube is more normalized than a DataStore object; b. An InfoCube is less normalized than a DataStore object; c. Surrogate IDs (SIDs) are static; d. Surrogate IDs (SIDs) are dynamic.

76. If the InfoCube is compressed, can the delta be determined?

Only one answer is correct.

a. Yes; b. No; c. Depends on certain conditions

BEx Broadcaster

77. Which of the following are the distribution options of BEx Broadcaster?

Only one answer is correct.

a. Broadcast as e-mail; b. Broadcast to portal; c. Print; d. None of the above; e. All of the above

78. Which of the following statements are true about evaluating exceptions?

More than one answer is correct.

a. Exceptions can be evaluated online when executing the query or the Web application; b. Exceptions can be evaluated online only by executing the query; c. Exceptions cannot be evaluated for a large number of queries in the background with the BEx Broadcaster; d. Exceptions can be evaluated for a large number of queries in the background with the BEx Broadcaster.

BEx Report Designer

79. Please indicate which of the following statements are not true about BEx Report Designer?

More than one answer is correct.

a. The Report Designer generates group levels according to the drilldown state of a query or query view; b. The Report Designer is not a standalone desktop application; c. We cannot call Report Designer in the Web Application Designer; d. Report Designer is used to format and adapt the layout of the business data as a report.

80. Which of the following is a prerequisite to create a report?

Only one answer is correct.

a. To create a report, a structure must be used in the rows of the query or query view on which the report is based; b. To create a report, a structure must be used in the columns of the query or query view on which the report is based; c. To create a report, a structure must be used in both the rows and columns of the query or query view on which the report is based.

Answers and Explanations for SAP BI Questions

For seeing answers and explanations for 80 SAP BI questions published above, please visit this page: Answers to SAP BI Questions.

Page last updated by Cleo Isco on

26 thoughts on “SAP BI Questions”

  1. Cleo,
    I am looking for the certification course code: P_BIR_73

    SAP Certified Application Professional – Business Intelligence with SAP BW 7.3 & SAP BI 4.0

    Will you be able to send me some sample questions for this?

    Thanks.
    Raj

  2. Hello.

    I am quite interested in your material but would like to know if the material covers SAP BW 7.3 & SAP BI 4.0.
    Thanks

    Larry

  3. Hi,

    I am taking up certification in the month of March. Please let me know if the certification questions are based on the latest courseware (TBW10, TBW20, TBW42 and TBW45).

    A quick response will be much appreciated.

    Regards,

    Mahesh

  4. Hi,Do you have more material for sap bw 45 exam. I already read this one and it was good … I would like to know if you have more papers for exam preparation…

    1. Hi,

      I am glad you liked our SAP BI questions set! We are currently working on more SAP BI prep material but are not yet ready to release it. I will keep you updated.

      Regards,
      Cleo

  5. how can we know for which exams precisly are the questions? Cause i’m interested in one particular exam.

  6. Hello,

    Nice one. Much help.

    One correction : Answer for Que 75 is wrong, though the explanation is correct.

    Thanks,
    Jaydip Patel

  7. Hello
    Is there any training courses for an Electrical engineering in Germany? If yes please send me the link, because I could not find it in your website
    thanks alot

Leave a Reply

Do you have a question and want it to be answered ASAP? Post it on our FORUM here --> SAP FORUM!

Your email address will not be published. Required fields are marked *