a. Activates the new Master data and Hierarchy data
b. Aggregates are realigned and recalculated
c. Always reads data from the InfoCube to realign aggregates
d. Aggregates are not affected by change run
ANSWER(S): A, B
Change run activates the Master data and Hierarchy data changes. Before the activation of these changes, all the aggregates that are affected by these changes are realigned. Realignment is not necessarily done by reading InfoCubes. If these are part of another aggregate that can be used to read data for the realignment, change run uses that aggregate
2. Which statement(s) is/are true about Multiproviders?
a. This is a virtual Infoprovider that does not store data
b. They can contain InfoCubes, ODSs, info objects and info sets
c. More than one info provider is required to build a Multiprovider
d It is similar to joining the data tables
ANSWER(S): A, B
Multiproviders are like virtual Infoproviders that do not store any data. Basic InfoCubes, ODSs, info sets or Info objects can be used to build a Multiprovider. Multiproviders can even be built on a single Infoprovider
3. The structure of the PSA table created for an info source will be...
a. Featuring the exact same structure as Transfer structure
b. Similar to the transfer rules
c. Similarly structured as the Communication structure
d. The same as Transfer structure, plus four more fields in the beginning
ANSWER(S): D
The structure of PSA tables will have an initial four fields: request id, packet number, partition value and record number. The remaining fields will be exactly like Transfer Structure.
4. In BW, special characters are not permitted unless it has been defined using this transaction:
a. rrmx
b. rskc
c. rsa15
d. rrbs
ANSWER(S): B
Rskc is the transacation used to enter the permitted characters in BW.
5. Select the true statement(s) about info sources:
a. One info source can have more than one source system assigned to it
b. One info source can have more than one data source assigned to it provided the data sources are in different source systems
c. Communication structure is a part of an info source
d. None of the above
ANSWER(S): A, C
Info sources can be assigned to multiple source systems. Also, info sources can have multiple data sources within the same source system. Communication structure is a part of the source system
6. Select the statement(s) that is/are true about the data sources in a BW system:
a. If the hide field indicator is set in a data source, this field will not be transferred to BW even after replicating the data source
b. A field in a data source won't be usable unless the selection field indicator has been set in the data source
c. A field in an info package will not be visible for filtering unless the selection field has been checked in the data source
d. All of the above
ANSWER(S): A, C
If the hide field is checked in a data source, that field will not be transferred to a BW system from the source system even after replication. If the selection field is not checked, that field won't be available for filtering the info package
7. Select the statement(s) which is/are true about the 'Control parameters for data transfer from the Source System':
a. The table used to store the control parameters is ROIDOCPRMS
b. Field max lines is the maximum number of records in a packet
c. Max Size is the maximum number of records that can be transferred to BW
d. All of the above
ANSWER(S): A
ROIDOCPRMS is the table in the BW source system that is used to store the parameters for transferring data to BW. Max size is the size in KB which is used to calculate the number of records in each packet. Max lines is the maximum number of records in each packet
8. The indicator 'Do not condense requests into one request when activation takes place' during ODS activation applies to condensation of multiple requests into one request to store it in the active table of the ODS.
a. True
b. False
ANSWER(S): B
This indicator is used to make sure that the change log data is not compressed to one request when activating multiple requests at the same time. If these requests are combined to one request in change log table, individual deletion will not be possible.
9. Select the statement(s) which is/are not true related to flat file uploads:
a. CSV and ASCII files can be uploaded
b. The table used to store the flat file load parameters is RSADMINC
c. The transaction for setting parameters for flat file upload is RSCUSTV7
d. None of the above
ANSWER(S): C
Transaction for setting flat file upload parameters is RSCUSTV6.
10. Which statement(s) is/are true related to Navigational attributes vs. Dimensional attributes?
a. Dimensional attributes have a performance advantage over Navigational attributes for queries
b. Change history will be available if an attribute is defined as navigational
c. History of changes is available if an attribute is included as a characteristic in the cube
d. All of the above
ANSWER(S): A, C
Dimensional attributes have a performance advantage while running queries since the number of table joins will be less compared to navigational attributes. For navigational attributes, the history of changes will not be available. But for dimensional attributes, the InfoCube will have the change history
11. When a Dimension is created as a line item dimension in a cube, Dimensions IDs will be same as that of SIDs.
a. True
b. False
ANSWER(S): A
When a Dimension is created as a line item dimension, the SIDs of the characteristic is directly stored in the fact tables and these are used as Dimension IDs. Dimension table will be a view off of SID table and fact table
12. Select the true statement(s) related to the start routine in the update rules:
a. All records in the data packet can be accessed
b. Variables declared in the global area is available for individual routines
c. Returncode greater than 0 will be abort the whole packet
d. None of the above
ANSWER(S): A, B, C
In the start routine, all records are available for processing. Variables declared in the global area can be used in individual routines. Returncode greater than 0 will abort processing of all records in the packet
13. If a characteristic value has been entered in InfoCube-specific properties of an InfoCube, only these values can be loaded to the cube for that characteristic.
a. True
b. False
ANSWER(S): A
If a constant is entered in the InfoCube-specific properties, only that value will be allowed in the InfoCube for that characteristic. This value will be fixed in the update rules and it is not possible to do the change in update rules for that characteristic.
14. After any changes have been done to an info set it needs to be adjusted using transaction RSISET.
a. True
b. False
ANSWER(S): A
After making any type of change to an info set, it needs to be adjusted using the transaction RSISET.
15. Select the true statement(s) about read modes in BW:
a. Read mode determines how the OLAP processor retrieves data during query execution and navigation
b. Three different types of read modes are available
c. Can be set only at individual query level
d. None of the above
ANSWER(S): A, B
Read mode determines how an OLAP processor retrieves data during query execution and navigation. Three types of read modes are available:
1. Read data during expand hierarchies
2. Read data during navigation
3. Read data all at once
Read mode can be set at info provider level and query level.
1. The following transactions are relevant to the data sources in an SAP BW source system.
a. RSA3
b. RSA4
c. RSA5
d. RSA6
ANSWER(S): A, C, D
Transaction RSA3, or extractor checker, is used in the BW source system to check data sources for various extraction modes, including full update, delta update and delta initialization.
RSA5 is for installing standard business content data sources and RSA6 is for maintaining data sources
2. True or False? A reference characteristic will use the SID table and master data table of the referred characteristic.
a. True
b. False
ANSWER(S): A
If an info object is created as a characteristic with a reference characteristic, it won't have its own sid and master data tables. The info object will always use the tables of the referred characteristic.
3. The following statements are not true about navigational attributes.
a. An attribute of an info object cannot be made navigational if the attribute-only flag on the attribute info object has been checked.
b. Navigational attributes can be used to create aggregates.
c. It is possible to make a display attribute to navigational in an info cube data without deleting all the data from the info cube.
d. Once an attribute is made navigational in an info cube, it is possible to change it back to a display attribute if the data has been deleted from the info cube.
ANSWER(S): D
All the statements except D are true. It is possible to change a navigational attribute back to a display attribute in an info cube, without deleting all data from the info cube
4. True or False? It is possible to create a key figure without assigning currency or unit.
a. True
b. False
ANSWER(S): A
Yes, it is possible to create a key figure without assigning a unit if the data type is one of these four: Number, Integer, Date or Time.
5. The following statements are true for compounded info objects.
a. An info cube needs to contain all info objects of the compounded info object if it has been included in the info cube.
b. An info object cannot be included as a compounding object if it is defined as an attribute only.
c. An info object can be included as an attribute and a compounding object simultaneously.
d. The total length of a compounded info object cannot exceed 60.
ANSWER(S): A, B, D
When a compounded info object is included in an info cube, all corresponding info objects are added to the info cube. If an info object is defined as an attribute, it cannot be included as compounding object. The total length of the compounding info objects cannot exceed 60 characters.
6. The following statements are true for an info cube.
a. Each characteristic of info cube should be assigned to at least one dimension.
b. One characteristic can be assigned to more than one dimensions.
c. One dimension can have more than one characteristic.
d. More than one characteristic can be assigned to one line item dimension.
ANSWER(S): A, C
Any characteristic in the info cube should be assigned to a dimension. One characteristic cannot be assigned to more than one dimension. One dimension can have more than one characteristic, provided it is not defined as a line item dimension.
7. The following statements are true for info cubes and aggregates.
a. Requests cannot be deleted if info cubes are compressed.
b. A request cannot be deleted from an info cube if that request (is compressed) in the aggregates.
c. Deleting a request from the cube will delete the corresponding request from the aggregate, if the aggregate has not been compressed.
d. All of the above.
ANSWER(S): A, C
Once the info cubes are compressed it is not possible to delete data based on the requests. There won't be request IDs anymore. Requests can be deleted even if the requests in aggregates have been compressed. But the aggregates will have to be de-activated. Deleting an uncompressed request from an info cube will automatically delete the corresponding request from aggregate if the aggregate request has not been compressed
8. The following statements are true regarding the ODS request deletion.
a. It is not possible to delete a request from ODS after the request has been activated.
b. Deleting an (inactive) request will delete all requests that have been loaded into the ODS after this request was loaded.
c. Deleting an active request will delete the request from the change log table.
d. None of the above.
ANSWER(S): C
It is possible to delete requests from an ODS, even if the request has been activated. The "before and after image" of the data will be stored in the change log table using which the request will be deleted.
Deleting a request which has not been activated in ODS will not delete the requests which are loaded after this request. But if the request has been activated then the loaded and activated requests later will get deleted. Also the change log entries will be deleted for that request.
9. The following statements are true for aggregates.
a. An aggregate stores data of an info cube redundantly and persistently in a summarized form in the database.
b. An aggregate can be built on characteristics or navigational attributes from the info cube.
c. Aggregates enable queries to access data quickly for reporting.
d. None of the above.
ANSWER(S): A, B, C
Aggregates summarize and store data from an info cube. Characteristics and navigational attributes of an info cube can be used to create aggregates. Since aggregates contain summarized data, the amount of data in aggregates will be much less that the cube which makes the queries to run faster when they access aggregates.
10. True or False? If an info cube has active aggregates built on it, the new requests loaded will not be available for reporting until the rollup has been completed successfully.
a. True
b. False
ANSWER(S): A
Newly-loaded requests in an info cube with aggregates will not be available for reporting until the aggregate rollup has been completed successfully. This is to make sure that the cube and aggregates are consistent while reporting.
11. What is the primary purpose of having multi-dimensional data models?
a. To deliver structured information that the business user can easily navigate by using any possible combination of business terms to show the KPIs.
b. To make it easier for developers to build applications, that will be helpful for the business users.
c. To make it easier to store data in the database and avoid redundancy.
d. All of the above.
ANSWER(S): A
The primary purpose of multi-dimensional modeling is to present the business users in a way that corresponds their normal understanding of their business. They also provide a basis for easy access of data which is OLAP engine
12. The following statements are true for partitioning.
a. If a cube has been partitioned, the E table of the info cube will be partitioned on time.
b. The F table of the info cube is partitioned on request.
c. The PSA table is partitioned automatically with several requests on one partition.
d. It is not possible to partition the info cube after data has been loaded, unless all the data is deleted from the cube.
ANSWER(S): A, B, C, D, F
BW allows partitioning of the info cubes based on time. If the info cube is partitioned, the e-fact table of the info cube will be partitioned on the time characteristic selected.
The F fact table is partitioned on request ids automatically during the loads. PSA tables are also partitioned during the loads and can accommodate more than one request. For an info cube to be partitioned, all data needs to be removed from the info cube.
13. The following statements are true for OLAP CACHE.
a. Query navigation states and query results are stored in the application server memory.
b. If the same query has been executed by another user the result sets can be used if the global cache is active.
c. Reading query results from OLAP cache is faster than reading from the database.
d. Changing the query will invalidate the OLAP cache for that query.
ANSWER(S): A, B, C, D
Query results are stored in the memory of application server, which can be retrieved later by another user running the same query. This will make the query faster since the results are already calculated and stored in the memory. By changing the query, the OLAP Cache gets invalidated
14. The following statements are true about the communication structure.
a. It contains all the info objects that belong to an info source.
b. All the data is updated into the info cube with this structure.
c. It is dependent on the source system.
d. All of the above.
ANSWER(S): A, B
The communication structure contains all info objects in the info source and it is used to update the info cube by temporarily storing the data that needs to be updates to the data target. It doesn't depend on the source system
15. The following statements are untrue about ODSs.
a. It is possible to create ODSs without any data fields.
b. An ODS can have a maximum of 16 key fields.
c. Characteristics and key figures can be added as key fields in an ODS.
d. After creating and activating, an export data source is created automatically
ANSWER(S): A,C
An ODS cannot be created without any data fields, and it can have a maximum of only 16 key fields. Key figures cannot be included as a key field in an ODS. The export data source is created after an ODS has been created and activated
Reporting
1. What are the primary reporting environments for SAP BW?
a) BEx Analyzer
b) BEx Access
c) Web browser
d) Windows Notepad
ANSWER(S): A, C
BW offers two primary reporting environments. The BEx Analyzer is integrated within Microsoft Excel. The second environment requires zero software footprint and allows users to view and navigate through reports via a Web browser such as Internet Explorer 5.5 or later.
2. Which of the following types of links can be created from within the BEx Browser?
a) Folders
b) SAP transaction codes
c) Internet addresses
d) All of the above
ANSWER(S): A, C
The Business Explorer (BEx) Browser is an excellent tool for organizing BW queries and workbooks into roles and folders. It also allows non-BW content to be referenced. Things like PDF documents, Website Addresses and shortcuts to applications on the user's PC
3. True or False? You can insert your own HTML code with the Web Application Designer.
a) True
b) False
ANSWER(S): A
The Web Application Designer (WAD) includes a tab that allows a user to switch between a WYSIWYG environment and an HTML environment. Savvy users can modify the generated HTML or insert their own additional code
4. What is the transaction code RSBBS to be used for?
a) Listing current BW users
b) Creating a bulletin board system for reports
c) Maintaining sender-receiver assignments
d) Reloading data into an InfoCube
ANSWER(S): C
The transaction code RSBBS allows maintenance of Sender-Receiver assignments. In practical terms it allows users to create a series of BW queries that can be linked to each other. For instance, it can link a high-level summary report to a detailed report. When the assignment is created, functionality to jump between reports is automatically added to the context menu within the BEx Analyzer and Web Reports.
5. Which of the following is true of the Business Explorer (BEx) Analyzer?
a) It is integrated with Microsoft Excel.
b) It allows multiple queries to be embedded into a single worksheet/workbook.
c) It can refresh queries automatically when a workbook is opened.
d) It has protection to prevent changes to cell values.
e) All of the above.
ANSWER(S): E
All of these answers are true of the BEx Analyzer. The BEx Analyzer is directly integrated with Microsoft Excel. One or more queries can be inserted onto a single worksheet and more than one worksheet can be used. A setting within the properties of a query definition allows reports to automatically refresh when they are opened in the BEx Analyzer. Finally, SAP protection (found in the tools menu of the BEx Analyzer toolbar) can lock worksheets from being modified.
6. Individual cell definitions can be created when a Query Definition has how many structures?
a) 0 Structures
b) 1 Structure
c) 2 Structures
d) More than 2 structures
ANSWER(S): C
A query must have two and exactly two structures in order to use the "define cells" functionality found in the query designer toolbar. A query definition can have at most two structures. A standard query definition has a single structure in the columns pane. To add a second structure to the rows section, right-click anywhere within the rows pane and select new structure
7. What is RRI?
a) A really-really-interesting acronym
b) Report-report-interfacing
c) A transaction code for creating new InfoCubes
ANSWER(S): B
Report-Report-Interfacing is the terminology used to describe linking reports together. Report-Report-Interfacing uses Jump Targets that are created using the transaction code RSBBS (see Question #4). A Query with RRI functionality can be identified by clicking on the Goto icon in the BEx Analyzer toolbar
8. Which of the following can be shared amongst query designers within a single InfoProvider?
a) Characteristic variables
b) Global structures
c) Restricted key figures
d) Technical names of a query
ANSWER(S): A, B, C
Characteristic variables can be created witin the Query Designer and are saved back to the InfoProvider in use. Future queries developed from this same InfoProvider will have the previously used variable available for others to use. The same is true of Global Structures and Restricted Key Figures (RKF). Techincally RKFs can be created local to a Query but can ALSO be saved globally against the InfoProvider.
9. True or False? The reporting agent can be used to pre-calculate Web templates.
a) True
b) False
ANSWER(S): A
The reporting agent is a valuable tool with a great deal of functionality. One feature allows precalculation of Web templates. The queries are run in the background and depending on the technical settings, can be saved so that wait time is minimized. Other functions within the reporting agent include bookmarking, printing, and integration with Crystal Reports
10. A combination of characteristics and key figures can be displayed in any desired order by:
a) Activating the download scheduler
b) Switching a query definition to tabular mode
c) Placing key figures in the rows section of a query definition
d) Using scissors and duct tape
ANSWER(S): B
An under-utilized tool within the BW query designer is the "table display" icon. Switching the format of a query definition to tabular mode allows a user to specify a specific order of columns for each characteristic and key figure found in the query definition. It also allows characteristic attributes to be displayed in any column position. If tabular mode is not selected, all of the characteristics in a query are displayed first, with the key figures displayed in subsequent columns
11. True or False? Characteristic variables cannot be created directly from the Query Designer tool.
a) True
b) False
ANSWER(S): B
Characteristic variables can be created from the query designer. Variables are created by right-clicking directly on a characteristic listed under the InfoProvider or by right-clicking on the pre-existing variable sub-folder for that Characteristic.
12. What SAP transaction code can access the reporting agent?
a) RSA1
b) AL08
c) RSRT
d) RSREP
ANSWER(S): A, D
OK, so this is a bit of a trick question. The reporting agent lies within the administrator workbench. Transaction code RSA1 launches the entire administrator workbench and from there you can click on reporting agent. Alternatively, you can execute transaction code RSREP, which launches only the reporting agent tool itself.
13. The Web Application Designer (WAD) allows which of the following to be displayed in a Web browser?
a) Query results in a table.
b) A corporate logo
c) Bar charts.
d) Links to other reports.
e) All of the above.
ANSWER(S): E
The Web Application Designer (WAD) is very similar to a standard Web publishing tool like Microsoft FrontPage. It allows any generic Web content such as images, text and HTML links to be added alongside BW-specific objects like data tables and filter boxes. The WAD allows multiple queries to be inserted into a single Web page. When it's published, the Web application can be referenced by a standard URL address.
14. A query that is not ready to be shared with other users should be saved to:
a) The BEx Browser
b) Favorites
c) Roles
d) A local PC
ANSWER(S): B
Queries that are under development should not be published to roles where other users have access to locate and execute them. A preferred location for these works in progress is the user favorites, which keeps the query separated from larger audiences. Answer D is correct for workbooks that have a query embedded into them, but query definitions themselves cannot be saved directly to a local PC. Query definitions are stored in the BW document repository
15. Characteristics found in a query definition can be restricted by:
a) Opening the administrator workbench
b) Changing the query properties within the query designer
c) Double-clicking on the characteristic in the query definition
d) Creating a calculated key figure
ANSWER(S): C
Characteristic values can be selected by double-clicking on the characteristic found in the query definition or by right-clicking on the characteristic and choosing restrict from the context menu. A selection menu returns all the values found for the characteristic and lets the user include or exclude single value(s) or range(s). A restriction can also be made dynamic by using variables which allows a report consumer to dynamically select their restrictions at runtime.
No comments:
Post a Comment