SAP C_HANAIMP_17 Online Practice Questions and Exam Preparation

SAP C_HANAIMP_17 Online Questions & Answers

• Question 41:

  You deleted the design-time file of a calculation view in your HDB module.

  Which of the following is the optimal way to ensure that the corresponding runtime object is also removed from the database? Note: There are 2 correct answers to this question.

  A. Delete the folder that contained the deleted design-time file.
  B. Build the folder that contained the deleted design-time file.
  C. Build the project that contained the deleted design-time file.
  D. Run a DELETE statement in an SQL console connected to the HDI container.
  B. Build the folder that contained the deleted design-time file.
  C. Build the project that contained the deleted design-time file.

  ---

  Explanation/Reference:

• Question 42:

  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.
  C. Create a level hierarchy and assign it to the variable. Ensure the variable's reference column is the leaf level of the hierarchy.

• Question 43:

  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
  C. Built- in application server
  D. Multiple development languages
  E. Choice of deployment to cloud or on-premise

  ---

  Explanation/Reference:

• Question 44:

  What type of data is relevant for SAP HANA Graph modeling?

  A. Highly-networked
  B. Timeseries
  C. Hierarchical data
  D. Forecast
  A. Highly-networked

• Question 45:

  What are the components of a graph workspace?

  Note: There are 2 correct answers to this question.

  A. Dimension
  B. Vertex
  C. Edge
  D. Association
  B. Vertex
  C. Edge

• Question 46:

  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
  D. Assign semantic type Enable the measure for conversion Choose client, source and target currencies Choose conversion date and rate type

• Question 47:

  In SAP Web IDE for SAP HANA, what can a flowgraph generate in a predictive analysis scenario?

  Note: There are 2 correct answers to this question.

  A. Function
  B. Container
  C. Procedure
  D. Task
  C. Procedure
  D. Task

• Question 48:

  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.
  A. To allow data analysis at different levels of granularity with the same calculation view.
  C. To ensure that the join execution only uses the join columns requested in the query.

• Question 49:

  A calculation view includes a rank node that uses the source data and settings shown in the graphic. Your query requests all columns of the rank node. How many rows are in the output of your query?

  

  A. 6
  B. 9
  C. 2
  D. 5
  B. 9

• Question 50:

  In a calculation view, which object type do you assign to a projection node to consume a Predictive Analysis Library (PAL) function?

  A. Synonym
  B. Scalar function
  C. Table function
  D. Input parameter
  C. Table function