SAP SAP Certifications C_HANAIMP_12 Questions & Answers

• Question 201:

  What does SAP recommend to improve performance of data models in SAP HANA?

  A. Move intensive calculations to the front-end application

  B. Perform calculation before aggregation

  C. Utilize as many different engines as possible

  D. Minimize data transfer between the engines

  Correct Answer: D

• Question 202:

  You want to report on data from SAP HANA using MS Excel. How can you achieve this? (Choose two)

  A. Select an analytic view using the Data Connection wizard.

  B. Create a ODBC connection between SAP HANA and MS Excel.

  C. Select an attribute view using the Data Connection wizard.

  D. Create an ODBO connection between SAP HANA and MS Excel.

  Correct Answer: AD

• Question 203:

  Exhibit:

  

  Which SAP BusinessObjects reporting tool can you use to create a report as shown in the attached screenshot?

  A. Web Intelligence

  B. Crystal Reports

  C. Analysis, edition for OLAP

  D. Dashboard

  Correct Answer: D

• Question 204:

  You have created several information models. A colleague of yours needs to be able to work on your information models.

  Which privileges do you give your colleague?

  A. Analytic privileges

  B. Package privileges

  C. Dynamic analytic privileges

  D. Object privileges

  Correct Answer: B

• Question 205:

  You create an analytic view and want to restrict access to departments with specific values using analytic privileges. Which tasks do you have to perform to accomplish this? (Choose three)

  A. Assign restricted values to the attribute view.

  B. Assign values to be restricted. Choose at least one information model to assign restrictions.

  C. Assign the analytic privilege to a user or role.

  D. Assign values to be restricted to a content table.

  E. Choose an attribute to define restricted values for it.

  Correct Answer: BCE

• Question 206:

  Where can you reactivate a user after too many invalid logon attempts? (Choose two)

  A. In the INVALID_CONNECT_ATTEMPS view

  B. In the user-specific schema

  C. In the user properties in the SAP HANA studio

  D. In the SQL Console

  Correct Answer: CD

• Question 207:

  Which of the following can you use to implement currency conversion in an information model? (Choose two)

  A. A calculated column in a calculation view

  B. A calculated column in an attribute view

  C. A calculated column in an analytic view

  D. A restricted column in an analytic view

  Correct Answer: AC

• Question 208:

  You are using SAP BusinessObjects Data Services as your ETL tool. What is the next step required after you have created the DataStore and imported the metadata from an SAP ERP system into SAP HANA?

  A. Import data from the SAP ERP system into SAP HANA.

  B. Create an SAP BusinessObjects Data Services job to migrate data to SAP HANA.

  C. Import the metadata from SAP HANA into SAP BusinessObjects Data Services.

  D. Create a connection in SAP BusinessObjects Data Services to the SAP ERP system.

  Correct Answer: C

• Question 209:

  What is the advantage of reporting directly from column tables?

  A. It provides multi-language support

  B. It eliminates the need for additional modeling

  C. It shifts complex calculations and logic to SAP HANA

  D. It supports analytical privileges

  Correct Answer: B

• Question 210:

  Which of the following SAP HANA schemas contains the runtime objects of activated views?

  A. _SYS_STATISTICS

  B. _SYS_REPO

  C. _SYS_BI

  D. _SYS_BIC

  Correct Answer: D