SAP SAP Certifications C_HANAIMP_12 Questions & Answers

• Question 81:

  You have a list of map locations for clinics. The government wants to build a new clinic, but wants to build

  it where there is the greatest need.

  You need to find the largest distance between any two clinics. With your current knowledge, how do you do

  this?

  Please choose the correct answer.

  Response:

  A. Use a temporal join to find the distance between clinics. Use a union with constant values to "pivot" the values.

  B. Use a dynamic join to find the longest distance between clinics. Use a ranking to find the top 10 values.

  C. Use a spatial join to find the distance between clinics. Use an aggregation with the maximum option.

  D. Use a spatial join to find the distance between clinics. Use a level hierarchy for drilldown.

  Correct Answer: C

• Question 82:

  What is the correct sequence for loading data with SAP Data Services? Please choose the correct answer. Response:

  A. Extract Transform Load

  B. Load Transform Extract

  C. Extract Load Transform

  D. Load Extract Transform

  Correct Answer: A

• Question 83:

  You are working with a currency measure. What is decimal shift used for? Please choose the correct answer. Response:

  A. Avoid rounding errors during the conversion

  B. To undo the decimal adjustment for ABAP

  C. For currencies with more than two decimal places

  D. Increase the accuracy of the currency conversion

  Correct Answer: C

• Question 84:

  Where in SAP HANA studio can you unload a table's data from memory? Please choose the correct

  answer.

  Response:

  A. The list of export destinations

  B. The data preview of the table

  C. The context menu of the table

  D. The table definition

  Correct Answer: C

• Question 85:

  What can be a remote data source for SAP HANA Remote Data Sync? Please choose the correct answer. Response:

  A. SAP ASE

  B. UltraLite

  C. SAP IQ

  D. Hadoop

  Correct Answer: B

• Question 86:

  You want to call a procedure in a SELECT statement (like a table function). Which clauses do you have to

  specify?

  There are 2 correct answers to this question.

  Response:

  A. READS SQL DATA

  B. LANGUAGE SQLSCRIPT

  C. SEQUENTIAL EXECUTION

  D. WITH RESULTS VIEW

  Correct Answer: AD

• Question 87:

  Prior to modeling in SAP HANA, you want to check whether a table is row-based or column-based. How

  can you do this in the SAP HANA studio?

  There are 2 correct answers to this question.

  Response:

  A. Select the Open Content option.

  B. Select the Open Definition option.

  C. Select the Open Data Preview option.

  D. View the icon of the table.

  Correct Answer: BD

• Question 88:

  Which tables do you need for currency conversion?

  Please choose the correct answer.

  Response:

  A. TCUR*

  B. BICS*

  C. SHINE*

  D. DD07*

  Correct Answer: A

• Question 89:

  You get the following requirements from a customer: They have a lot of purchasing data in their SAP

  system which they wish to analyze in SAP HANA.

  They want to have reports every morning showing the total expenditure per department. Their SAP BW

  developers have not yet had any SAP HANA training.

  Which data provisioning tool would you recommend?

  Please choose the correct answer.

  Response:

  A. DXC

  B. EIM

  C. SDA

  D. SLT

  Correct Answer: A

• Question 90:

  What performance technique should you implement to improve join performance? Please choose the

  correct answer.

  Response:

  A. Use joins instead of unions for combining large data sets.

  B. Join on key fields between tables in a dimension view.

  C. Do NOT use dynamic joins if you require optimal performance.

  D. Always use referential joins in star join views.

  Correct Answer: B