C-HANAIMP-18 by SAP Actual Free Exam Questions And Answers

Question 1

You define a hierarchy in a calculation view. You want to expose the hierarchy to SQL Which of the following conditions must be met?Note: There are 2 correct answers to this question.

A. The hierarchy must be exposed by a calculation view of type CUBE with star join.

B. The hierarchy must be defined in a calculation view of type SQL ACCESS ONLY.

C. The hierarchy must be a shared hierarchy.

D. The hierarchy must be a local hierarchy.

Discussion 0

Correct Answer: A,C Vote an answer

Question 2

Which options do you have to handle orphan nodes in your hierarchy?Note: There are 2 correct answers to this question.

A. Generate additional root nodes.

B. Assign them to a level below the root.

C. Define an expression to determine a parent.

D. Assign them to a node at the root level.

Discussion 0

Correct Answer: A,D Vote an answer

Question 3

After importing a project in the workspace of the SAP Web IDE, you execute a build at the HDB module level. The build fails.What could be the reason?Note: There are 2 correct answers to this question.

A. You have not defined the HDI build plug-in version.

B. You have not built the project yet.

C. You have not assigned the project to a space.

D. Your HDB module references a user-provided service that does not exist.

Discussion 0

Correct Answer: C,D Vote an answer

Question 4

What are possible consequences of unfolding?Note: There are 2 correct answers to this question.

A. Results are read from static cache

B. Count-distinct results are incorrect

C. SQL compilation time increases

D. Query processing time improves

Discussion 0

Correct Answer: A,C Vote an answer

Question 5

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. Your function includes a TRUNCATE statement.

B. You did not define at least one input parameter.

C. You did NOT define a valid table type.

D. Your function refers to a scalar function.

Discussion 0

Correct Answer: A Vote an answer

Question 6

Which of the following are warm data tier solutions?Note: There are 3 correct answers to this question.

A. Extension Node

B. Persistent memory

C. Dynamic Tiering

D. Active / active read-enabled mode

E. Native Storage Extension

Discussion 0

Correct Answer: A,C,E Vote an answer

Question 7

You have generated a calculation view properties file.What does it contain?

A. Dependencies between calculation views

B. Documentation to support the calculation view

C. Descriptions of all objects defined in a calculation view

D. All settings defined in a calculation view

Discussion 0

Correct Answer: C Vote an answer

Question 8

You have imported a new calculation view in a folder that contains an .hdinamespace file. This calculation view consumes one data source, which is a table. When trying to build the calculation view, the build fails with a namespace-related issue.What could be the reason?Note: There are 2 correct answers to this question.

A. The imported calculation view and its data source have different namespaces.

B. The namespace used within the calculation view to reference the table is different from the actual namespace in the identifier of this table.

C. The .hdinamespace specifies "sub-folder":"append", so calculation views can only be created in subfolders.

D. An .hdinamespace file is defined in the SRC folder that specifies a different namespace property than the one in the identifier of the calculation view.

Discussion 0

Correct Answer: A,B Vote an answer

Question 9

You want to create a star schema using a calculation view. The measures are based on columns from two transaction tables. Dimension calculation views provide the attributes.What is the correct approach?

A. Combine the transaction tables using a join node in a calculation view of type cube with star join.Use a star join node to join the dimensions to the fact table.

B. Combine the transaction tables using a star join node in a calculation view of type cube with star join.Use a join node to join the dimensions to the fact table.

C. Combine the transaction tables using an aggregation node in a calculation view of type cube with star join.Use a star join node to join the dimensions to the fact table.

D. Combine the transaction tables using a star join node in a calculation view of type cube with star join.Use the same star join node to connect the dimensions to the fact table.

Discussion 0

Correct Answer: A Vote an answer

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

Contact Us

Useful Links

Latest Updated