SAP Certified Application Associate - SAP HANA (Edition 2014) (C_HANAIMP142) Free Practice Test

Question 1

Which view do you use to combine two analytic views?

A. Attribute view

B. Database view

C. Calculation view

D. Analytic view

Correct Answer: C

Question 2

Which of the following steps do you have to execute to import models from one SAP HANA system (system1) to another SAP HANA system (system2)? (Choose three)

A. Create a delivery unit on system2.

B. Create a schema on system2.

C. Import the models into system2.

D. Create a delivery unit on system1.

E. Export the models from system1.

Correct Answer: C,D,E

Question 3

Table SALES_TABLE contains the columns COUNTRY and SALES. Function calc_tax calculates sales tax based on input parameter SALES.
Using a scripted calculation view, how can you call the calc_tax function?

A. :v_tax = SELECT COUNTRY, CALL :calc_tax(SALES) AS TAX FROM :SALES_TABLE;

B. v_tax = CE_PROJECTION(SALES_TABLE, ["COUNTRY","calc_tax(SALES)"]);

C. v_tax = SELECT COUNTRY, calc_tax(SALES) AS TAX FROM SALES_TABLE;

D. :v_tax = CE_PROJECTION(SALES_TABLE, ["COUNTRY","CALL :calc_tax(SALES)"]);

Correct Answer: C

Question 4

When loading data into SAP HANA, which of the following tasks can you perform using SAP Data Services? (Choose two)

A. Real-time replication

B. Data filtering

C. Data transformations

D. Upload data via the SAP HANA studio

Correct Answer: B,C

Question 5

A company loads data every night from several source systems into multiple tables in SAP HANA using complex transformation rules. The calculation view that joins these tables performs unexpectedly slow.
Which of the following could you investigate to be able to improve performance? (Choose two)

A. Whether the joins and transformations of the tables can be moved to the data loading process of SAP BusinessObjects Data Services.

B. Whether an InfoCube compression is running.

C. Whether savepoints are written during execution.

D. Whether the calculation view needs to create large intermediate result sets.

Correct Answer: A,D

Question 6

Which of the following information models does SAP recommend to combine fact table fields with the corresponding master data attributes? (Choose two)

A. Attribute view

B. Database view

C. Calculation view

D. Analytic view

Correct Answer: C,D

Question 7

When you load data from SAP ECC using SAP BusinessObjects Data Services, where would you create an ABAP data flow?

A. In a batch job

B. In the Job overview (transaction SM37)

C. In a query transformation

D. In the ABAP editor (transaction SE38)

Correct Answer: A

Question 8

Which of the following tools can you use to monitor the query time from SAP HANA?

A. Central Management Console

B. Event Viewer

C. SQL Trace

D. Performance tab of the System Monitor

Correct Answer: C

Question 9

A calculation view that joins one fact table with dimension tables performs slowly.
Which of the following can you do to improve performance?

A. Turn the calculation view into a simple calculation view.

B. Load the calculation view into the _SYS_BI schema.

C. Load the calculation view into memory.

D. Turn the calculation view into an analytic view.

Correct Answer: D

Question 10

User A has to set up tables and views in a database schema that is owned by user B.
Which of the following privilege must you grant?

A. REFERENCES to user A

B. REFERENCES to user B

C. CREATE ANY to user A

D. CREATE ANY to user B

Correct Answer: C

Question 11

Which of the following would you create to ensure the fastest calculation performance?

A. A calculated column in an SAP HANA information model

B. An input parameter in an SAP HANA information model

C. A report variable in an SAP BusinessObjects reporting client

D. A calculated measure in an SAP BusinessObjects universe

Correct Answer: A

Question 12

Which best practices should you apply when you use SQL script in SAP HANA? (Choose three)

A. Use UNION ALL instead of UNION.

B. Use CE functions.

C. Use cursors.

D. Use the WHERE clause for updates.

E. Use dynamic SQL with variables.

Correct Answer: A,B,D

Question 13

You plan to migrate your existing SAP NetWeaver landscape with a non-SAP HANA database.
Which of the following are key considerations for the migration of your database to SAP HANA? (Choose three)

A. Upgrade all end-user front-end workstations to SUSE Linux (SLES).

B. Plan downtime for the migration of the old database to SAP HANA.

C. Resize application servers to handle incremental data volumes.

D. Provision hardware that runs SUSE Linux (SLES) for SAP HANA.

E. Reuse existing SAP NetWeaver application servers.

Correct Answer: B,D,E

Question 14

How can you improve the performance of an information model? (Choose three)

A. Use attribute views wherever possible.

B. Use analytic views wherever possible.

C. Use indexes on all measures.

D. Use generated columns.

E. Use constraint filters.

Correct Answer: B,D,E

Welcome to TestSimulate

SAP Certified Application Associate - SAP HANA (Edition 2014) (C_HANAIMP142) Free Practice Test