Interested in FI/CO Video Training? Click here for a free 30 minute Video
SAP Certified Application Associate – Business Intelligence with SAP BW and SAP BI Certification Exam Questions
These questions are similar to the ones asked in the actual Test.
How should I know? I know, because although I got my SAP Certified Application Associate – Business Intelligence with SAP BW and SAP BI Certification five years back, I have re-certified with the latest version of the Associate Certification test.
Before you start here are some Key features of the SAP Certified Application Associate – Business Intelligence with SAP BW and SAP BI Certification Exam
– The exam is Computer based and you have three Hours to answer 80 Questions.
– The Questions are (mostly) multiple choice type and there is NO penalty for an incorrect answer.
– Some of the Questions have more than one correct answers. You must get ALL the options correct for you to be awarded points.
– The Official Pass percentage is 65% (But this can vary). You will be told the exact passing percentage before your begin your test.
Sample Questions
1. SAP BW administrators and architects can improve reporting performance on the database level. Is this statement true?
Please choose the correct answer.
a. Yes
b. No
c. Depends on certain conditions.
Answer: a
Explanation:
SAP BW administrators and architects can also improve reporting performance on the database level, for example, by creating indices or optimizing the database settings. A strategic switch to SAP BW on SAP HANA can result in a dramatic improvement of reporting performance. SAP HANA uses in-memory technology and special data storage technologies for fast read access to the database.
2. Variables also improve query performance by making data requests more specific. This is important for queries against which of the following?
Please choose the correct answer.
a. DataStore objects
b. lnfoSets
c. InfoCubes
d. Only a and b
e. All of the above
Answer: d
Explanation:
Variables also improve query performance by making data requests more specific. This is important for queries against DataStore objects and lnfoSets, which are not aggregated like lnfoCubes. You can add a mandatory characteristic value variable so that reporting users must define a filter. This ensures that not all the detail values are read from the lnfoProvider.
3. Which of the following types of query read modes are supported?
Note: There are more than one correct answers to this question
a. Query to be read when you navigate or expand hierarchies (H)
b. Query to read data during navigation (X)
c. Query to read all data at once (A)
d. Query to read partial data at once (P)
Answer: a, b, c
Explanation:
Query read mode determines how the OLAP processor gets data during navigation. In SAP BW, you can set the read mode for a query in Customizing for an Info Provider and in the Query Monitor.
The following types of query read mode are supported:
Query to be read when you navigate or expand hierarchies (H)
- Transfers the smallest amount of data from the database to the OLAP processor.
- Has the highest number of read processes.
- Aggregates data across a hierarchy and transfers it to the OLAP processor on the hierarchy level that is the lowest in the start list. When expanding a hierarchy node, the children of the node are read.
- Significantly improves performance in almost all cases, compared to the other two read modes, because only data that the user wants to see is requested.
Query to read data during navigation (X)
- Requests data that is needed for each navigational status of the query in SAP Business Explorer.
- Reads the data that is needed for each step in the navigation.
- Imports presentation hierarchies on a leaf level. The data for the fully expanded hierarchy is requested for a hierarchy drill-down.
- Only has an effect on performance for queries with presentation hierarchies.
- Can read data from the main memory when the nodes are expanded.
- Uses the best aggregate table when accessing the database, and if possible, aggregates data in the database.
Query to read all data at once (A)
- Has only one read process.
- Reads all data in the main memory area of the OLAP processor that is needed for all possible navigational steps of the executed query.
- Aggregates and calculates all new navigational states from the data from the main memory during navigation.
- Has an effect on performance for queries with free characteristics because the OLAP processor aggregates on the corresponding query view.
- Least supports working with pre-aggregated data, compared to the other two read modes.
4. Query Monitor can be used for which of the following?
Note: There are more than one correct answers to this question
a. Test or regenerate queries and query views
b. Check or change query properties
c. Display technical information about queries if required.
Answer: a, b, c
Explanation:
The query monitor tests, checks, and manages SAP BW queries and is intended for use by SAP BW administrators. You can open the query monitor from the SAP Easy Access screen. Follow the path Start.- Programs.- Business Explorer.- BEx Query Monitor (transaction RSRTl).
Use the query monitor to:
- Test or regenerate queries and query views
- Check or change query properties
- Display technical information about queries if required.
In the SAP BEx Query Monitor, enter the technical name of the query. To perform detailed analysis. Choose Execute and Debug. You can execute the query without using cache and display statistics data to get an overview of the different steps that were performed and the runtime of each step.
5. The Where-Used List will show references of the query in Analysis workbooks. Is this statement true?
Please choose the correct answer.
a. Yes
b. No
c. Depends on certain conditions.
Answer: b
Explanation:
Choose the Where-Used List icon from the Query Designer tool bar to view a list of places where a query definition is being used.
Where-Used List:
The Where-Used List will not show references of the query in Analysis workbooks.
6. In the Translation area of the Data Warehousing Workbench, you can translate short and long texts for query objects. Is this statement true?
Please choose the correct answer.
a. Yes
b. No
c. Depends on certain conditions.
Answer: a
Explanation:
In the Translation area of the Data Warehousing Workbench, you can translate short and long texts for SAP BW objects, including query objects.
When a query is selected for translation, the worklist automatically includes the query objects for translation. The worklist also includes any connected objects such as workbooks.
Translating Query Objects:
7. Users who work with queries and query components need authorizations in which of the following authorization objects?
Note: There are more than one correct answers to this question
a. S_RS_COMP
b. S_RS_COMPl
c. S_RS_COMPA
d. S_RS_COMPQ
Answer: a, b
Explanation:
Individual authorizations are combined into roles by system administration and are based on the SAP standard authorization concept. You can copy the roles delivered by SAP and adjust them as necessary. The system administrator creates the authorizations and enters them as profiles in users’ master records.
Users who work with queries and query components need authorizations in the authorization objects S_RS_COMP and S_RS_COMPl.
In addition to the fields in the authorization object S_RS_COMP, the authorization object
S_RS_COMPl contains the field Owner of the reporting component.
Use the transaction PFCG for role maintenance. Assign the authorization objects to a role’s authorization profile, and assign the role to users.
8. Which of the following statements are true about Authorizations?
Note: There are more than one correct answers to this question
a. To access protected data, users require analysis authorization.
b. Standard authorizations are sufficient for users who want to display data from authorization-relevant characteristics.
c. Authorizations are transportable to other systems
d. You can create analysis authorizations for a group of characteristics and restrict the values for the characteristics
Answer: a, c, d
Explanation:
Authorization-relevant characteristics are characteristics with protected data. Standard authorizations are not sufficient for users who want to display data from authorization-relevant characteristics. To access protected data, users require analysis authorization.
Authorization-Relevant Characteristic:
Analysis authorizations are based on BW reporting and analysis features. Using transaction RSECADMIN, you can create analysis authorizations for a group of characteristics and restrict the values for the characteristics. Assign the authorization to one or more profiles or roles using the authorization object S_RS_AUTH. Since the authorizations are TLOGO objects (transportable object types), they may be transported to other systems.
Analysis Authorization:
9. Analysis, edition for OLAP (web client) provides access to a range of OLAP data sources, and can also combine information from different OLAP data sources within a single workspace. Is this statement true?
Please choose the correct answer.
a. Yes
b. No
c. Depends on certain conditions.
Answer: a
Explanation:
Analysis, edition for OLAP (web client)
SAP BusinessObjects Analysis, edition for OLAP (formerly Voyager) is an online analytical processing (OLAP) tool for working with multi-dimensional data. It provides access to a range of OLAP data sources, and can also combine information from different OLAP data sources within a single workspace.
10. Which of the following enables a designer to extract, define, and manipulate metadata from relational and OLAP sources to create and deploy the new semantic layer UNX universes?
Please choose the correct answer.
a. Explorer
b. Information Design Tool
c. Live Office
d. Query as a Web Service Designer
Answer: b
Explanation:
Information Design Tool
The Information Design Tool is an SAP BusinessObjects metadata design environment that enables a designer to extract, define, and manipulate metadata from relational and OLAP sources to create and deploy the new semantic layer UNX universes.
More Questions? Have a look at: