Online Access Free C-HANAIMP-17 Exam Questions

When would you develop an SQL procedure instead of a function?

• A.You need to implement Data Definition Language (DDL) statements.
• B.Optimal performance is apriority.
• C.The code should modify data in the table.
• D.You want to create a dynamic analytic privilege.
• E.You need to use conditional logic.

You have a calculation view which includes nodes as shown in the graphic. You decide to select the "Ignore Multiple Output for Filters" check box on Projection Node 3. What might the effects of this be?
Note: There are 2 correct answers to this question.

• A.The view will return the profit calculation for only the US
• B.Decreased performance
• C.Increased performance
• D.A change to the data that is returned by the view

What are the components of a custom text analysis?
Note: There are 3 correct answers to this question.

• A.Rule set
• B.Term Document Matrix
• C.Python script
• D.Dictionary
• E.Configuration

You have imported a new calculation view in a folder that contains a .hdinamespace file. This calculation view consumes one data source which is a table. When trying to build the calculation view, there is a namespace-related issue and the build fails.
What could be the reason? Note: There are 2 correct answers.

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

In a calculation view of type cube with star join, you want to join three dimensions to the facts. Two of the dimensions use full outer joins and one dimension uses a left outer join. You did NOT set cardinality of the data sources. Why will this NOT work?

• A.Full outer joins CANNOT be mixed in the same star join node with other join types.
• B.Full outer joins are NOT available in the star join node.
• C.Full outer joins are restricted to one dimension in a star join node.
• D.Full outer joins require cardinality to beset.