SAP C_HAMOD_2404 問題練習

Question No : 1
You create a user-provided service to access tables in external schemas.
In which file type do you assign the user-provided service to your database module?

• A..hdiconfig
• B..mtar
• C..yaml
• D..namespace

答えを確認する

正解:

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

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

答えを確認する

正解:

Question No : 3
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.Incorrect aggregations may be generated
• C.Column engine language is not supported.
• D.To define limits for query unfolding

答えを確認する

正解:

Question No : 4
You implement a referential join between Table A and Table B, but when you query the calculation view, Table B is not pruned.



What could be the problem? Note: There are 2 correct answers to this question.

• A.The Country column is requested.
• B.Join cardinality is set :1.
• C.The Keep flag is activated for the Customer column.
• D.Integrity constraint is set to RIGH

答えを確認する

正解:

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

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

答えを確認する

正解:

Question No : 6
What is a restricted measure?

• A.A measure that can be consumed by a CUBE and not a DIMENSIO
• B.A measure that is filtered by one or more attribute values.
• C.A measure that can only be displayed by those with necessary privileges.
• D.A measure that cannot be referenced by a calculated column.

答えを確認する

正解:

Question No : 7
What are some of the restrictions that apply when defining parallelization blocks in calculation views? Note: There are 2 correct answers to this question.

• A.Multiple blocks can only be defined within a single calculation view.
• B.Only one block can be defined across a stack of calculation views.
• C.The block must only have one start node.
• D.The block must start with a node that defines a table as a data source.

答えを確認する

正解:

Question No : 8
Which components are part of SAP HANA Cloud? Note: There are 2 correct answers to this question.

• A.SAP Analytics Cloud
• B.Data lake
• C.SAP HANA database
• D.SAP Enterprise Architecture Designer

答えを確認する

正解:

Question No : 9
Why does SAP issue warnings about the use of imperative or procedural SQL Script statements?

• A.They can limit parallelization of query execution.
• B.They introduce potential security risks.
• C.They could modify the database.
• D.They call multiple processing engines.

答えを確認する

正解:

Question No : 10
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.

• A.The hierarchy must be exposed by a calculation view of type CUBE with star join.
• B.The hierarchy must be a shared hierarchy.
• C.The hierarchy must be a local hierarchy.
• D.The hierarchy must be a parent-child hierarchy.

答えを確認する

正解:

Question No : 11
Why would you enable Debug Query mode in a calculation view?

• A.To identify data sources that are not accessed by a query
• B.To check which database engines are invoked
• C.To set breakpoints and step through the execution
• D.To understand how tables are partitioned

答えを確認する

正解:

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

• A.Cached results to improve read performance
• B.Metadata to enable consumption by external tools
• C.An SQL execution plan
• D.A column view in a container

答えを確認する

正解:

Question No : 13
You have imported a new calculation view in a folder that contains an .hdinamespace file. This calculation view consumes one data source, which is a table. When trying to deploy the calculation view, the deployment fails with a namespace-related issue.
What could be the reason? Note: There are 2 correct answers to this question.

• A.The namespace used within the calculation view to reference the table is different from the actual namespace in the identifier of this table.
• B.The imported calculation view and its data source have different namespaces.
• C.An .hdinamespace file is defined in the SRC folder that specifies a different namespace property than the one in the identifier of the calculation view.
• D.The .hdinamespace specifies "sub-folder":"append", so calculation views can only be created in subfolders.

答えを確認する

正解:

Question No : 14
At which levels of a project structure can you execute a deploy operation? Note: There are 2 correct answers to this question.

• A.Individual source file
• B.Entire workspace
• C.Sub-folder of a database module
• D.Individual container

答えを確認する

正解:

Question No : 15
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?

• A.The cache data retention period has expired.
• B.You did not define any columns in the cache setting.
• C.You did not define a filter in the cache setting.
• D.The query requests only a subset of the cached results.

答えを確認する

正解: