Which of the following approaches improve the performance of joins in a cube calculation view? Note: There are 2 correct answers to this question.

• A.Implement pruning rules.
• B.Specify the join cardinality.
• C.Use an inner join.
• D.Limit the number of joined columns.

Comment: *

Name: *

Email: *

Verification: *

In your calculation view, you need to define a custom data source using SQLScript. In which object do you write your SQL Script?

• A.CDS view
• B.Table function
• C.Procedure
• D.Virtual Table

Comment: *

Name: *

Email: *

Verification: *

Which of the following approaches can be used to implement union pruning?
There are 2 correct answers to this question.
Response:

• A.Define the cardinality between the data sources.
• B.Define a restricted column and include it in both data sources of a union.
• C.Define union pruning conditions in a pruning configuration table.
• D.Define a constant value for each data source in the Union node.

Comment: *

Name: *

Email: *

Verification: *

Which of the following tasks are required to get the database objects created in the HDI container?
There are 2 correct answers to this question.
Response:

• A.Build the MTA project.
• B.Assign the project to a space to which you have developer authorizations.
• C.Explicitly build the HDB module instead of the MTA project.
• D.Create at least one namespace in the HDB module.

Comment: *

Name: *

Email: *

Verification: *

Which types of data are used to represent spatial information?
Note: There are 2correct answers to this question.

• A.Graph data
• B.Raster data
• C.Vector data
• D.Column data

Comment: *

Name: *

Email: *

Verification: *