Online Access Free C_HANAIMP_16 Exam Questions

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

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

You want to expose a hierarchy that is defined in a calculation view for access to SQL which of the following conditions must be met?
Note: There are 2 correct answers .

• A.The hierarchy must be a shared hierarchy.
• B.The hierarchy must be defined in a calculation view of type SQL ACCESSONLY.
• C.The hierarchy must be exposed by a calculation view of type CUBE with star join.
• D.The hierarchy must be a local hierarchy.

Why do you create calculation views of data category DIMENSION with type TIME?

• A.To store historical version of attributes.
• B.To provide the time intervals required by time-dependent parent-child hierarchies.
• C.To add a temporal condition to a join to find matching records from two tables based on a date.
• D.To provide additional time-related navigation possibilities

A calculation view consumes the data sources shown in the graphic. You want to identify which companies SQLd products in January 2018 AND February 2018. What is the optimal way to do this?

• A.Use a full outer join.
• B.Use an intersect node
• C.Use a union node.
• D.Use an left outer join.

When you create a full text index, why do you specify FAST_PREPROCESS OFF?

• A.To prevent the creation of a fuzzy search index
• B.To enable a full linguistic search
• C.To avoid the generation of the term document matrix
• D.To generate text analysis results in multiple languages