SAP BI/BW 初中高级问题及答案（初級）

   

Quiz: SAP BI/BW -- beginner 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

2. True or False? A reference characteristic will use the SID table and master data table of the referred characteristic.

a. True

b. False

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.

4. True or False? It is possible to create a key figure without assigning currency or unit.

a. True

b. False

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.

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.

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.

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.

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.

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

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.

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.

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.

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.

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.

   

   

Correct answers:

Question #1: 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.

Question #2: 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.

Question #3: 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.

Question #4: 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.

Question #5: 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.

Question #6: 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.

Question #7: 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.

Question #8: 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.

Question #9: 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.

Question #10: 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.

Question #11: 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.

Question #12: A, B, C, D

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.

Question #13: 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.

Question #14: 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.

Question #15: 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.

   

源文档 <http://hi.baidu.com/supergukai/blog/item/77d801fca8cd11f5fc037fb3.html>