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.Reporting tools
• C.Text analytics
• D.Calculation views
• E.Security

Comment: *

Name: *

Email: *

Verification: *

What are the advantages of columnar storage?
There are 2 correct answers to this question.
Response:

• A.Improved compression
• B.Improved data writing performance
• C.Improved performance when all fields are selected
• D.Improved data reading performance

Comment: *

Name: *

Email: *

Verification: *

Using the table in the diagram, you need to create a cube calculation view. What is the simplest approach to create the output form the screenshot?
Please choose the correct answer.
Table A Output A
Year Value 2014 2015 2016
2014 100 300 500 200
2014 200
2015 100
2015 100
2015 200
2015 100
2015 200
Response:

• A.Create a filter expression that uses an OR operator
• B.Implement a union node and map each year as a separate column
• C.Create a restricted column for each year

Comment: *

Name: *

Email: *

Verification: *

Why do you use a hierarchy function node in a calculation view?

• A.To enable hierarchical navigation in reporting tools
• B.To assist the developer by visualizing hierarchies
• C.To generate additional Meta data that can be used for analysis of a hierarchy structure
• D.To display value help using hierarchies

Comment: *

Name: *

Email: *

Verification: *

In which programming languages can you create procedures in SAP HANA?
There are 2 correct answers to this question.
Response:

• A.L
• B.JavaScript
• C.R
• D.SQLScript

Comment: *

Name: *

Email: *

Verification: *