What does SAP recommend you do to improve the overall reporting performance of an InfoCube in SAP BW 7.4? There are 3 correct answers.
A. Include the InfoCube into a semantically partitioned object (SPO).
B. Execute a pre-load OLAP cache process in a process chain.
C. Create aggregates.
D. Create one or more line item dimensions.
What are the advantages of using a line-item dimension when modeling an InfoCube? (2)
A. The primary key of the InfoCube fact table is shorter
B. The number of joins that must be executed during query runtime is reduced
C. Data is loaded into the InfoCube without generating DIM Ids for this dimension
D. Aggregates on this InfoCube do NOT need to be built
E. The number of joins that must be executed during query runtime is reduced
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 Accelerator (BWA)
D. SAP BW Statistics
Which of the following settings can you make for error handling in the data transfer process? There are 2 correct answers.
A. Write invalid records into the target InfoProvider.
B. Process the correct records and allow reporting on them.
C. Process the correct records and do NOT allow reporting on them.
D. Get all new data in source request by request.
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. The query is running in a batch process.
C. There are non-cumulative key figures in the InfoCubes.
D. The query is configured for nonparallel processing.
E. There are insufficient background processes at execution time.
Which of the following are true in designing aggregates?
There are 3 correct answers.
A. Multiple aggregates should be designed to fit into a rollup hierarchy.
B. Aggregates containing navigational attributes can be larger than aggregates based on dimensional characteristics.
C. Aggregates are evaluated by the BW system based on usage and number of records.
D. Aggregates can share dimension tables with the InfoCube.
E. Time-dependent aggregates can be adjusted upon changes of the key date only through process chains.
What is the purpose of the Enterprise Data Warehouse (EDW) Layer? (2)
A. To ensure vertical consistency of the data flow
B. To provide a layer where data can be overwritten to reflect the current status of business transactions
C. To provide an enterprise wide repository of business data at a summary level
D. To ensure that data is only extracted once from source systems
Partitioning can be used to either aid query response time or manage large amounts of InfoCube data.
Which of the following statements are true about InfoCube partitioning? There are 2 correct answers.
A. Logical and table partitioning cannot be combined.
B. The Analytic Engine can do partition pruning.
C. Table partitions are based either on 0CALMONTH or 0FISCPER.
D. The Repartitioning toolbox can be used with logical partitioning.
Which of the following are true regarding Aggregates? There are 3 correct answers.
A. They are intended to increase query performance.
B. They can be created for DataStore Objects.
C. They can be created with reference to a time-dependent navigational attribute.
D. They are flat when containing 15 or less user-defined Characteristics.
E. Flat aggregates have no effect on query performance.
Which of the following are true about the process step options Repair and Repeat? There are 3 correct answers.
A. Repeat schedules the process chain for a future date.
B. Repair automatically fixes the error allowing the process chain to continue.
C. Repair uses the same step instance.
D. Certain steps can use either option.
E. Repeat begins a new step instance.
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only SAP exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your C_TBW60_74 exam preparations and SAP certification application, do not hesitate to visit our Vcedump.com to find your solutions here.