SAP Certified Application Professional – BI Enterprise Data Warehousing with SAP NetWeaver 7.0 – print view

Disclaimer: These sample 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. The certification exam covers a much broader spectrum of topics, so do make sure you have familiarized yourself with all topics listed in the exam competency areas before taking the certification exam.

Introduction

Advanced Professional certifications require proven project experience, business process knowledge, and a more detailed understanding of SAP solutions. Professional certifications are targeting profiles with approximately four to seven years of experience. Besides the recommended education courses also practical job experience is required and tested. With professional-level certification, you can:

• Demonstrate both your experience and your expertise through a rigorous testing process
• Promote a more globally applicable accreditation
• Lead as well as execute tasks and engagements
• Access a community of SAP professional-level certified peers

If you are a consultant with more than four years of experience, you probably are already in possession of the knowledge you need to pass the exam. This certification preparation guide is designed to provide some guidance as to the topics covered in the exam, sample questions, and study resources.

Exam Competency Areas

The certification test for "SAP Certified Application Professional – BI Enterprise Data Warehousing with SAP NetWeaver 7.0" verifies profound knowledge in the area of Enterprise Data Warehousing with SAP NetWeaver Business Intelligence. This certificate proves that you have an advanced understanding within this profile and are able to apply these skills practically and provide guidance in project implementation.

Software components: SAP NetWeaver 7.0

Number of Questions: 90

Duration: 180 minutes

Competency Areas: The following list helps you to identify the competency areas covered in this test. The percentage indicates the portion of the test dedicated to a particular competency area.

1. You should be able to interpret complex customer requirements into feasible solutions, applying your substantial project experience and high level analytical skills, in the following areas (40%).

Topics / Learning Options:

• ETL: Staging / Data Flow (BW310, BW350)
  All aspects of data acquisition and the data flow are tested in this topic. You should have a thorough knowledge of all the components of a BI data flow, their settings, usage and capabilities. Data flow migration, the flow of data through a typical process chain, reconstructing InfoProviders, RDA and Open Hub are also tested in this area.
• InfoProviders (BW310)
  In addition to knowing all the types of InfoProviders and their specific properties, expect questions here about the BI extended star schema tables, selective deletion of data and selecting the proper InfoProvider for a specific report.
• Information Lifecycle Management (ILM) (BW360, BW330)
  The archiving of BI data is tested here, including the general archiving process and how to use and manage archiving-relevant tables.
• Performance Tuning in Data Modeling, Data Staging and Reporting (BW360)
  In this topic, some of the tested areas will be MultiProvider, InfoCube and DataStore Object performance settings, change run processing, parallel processing, request management, aggregates, BIA performance settings and the OLAP cache.
• EDW / Data Modeling (BW330)
  This is one of the chief topic areas, and you can expect questions on the features and functions of most of the InfoProvider types, attribute change runs, sizing of objects, interpreting performance statistics, enhancing data flows, navigational attribute usage and time-dependency.

2. You should be able to autonomously build solid customer solutions based on profound understanding and the application of your project experience in the following areas (40%).

Topics / Learning Options:

• InfoObjects (BW310)
  The meaning and usage of all InfoObject settings form the basis of this topic. In addition, questions on non-cumulative key figures, usage of hierarchies, loading and cleansing master data and currency/UOM conversion techniques are found in this topic.
• Meta Data Maintenance & BI Content (BW310)
  Here the questions focus on managing the installation and activation of Business Content, including the 'match' and 'copy' functions, language translation support, enhancing meta data and using Business Content tools such as the Content Analyzer and Content Browser.
• ETL: Source Systems (Connection, DataSources) (BW350)
  A good familiarity with all the source system adapters for data acquisition is needed in this topic. Enabling and enhancing Business Content DataSources, troubleshooting transport processes and a knowledge of which tables are used to help control the data acquisition process are all areas that can be tested here in this topic.
• BI Administration / Monitoring (BW360)
  All aspects of performance monitoring are explored here including the purpose of the assorted BI monitors, system copy and transport procedures, the BIA landscape, Error Stack processing, configuration settings in BI and physical partitioning.
• Development / Programming (BW350)
  Knowledge of all possible ABAP routine usage in BI is tested, including start, end, InfoObject and InfoPackage routines. In addition, the topics of data validation and virtual characteristics are covered here.
• Analytical Engine / OLAP (BW305)
  In this topic, you will be questioned about your knowledge of the OLAP Cache, inventory management scenarios and the use of non-cumulative key figures, the OLAP BAPI interface, logical partitioning and various BEx Query Designer tasks such as the use of structures, exception aggregation and good query design.

3. You should be able to perform identified tasks in the following areas, based on your basic understanding during system implementation, configuration, and testing (20%).

Topics / Learning Options:

• BI-relevant database aspects (BW360)
  In this area, you should be comfortable with topics such as indexing, re-partitioning and various database-specific parameters relevant to BI.
• Analysis Authorizations /Security (BW365)
  Expect questions here about which authorization objects are needed in specific scenarios, processes for applying authorizations, and the outcome of specific authorization examples.
• Data Quality Management (BW350)
  Standard BI processes such as testing for and repairing data inconsistencies, repairing BI objects and managing quality of 3rd party data acquisition are tested in this topic.
• SAP NetWeaver Platform (BW305, BW310)
  As one of the smaller topics, an understanding of the NetWeaver architecture, terminology and installation usage types is important here.
• Data Warehousing Workbench (BW310)
  All functions of the Data Warehousing Workbench are tested here, including data deletion and reloading, settings for various BI objects such as InfoObjects, InfoCubes and DataStore Objects, conversion routines in InfoObjects and the Administrator Cockpit.
• Solution Manager
  Another small topic, a general understanding of the purpose and usage of the Solution Manager is tested here.

Questions

Disclaimer: These sample 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. The certification exam covers a much broader spectrum of topics, so do make sure you have familiarized yourself with all topics listed in the exam competency areas before taking the certification exam.

1. Which of the following statements best describes analysis authorizations?

Please choose the correct answer.

a)	0	Analysis authorizations are required only by data analysts working in the Data Warehousing Workbench to model or load data
b)	O	Analysis authorizations are required by all users working in the Business Explorer Suite to export query data to a local file
c)	0	Analysis authorizations are required by users who want to display transaction data from authorization-relevant characteristics in a query
d)	0	Analysis authorizations are required by users who want to make characteristics authorization-relevant in the Data Warehousing Workbench

2. Which of the following common query design mistakes degrade performance?

Note: There are 2 correct answers to this question.

a)	0	Setting the display property of all characteristics to display the key value only
b)	0	Using too many characteristic value variables with default values
c)	0	Using excluding filters on characteristics with high cardinality
d)	0	Placing a large number of characteristics in the rows

3. A customer's financial master data is sourced from multiple OLTP systems. The customer does not want to implement any new application to consolidate master data. As a BI consultant, what would you recommend as the best approach to consolidate the data?

Please choose the correct answer.

a)	0	Do not consolidate master data using SAP NetWeaver BI
b)	0	Make use of the EDW layer concept to consolidate the financial master data
c)	0	Use a source-system naming convention when extracting the financial master data
d)	0	Use complex mapping rules and end routines in transformations to perform the consolidation when extracting the financial master data

4. Your customer is seeking better performance on the query filter selection screens for the InfoObject 0CUSTOMER. The customer has also asked for the user to only be allowed to select customers who have transaction data in the InfoProvider being used by the query. What is an easy option to consider in fixing both problems?

Please choose the correct answer.

a)	0	For InfoObject 0CUSTOMER, set the Query Execution Filter Value Selection parameter to "Values in InfoProvider".
b)	0	For InfoObject 0CUSTOMER, set the Query Definition Filter Value Selection parameter to "Values in InfoProvider".
c)	0	Create a separate index on 0CUSTOMER in the InfoProvider and reference the index in the filter screen.
d)	0	Build an aggregate on 0CUSTOMER for this InfoProvider and reference the aggregate in the filter screen.

5. Your customer needs to load massive volumes of transactional data daily into a write-optimized DataStore Object. You have analyzed the source of the data and determined that it will always contain unique records based on the document number. For this reason, there will be no need to use delta loads of the data.

In order to capture any duplicate document numbers that were accidentally loaded, but still allow the data to be reported, how would you configure the write-optimized DataStore Object?

Note: There are 2 correct answers to this question.

a)	0	Only use the technical key of the write-optimized DataStore Object
b)	0	Ensure that the semantic key contains the document number
c)	0	Deselect the indicator for "Do not check uniqueness of data"
d)	0	Deselect the indicator for "Unique Data Records"

6. Which of the following statements are accurate regarding the source system adapters that SAP NetWeaver BI provides to extract data from non-SAP data sources?

Note: There are 2 correct answers to this question.

a)	0	Staging BAPI DataSources support Real-time Data Acquisition (RDA) regardless of the third-party ETL tool used
b)	0	UD Connect DataSources in BI allow data staging for both physical and virtual InfoProviders
c)	0	Technical field names of tables and views extracted using DB Connect cannot be longer than 24 characters
d)	0	The process type "Delete Overlapping Requests from InfoCube" within a process chain enables "Pseudo Delta" loads from flat file DataSources

7. You need to update a record in a standard DataStore Object but the corresponding record no longer exists in the source system. What is the best approach to solve this problem, assuming that directly updating the DataStore Object table is not an option?

Note: There are 2 correct answers to this question.

a)	0	Create a new DTP and transformation and then reconstruct the request with the new record
b)	0	Reconstruct the DataStore Object from the Data Warehouse layer of the EDW
c)	0	If the PSA still has the original record, change the record manually in the PSA and then reload the request
d)	0	Use Open Hub to export the record from the DataStore Object, change the record then reload the changed record

8. You need to supply attribute data for a characteristic from two source systems. Some attributes are supplied by one source system; the remainder comes from the other source system with no duplication of attributes between the systems. You have already created all the necessary InfoObjects in your BI system and verified that the keys to the characteristic data in both systems are the same. Which additional design options are necessary?

Note: There are 2 correct answers to this question.

a)	0	Create a separate DataSource for each source system, then connect each DataSource to the characteristic attribute table with a transformation
b)	0	Create two separate InfoObjects for the characteristic, each with the set of attributes supplied by the two separate source systems. Populate the attribute tables of both the InfoObjects, then use the DataMart Interface to consolidate the two sets of data into the original characteristic InfoObject
c)	0	Use the feature "Insert Characteristic as InfoProvider" and use transformations for both source systems containing all attributes of the characteristic
d)	0	Use two Data Transfer Processes to load the data.

9. You are investigating performance problems with a query created on a MultiProvider. The MultiProvider consists of 6 InfoCubes, 3 for planning and 3 for actual data. All InfoCubes are logically partitioned by fiscal year and contain data for the past 5 years including the current year. Your research using transaction RSRT shows that, although the query is only requesting current year actual data, all 6 InfoCubes are being read during query execution.

Which performance changes can be implemented without aggregates or data structure changes?

Note: There are 2 correct answers to this question.

a)	0	In table RRKMULTIPROVHINT, enter the 0FISCYEAR and 0VAL_TYPE characteristics for each of the 6 InfoCubes
b)	0	In the definition of the InfoCubes, in the "InfoProvider Specific Properties" section, enter the fiscal year and value type for each of the 6 InfoCubes
c)	0	In the MultiProvider properties, change the Read Mode to "Read all data"
d)	0	In the definition of the MultiProvider, in the "InfoProvider Specific Properties" section, hard-code the values for fiscal year and value type
e)	0	In the definition of the MultiProvider, add 0FISCYEAR and 0VAL_TYPE as navigational attributes

10. A customer reports that selective deletion of records from an InfoCube with 9 million data records runs for several hours. Which of the following factors directly influence the deletion process?

Note: There are 2 correct answers to this question.

a)	0	High number of characteristics in one dimension
b)	0	High number of non-cumulative key figures
c)	0	Uncompressed aggregates on the InfoCube
d)	0	High number of physical partitions
e)	0	High number of display attributes

Expert Guidance

In preparing for this exam, it is important to remember that the exam covers a broad range of topics, and therefore it is not possible to ask many questions on any one topic. Certain topics, such as the BI Administration / Monitoring and ETL: Data Flow receives more emphasis than topics such as Data Quality or the NetWeaver Platform. Also, be advised that although this exam is focused on data warehousing, you will be asked questions regarding queries, reporting and analysis as it relates to the OLAP engine and query performance tuning. You should use the percentage guides from the Exam Competency Areas section above to guide the allocation of your preparation time.

As shown in the sample exam questions, a good understanding of various business scenarios is helpful when choosing the best answer from a list of possible approaches. For these types of questions where multiple answers are correct, it may be helpful to use a selection/elimination strategy. You can possibly eliminate answers that are factually wrong, while selecting answers that are clearly correct. This leaves fewer answers where you might not be sure, thus speeding up the selection process.

For questions that are based on product functionality rather than a business scenario, the answers are usually found in the course material listed for that area in the Exam Competency Areas section above. While several answers may be very similar in their wording, take sufficient time to clearly understand the meaning of each answer rather than rushing. That will help in distinguishing which answer(s) is/are correct. Functionality questions are normally about the primary functions of the software, not obscure or secondary features and options. BI administration / monitoring and performance tuning are both areas where practical knowledge will be especially helpful. Some of the questions in these areas are not discussed directly in the training material and require an understanding of relevant transaction codes, tables and processes. The resources listed below can also be useful in learning the more technical aspects of BI administration and performance tuning. For example, you can expect questions about settings made in specific tables that influence the performance of data loads, query execution or other performance-related areas.

Data modeling and EDW design are also important areas of the exam where experience and additional knowledge will make it easier to score well. Several of the questions in this area are in the format of a business scenario where you must judge between several plausible options. There are no 'trick' questions or answers, but you should think through the choices to make sure you understand the exact meaning and impact of each option before making your choices.

The majority of the questions in this exam are multiple choice questions. Some of these require you to select the single correct option whilst others are multiple response questions. In the multiple response questions, be sure to note the advice in the question stem on the number of correct responses. You must choose the number of options indicated as there is no partial scoring and multiple response questions are scored as either correct or incorrect. There may also be a small number of Fill-in-the Blank items. These questions are not designed to test your language skills so there is normally a range of possible options, for example with or without capitalization, etc.

Resource Page

SAP Developer's Network (SDN): http://sdn.sap.com > Information Management > Business Intelligence

A great source of whitepapers, blogs, wikis and forums for SAP NetWeaver BI
SAPPress web site: www.sap-press.com

Book: SAP Business Intelligence (BI) by Egger, Fiechter, Kramer, Sawicki and Weber
ISBN 978-1-59229-082-6

Book: Efficient SAP NetWeaver BI Implementation and Project Management by Gary Nolan
ISBN 978-1-59229-105-2

Book: SAP NetWeaver BI 7.0 Migration Guide by Daniel Knapp
ISBN 978-1-59229-228-8

Solutions

1 a) Incorrect	2 a) Incorrect	3 a) Incorrect	4 a) Correct	5 a) Incorrect
1 b) Incorrect	2 b) Incorrect	3 b) Correct	4 b) Incorrect	5 b) Correct
1 c) Correct	2 c) Correct	3 c) Incorrect	4 c) Incorrect	5 c) Correct
1 d) Incorrect	2 d) Correct	3 d) Incorrect	4 d) Incorrect	5 d) Incorrect

6 a) Incorrect	7 a) Incorrect	8 a) Correct	9 a) Correct	10 a) Incorrect
6 b) Correct	7 b) Incorrect	8 b) Incorrect	9 b) Correct	10 b) Incorrect
6 c) Incorrect	7 c) Correct	8 c) Incorrect	9 c) Incorrect	10 c) Correct
6 d) Correct	7 d) Correct	8 d) Correct	9 d) Incorrect	10 d) Correct
			9 e) Incorrect	10 e) Incorrect

Further Information

Further information about SAP Certification can be found on the following Web site:
http://www.sap.com/services/education/certification/index.epx

If you have any queries about this document please contact your local SAP Education representative or SAP Education via the following:
https://www.sap.com/contactsap/index.epx