SAP C_HANAIMP_18 Exam Questions Instant Access

Question 1

Which of the following supports data replication?

ASAP HANA smart data access

BSAP HANA, streaming analytics option

CSAP HANA smart data quality

DSAP HANA smart data integration

Answer : D

Question 2

A calculation view consumes the data sources shown in the graphic. You want to identify which companies sold products in January AND February.

What is the optimal way to do this?

AUse a union node.

BUse a minus node.

CUse an intersect node.

DUse an aggregation node.

Answer : A

Question 3

Why does SAP issue warnings about the use of imperative or procedural SQLScript statements?

AThey could modify the database.

BThey call multiple processing engines.

CThey introduce potential security risks.

DThey can limit parallelization of query execution.

Answer : C

Question 4

Why would you develop an SQL procedure instead of a function?Note: There are 3 correct answers to this question.

AYou want to create a dynamic analytic privilege.

BA temporary table must be created within the code.

COptimal performance is a priority.

DThe code should modify data in a table.

EYou need to use conditional logic.

Answer : A, B, D

Question 5

What do you use in the definition of a dynamic SQL analytic privilege?

AAn organization hierarchy that provides role-based access to data.

BA table function that returns a list of allowed values.

CA scalar function that returns a list of the allowed values for each attribute.

DA procedure that returns the data access condition as an SQL expression.

Answer : D

Question 6

Why do you create calculation views of data category DIMENSION with type TIME?

ATo provide additional time-related navigation possibilities

BTo add a temporal condition to a join to find matching records from two tables based on a date

CTo store historical versions of attributes

DTo provide the time intervals required by time-dependent parent-child hierarchies

Answer : A

Question 7

Why might you use the Keep Flag property in an aggregation node?

ATo ensure that the aggregation behavior defined in the aggregation node for a measure CANNOT be overridden by a query

BTo retain the correct aggregation behavior in stacked views

CTo include columns that are NOT requested by a query but are essential for the correct result

DTo exclude columns that are NOT requested by a query to avoid incorrect results

Answer : C

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