SAP C_HANAIMP_17 Online Practice Questions and Exam Preparation

SAP C_HANAIMP_17 Online Questions & Answers

• Question 31:

  Why do you use the debug query mode in a calculation view?

  A. To observe the generated SQL for each node
  B. To highlight potential performance issues at design-time
  C. To measure the overall run-time of the query
  D. To check which database engines will be invoked by each node
  A. To observe the generated SQL for each node

• Question 32:

  What do you use in the definition of a dynamic SQL analytic privilege?

  A. A procedure that returns the data access condition as an SQL expression.
  B. A table function that returns a list of allowed values.
  C. An organization hierarchy that provides role-based access to data.
  D. A scalar function that returns a list of the allowed values for each attribute.
  A. A procedure that returns the data access condition as an SQL expression.

• Question 33:

  Which tool do you use to display the generated SQL for each node of your calculation view?

  A. SQL Analyzer
  B. Debug Query Mode
  C. Plan Visualizer
  D. Performance Analysis Mode
  B. Debug Query Mode

• Question 34:

  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.
  B. Limit the number of joined columns.
  D. Specify the join cardinality.

• Question 35:

  In which of the following scenarios would you benefit from enabling table partitioning in SAP HANA?

  A. You have a large row store table that is consumed in a view with a variable on COUNTRY column.
  B. You have a large column store table that is consumed in a view with a variable on COUNTRY column.
  C. You have a dedicated table lo generate the lists of help values for an input parameter.
  D. Your stacked model consists of multiple calculation views.
  B. You have a large column store table that is consumed in a view with a variable on COUNTRY column.

• Question 36:

  You are a data analyst working with medical records that contain confidential patient information. Why do you use the anonymization node in a calculation view?

  Note: There are 2 correct answers to this question.

  A. To restrict data access for specific users or roles
  B. To hide individual patients in groups of similar records
  C. To provide partial value such as #34343#34##
  D. To add noise to the data to hide the actual values
  B. To hide individual patients in groups of similar records
  D. To add noise to the data to hide the actual values

• Question 37:

  Why do we use Git when modeling calculation views?

  A. Develop conceptual prototypes
  B. Enable collaboration between developers
  C. Provide access to external schemas
  D. Control specifically object versioning
  D. Control specifically object versioning

• Question 38:

  You created a table function to remove previous records, sum the current total weekly working hours for each employee, and updated the personnel table. The build of the table function fails. Which of the following could be a valid reason?

  A. You did NOT define a valid table type.
  B. Your function refers to a scalar function.
  C. You did not define at least one input parameter.
  D. Your function includes a TRUNCATE statement
  D. Your function includes a TRUNCATE statement

• Question 39:

  Using the table in the diagram, you need to create a cube calculation view. What is the simplest approach to create the output from the screen shot?

  

  A. Create a restricted column for each year.
  B. Implement a union node and map each year as a separate column.
  C. Create 3 calculated columns.
  D. Create a filter expression that uses an OR operator.
  A. Create a restricted column for each year.

• Question 40:

  You created a table using the SQL conSQLe inside the HANA Deployment Infrastructure (HDI) container of your project. You add this table as a data source to a calculation view and try to build it. What do you observe in the SAP HANA database container?

  A. The build is successful, and you get the expected data.
  B. The build fails, and the table is dropped.
  C. The build fails but the table is not dropped.
  D. The build is successful, but the data preview is empty.
  D. The build is successful, but the data preview is empty.

  ---

  Explanation/Reference: