Practice Question Answers and Explanations

1. Correct answers: C, D

   You can create calculated columns in a join node and a projection node.

2. Correct answer: B

   You use a level hierarchy to build a hierarchy on a time-based data structure. Time-based means you have year on level 1, months on level 2, days on level 3, and hours on level 4. A parent-child hierarchy can be time-dependent. (The words are confusing, so watch out.)

   Ragged and unbalanced hierarchies are not mentioned in SAP HANA.

3. Correct answers: A, C

   Features of a calculated column:

   • It is a column in the result set.
   • It is created in the output area.
   • Its calculations are NOT persisted! It is NOT created in the semantics nodes.
4. Correct answers: B, C, E

   You can show a male and female option to users with either variables or input parameters, and then opening the value help.

   Domain fix values can be used for filtering. Male and female got mentioned in this section, but the context was completely different.

5. Correct answers: A, B, D

   The options you have for the target currency field in a currency conversion are:

   • Select a fixed currency
   • Select a column
   • Use an input parameter
6. Correct answers: A, D

   You can use table types and calculation views as data sources for a decision table. Scalar functions do not return table-type data. More information will be available in the next chapter.

7. Correct answer: B

   You create a variable in the semantics node.

8. Correct answers: A, C

   You show the total number of website visitors that used a mobile phone by creating either a restricted column or a filter expression. An action is part of decision tables. A rank column will rank then by numbers, not show the total number. (You could perhaps rank all the data, rank the data, and then search for the total number in the rankings. So technically it is possible, but requires that you still manually search the correct output.)

9. Correct answer: C

   A level hierarchy can enable drill-down in a value help list. Only parent-child hierarchies have time-dependency, variable deepness in the data, and can be used for a bill of materials structure.

10. Correct answer: D

    A variable can be used for filtering. You will use input parameters for currency conversion, and in calculated column expression. The input parameters when calling a decision table in SQLScript is different from the input parameters discussed in this chapter.

11. Correct answer: C

    Decimal shift is used for currencies with more than two decimal places. Decimal shift back is used to undo the decimal adjustment for ABAP.

12. Correct answer: B

    You use an interval variable type if you want to allow the user to choose dates from 2011 to 2014. Range would allow for year > 2011. Do not confuse the range type with the interval type.

13. Correct answer: C

    You create a calculation view with a counter in an aggregation node to find the number of unique items sold per shop. You need a counter for this, so two answers are eliminated. A calculation view with a counter in a projection node is not valid because a counter cannot be created in a projection node.

14. Correct answers: C, D

    You use actions and conditions in the output area of a decision table node. Input parameters are not the same as vocabulary parameters.

15. Correct answers: A, B, C

    You can use SAP client restrictions, domain fix values, and filter expressions to limit the number of records produced by a calculation view. Restricted columns do not restrict the number of records.

16. Correct answer: C

    If you get errors in a calculated column in an analytic view, you must enable the Calculate Before Aggregation flag.

17. Correct answer: C

    You can only create a filter expression in a projection node.

18. Correct answer: D

    You use a decision table to run simulations on the year-end financial data.

19. Correct answer: B

    You need the TCUR* tables for currency conversion. You need the DD07* tables for domain fix values.

20. Correct answer: D

    You use an input parameter from the semantics node (that is where it gets created) to build a financial report for the company’s board members that allows them to choose if they want the report to be in euros or dollars. You just reference the already created input parameter in the currency conversion.

21. Correct answer: D

    You use a Column type of input parameter to choose the data from a field in the current table. The Direct type is used to directly type in values. The Derived From Table type is used to get data from another table.