C_HANAIMP_12 Exam Questions

Which of following are features associated with SAP HANA Live? There are 2 correct answers to this question.

What information can you find in Performance Analysis Mode when you view the analysis for a join node? There are 2 correct answers to this question. Response:

You have a view with two tables, joined by a left outer join. If you redesign the view and accidently swap the two tables around, what should you do to the join? Please choose the...

Which of the following VDM views can be called by applications and reports? There are 2 correct answers to this question. Response:

What does SAP HANA smart data integration use for data provisioning? There are 3 correct answers to this question Response:

The entity is the core artifact for persistence-model definition using the CDS syntax. You create a database entity as a design-time file in the SAP HANA repository. Which are the...

Where is SAP HANA Live installed? Please choose the correct answer. Response:

The company's board members want to run simulations on the year-end financial data. What do you use to build this for them? Please choose the correct answer. Response:

What join type should you use to see all the suppliers? Please choose the correct answer. Response:

You are working with a currency measure. What is decimal shift used for? Please choose the correct answer. Response:

You have created a SQL analytic privilege on an information view. Where do you tell the view to enable SQL analytic privileges? Please choose the correct answer. Response:

Which type of cloud solution is SAP HANA Enterprise Cloud (HEC) an example of? Please choose the correct answer. Response:

You are using the SAP HANA studio. Which of the following SAP HANA modeling artifacts require the SAP HANA application function modeler (AFM) to be installed? There are 3 correct a...

Where do you create a variable? Please choose the correct answer. Response:

What performance technique should you implement to improve the performance of SAP HANA information views that include SQLScript? Please choose the correct answer. Response:

What API would you use in SAP HANA SPS 11/12 to display search results in an ABAP system? Please choose the correct answer. Response:

To start and stop Data Provisioning tasks, which are the following privileges should users have to start or stop tasks? There are 2 correct answers to this question Response:

You get the following requirements from a customer: They have a lot of purchasing data in their SAP system which they wish to analyze in SAP HANA. They want to have reports every m...

Schema mapping is used during which process? Please choose the correct answer. Response:

Which are the recommended assignments in SAP HANA? There are 2 correct answers to this question.

What is a new and recommended way to work with SQL and SQLScript? Please choose the correct answer.

What can you use as data sources for a decision table? There are 2 correct answers to this question. Response:

In which type of node can you create calculated columns? There are 2 correct answers to this question. Response:

Which of the following terms are associated with an operational system? There are 2 correct answers to this question. Response:

Which tasks are part of the migration tool workflow? There are 2 correct answers to this question. Response:

Which of the following are examples for validation rules? There are 2 correct answers to this question. Response:

Which can a level hierarchy do? Please choose the correct answer. Response:

For what SQL keyword is the aggregation node the equivalent? Please choose the correct answer. Response:

Which of the following are results of deploying SAP HANA as a distributed (scale-out) solution? There are 3 correct answers to this question. Response:

Which SAP HANA column types are part of an SAP HANA graph workspace? There are 2 correct answers to this question. Response:

What node is used to link dimension views to a data foundation (fact tables)? Please choose the correct answer. Response:

You created a procedure without defining the security option. Which user's authorizations are checked when the procedure is executed in production? Please choose the correct answer...

For what tasks would you use the Where-Used feature in SAP HANA? Please choose the correct answer. Response:

Of which SAP HANA process are the transaction manager and page manager a part? Please choose the correct answer. Response:

In the SAP HANA modeler, what object does the `Rename and Adjust References' feature apply to? Please choose the correct answer. Response:

Which text feature do you use to find sentiment in textual data? Please choose the correct answer. Response:

What enables the delta buffer technique to speed up both reads and inserts in SAP HANA? Please choose the correct answer. Response:

You rename a field in the semantics node to add clarity for end users. What does SAP HANA use to keep track of what the original field name is? Please choose the correct answer. Re...

How do you move code to SAP HANA? There are 2 correct answers to this question. Response:

You want to build a hierarchy on a time-based data structure. What type of hierarchy do you use? Please choose the correct answer. Response:

You want to publish your business intelligence content directly to SAP Cloud for Analytics. Which tool do you use? There are 2 correct answers to this question. Response:

Global session variables can be used in SQLScript to share a scalar value between procedures and functions that are running in the same session. The value of a global session varia...

You created a calculated column in an analytic view for a table containing the number of units ordered, the price per unit, and the number of units in stock. You get the wrong resu...

In which direction do you build calculation views when including the source tables in join nodes? Please choose the correct answer. Response:

To what subset of SQL does the SELECT statement belong? Please choose the correct answer. Response:

You want to rename an information view with the SAP HANA Modeler without losing its existing behavior. What are the next steps after the renaming utility has finished? There are 2...

You are writing a mobile application for the World Series. You have details about all the baseball players and the baseball scores for all the previous matches. How do you use the...

Modeling package Shops is a subpackage of package Regions. You want to authorize a user to list the content of package Regions, but prevent listing the content of package Shops. Ho...

Which development tools are available for creating SAP HANA information models? There are 2 correct answers to this question. Response:

In which SAP HANA views will you find measures? There are 2 correct answers to this question.