SAP SAP Certifications C_HANAIMP_12 Questions & Answers

• Question 101:

  In which package in SAP HANA will you find the SAP HANA Live views? Please choose the correct

  answer.

  Response:

  A. /public

  B. /sap/hana/democontent

  C. /sap/be

  D. /sap/hba

  Correct Answer: D

• Question 102:

  Which of the following database terms are used when providing OLAP data with hierarchies? There are 3

  correct answers to this question.

  Response:

  A. BICS

  B. ODBC

  C. MDX

  D. JDBC

  E. ODBO

  Correct Answer: ACE

• Question 103:

  Which business intelligence tools use BICS connectivity to SAP HANA? There are 2 correct answers to

  this question.

  Response:

  A. SAP BusinessObjects Design Studio

  B. Microsoft Excel

  C. SAP Lumira

  D. SAP BusinessObjects Analysis, edition for Microsoft Office

  Correct Answer: AD

• Question 104:

  You create a full-text index. For what text feature clause do you need to specify a configuration? Please

  choose the correct answer.

  Response:

  A. TEXT MINING

  B. TEXT ANALYSIS

  C. FUZZY SEARCH INDEX

  D. SEARCH ONLY

  Correct Answer: B

• Question 105:

  Which modeling views are fading out and are not available in the SAP HANA web-based development

  workbench?

  There are 2 correct answers to this question.

  Response:

  A. Attribute views

  B. Analytic views

  C. Graphical calculation views

  D. Scripted calculation views

  Correct Answer: AB

• Question 106:

  You have created a SQL analytic privilege on an information view. Where do you tell the view to enable

  SQL analytic privileges?

  Please choose the correct answer.

  Response:

  A. In the SAP HANA studio preferences

  B. In the migration tool

  C. In the restrictions settings of the SQL analytic privilege

  D. In the semantic node of the information model

  Correct Answer: D

• Question 107:

  What performance techniques should you implement to improve the performance of SAP HANA

  information views?

  There are 3 correct answers to this question.

  Response:

  A. Push down aggregations to SAP HANA.

  B. Perform calculation before aggregation in your analytic views.

  C. Minimize the transfer of data between the execution engines.

  D. Investigate partitioning of large tables.

  E. Apply filters as late as possible.

  Correct Answer: ACD

• Question 108:

  What can a variable be used for? Please choose the correct answer. Response:

  A. Currency conversion

  B. Calculated column expression

  C. Call decision table in SQLScript

  D. Filtering

  Correct Answer: D

• Question 109:

  Which business intelligence tool can publish storyboards? Please choose the correct answer. Response:

  A. SAP BusinessObjects Design Studio

  B. SAP BusinessObjects Web Intelligence

  C. SAP Predictive Analytics

  D. SAP BusinessObjects Analysis, edition for Microsoft Office

  Correct Answer: C

• Question 110:

  In which direction do you build calculation views when including the source tables in join nodes? Please

  choose the correct answer.

  Response:

  A. From the join node down to the default node

  B. From the semantic node down to the join nodes

  C. From the semantic node up to the default node

  D. From the join nodes up to the semantic node

  Correct Answer: D