最新的SAP C_HANAIMP_14免費考試真題

問題1

For which data types does SAP HANA automatically create full-text indexes?
There are 3 correct answers to this question.
Response:

A. SHORTTEXT

B. NVARCHAR

C. BINTEXT

D. CLOB

E. TEXT

正確答案: A,C,E

問題2

Which variable type would you define if you want to use operators such as Greater Than or Less Than?
Please choose the correct answer.
Response:

A. Expression

B. Multiple Entries

C. Range

D. Interval

正確答案: C

問題3

For what type of data are SAP HANA calculation views of type dimension used?
Please choose the correct answer.
Response:

A. Transactional data

B. Calculated data

C. Materialized cube data

D. Master data

正確答案: D

問題4

Where can you create a filter expression?
Please choose the correct answer.
Response:

A. In a data foundation node

B. In the semantics node

C. In an aggregation node

D. In a projection node

正確答案: D

問題5

You have to build a parent-child hierarchy. What type of join do you expect to use?
Please choose the correct answer.
Response:

A. Dynamic join

B. Relational join

C. Self-join

D. Temporal join

正確答案: C

問題6

How does SQL Script extend SQL?
There are 3 correct answers to this question.
Response:

A. It enables usage of variables to break up complex code.

B. It provides the data definition language (DDL) to create column tables.

C. It allows an alternative syntax to simplify expressions.

D. It improves push-down opportunities.

E. It adds imperative expressions to control data flow.

正確答案: A,B,E

問題7

What engine executes the spatial queries?
Please choose the correct answer.
Response:

A. SQL

B. OLAP

C. Join

D. Calculation

正確答案: D

問題8

What performance techniques should you implement to improve the performance of SAP HANA information views?
There are 3 correct answers to this question.
Response:

A. Push down aggregations to SAP HANA.

B. Apply filters as late as possible.

C. Minimize the transfer of data between the execution engines.

D. Perform calculation before aggregation in your analytic views.

E. Investigate partitioning of large tables.

正確答案: A,C,E

問題9

What should you keep in mind when using dynamic SQL?
There are 2 correct answers to this question.
Response:

A. You can dynamically change your data sources.

B. It is always bad for security.

C. It delivers the best possible performance.

D. It could be used for SQL injection.

正確答案: A,D

問題10

With which statement can you call a table function?
There are 2 correct answers to this question.
Response:

A. SELECT

B. EXEC

C. INSERT INTO

D. CALL

正確答案: A,B

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

聯系我們

站內鏈接

最新更新