SAP SAP Certifications C_HANAIMP_12 Questions & Answers

• Question 111:

  Where do you graphically create a design-time role in SAP HANA? Please choose the correct answer. Response:

  A. In the Security area of the SAP HANA web-based development workbench

  B. In the Repository area in the development perspective in SAP HANA studio

  C. In the Roles area under Security in SAP HANA studio

  D. In the Editor area of the SAP HANA web-based development workbench

  Correct Answer: D

• Question 112:

  You want to publish your business intelligence content directly to SAP Cloud for Analytics. Which tool do

  you use?

  There are 2 correct answers to this question.

  Response:

  A. SAP Crystal Reports for Enterprise

  B. SAP Lumira

  C. SAP BusinessObjects Analysis, edition for Microsoft Office

  D. SAP Predictive Analytics

  Correct Answer: BD

• Question 113:

  A referential join gives the same results as which other join type? Please choose the correct answer. Response:

  A. Left outer join

  B. Spatial join

  C. Inner join

  D. Star join

  Correct Answer: C

• Question 114:

  Which are the recommended assignments in SAP HANA?

  There are 2 correct answers to this question.

  Response:

  A. Privileges to users

  B. Roles to roles

  C. Roles to privileges

  D. Roles to users

  Correct Answer: BD

• Question 115:

  What can you do in the Raw tab of the data preview in SAP HANA studio? There are 2 correct answers to

  this question.

  Response:

  A. Create a graph while analyzing the entire data result set.

  B. Sort the entire data result set and show the top 200 records.

  C. Show all distinct values in the entire data result set.

  D. Export the entire data result set to your local machine.

  Correct Answer: BD

• Question 116:

  What paradigm describes the SQL language? Please choose the correct answer. Response:

  A. Object-oriented

  B. Set-oriented

  C. Application-focused

  D. Procedural

  Correct Answer: B

• Question 117:

  Of which SAP HANA process are the transaction manager and page manager a part? Please choose the

  correct answer.

  Response:

  A. SAP HANA XS server

  B. Name server

  C. Index server

  D. Statistics server

  Correct Answer: C

• Question 118:

  You need a business intelligence tool that is Microsoft Excel-based and can use parent-child hierarchies.

  Which tool do you use?

  Please choose the correct answer.

  Response:

  A. SAP BusinessObjects Web Intelligence

  B. SAP Lumira

  C. SAP BusinessObjects Analysis, edition for OLAP

  D. SAP BusinessObjects Design Studio

  Correct Answer: A

• Question 119:

  You are given an old government paper form with lines, blocks, and fields. You are asked to create a

  report that looks like this form. Which business intelligence tools do you use? Please choose the correct

  answer.

  Response:

  A. SAP BusinessObjects Design Studio

  B. SAP Crystal Reports for Enterprise

  C. SAP Lumira

  D. SAP BusinessObjects Web Intelligence

  Correct Answer: B

• Question 120:

  What performance technique should you implement to improve the performance of SAP HANA information

  views that include SQLScript?

  Please choose the correct answer.

  Response:

  A. Use SELECT *.

  B. Break large statements into smaller steps.

  C. Use imperative logic.

  D. Use dynamic SQL

  Correct Answer: B