Online Access Free C-TBW60-74 Exam Questions

Which of the following statements about aggregates is true? (2)

• A.Several dimension characteristics used in an aggregate always have the same aggregation level
• B.Aggregates are stored as a single transparent table, which houses the aggregated data
• C.Aggregates reduce the number of key figures
• D.Aggregates can only be created for Basic Cubes
• E.Aggregates can be created on dimension characteristics and navigational attributes

What can you use to accelerate an SAP BW implementation project? (1)

• A.SAP BW Data Warehousing Workbench
• B.SAP BI Content
• C.SAP BW Statistics
• D.SAP BW Accelerator (BWA)

Which of the following statements about the compression of an InfoCube are true? (1)

• A.Compression leads to a reduction in storage space and an increase in read performance
• B.During compression the Request ID in the Data Packet Dimension is ignored
• C.The compressed data is retained in the F Table of the InfoCube
• D.Once compression takes place it is still possible to manage individual request separately

Your business is using a variety of queries. You plan on upgrading your SAP BW 7.4 system to the latest support package. You want to ensure that the query results are correct with various navigation steps. What tool would you use to accomplish this? Select the correct answer.

• A.The BW Trace Tool.
• B.The BW Administration Cockpit.
• C.The BEx Analyzer.
• D.The BEx Web Analyzer.
• E.The BW Metadata Repository.

A MultiProvider has four InfoCubes as components. One InfoCube is a VirtualProvider and two of the others have aggregates. The total execution time of the MultiProvider query is 29 sec when you expect 10 sec. What can account for this scenario? There are 3 correct answers.

• A.The shadow aggregates are being used because of the roll up job.
• B.There are non-cumulative key figures in the InfoCubes.
• C.The query is running in a batch process.
• D.The query is configured for nonparallel processing.
• E.There are insufficient background processes at execution time.