C-HANAIMP-18 by SAP Valid Free Exam Practice Test

Question 1

Why would you create a multistore table?

A. To enable partitioning of the table across different storage tiers B. To improve read performance when the table is accessed by simultaneous applications C. To evenly distribute the data across all available server nodes D. To implement a table that combines the features of row and column store

Correct Answer: A

Question 2

When modeling in the SAP Web IDE for SAP HANA, which object do you build to provide access to tables in external schemas?

A. Alias B. Synonym C. Association D. Virtual Table

Correct Answer: B

Question 3

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.

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

Correct Answer: B,C

Question 4

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?

A. Table function B. Scalar function C. Anonymous block D. Procedure

Correct Answer: A

Question 5

Why would you develop an SQL procedure instead of a function?Note: There are 3 correct answers to this question.

A. The code should modify data in a table. B. You need to use conditional logic. C. A temporary table must be created within the code. D. You want to create a dynamic analytic privilege. E. Optimal performance is a priority.

Correct Answer: A,C,D

Question 6

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. You did NOT define a valid table type. C. Your function includes a TRUNCATE statement. D. Your function refers to a scalar function.

Correct Answer: C

Question 7

What are some of the restrictions that apply when defining parallelization blocks in calculation views?Note:
There are 2 correct answers to this question.

A. The block must only have one start node. B. Only one block can be defined across a stack of calculation views. C. Multiple blocks can only be defined within a single calculation view. D. The block must start with a node that defines a table as a data source.

Correct Answer: B,D

Question 8

What is generated when you deploy a CUBE calculation view design-time file?Note: There are 2 correct answers to this question.

A. Cached results to improve read performance B. An SQL execution plan C. A column view in a container D. Metadata to enable consumption by external tools

Correct Answer: C,D

Question 9

You created a calculation view that combines two tables in a join node. To improve the runtime of your calculation view, you use a referential join to prune data sources.How do you check if pruning occurs?Note:
There are 2 correct answers to this question.

A. Use the SQL Analyzer to identify the tables used B. Preview the data results in the calculation view C. Explore the number of used columns in the Performance Analysis mode D. Enable Debug Query mode to identify the columns used

Correct Answer: C,D

SAP Certified Application Associate - SAP HANA 2.0 SPS06 - C-HANAIMP-18 Exam Practice Test