What SELECT statement isn't recommended for use with column tables?
Please choose the correct answer.
Response:

• A.SELECT *
• B.SELECT ALL
• C.SELECT with a time-travel clause
• D.SELECT in a subquery

Comment: *

Name: *

Email: *

Verification: *

How can you optimize performance when writing SQL for use with calculation views?
There are 2 correct answers to this question.
Response:

• A.Increase paralization by using variables to break up statements
• B.Control the flow logic using IF-THEN-ELSE conditions
• C.Use calculation engine (CE) functions instead of plain SQL
• D.Use declarative language instead of cursors

Comment: *

Name: *

Email: *

Verification: *

You join two tables using a referential join and set the cardinality to 1...n What type of join is executed at runtime if your query does not request columns from the right table?
Please choose the correct answer.
Response:

• A.Inner join
• B.Right outer join
• C.Full outer join
• D.left outer join

Comment: *

Name: *

Email: *

Verification: *

Which modeling features can you use in flowgraphs?
There are 2 correct answers to this question.
Response:

• A.Spatial
• B.Predictive
• C.Text
• D.Graph

Comment: *

Name: *

Email: *

Verification: *

When would you use a function?
Please choose the correct answer.
Response:

• A.To break SQL into smaller statements.
• B.To develop a calculation view with the best possible performance.
• C.When you need to define complex data sources for my calculation view that require conditional logic.
• D.When you need to write results back to a table.

Comment: *

Name: *

Email: *

Verification: *