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.

正解:

SAP C_HAMOD_2404 問題練習