Free SAP Certified Application Associate – SAP HANA 2.0 SPS06 Exam C_HANAIMP_18 Exam Practice Test

Why would you implement active / active read-enabled mode?

• To provide offline access to data
• To synchronize query results with operational data
• To enhance security for data access
• To improve query performance

Which of the following are usually not required In the data model of SAP S/4HANA?Note: There are 2 correct answers to this question.

• Stored aggregates
• Views
• Partitions
• Indexes

Which of the following supports data replication?

• SAP HANA smart data access
• SAP HANA, streaming analytics option
• SAP HANA smart data quality
• SAP HANA smart data integration

Why would you partition a table in an SAP HANA Cloud 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

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.

• Use an inner join
• Limit the number of joined columns
• Specify the join cardinality
• Define join direction in a full outer join

You combine two tables in a join node using multiple columns in each table.Why do you enable the dynamic join option?Note: There are 2 correct answers to this question.

• To ensure that the join execution only uses the join columns requested in the query
• To ensure that the aggregation always happens after the join execution
• To force the calculation at the relevant level of granularity, even if this level is not the grouping level defined by the query
• To allow data analysis at different levels of granularity with the same calculation view

What do you use in the definition of a dynamic SQL analytic privilege?

• An organization hierarchy that provides role-based access to data.
• A table function that returns a list of allowed values.
• A scalar function that returns a list of the allowed values for each attribute.
• A procedure that returns the data access condition as an SQL expression.

What are the key steps to implement currency conversion in a calculation view?

• Assign semantic type Enable the measure for conversion Choose client, source and target currencies Choose conversion date and rate type
• Enable the measure for conversion Choose client, source and target currencies Choose conversion date and rate type Assign the conversion rule to your calculation view
• Enable the measure for conversion Choose client, source, and target currencies Choose conversion date and rate type Build the conversion rule
• Assign semantic type Choose client, source and target currencies Choose conversion date and rate type Define an expression in a calculated column

In your calculation view, you want to consume a custom data source defined using SQLScript.In which type of object do you write your code?

• Procedure
• Scalar function
• Anonymous block
• Table function

In a calculation view, what is the purpose of a variable?

• To provide a dynamic value in a calculated column
• To break up complex SQL into smaller steps
• To filter an attribute at run-time based on a user input
• To pass values between procedures and calculation views