[2023年04月] 検証済み SAP 試験問題集 C-HANAIMP-18 試験学習ガイド [Q24-Q46]

[2023年04月] 検証済みSAP試験問題集でC-HANAIMP-18試験学習ガイド

ベスト品質のSAP C-HANAIMP-18試験解答リアル練習試験問題集で[2023]

SAP C-HANAIMP-18 認定試験の出題範囲：

トピック	出題範囲
トピック 1	Demonstrate that you can setup the modeling ennvironment Describing the Technology and Deployment Scenarios of SAP HANA
トピック 2	Demonstrate that you can apply SQL and SQLScript in SAP HANA modeling Working with SQL and SQL Script in models
トピック 3	Configuring modeling functions Building calculation views Demonstrate that you can implement security features to prevent unauthorised access to data models

質問 24
You want to map an input parameter of calculation view A to an input parameter of calculation view B using the parameter mapping feature in the calculation view editor. However, the input parameters of calculation view B are not proposed as source parameters.What might be the reason for this?

A. Your source calculation view is of type DIMENSION.
B. The names of the input parameters do not match.
C. You selected the wrong parameter mapping TYPE.
D. You already mapped the input parameters in another calculation view.

正解: D

質問 25
Which of the following are standard options provided to define analytic privileges?Note: There are 3 correct answers to this question.

A. Dynamic
B. Graph
C. Attributes
D. SQL expression
E. Hierarchy function

正解: A,C,D

質問 26
Which of the following supports data replication?

A. SAP HANA smart data quality
B. SAP HANA smart data access
C. SAP HANA smart data integration
D. SAP HANA, streaming analytics option

正解: C

質問 27
Why do you use the Hidden Columns checkbox in the semantics node of your calculation view?Note: There are 2 correct answers to this question.

A. To avoid exposing sensitive columns when defining calculated columns
B. To ensure specific columns are NOT exposed to the reporting tool
C. To prevent passing columns in stacked calculation views
D. To remove a column that is also used as a Label column

正解: B,D

質問 28
Which of the following data sources can you include in a graphical calculation view?Note: There are 2 correct answers to this question.

A. Table function
B. Procedure
C. Scalar function
D. Row table

正解: A,D

質問 29
Which of the following are capabilities of SAP HANA smart data access?Note: There are 2 correct answers to this question.

A. Push-down of queries to remote data sources
B. Exposure of real-time data from remote tables
C. Replication of remote data
D. Cleansing and harmonization of data from disparate sources

正解: A,B

質問 30
Using the table in the diagram, you need to create a cube calculation view.What is the simplest approach to create the output from the screenshot?

A. Create a filter expression that uses an OR operator.
B. Implement a union node and map each year as a separate column.
C. Create a restricted column for each country.
D. Create 3 calculated columns.

正解: B

質問 31
What can you identify using Performance Analysis mode?Note: There are 2 correct answers to this question.

A. Information about join cardinality
B. Joins that are defined on calculated columns
C. Expected memory consumption
D. Usage statistics of the calculation view

正解: A,B

質問 32
What are the limitations of using a full outer join in a star join node?Note: There are 2 correct answers to this question.

A. It is restricted to one DIMENSION in a star join node.
B. It CANNOT be mixed in the same star join node with other join types.
C. It must appear in the last DIMENSION in the star join node.
D. Only one column can be included in the join condition.

正解: A,C

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

A. Your function refers to a scalar function.
B. You did not define at least one input parameter.
C. You did NOT define a valid table type.
D. Your function includes a TRUNCATE statement.

正解: D

質問 34
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 a table located in an external schema within the same local database.Which of the following items do you need?Note: There are 2 correct answers to this question.

A. SQL view
B. Remote source
C. Synonym
D. Authorization

正解: C,D

質問 35
Referring to the diagram, which privileges would a user require to view United States data when querying the CUBE calculation view?

A. A SELECT privilege on the CUBE calculation view and an Analytic Privilege (Country = United States) on the DIMENSION calculation view
B. A SELECT privilege and an Analytic Privilege (Country = United States) on the CUBE calculation view
C. A SELECT privilege and an Analytic Privilege (Country = United States) on the DIMENSION calculation view
D. SELECT privileges and Analytic Privileges (Country = United States) on both views

正解: A

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

A. US for P1 and P2, and GE for P1 and P2
B. US for P1
C. US for P1 and GE for P1
D. US for P1 and P2, and GE for P2

正解: B

質問 37
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:
There are 2 correct answers to this question.

A. Enable Debug Query mode to identify the columns used
B. Use the SQL Analyzer to identify the tables used
C. Preview the data results in the calculation view
D. Explore the number of used columns in the Performance Analysis mode

正解: A,D

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

A. Create a level hierarchy and assign it to the variable.Ensure the variable's reference column is the top level of the hierarchy.
B. Create a level hierarchy and assign it to the variable.Ensure the variable's reference column is the leaf level of the hierarchy.
C. Create a parent-child hierarchy and assign it to the variable.Ensure the variable's reference column is the child attribute of the hierarchy.
D. Create a parent-child hierarchy and assign it to the variable.Ensure the variable's reference column is the parent attribute of the hierarchy.

正解: B,C

質問 39
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. Use an inner join
B. Limit the number of joined columns
C. Specify the join cardinality
D. Define join direction in a full outer join

正解: B,C

質問 40
Why would you develop an SQL procedure instead of a function?Note: There are 3 correct answers to this question.

A. Optimal performance is a priority.
B. You want to create a dynamic analytic privilege.
C. You need to use conditional logic.
D. The code should modify data in a table.
E. A temporary table must be created within the code.

正解: B,D,E

質問 41
Which calendar types can be selected when creating time-based DIMENSIONS?Note: There are 2 correct answers to this question.

A. Julian
B. Factory
C. Fiscal
D. Gregorian

正解: C,D

質問 42
You created a table and inserted data in it using SQL statements inside the SAP HANA Deployment Infrastructure (HDI) container of your project. You add this table as a data source to a calculation view and try to build it.What do you observe in the SAP HANA database container?