SAP C_HANAIMP_17 Online Practice Questions and Exam Preparation

SAP C_HANAIMP_17 Online Questions & Answers

• Question 1:

  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 2:

  When you create a full text index, why do you specify FAST_PREPROCESS OFF?

  A. To avoid the generation of the term document matrix
  B. To prevent the creation of a fuzzy search index
  C. To generate text analysis results in multiple languages
  D. To enable a full linguistic search
  D. To enable a full linguistic search

• Question 3:

  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 4:

  After importing a project in the workspace of the Web IDE, you try to build the HDB module. The build fails. What could be the reason?

  Note: There are 2 correct answers.

  A. The HDB module references a user-provided service that does not exist.
  B. You have assigned the project to a space that you do not have developer authorizations for.
  C. You have not built the project.
  D. The project is not assigned to a space.
  A. The HDB module references a user-provided service that does not exist.
  B. You have assigned the project to a space that you do not have developer authorizations for.

• Question 5:

  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 6:

  How can you optimize performance when writing SQL for use with calculation views?

  Note: There are 2 correct answers to this question.

  A. Use declarative language instead of cursors
  B. Use calculation engine (CE) functions instead of plain SQL
  C. Control the flow logic using IF-THEN-ELSE conditions
  D. Increase parallelization by using variables to break up statements
  A. Use declarative language instead of cursors
  D. Increase parallelization by using variables to break up statements

• Question 7:

  Which of the following data sources can you include in a graphical calculation view?

  Note: There are 2 correct answers to this question.

  A. SQL view
  B. Table function
  C. Scalar function
  D. Procedure
  A. SQL view
  B. Table function

• Question 8:

  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 9:

  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 10:

  What can you use SAP HANA smart data access for?

  Note: There are 2 correct answers to this question.

  A. To push down queries to data sources
  B. To expose data from remote tables
  C. To load and harmonize data from disparate sources
  D. To replicate remote data sources
  A. To push down queries to data sources
  B. To expose data from remote tables