Course 2023 C-HCMOD-03 Test Prep Training Practice Exam Download [Q31-Q47]

3月 11, 2023 管理者 0 コメント

この記事を評価する

Course 2023 C-HCMOD-03 Test Prep Training Practice Exam Download

C-HCMOD-03 Exam Info and Free Practice Test Professional Quiz Study Materials

質問31
When is the first column store compression executed?

When a delta merge is triggered

When the table is created

When partitions are regenerated

When a backup is started

Question

質問32
Why do you use the Hidden Columns checkbox in the semantics node of your calculation view?Note:
この問題には2つの正解がある。

To prevent passing columns in stacked calculation views

To ensure specific columns are NOT exposed to the reporting tool

To remove a column that is also used as a Label column

To avoid exposing sensitive columns when defining calculated columns

質問33
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?

質問34
Why would you use parameter mapping in a calculation view?Note: There are 2 correct answers to this question.

変数値を外部値ヘルプ・ビューに渡すには

1つまたは複数の属性に変数を割り当てるには

フィルターを最下層の計算ビューにプッシュダウンするには

入力パラメータのデータ型を変換するには

質問35
What is generated when you deploy a CUBE calculation view design-time file?Note: There are 2 correct answers to this question.

Cached results to improve read performance

Metadata to enable consumption by external tools

An SQL execution plan

A column view in a container

質問36
あなたは計算ビューのプロパティファイルを作成しました。

計算ビューで定義されたすべてのオブジェクトの説明

計算ビューで定義されたすべての設定

計算ビュー間の依存関係

計算ビューをサポートする文書

質問37
Using the table in the diagram, you need to create a CUBE calculation view.
What is the simplest approach to create the output shown in the screenshot?

Implement a union node and map each country as a separate column.

Create a restricted column for each country.

Create a filter expression that uses an OR operator.

Create 3 calculated columns.

質問38
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?

ユニオン・ノードを使う。

交差ノードを使う。

アグリゲーション・ノードを使用する。

Use a minus node

質問39
SAP Business Technology Platform を構成するソリューションはどれですか？注：この質問には2つの正解があります。

アプリケーション開発と統合

アナリティクス

インテリジェント・スイート

エクスペリエンス・マネジメント

質問40
計算ビューで、SQLScriptを使用して定義されたカスタム・データ・ソースを使用したいとします。

スカラー関数

テーブル機能

匿名ブロック

手続き

質問41
You create a table function to remove historic records, sum the current total weekly working hours for each employee, and update the personnel table with the results. The deployment of the table function fails.Which of the following could be a valid reason?

Your function includes a TRUNCATE statement.

Your function refers to a scalar function.

You did NOT define a valid table type.

You did not define at least one input parameter.

質問42
In a calculation view, your table function node executes a table function that requires input parameters.
How can you fill the input parameters of the table function? Note: There are 3 correct answers to this question.

Define constant values.

Assign a hierarchy node.

Reference the output of a procedure.

Map columns from lower nodes.

Create and map an input parameter

質問43
You define a hierarchy in a calculation view. You want to expose the hierarchy to SQL.Which of the following conditions must be met?Note: There are 2 correct answers to this question.

The hierarchy must be exposed by a calculation view of type CUBE with star join.

The hierarchy must be a shared hierarchy.

The hierarchy must be a local hierarchy.

The hierarchy must be a parent-child hierarchy.

質問44
You want to ensure that your calculation view does not give unexpected results for a query that is based on any combination of columns.What is the recommended approach for verifying the results?

必須でない列にはHIDEプロパティを設定する。

Write and execute a custom SQL query in the SQL Console.

計算ビューのデータプレビューを選択する。

出力マッピングからの列の選択と解除。

質問45
You have imported calculation views from SAP HANA on-premise to SAP HANA Cloud.Why should you switch calculated column expression language from column engine to SQL?

To benefit from additional SQL optimizations

Incorrect aggregations may be generated

Column engine language is not supported.

To define limits for query unfolding

質問46
Which project structure object corresponds to a unique HDI container?

project

space

src folder

database module

質問47
Two calculation views, A and B, are defined as shown in the diagram. Three analytic privileges have been granted to you.

When you preview calculation view A, what data do you see?