Which of the following data sources can you include in a graphical calculation view?
There are 2 correct answers to this question.
Response:

• A.Table function
• B.Scalar function
• C.SQL VIEW
• D.Procedure

Comment: *

Name: *

Email: *

Verification: *

Which join types are available in a Join node of a calculation view?
There are 2 correct answers to this question.
Response:

• A.Cross joins
• B.Temporal joins
• C.Referential joins
• D.Spatial joins

Comment: *

Name: *

Email: *

Verification: *

You want to call a procedure in a SELECT statement (e.g., a table function). Which clauses do you have to specify?
There are 2 correct answers to this question.
Response:

• A.WITH RESULTS VIEW
• B.LANGUAGE SQLSCRIPT
• C.READS SQL DATA
• D.SEQUENTIAL EXECUTION

Comment: *

Name: *

Email: *

Verification: *

Your newly created analytic privilege does NOT want to build. What must you do?
Please choose the correct answer.
Response:

• A.Grant rights to the _SYS_REPO user.
• B.Change the Apply Privileges property of the view.
• C.Assign the ::access role to the HDI container user.
• D.Change the analytic privilege to use an SQL Expression.

Comment: *

Name: *

Email: *

Verification: *

What spatial data type would you use to store multiple shop locations?
Please choose the correct answer.
Response:

• A.ST_MultiPoint
• B.ST_Point
• C.ST_MultiLineString
• D.ST_Polygon

Comment: *

Name: *

Email: *

Verification: *