C-HANAIMP-16 試験問題を無料オンラインアクセス

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 one table located in an external schema. Which of the following items must you build?
Note: There are 2 correct answers to this question.

• A.Synonym
• B.Authorization
• C..hdinamespacefile
• D.Project

In your calculation view, you need to define a custom data source using SQLScript. In which object do you write your SQL Script?

• A.Table function
• B.Procedure
• C.CDS view
• D.Virtual Table

A calculation view includes a rank node that uses the source data and settings shown in the graphic. Your query requests all columns of the rank node. How many rows are in the output of your query?

• A.6
• B.5
• C.9
• D.2

Which of the following techniques can you use to improve the performance of calculation views?
Note: There are 2 correct answers to this question.

• A.Partition large tables
• B.Limit the number of stacked calculation views
• C.Implement union pruning
• D.Avoid aggregating data early in the dataflow

When using the CONTAINS predicate, what are the restrictions you must keep in mind? Note: There are 2 correct answers to this question.

• A.The NOT (-) operator can only be specified directly after the OR operator.
• B.Wild cards * and ? are supported for text columns but not string columns.
• C.Non-physical columns, such as calculated columns, are not search-relevant.
• D.If several tables are joined, all columns mentioned in the CONTAINS predicate must come from only one of the tables.