C-HANAIMP142 by SAP Actual Free Exam Q&As

Question 1

You need to retrieve data from SAP HANA that is restricted to a certain region and specific users. How can you implement this security strategy?

A. By assigning Analytic privileges to the necessary users B. By assigning Package privileges to the necessary users C. By assigning System privileges to the necessary users D. By assigning SQL privileges to the necessary users

Discussion 0

Correct Answer: A Vote an answer

Question 2

Which of the following can be grouped inside a single schema in an SAP HANA database?

A. Information models B. Packages C. Users D. Database tables

Discussion 0

Correct Answer: D Vote an answer

Question 3

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 savepoints are written during execution. C. Whether the calculation view needs to create large intermediate result sets. D. Whether an InfoCube compression is running.

Discussion 0

Correct Answer: A,C Vote an answer

Question 4

You have made modifications to an information model within a delivery unit. You want to export the model to an SAP HANA target system.
In the Schema Mapping dialog, where do you define the target system schema?

A. In the _SYS_BI schema B. In the Authoring schema C. In the Physical schema D. In the Authorization schema

Discussion 0

Correct Answer: C Vote an answer

Question 5

You receive an activation error in a scripted calculation view that uses the following function:
CE_PROJECTION(:table1, ["AMOUNT"], '"PROD" = A')
What could be a reason for this error?

A. The filter condition must be specified inside the projection list. B. The projection list contains a field that is not specified in the filter condition. C. The filter condition contains a field that is not part of the projection list. D. The filter condition is not set within square brackets.

Discussion 0

Correct Answer: C Vote an answer

Question 6

You have a table of transactional data with different transaction types. You want to create an analytic view for only one of the transaction types.
How can you ensure that only rows with the required transaction type are displayed in the analytic view?

A. Create a restricted column B. Create a calculated column C. Create an input parameter D. Create a filter on the table

Discussion 0

Correct Answer: D Vote an answer

Question 7

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

A. Use CE functions. B. Use UNION ALL instead of UNION. C. Use cursors. D. Use the WHERE clause for updates. E. Use dynamic SQL with variables.

Discussion 0

Correct Answer: A,B,D Vote an answer

Question 8

What can be used as a source for the data foundation of an analytic view? (Choose two)

A. A table that contains only descriptive attributes B. A table that contains foreign keys referring to primary keys in the attribute views C. A table that contains surrogate IDs referring to primary keys in the attribute views D. A table that contains business facts or measures

Discussion 0

Correct Answer: B,D Vote an answer

Question 9

Which of the following data provisioning tasks can you perform in the SAP HANA studio? (Choose three)

A. Activate the SAP Web Dispatcher service for SAP HANA Direct Extractor Connection (DXC). B. Create replication configurations for SAP Landscape Transformation (SLT). C. Create an SAP ECC extractor datastore for SAP Data Services. D. Start replication of tables for SAP Landscape Transformation (SLT). E. Configure remote sources for SAP HANA smart data access.

Discussion 0

Correct Answer: A,D,E Vote an answer

Question 10

What is the advantage of reporting directly from column tables?

A. It eliminates the need for additional modeling B. It supports analytical privileges C. It shifts complex calculations and logic to SAP HANA D. It provides multi-language support

Discussion 0

Correct Answer: A Vote an answer

Question 11

Which of the following can be part of an analytic view? (Choose three)

A. Data foundation B. Logical joins C. Attributes D. Unions E. Query transformation

Discussion 0

Correct Answer: A,B,C Vote an answer

SAP Certified Application Associate - SAP HANA (Edition 2014) - C-HANAIMP142 Exam Practice Test