SAP SAP Certifications C_HANAIMP_17 Questions & Answers

• Question 31:

  How can you define a variable that presents its value help hierarchically?

  Note: There are2 correct answers to this question.

  A. Create a parent-child hierarchy and assign it to the variable. Ensure the variable's reference column is the parent attribute of the hierarchy.

  B. Create a parent-child hierarchy and assign it to the variable. Ensure the variable's reference column is the child attribute of the hierarchy.

  C. Create a level hierarchy and assign it to the variable. Ensure the variable's reference column is the leaf level of the hierarchy.

  D. Create a level hierarchy and assign it to the variable. Ensure the variable's reference column is the top level of the hierarchy.

  Correct Answer: C

• Question 32:

  Which of the following approaches improve the performance of joins in a cube calculation view? Note: There are 2 correct answers to this question.

  A. Use an inner join.

  B. Limit the number of joined columns.

  C. Implement pruning rules.

  D. Specify the join cardinality.

  Correct Answer: BD

• Question 33:

  Why do we support SQL development in SAP HANA data modeling projects?

  A. To provide access to your data model to additional client tools.

  B. To support development of custom logic within calculation views.

  C. To make changes to the runtime objects of your calculation view with SQL.

  D. As an alternative to developing calculation views when high performance is essential.

  Correct Answer: B

• Question 34:

  You combine two customer master data tables with a union node in a calculation view. Both master data tables include the same customer name. The same customer can exist in both tables. How do you ensure that each customer appears only once in the results?

  A. Add a minus node above the union node.

  B. Add an intersect node above the union node.

  C. Include an aggregation node above the union node.

  D. In the union node, map both source customer name columns to one target column.

  Correct Answer: C

• Question 35:

  Why does query performance decrease when the data volume of the delta storage is large?

  Note: There are 2 correct answers to this question.

  A. The data is unstructured.

  B. The data is uncompressed.

  C. The data is stored in the warm tier.

  D. The data is NOT sorted.

  Correct Answer: BD

• Question 36:

  What must you create to access a Predictive Analysis Library (PAL) procedure from inside your HDI container?

  A. Database connection

  B. Wrapper

  C. Function

  D. Synonym

  Correct Answer: C

• Question 37:

  Why might you use SAP HANA Graph with text analysis?

  A. To illustrate multi-point relationships between text entities

  B. To provide a visual method to build a custom text analysis

  C. To highlight similarities between documents using hierarchies

  D. To uncover the dependencies between parts of speech

  Correct Answer: B

• Question 38:

  You combine two tables in a join using multiple columns in each table. Why do you enable the dynamic join option?

  Note: There are 2 correct answers to this question.

  A. To allow data analysis at different levels of granularity with the same calculation view.

  B. To force the calculation at the relevant level of granularity, even if this level is not the grouping level defined by the query.

  C. To ensure that the join execution only uses the join columns requested in the query.

  D. To improve execution time under specific query conditions.

  Correct Answer: AC

• Question 39:

  What are the key steps to implement currency conversion in a calculation view?

  A. Enable the measure for conversion Choose client, source and target currencies Choose conversion date and rate type Build the conversion rule

  B. Enable the measure for conversion Choose client, source and target currencies Choose conversion date and rate type Assign the conversion rule to your calculation view

  C. Assign semantic type Choose client, source and target currencies Choose conversion date and rate type Define an expression in a calculated column

  D. Assign semantic type Enable the measure for conversion Choose client, source and target currencies Choose conversion date and rate type

  Correct Answer: D

• Question 40:

  What are the components of a custom text analysis?

  Note: There are 3 correct answers to this question.

  A. Rule set

  B. Python script

  C. Term Document Matrix

  D. Dictionary

  E. Configuration

  Correct Answer: ADE