In your calculation view, you want to consume a custom data source defined using SQLScript.In which type of object do you write your code?

• A.Procedure
• B.Scalar function
• C.Table function
• D.Anonymous block

Comment: *

Name: *

Email: *

Verification: *

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

• A.Access hierarchies created in external schemas
• B.Enable SQL SELECT statements to access hierarchies
• 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 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.It is restricted to one DIMENSION in a star join node.
• D.Only one column can be included in the join condition.

Comment: *

Name: *

Email: *

Verification: *

What are the consequences of NOT executing a delta merge?Note: There are 2 correct answers to this question.

• A.Memory is not optimized.
• B.Aggregates are not adjusted.
• C.New records are not read.
• D.Read performance decreases.

Comment: *

Name: *

Email: *

Verification: *

You create a table function to remove historic records, sum the current total weekly working hours for each employee, and update the personnel table with the results. The deployment of the table function fails.Which of the following could be a valid reason?

• A.Your function includes a TRUNCATE statement.
• B.You did not define at least one input parameter.
• C.Your function refers to a scalar function.
• D.You did NOT define a valid table type.

Comment: *

Name: *

Email: *

Verification: *