SAP C_HAMOD_2404 Practice Test - Questions Answers, Page 6
List of questions
Question 51

What are some of the restrictions that apply when defining parallelization blocks in calculation views? Note: There are 2 correct answers to this question.
Multiple blocks can be defined only within a single calculation view.
The block must have only one start node.
The block must start with a node that defines a table as a data source.
Only one block can be defined across a stack of calculation views.
Question 52

Which of the following techniques can you use to improve the performance of calculation views? Note: There are 2 correct answers to this question.
Avoid union pruning.
Partition large tables.
Limit the number of stacked calculation views.
Aggregate data early in the data flow.
Question 53

Which tool generates and runs the SQL for a specific node of your calculation view?
SQL analyzer
Explain plan
Database explorer
Debug Query mode
Question 54

Which of the following approaches might improve the performance of joins in a CUBE calculation view? Note: There are 2 correct answers to this question.
Specify the join cardinality.
Limit the number of joined columns.
Define join direction in a full outer join.
Use an inner join.
Question 55

You implement a referential join between Table A and Table B, but when you query the calculation view, Table B is not pruned. What could be the problem? Note: There are 2 correct answers to this question.
The Country column is requested.
Join cardinality is set: 1.
The Keep flag is activated for the Customer column.
Integrity constraint is set to RIGHT.
Question 56

Which of the following are standard options provided to define analytic privileges? Note: There are 3 correct answers to this question.
Dynamic
SQL expression
Hierarchy function
Graph
Attributes
Question 57

What do you use in the definition of a dynamic SQL analytic privilege?
An organization hierarchy that provides role-based access to data.
A scalar function that returns a list of the allowed values for each attribute.
A table function that returns a list of allowed values.
A procedure that returns the data access condition as an SQL expression.
Question 58

You run a CREATE REMOTE SOURCE SQL statement to create a smart data integration remote source, but the statement fails. What could be the reason? Note: There are 2 correct answers to this question.
The credentials clause defines TYPE 'PASSWORD' but does not specify a technical user
The remote system is not reached through the company network
You do not have the CREATE REMOTE SOURCE privilege on the remote system
The specified adapter is not registered with your SAP HANA system
Question 59

In a data source node of a flowgraph, in addition to tables and views, which other objects can you define as the data source? Note: There are 3 correct answers to this question.
virtual table
calculation view
procedure
synonym
table function
Question 60

Why do you nest flowgraphs? Note: There are 2 correct answers to this question.
Question