C_HANAIMP_12 Exam Questions

If we change the transaction "Laura buys 10 apples" to "Laura buys 10 green apples," how would we store the color green? Please choose the correct answer. Response:

What do you call the data displayed in the data foundation of an SAP HANA information view? Please choose the correct answer.

Which programming language do you use for streaming projects? Please choose the correct answer. Response:

You have a list of map locations for clinics. The government wants to build a new clinic, but wants to build it where there is the greatest need. You need to find the largest dista...

What should you keep in mind about procedures? There are 3 correct answers to this question. Response:

What are the advantages of columnar storage? There are 2 correct answers to this question. Response:

As what are most of the views in SAP HANA Live created? Please choose the correct answer. Response:

Which of the following database terms are used when providing OLAP data with hierarchies? There are 3 correct answers to this question. Response:

What can be used to return multiple result sets? There are 2 correct answers to this question. Response:

What artifacts do you use in the output area of a decision table node? There are 2 correct answers to this question. Response:

What variable type do you use if you want to allow the user to choose dates from 2011 to 2014? Please choose the correct answer. Response:

A company sends out a lot of quotes. Some customers accept the quotes, and they're invoiced. The company asks you to find a list of the customers that did NOT accept the quotes. Ho...

What PAL algorithm would you use to analyze shopping baskets? Please choose the correct answer. Response:

In a graphical calculation view of type cube, two tables are joined on multiple columns in a join node. Most queries using the view have no problems, but one query always gets a qu...

Which tab in SAP HANA studio shows validation check errors? Please choose the correct answer. Response:

In which SAP HANA solution do you eliminate stored data, like year-to-date figures? Please choose the correct answer. Response:

What type of input parameters do you use to choose the data from a field in the current table? Please choose the correct answer. Response:

Where in SAP HANA studio can you unload a table's data from memory? Please choose the correct answer. Response:

In which deployment scenarios does security stay in the application server, and end users do not log into the SAP HANA system? There are 2 correct answers to this question. Respons...

Which of the following ways of publishing SAP HANA information model content could require some JavaScript knowledge? There are 2 correct answers to this question. Response:

For which data types does SAP HANA automatically create full-text indexes? There are 3 correct answers to this question. Response:

What must be installed for PAL to work? Please choose the correct answer. Response:

What does SAP HANA load when starting up and before indicating that it is ready? There are 3 correct answers to this question. Response:

Which engine do most SAP HANA Live views use? Please choose the correct answer. Response:

Which features are similar between an analytic view and a calculation view of type cube with star join? There are 3 correct answers to this question. Response:

You create a full-text index. For what text feature clause do you need to specify a configuration? Please choose the correct answer. Response:

What paradigm describes the SQL language? Please choose the correct answer. Response:

What are the values for X, Y, and Z? Please choose the correct answer. Response:

What performance techniques should you implement to improve the performance of SAP HANA information views? There are 3 correct answers to this question. Response:

What is used in SQL to indicate that there is no value? Please choose the correct answer. Response:

What information is available when you use the Explain Plan functionality on an SQL statement? There are 2 correct answers to this question. Response:

Which join types are available in a join node of a calculation view? There are 2 correct answers to this question. Response:

Which modeling views are fading out and are not available in the SAP HANA web-based development workbench? There are 2 correct answers to this question. Response:

You are creating a currency conversion. What options do you have for the Target Currency field? There are 3 correct answers to this question. Response:

Which of the following describe design-time objects? There are 3 correct answers to this question. Response:

What SAP HANA information object does AFM create? Please choose the correct answer. Response:

What performance techniques should you implement to improve join per-formance? There are 3 correct answers to this question. Response:

Which are features of a calculated column? There are 2 correct answers to this question. Response:

You create a graphical calculation view that is consumed in ABAP. What setting in the currency semantics dialog box ensures that a currency column is interpreted correctly in the A...

What SQL construct do you use to return multiple result sets from a single SQL statement? There are 2 correct answers to this question. Response:

Where in the Systems view of SAP HANA studio can you create new SAP HANA models? Please choose the correct answer. Response:

In which SAP HANA studio perspective do you find the Quick View tab options? Please choose the correct answer. Response:

Which of the following SAP data provisioning methods provide complex transformations? There are 2 correct answers to this question

Refactoring is used with which of the following actions? Please choose the correct answer. Response:

What character is used to terminate SQL statements? Please choose the correct answer. Response:

You have two calculation views for viewing manufactured products. The WORLD calculation view shows worldwide information. The INDIA calculation view is built on top of the WORLD ca...

What node can you use to generate a column for use in sorting results? Please choose the correct answer. Response:

What is the default node for a calculation view of type cube? Please choose the correct answer. Response:

What should you keep in mind about user-defined functions? Please choose the correct answer. Response:

What do you use in a SQL query to sort fuzzy text search results by relevance? Please choose the correct answer. Response: