问题 47
在计算视图中实现货币转换的关键步骤是什么？

问题 48
Which of the following are warm data tier solutions?Note: There are 3 correct answers to this question.

问题 49
You have configured static cache for your calculation view and run a query against it, but the cache results are not being used.What might be the reason for this?

问题 50
Why would you create SQL in calculation views?

问题 51
You are building a new calculation view A that uses calculation view B, as shown in the diagram. When you preview the calculation view A, the Account Number is not masked.

原因何在？

问题 52
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?

问题 53
In your calculation view, you want to consume a custom data source defined using SQLScript.In which type of object do you write your code?

问题 54
What are possible consequences of unfolding?Note: There are 2 correct answers to this question.

问题 55
What are the consequences of NOT executing a delta merge?Note: There are 2 correct answers to this question.

问题 56
Which of the following are standard options provided to define analytic privileges?Note: There are 3 correct answers to this question.

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

问题 58
You have defined a pruning configuration table in a calculation view.What are you attempting to prune from the query execution?

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

问题 60
What are some best practices for writing SQLScript for use with calculation views?Note: There are 2 correct answers to this question.

问题 61
为什么要在聚合节点中使用 Keep Flag 属性？

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

问题 63
How can you define a variable that presents its value help hierarchically?Note: There are 2 correct answers to this question.

问题 64
You have generated a calculation view properties file.What does it contain?

问题 65
In SAP Web IDE, you rename a dimension calculation view that is used by a cube calculation view. You do NOT use the option to rename the runtime view and adjust the reference. Afterward, you perform the following build operations:Build the dimension calculation view as a single object.Build the entire SAP HANA database module.What is the outcome of the build operations?

问题 66
You created a calculation view that combines two tables in a join node. To improve the runtime of your calculation view, you use a referential join to prune data sources.How do you check if pruning occurs?Note:
本题有 2 个正确答案。

问题 67
You have made changes to the design-time files of several calculation views in your DEV environment. These calculation views all belong to the same project.Before deploying your calculation views to a PROD environment, which sequence of steps is required in the DEV environment?

问题 68
哪种连接类型支持计算视图中的时间条件？

问题 69
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?

问题 70
You combine two customer master data tables with a union node in a calculation view. Both master data tables include the same customer name.How do you ensure that each customer name appears only once in the results?