SAP C_HANAIMP_18 Exam Practice Test Instant Access

Question 1

What does SAP HANA provide to support full stack native application development?Note: There are 2 correct answers to this question.

ACode editors and debugger

BSupport for automated regression testing

CSource code version management tool

DIncident tracking tools

Answer : A, C

Question 2

You want to ensure that your calculation view does not give unexpected results for a query that is based on any combination of columns.What is the recommended approach for verifying the results?

AWrite and execute a custom SQL query in the SQL Console.

BSelect and deselect columns from the output mapping.

CSet the HIDE property for columns NOT required.

DSelect Data Preview for the calculation view.

Answer : A

Question 3

Which of the following are usually not required In the data model of SAP S/4HANA?Note: There are 2 correct answers to this question.

AStored aggregates

BViews

CPartitions

DIndexes

Answer : A, D

Question 4

In your calculation view, you want to consume a custom data source defined using SQLScript.In which type of object do you write your code?

AProcedure

BScalar function

CAnonymous block

DTable function

Answer : D

Question 5

When modeling in the SAP Web IDE for SAP HANA, which object do you build to provide access to tables in external schemas?

AVirtual Table

BSynonym

CAssociation

DAlias

Answer : B

Question 6

You have configured static cache for your calculation view and run a query against it, but the cache results are not being used.What might be the reason for this?

AYou did not define any columns in the cache setting.

BThe cache data retention period has expired.

CThe query requests only a subset of the cached results.

DYou did not define a filter in the cache setting.

Answer : A

Question 7

Which calendar types can be selected when creating time-based DIMENSIONS?Note: There are 2 correct answers to this question.

AJulian

BGregorian

CFactory

DFiscal

Answer : B, D

SAP C_HANAIMP_18 SAP Certified Application Associate - SAP HANA 2.0 SPS06 Exam Practice Test