SAP SAP Certifications C_HANAIMP_12 Questions & Answers

• Question 141:

  Global session variables can be used in SQLScript to share a scalar value between procedures and

  functions that are running in the same session.

  The value of a global session variable is not visible from another session.

  Please choose the correct answer. Response:

  A. SET = ;

  B. SET = ;

  C. SET = ;

  D. SET = ;

  Correct Answer: A

• Question 142:

  Response:

  A. Physical data warehouse

  B. Logical data warehouse

  C. Big data

  D. Real-time replication

  E. Data federation

  Correct Answer: BCE

• Question 143:

  Which sentence best describes SAP HANA Live?

  Please choose the correct answer.

  Response:

  A. Analytical reporting moving back to the OLAP system

  B. Operational reporting moving back to the OLTP system

  C. Operational reporting moving back to the OLAP system

  D. Analytical reporting moving back to the OLTP system

  Correct Answer: B

• Question 144:

  You have a view with two tables, joined by a left outer join. If you redesign the view and accidently swap

  the two tables around, what should you do to the join? Please choose the correct answer.

  Response:

  A. Change the join to a referential join.

  B. Keep the left outer join.

  C. Change the join to a text join.

  D. Change the join to a right outer join.

  Correct Answer: D

• Question 145:

  What PAL algorithm category can you use for supervised learning? Please choose the correct answer. Response:

  A. Association

  B. Clustering

  C. Classification

  D. Social network analysis

  Correct Answer: C

• Question 146:

  What combination enabled real-time computing?

  Please choose the correct answer.

  Response:

  A. Multicore CPUs and solid-state disks

  B. In-memory technology with solid-state disks

  C. Multicore CPUs with large level 1 caches

  D. In-memory technology and multicore CPUs

  Correct Answer: D

• Question 147:

  Which of the following views can you extend with the SAP HANA Live Extension Assistant? Please choose

  the correct answer.

  Response:

  A. Your own custom views

  B. Reuse views

  C. Query views with a union

  D. All SAP-delivered views

  Correct Answer: B

• Question 148:

  You want to use a field in a formula but do not want to expose the values of the original field to the end

  users. What do you do?

  Please choose the correct answer.

  Response:

  A. Mark the field as hidden

  B. Make the field a key column

  C. Change the data type of the field

  D. Rename the field

  Correct Answer: A

• Question 149:

  Where in the Systems view of SAP HANA studio can you create new SAP HANA models? Please choose

  the correct answer.

  Response:

  A. In the packages of the Catalog area

  B. In the schemas of the Content area

  C. In the schemas of the Catalog area

  D. In the packages of the Content area

  Correct Answer: D

• Question 150:

  You build a financial report for the company's board members that allows them to choose if they want the

  report to be in euros or dollars.

  What do you use?

  Please choose the correct answer.

  Response:

  A. A variable from the semantics node

  B. A variable from a projection node

  C. An input parameter from an aggregation node

  D. An input parameter from the semantics node

  Correct Answer: D