Which of the following techniques can you use to improve the performance of calculation views?
There are 2 correct answers to this question.
Response:

• A.Partition large tables
• B.Implement union pruning
• C.Avoid aggregating data early in the data flow
• D.Minimize layering of calculation views

Comment: *

Name: *

Email: *

Verification: *

What must be installed for PAL to work?
Please choose the correct answer.
Response:

• A.SAP HANA BFL
• B.SAP HANA AFL
• C.SAP HANA AFM
• D.SAP HANA SINA

Comment: *

Name: *

Email: *

Verification: *

Which interface client is used for XSA application development?
Please choose the correct answer.
Response:

• A.SAP Web IDE for SAP HANA
• B.SAP HANA Studio
• C.SAP HANA Web-based Workbench
• D.SAP Web IDE

Comment: *

Name: *

Email: *

Verification: *

Where do you use SQLScript outside of the development environment discussed in this chapter?
There are 3 correct answers to this question.
Response:

• A.Creating tables
• B.Calculation views
• C.Reporting tools
• D.Text analytics
• E.Security

Comment: *

Name: *

Email: *

Verification: *

You created a user-defined function with a return type of BIGINT. What type of function have you created?
Please choose the correct answer.
Response:

• A.Window function
• B.Table function
• C.SQL function
• D.Scalar function

Comment: *

Name: *

Email: *

Verification: *