Which tool generates and executes the SQL for a specific node of your calculation view?

• A.Database explorer
• B.Debug Query mode
• C.Explain plan
• D.SQL analyzer

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

Comment: *

Name: *

Email: *

Verification: *

You set the Null Handling property for an attribute but do not set a default value. What is displayed when null values are found in a column of data type NVARCHAR?

• A."?"
• B.<empty string>
• C."0"
• D."Null"

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 and GE for P1
• B.US for P1 and P2, and GE for P2
• C.US for P1
• D.US for P1 and P2, and GE for P1 and P2

Comment: *

Name: *

Email: *

Verification: *

Why would you create SQL in calculation views?

• A.To provide an alternative to graphical modeling
• B.To implement custom logic
• C.To enable write capabilities
• D.To fine-tune performance

Comment: *

Name: *

Email: *

Verification: *