Why would you set the "Ignore multiple outputs for filters" property in a calculation view?

• A.To force filters to apply at the lowest node
• B.To ensure semantic correctness
• C.To hide columns that are not required
• D.To avoid duplicate rows in the output

Comment: *

Name: *

Email: *

Verification: *

You have defined a pruning configuration table in a calculation view.What are you attempting to prune from the query execution?

• A.Calculated columns
• B.Joins
• C.Filters
• D.Data sources of unions

Comment: *

Name: *

Email: *

Verification: *

Two calculation views, A and B, are defined as shown in the diagram. Three analytic privileges have been granted to you.

When you preview calculation view A, what data do you see?

• A.US for P1
• B.US for P1 and GE for P1
• C.US for P1 and P2, and GE for P2
• D.US for P1 and P2, and GE for P1 and P2

Comment: *

Name: *

Email: *

Verification: *

You want to map an input parameter of calculation view A to an input parameter of calculation view B using the parameter mapping feature in the calculation view editor.

However, the input parameters of calculation view B are not proposed as source parameters. What might be the reason for this?

• A.You already mapped the input parameters in another calculation view.
• B.You selected the wrong parameter mapping TYPE.
• C.Your source calculation view is of type DIMENSION.
• D.The names of the input parameters do not match.

Comment: *

Name: *

Email: *

Verification: *

When is the first column store compression executed?

• A.Question
• B.When a backup is started
• C.When the table is created
• D.When partitions are regenerated
• E.When a delta merge is triggered

Comment: *

Name: *

Email: *

Verification: *