最新的SAP C_HANAIMP_17免費考試真題

問題1

Your calculation view consumes one data source which includes the following columns :
SALES_ORDER_ID, PRODUCT_ID, QUANTITY & PRICE.
In the output, you want to see summarized data by PRODUCT_ID and a calculated column, PRODUCT_TOTAL, with the formula QUANTITY * PRICE.
In which type of node do you define the calculation to display the correct result?

A. Projection

B. Join

C. Union

D. Aggregation

正確答案: A

問題2

What can you use SAP HANA smart data access for?
Note: There are 2 correct answers to this question.

A. To expose data from remote tables

B. To replicate remote data sources

C. To load and harmonize data from disparate sources

D. To push down queries to data sources

正確答案: A,D

問題3

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

A. To include columns that are NOT requested by a query but are essential for the correct result

B. To retain the correct aggregation behavior in stacked views.

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

D. To cache the results of the aggregation node for drill-down

正確答案: A

問題4

What can you identify using the Performance Analysis Mode?
Note: There are 2 correct answers to this question.

A. Usage statistics of the calculation view

B. If the data is in the hot or warm storage tier

C. Joins that are defined on calculated columns

D. Information about join cardinality

正確答案: C,D

問題5

Why do you build a calculation view of type SQL Access only?

A. To provide a data source that is only consumed by other calculation views

B. To enable SQL access to your hierarchies

C. To provide a data source that can only be consumed by a function or procedure

D. To provide a high-performance model when only attributes are required

正確答案: A

問題6

You have a calculation view which includes nodes as shown in the graphic. You decide to select the "Ignore Multiple Output for Filters" check box on Projection Node 3. What might the effects of this be?
Note: There are 2 correct answers to this question.

A. Increased performance

B. A change to the data that is returned by the view

C. Decreased performance

D. The view will return the profit calculation for only the US

正確答案: A,D

問題7

Why do you implement Active / active read-enabled mode?

A. To synchronize query results with operational data

B. To improve query performance

C. To enhance security for data access

D. To provide offline access to data

正確答案: A

問題8

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

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

B. A table function that returns a list of allowed values.

C. An organization hierarchy that provides role-based access to data.

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

正確答案: D

問題9

You are building a new calculation view B that uses calculation view A as a data source. In the Semantics node of calculation view A, you define a mask for the first 10 digits of a 15 digit Account Number. When you preview calculation view B, the Account Number is not masked.
Why do you see the Account Number unmasked?

A. The UNMASKED privilege for calculation view A has been granted.

B. The masking is based on the column of a row table.

C. The Account Number is based on the Integer datatype.

D. You did not define masking in calculation view B.

正確答案: A

最新的SAP Certified Application Associate - SAP HANA 2.0 (SPS05) - C_HANAIMP_17免費考試真題

聯系我們

站內鏈接

最新更新