SAP C_HANAIMP_18 Exam Questions Instant Access

Question 1

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 2

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 3

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 4

You import a project that includes an SAP HANA database (HDB) module to your workspace. You need to create a calculation view that uses data from a table located in an external schema within the same local database.Which of the following items do you need?Note: There are 2 correct answers to this question.

AAuthorization

BSynonym

CSQL view

DRemote source

Answer : A, B

Question 5

You created a calculation view that combines two tables in a join node. To improve the runtime of your calculation view, you use a referential join to prune data sources.How do you check if pruning occurs?Note: There are 2 correct answers to this question.

AUse the SQL Analyzer to identify the tables used

BEnable Debug Query mode to identify the columns used

CExplore the number of used columns in the Performance Analysis mode

DPreview the data results in the calculation view

Answer : B, C

Question 6

Which tool generates and executes the SQL for a specific node of your calculation view?

ADebug Query mode

BExplain plan

CSQL analyzer

DDatabase explorer

Answer : A

Question 7

What is a restricted measure?

AA measure that cannot be referenced by a calculated column.

BA measure that can only be displayed by those with necessary privileges.

CA measure that is filtered by one or more attribute values.

DA measure that can be consumed by a CUBE and not a DIMENSION.

Answer : C

SAP Certified Application Associate - SAP HANA 2.0 SPS06 C_HANAIMP_18 Exam Questions