C_HANAIMP_18 試験問題を無料オンラインアクセス

Why would you partition a table in an SAP HANA Cloud database?Note: There are 2 correct answers to this question.

• A.To improve response time when multiple users access the same table
• B.To overcome the 2 billion record limit
• C.To improve query performance when accessing large column tables
• D.To improve data replication performance on large row tables

You set the Null Handling property for an attribute but do not set a default value.What is displayed when null values are found in a column of data type NVARCHAR?

• A.<empty string>
• B."0"
• C."?"
• D."Null"

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 exclude columns that are NOT requested by a query to avoid incorrect results
• C.To ensure that the aggregation behavior defined in the aggregation node for a measure CANNOT be overridden by a query
• D.To retain the correct aggregation behavior in stacked views

Which of the following approaches might improve the performance of joins in a CUBE calculation view?Note:
There are 2 correct answers to this question.

• A.Specify the join cardinality
• B.Define join direction in a full outer join
• C.Use an inner join
• D.Limit the number of joined columns

You want to join two tables in a calculation view.Why do you use a non-equi join?

• A.Join columns have different data types.
• B.The join condition is not represented by matching values.
• C.The number of joined columns is different in each table.
• D.Join columns need to be ignored when NOT requested by the query.