SAP C_HAMOD_2404 Practice Test - Questions Answers, Page 5
Question list
List of questions
Related questions
What are possible consequences of unfolding? Note: There are 2 correct answers to this question.
Results are read from static cache.
Count-distinct results are incorrect.
SQL compilation time increases.
Query processing time improves.
Why would you partition a table in an SAP HANA database? Note: There are 2 correct answers to this question.
To improve response time when multiple users access the same table
To overcome the 2 billion record limit
To improve data replication performance on large row tables
To improve query performance when accessing large column tables
Why would you enable Debug Query mode in a calculation view?
To set breakpoints and step through the execution
To identify data sources that are not accessed by a query
To understand how tables are partitioned
To check which database engines are invoked
What are some best practices for writing SQLScript for use with calculation views? Note: There are 2 correct answers to this question.
Break up large statements by using variables.
Use dynamic SQL.
Control the flow logic using IF-THEN-ELSE conditions.
Choose declarative language instead of imperative language.
You have defined a pruning configuration table in a calculation view. What are you attempting to prune from the query execution?
Data sources of unions
Joins
Calculated columns
Filters
What is a calculation view query snapshot?
The stored results of a query on a calculation view
The results of a query generated by a front end tool on a calculation view
A record of the query statement executed on a calculation view
A bookmark of a frequently used navigation state of a query result
What can you identify using Performance Analysis mode? Note: There are 2 correct answers to this question.
Usage statistics of the calculation view
Expected memory consumption
Information about join cardinality
Joins that are defined on calculated columns
You have created a calculation view query snapshot and you want to generate an interface view. What is the purpose of the generated input parameter of the interface view?
To map the attributes of the interface view to the original calculation view attributes
To allow the user to select whether to run a query on the snapshot table or on the original calculation view
To define the selection criteria used during the scheduled insertion of records into the snapshot table
To evaluate the analytic privileges of different users who access the snapshot table
What are some best practices when developing calculation views? Note: There are 2 correct answers to this question.
Avoid defining joins on calculated columns.
Include all data flow logic within one calculation view.
Define filters on calculated columns.
Aggregate at the lowest possible node.
You have configured static cache for your calculation view and run a query against it, but the cache results are not being used. What might be the reason for this?
The query requests only a subset of the cached results.
You did not define a filter in the cache setting.
Your cache setting does not specify any columns.
The cache data retention period has expired.
Question