SAP SAP Certifications C_HANAIMP_17 Questions & Answers

• Question 21:

  You have a calculation view which includes nodes as shown in the graphic. You decide to select the "Ignore Multiple Output for Filters" check box on Projection Node 3. What might the effects of this be?

  Note: There are 2 correct answers to this question.

  

  A. The view will return the profit calculation for only the US

  B. A change to the data that is returned by the view

  C. Increased performance

  D. Decreased performance

  Correct Answer: AC

• Question 22:

  What does SAP HANA provide to support native application development?

  Note: There are 3 correct answers.

  A. Embedded SAP Business Warehouse(BW)

  B. Project management tools

  C. Built- in application server

  D. Multiple development languages

  E. Choice of deployment to cloud or on-premise

  Correct Answer: CDE

• Question 23:

  Which is the correct syntax when you refer to an input parameter in a calculation view expression?

  A. $$Choose_Country$S

  B. :Choose_Country

  C. ..Choose_Country"

  D. @Choose_Country

  Correct Answer: A

• Question 24:

  When would you develop an SQL procedure instead of a function?

  A. You need to implement Data Definition Language (DDL) statements.

  B. The code should modify data in the table.

  C. Optimal performance is apriority.

  D. You need to use conditional logic.

  E. You want to create a dynamic analytic privilege.

  Correct Answer: B

• Question 25:

  Why do you implement Active / active read-enabled mode?

  A. To enhance security for data access

  B. To provide offline access to data

  C. To improve query performance

  D. To synchronize query results with operational data

  Correct Answer: D

• Question 26:

  Which of the following techniques can you use to improve the performance of calculation views?

  Note: There are 2 correct answers to this question.

  A. Limit the number of stacked calculation views

  B. Avoid aggregating data early in the dataflow

  C. Implement union pruning

  D. Partition large tables

  Correct Answer: AD

• Question 27:

  Why do you use parameter mapping in a calculation view?

  Note: There are 2 correct answers to this question.

  A. To convert the data types of input parameters

  B. To push down filters to the lowest level calculation views

  C. To pass variable values to external value help views

  D. To enable an input parameter in a calculation view

  Correct Answer: BC

• Question 28:

  What can you extract using the standard text analysis configuration: Voice of the Customer? Note: There are 2 correct answers to this question.

  A. Recommendations

  B. Sentiments

  C. Suggestions

  D. Requests

  Correct Answer: BD

• Question 29:

  Which of the following are usually no longer required in the architecture of SAPS/4HANA? Note: There are 2 correct answers to this question.

  A. Aggregates

  B. ABAP CDS

  C. Synonyms

  D. Indexes

  Correct Answer: AC

• Question 30:

  What can you identify using the Performance Analysis Mode?

  Note: There are 2 correct answers to this question.

  A. Usage statistics of the calculation view

  B. Joins that are defined on calculated columns

  C. If the data is in the hot or warm storage tier

  D. Information about join cardinality

  Correct Answer: BD