Online Access Free C-HANAIMP-18 Exam Questions

In a calculation view, what is the purpose of a variable?

• A.To break up complex SQL into smaller steps
• B.To provide a dynamic value in a calculated column
• C.To filter an attribute at run-time based on a user input
• D.To pass values between procedures and calculation views

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.Integrity constraint is set to RIGHT.
• B.The Country column is requested.
• C.Join cardinality is set :1.
• D.The Keep flag is activated for the Customer column.

In an XS Advanced project, what is the purpose of the .hdiconfig file?

• A.To specify which HDI plug-ins are available
• B.To specify in which space the container should be deployed
• C.To specify an external schema in which calculation views will get their data
• D.To specify the namespace rules applicable to the name of database objects

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 build the calculation view, the build fails with a namespace-related issue.What could be the reason?Note: There are 2 correct answers to this question.

• A.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.
• B.The imported calculation view and its data source have different namespaces.
• C.The namespace used within the calculation view to reference the table is different from the actual namespace in the identifier of this table.
• D.The .hdinamespace specifies "sub-folder":"append", so calculation views can only be created in subfolders.

Why would you build a calculation view of type SQL Access only?

• A.To provide a data source that is only consumed by other calculation views
• B.To enable SQL access to your hierarchies
• C.To provide a data source that can only be consumed by a function or procedure
• D.To provide a high performance model when only attributes are required