SAP HANA: Certification Questions 411 through 420

QUESTION: 411

A calculation view that joins one fact table with dimension tables performs slowly. 
Which of the following can you do to improve performance?

A. Turn the calculation view into an analytic view

B. Turn the calculation view into a simple calculation view

C. Load the calculation view into memory

D. Load the calculation view into the _SYS_BI schema

Answer: A

QUESTION: 412

You have to do reverse pivot transformations on large data tables before loading the data into SAP HANA. 
Which of the following do you recommend to use?

A. SAP Landscape Transformation (SLT) 

B. SAP BusinessObjects Data Services 4.0 

C. SAP HANA Direct Extractor Connection (DXC)

D. SAP System Landscape Directory (SLD)

Answer: B

QUESTION: 413

You need to run a Web Intelligence report that requires data from SAP HANA filtered for a specific year based on Ad hoc user input.  
For best performance, how would you achieve this?

A. Use a pre-defined prompt based on a self-join in the business layer

B. Use input from a Web Intelligence report passed to a variable in an information model

C. Use a dynamic transformation rule during data provisioning

D. Use a prompt in the query of the Web Intelligence report

Answer: B

QUESTION: 414

Your SAP BusinessObjects report runs slowly. Which of the following actions could improve the performance?
Note: There are multiple correct answers to the question

A. Restrict data by using variables in the information model

B. Tune the Array Fetch Size parameter of the universe

C. Move calculated measures from the information model to the report

D. Join all the analytic views with each other in the business layer

Answer: A, B

QUESTION: 415

A company loads data every night from several source systems into multiple tables in SAP HANA using complex transformation rules. The calculation view that joins these tables performs unexpectedly slow. 
Which of the following could you investigate to be able to improve performance?
Note: There are multiple correct answers to the question

A. Whether the joins and transformations of the tables can be moved to the data loading process of SAP BusinessObjects Data Services

B. Whether an InfoCube compression is running

C. Whether the calculation view needs to create large intermediate result sets

D. Whether savepoints are written during execution

Answer: A, C

QUESTION: 416

How can you improve the performance of a report that is based on SAP HANA data?
Note: There are multiple correct answers to the question

A. Ensure that all SAP HANA tables are in the same schema

B. Maintain appropriate constraint filters in SAP HANA

C. Ensure that all calculations are pushed down to the SAP HANA database

D. Gather new database statistics

Answer: B, C

QUESTION: 417

You discover row count discrepancies between source data and SAP HANA information models. 
Which of the following can you investigate to find the source of the discrepancies?
Note: There are multiple correct answers to the question

A. Client filtering in the Delivery unit view

B. Joins in information models

C. Memory leaks

D. Client filtering in SAP Landscape Transformation (SLT)

Answer: B, D

QUESTION: 418

When you load data from SAP ECC using SAP BusinessObjects Data Services, where would you create an ABAP data flow?

A. In a query transformation 

B. In a batch job 

C. In the ABAP editor (transaction SE38) 

D. In the Job overview (transaction SM37)

Answer: B

QUESTION: 419

When must you create a calculation view in SAP HANA?
Note: There are multiple correct answers to the question

A. When you need to perform join operations

B. When you need calculations before aggregations

C. When key figures span across tables

D. When you need to perform a union of base tables

Answer: C, D

QUESTION: 420

In which of the following can you use a FOR loop over your data?

A. Monitoring View

B. Calculation View 

C. Analytic View

D. Attribute View 

Answer: B