SAP C_HAMOD_2404 Practice Test - Questions Answers, Page 6
Question list
List of questions
Related questions
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.
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.
Which tool generates and runs the SQL for a specific node of your calculation view?
SQL analyzer
Explain plan
Database explorer
Debug Query mode
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.
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.
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
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.
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
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
Why do you nest flowgraphs? Note: There are 2 correct answers to this question.
To reduce flowgraph maintenance
To access additional node types
To improve flowgraph performance
To start multiple flowgraphs at the same time
Question