Why would you use parameter mapping in a calculation view?Note: There are 2 correct answers to this question.

• A.To convert the data types of input parameters
• B.To push down filters to the lowest level calculation views
• C.To pass variable values to external value help views
• D.To assign variables to one or more attributes

Comment: *

Name: *

Email: *

Verification: *

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 generate a restricted column
• C.To generate a calculated column
• D.To convert currencies
• E.To define a filter

Comment: *

Name: *

Email: *

Verification: *

You created a procedure to be consumed in an analytic privilege of the type DYNAMIC, but it isn't working as expected.What could be the reason?Note: There are 2 correct answers to this question.

• A.The output parameter is defined as NVARCHAR
• B.The procedure is write-enabled
• C.No input parameter is specified
• D.You defined more than one output parameter

Comment: *

Name: *

Email: *

Verification: *

What can you do with shared hierarchies? Note:There are 2 correct answers to this question.

• A.Enable SQL SELECT statements to access hierarchies
• B.Access hierarchies created in external schemas
• C.Provide reusable hierarchies for drilldown in a CUBE without star join
• D.Provide reusable hierarchies for drilldown in a CUBE with star join

Comment: *

Name: *

Email: *

Verification: *

What are some best practices for writing SQLScript for use with calculation views? Note: There are 2 correct answers to this question.

• A.Choose declarative language instead of imperative language.
• B.Control the flow logic using IF-THEN-ELSE conditions.
• C.Break up large statements by using variables.
• D.Use dynamic SQL.

Comment: *

Name: *

Email: *

Verification: *