Developing Custom Logic using SQL

1.

Choose the correct answer.

Cube

Dimension

2.

There are three correct answers.

To generate values for input parameters

To define filter conditions for restricted columns

To define a calculated column

To create a level hierarchy

3.

Choose the correct answer.

Table Functions

Column Engine Functions

Scalar Functions

4.

Choose the correct answer.

The syntax is simpler

Performance of the table is better.

The table definition is easily transported as part of the overall application to ensure all project artifacts are kept together.

5.

There are two correct answers.

By providing table variables to break up larger statements in to smaller ones

By allowing JavaScript language to be used

By providing conditional statements such as IF..THEN..ELSE

6.

There are two correct answers.

So that they can develop calculation views using SQL instead of using the graphical editor

So that they can develop custom logic using an SQL function and consume this within a calculation view

So that they can extend the capabilities of a calculation view using SQL expressions

Knowledge quiz