SAP SAP Certifications C_HANAIMP_17 Questions & Answers

• Question 71:

  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

  Correct Answer: AB

• Question 72:

  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

  Correct Answer: A

• Question 73:

  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.

  Correct Answer: A

• Question 74:

  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

  Correct Answer: AB

• Question 75:

  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

  Correct Answer: AD

• Question 76:

  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

  Correct Answer: BD

• Question 77:

  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.

  Correct Answer: AB

• Question 78:

  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

  Correct Answer: CD

• Question 79:

  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

  Correct Answer: D

• Question 80:

  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

  Correct Answer: B