2022年11月 SAP C_HCMOD_01認定リアル2022年最新の模擬試験合格させます [Q47-Q72]

2022年11月 SAP C_HCMOD_01認定リアル2022年最新の模擬試験合格させます

C_HCMOD_01試験問題と有効なC_HCMOD_01問題集でPDF

質問 47
You have generated a calculation view properties file. What does it contain?

A. All settings defined in a calculation view
B. Dependencies between calculation views
C. Descriptions of all objects defined in a calculation view
D. Documentation to support the calculation view

正解: C

質問 48
What are the consequences of NOT executing a delta merge? Note: There are 2 correct answers to this question.

A. Aggregates are not adjusted.
B. New records are not read.
C. Read performance decreases.
D. Memory is not optimized.

正解: B,C

質問 49
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.

A. Define constant values.
B. Reference the output of a procedure.
C. Assign a hierarchy node.
D. Create and map an input parameter.
E. Map columns from lower nodes.

正解: A,D,E

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

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

正解: C,D

質問 51
Which type of join supports a temporal condition in a calculation view?

A. Referential join
B. Text join
C. Inner join
D. Left outer join

正解: C

質問 52
A new release of SAP HANA Cloud, SAP HANA database is available as of today. If you do not perform the upgrade manually, how much time do you have before your database will be automatically upgraded to the next release?

A. 7 months
B. 2 weeks
C. 3 months
D. 1 year

正解: C

質問 53
You have defined a pruning configuration table in a calculation view. What are you attempting to prune from the query execution?

A. Calculated columns
B. Joins
C. Filters
D. Data sources of unions

正解: D

質問 54
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. "Null"
C. "0"
D. "?"

正解: A

質問 55
What are possible consequences of unfolding? Note: There are 2 correct answers to this question.

A. Query processing time improves
B. Results are read from static cache
C. Count-distinct results are incorrect
D. SQL compilation time increases

正解: C,D

質問 56
Why would you create calculation views of data category DIMENSION with type TIME?

A. To provide the time intervals required by time-dependent parent-child hierarchies
B. To add a temporal condition to a join to find matching records from two tables based on a date
C. To provide additional time-related navigation possibilities
D. To store historical versions of attributes

正解: C

質問 57
You deleted the design-time file of a calculation view in your HDB module. What is the recommended way to ensure that the corresponding runtime object is also removed from the database?

A. Execute the refactor function for the calculation view.
B. Deploy the project that contained the deleted design-time file.
C. Execute a DROP statement in an SQL Console connected to the HDI container.
D. Deploy the folder that contained the deleted design-time file.

正解: D

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

A. To benefit from additional SQL optimizations
B. Column engine language is not supported.
C. Incorrect aggregations may be generated
D. To define limits for query unfolding

正解: A

質問 59
What are the advantages of column store tables compared to row store tables? Note: There are 3 correct answers to this question. Improved write performance on frequent updates.

A. Parallel access is improved
B. Additional indexes are used
C. Higher performance for query operations
D. Higher data compression rates

正解: A,C,D

質問 60
In a calculation view, why would you implement an SQL expression? Note: There are 3 correct answers to this question.

A. To convert currencies
B. To generate hierarchies
C. To define a filter
D. To generate a calculated column
E. To generate a restricted column

正解: C,D,E

質問 61
In SAP HANA Cloud, which tasks are handled by the cloud provider? Note: There are 3 correct answers to this question.

A. Tuning the database to run optimally on the underlying operating system, and hardware
B. Backing up and restoring, and recovering the database software
C. Installing, configuring, and upgrading the operating system
D. Sizing, provisioning, and monitoring the database
E. Managing users, roles, and permissions in the database

正解: A,B,C

質問 62
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 ensure specific columns are NOT exposed to the reporting tool
B. To prevent passing columns in stacked calculation views
C. To remove a column that is also used as a Label column
D. To avoid exposing sensitive columns when defining calculated columns

正解: A,C

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

A. Table function
B. Procedure
C. Scalar function
D. Anonymous block

正解: A

質問 64
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 DIMENSION calculation view
C. A SELECT privilege and an Analytic Privilege (Country = United States) on the CUBE calculation view
D. SELECT privileges and Analytic Privileges (Country = United States) on both views

正解: A

質問 65
Why would you choose an HDI-shared service plan instead of a schema service plan? Note: There are 3 correct answers to this question.

A. You want to use SAP Business Application Studio.
B. You want to use containers to isolate objects.
C. You want to create database objects using source files.
D. You want to develop calculation views.
E. You want to use synonyms to access external data.

正解: A,B,C

質問 66
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 deploy it. What do you observe in the SAP HANA database container?

A. The deployment is successful and the data preview returns expected data.
B. The deployment fails and the table is dropped.
C. The deployment fails and the table is not dropped.
D. The deployment is successful but the data preview returns an error message.

正解: C

質問 67
What is the SQL keyword used to process input parameters defined in a calculation view?

A. PLACEHOLDER
B. SET
C. WHERE
D. HINT

正解: A

質問 68
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 P2
B. US for P1 and P2, and GE for P1 and P2
C. US for P1
D. US for P1 and GE for P1

正解: D

質問 69
You want to create a star schema using a calculation view. The measures are based on columns from two transaction tables. DIMENSION calculation views provide the attributes. What is the correct approach?

A. Combine the transaction tables using a star join node in a calculation view of type CUBE with star join./Use a join node to join the DIMENSIONS to the fact table.
B. Combine the transaction tables using an aggregation node in a calculation view of type CUBE with star join./Use a star join node to join the DIMENSIONS to the fact table.
C. Combine the transaction tables using a join node in a calculation view of type CUBE with star join./Use a star join node to join the DIMENSIONS to the fact table.
D. Combine the transaction tables using a star join node in a calculation view of type CUBE with star join./Use the same star join node to connect the DIMENSIONS to the fact table.

正解: C

質問 70
In a calculation view, why would you choose the DEPRECATED setting? Note: There are 2 correct answers to this question.

A. To ensure it is not exposed to reporting tools for consumption
B. To warn developers that the calculation view is no longer supported
C. To lock the calculation view from further modifications
D. To indicate that it should not be used as a data source to other calculation views

正解: A,B

質問 71
Your calculation view consumes one data source, which includes the following columns:
SALES_ORDER_ID, PRODUCT_ID, QUANTITY and PRICE. In the output, you want to see summarized data by PRODUCT_ID and a calculated column, PRODUCT_TOTAL, with the formula QUANTITY * PRICE. In which type of node do you define the calculation to display the correct result?