SAP C_HANAIMP_17 Online Practice Questions and Exam Preparation

SAP C_HANAIMP_17 Online Questions & Answers

• Question 61:

  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
  B. Joins that are defined on calculated columns
  D. Information about join cardinality

• Question 62:

  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
  A. Aggregates
  C. Synonyms

• Question 63:

  Which types of data are used to represent spatial information?

  Note: There are 2correct answers to this question.

  A. Column data
  B. Vector data
  C. Raster data
  D. Graph data
  B. Vector data
  C. Raster data

• Question 64:

  Which of the following are warm tier Solutions? Note: There are 3 correct answers.

  A. Active / active read-enabled mode
  B. Native Storage Extension
  C. Extension Node
  D. Dynamic Tiering
  E. Persistent Memory
  C. Extension Node
  D. Dynamic Tiering
  E. Persistent Memory

  ---

  Explanation/Reference:

• Question 65:

  Why does SAP issue warnings about the use of imperative or procedural SQL Script statements?

  A. They can harm SQL optimization.
  B. NOT all reporting tools can consume the results.
  C. They introduce potential security risk.
  D. They call multiple processing engines
  C. They introduce potential security risk.

• Question 66:

  You have made changes to the design-time files of several calculation views in your DEV environment. These calculation views belong to the same project. Before deploying your calculation views to a PROD environment, which sequence of steps is required in the DEV environment?

  A. Export the HDB module -> Export the project
  B. Build the HDB module -> Build the project
  C. Activate the project -> Build the HDB module
  D. Build the project -> Build the HDB module
  D. Build the project -> Build the HDB module

• Question 67:

  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
  B. To push down filters to the lowest level calculation views
  C. To pass variable values to external value help views

• Question 68:

  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
  A. The view will return the profit calculation for only the US
  C. Increased performance

• Question 69:

  Referring to the diagram, which privileges would a user require to view United States data when querying the CUBE Calculation view?

  

  A. Analytic Privileges and SELECT privileges on the CUBE Calculation view
  B. A SELECT privilege and an Analytic Privilege (Country = United States) on the DIMENSION Calculation view
  C. A SELECT privilege on the CUBE and an Analytic Privilege (Country = United States) on the DIMENSION Calculation view
  D. SELECT or Privileges and Analytic Privileges on both views
  C. A SELECT privilege on the CUBE and an Analytic Privilege (Country = United States) on the DIMENSION Calculation view

• Question 70:

  You want to create a star schema using a calculation view. The measures are based on columns from two transaction tables. Dimension calculation views provide the attributes.

  What is the correct approach?

  A. Combine the transaction tables using a join node in a calculation view of type cube. Use the multi-join capability of the join node to connect the transactional tables with the dimension calculation views.
  B. Combine the transaction tables using a star join node in a calculation view of type cube with star join. Use a join node to join the dimensions to the fact table.
  C. Combine the transaction tables using an aggregation node in a calculation view of type cube with star join. Use a star join node to join the dimensions to the fact table.
  D. Combine the transaction tables using a join node in a calculation view of type cube with star join. Use a star join node to join the dimensions to the fact table.
  D. Combine the transaction tables using a join node in a calculation view of type cube with star join. Use a star join node to join the dimensions to the fact table.