What are the advantages of column store tables compared to row store tables? Note: There are 3 correct answers to this question. Improved write performance on frequent updates.

• A.Higher performance for query operations
• B.Additional indexes are used
• C.Higher data compression rates
• D.Parallel access is improved

Comment: *

Name: *

Email: *

Verification: *

Which solutions form the SAP Business Technology Platform? Note: There are 2 correct answers to this question.

• A.Experience Management
• B.Application Development & Integration
• C.Intelligent Suite
• D.Analytics

Comment: *

Name: *

Email: *

Verification: *

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 avoid duplicate rows in the output
• C.To ensure semantic correctness
• D.To hide columns that are not required

Comment: *

Name: *

Email: *

Verification: *

You create a table function to remove historic records, sum the current total weekly working hours for each employee, and update the personnel table with the results. The deployment of the table function fails. Which of the following could be a valid reason?

• A.You did not define at least one input parameter.
• B.Your function refers to a scalar function.
• C.Your function includes a TRUNCATE statement.
• D.You did NOT define a valid table type.

Comment: *

Name: *

Email: *

Verification: *

In a database module, what is the purpose of the .hdiconfig file?

• A.To specify an external schema in which calculation views will get their data
• B.To specify which HDI plug-ins are available
• C.To specify in which space the container should be deployed
• D.To specify the namespace rules applicable to the name of database objects

Comment: *

Name: *

Email: *

Verification: *