C-HANAIMP-12 Exam Training Practice Tests (SAP Certified Application Associate - SAP HANA (Edition 2016

Question 1

What technique is used to convert record updates into insert statements in the delta buffer?
Please choose the correct answer.

A. Insert-only B. Unsorted inserts C. Parallelism D. Sorted inserts

Correct Answer: A

Question 2

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

A. Platform as a Service (PaaS) B. Managed Cloud as a Service (MCaaS) C. Software as a Service (SaaS) D. Infrastructure as a Service (IaaS)

Correct Answer: B

Question 3

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 data of the player information and the scores?
Please choose the correct answer.
Response:

A. The player information is used as transactional data, and the scores are used as master data. B. The player information is used as master data, and the scores are used as transactional data. C. Both the player information and the scores are used as master data. D. Both the player information and the scores are used as transactional data.

Correct Answer: B

Question 4

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

A. NVARCHAR B. SHORTTEXT C. TEXT D. CLOB E. BINTEXT

Correct Answer: B,C,E

Question 5

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

A. The tool requires a script-based calculation view as input. B. The tool produces a table function linked to a graphical calculation view. C. The tool produces only a table function. D. The tool requires a graphical calculation view as input.

Correct Answer: A,B

Question 6

You created a user-defined function with the INVOKER security option. Which user's authorizations are checked when the function is executed?
Please choose the correct answer.
Response:

A. The user calling the function B. The _SYS_REPO user C. The SYSTEM user D. The owner of the function

Correct Answer: A

Question 7

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.
How do you find the customers that received quotes but did NOT receive invoices?
Please choose the correct answer.
Response:

A. Use a right outer join. Filter to show only customers on the left table. B. Use a left outer join. Filter to show only customers on the right table. C. Use a right outer join. Filter to show only the NULL values on the right table. D. Use a left outer join. Filter to show only the NULL values on the right table.

Correct Answer: D

Question 8

What combination enabled real-time computing?
Please choose the correct answer.
Response:

A. In-memory technology with solid-state disks B. Multicore CPUs and solid-state disks C. Multicore CPUs with large level 1 caches D. In-memory technology and multicore CPUs

Correct Answer: D

Question 9

What performance technique should you implement to improve join performance?
Please choose the correct answer.
Response:

A. Use joins instead of unions for combining large data sets. B. Do NOT use dynamic joins if you require optimal performance. C. Always use referential joins in star join views. D. Join on key fields between tables in a dimension view.

Correct Answer: D

Question 10

What is the preferred way to create a procedure?
Please choose the correct answer.
Response:

A. Create a .hdbprocedure file. B. Use the CREATE PROCEDURE statement in the SQL Console. C. Use the context menu of a package. D. Create a .procedure file.

Correct Answer: A

Question 11

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 following prerequisites to create an entity in CDS (core data services)?
There are 2 correct answers to this question
Response:

A. You must have access to an SAP HANA system B. You must have deployed to schema for the CDS catalog objects C. You must have already created a development workspace and a project. D. You must have access to schema for the CDS catalog objects

Correct Answer: A,C

Question 12

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

A. CDS views B. Scalar functions C. Table types D. Calculation views

Correct Answer: C,D

Question 13

What SELECT statement is not recommended for use with column tables?
Please choose the correct answer.
Response:

A. SELECT with a time-travel clause B. SELECT in a subquery C. SELECT * D. SELECT ALL

Correct Answer: C

Question 14

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

A. Star join node B. Join node C. Aggregation node D. Projection node

Correct Answer: C

Question 15

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:

A. The time taken by the join B. The suggested filter for the tables in the join node C. The total number of records returned by the node D. The tables used by the join in the node

Correct Answer: C,D

SAP Certified Application Associate - SAP HANA (Edition 2016 - SPS12) - C-HANAIMP-12 Exam Practice Test