C-HANAIMP-18 試験問題を無料オンラインアクセス

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 high performance model when only attributes are required
• D.To provide a data source that can only be consumed by a function or procedure

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

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 must appear in the last DIMENSION in the star join node.
• B.It CANNOT be mixed in the same star join node with other join types.
• C.Only one column can be included in the join condition.
• D.It is restricted to one DIMENSION in a star join node.

Which tool generates and executes the SQL for a specific node of your calculation view?

• A.Database explorer
• B.Explain plan
• C.Debug Query mode
• D.SQL analyzer

Why would you implement active / active read-enabled mode?

• A.To synchronize query results with operational data
• B.To enhance security for data access
• C.To improve query performance
• D.To provide offline access to data