SAP Certified Application Associate - SAP HANA 2.0 (SPS01) (C_HANAIMP_13) Free Practice Test

Question 1

Why should you use variables in SQL Script?
There are 2 correct answers to this question.
Response:

A. To increase parallelization opportunities

B. To improve code readability

C. To implement flow control logic

D. To support processing push-down

Correct Answer: A,B

Question 2

What are the rules for defining a stepparent in a hierarchy?
There are 2 correct answers to this question.
Response:

A. The stepparent node must already exist in the hierarchy at any level.

B. The stepparent node must already exist in the hierarchy at the root level.

C. A stepparent only applies to parent-child hierarchies.

D. The stepparent node ID must be entered according to the node style you selected for the hierarchy.

Correct Answer: B,D

Question 3

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

A. Union node

B. Rank node

C. Projection node

D. Aggregation node

Correct Answer: B

Question 4

What is the recommended way to create full-text indexes going forward?
Please choose the correct answer.
Response:

A. Procedures

B. SQL statements in the SQL Console

C. User-defined functions

D. Core Data Services

Correct Answer: D

Question 5

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:

A. SAP Predictive Analytics

B. SAP Crystal Reports for Enterprise

C. SAP Lumira

D. SAP BusinessObjects Analysis, edition for Microsoft Office

Correct Answer: A,C

Question 6

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

A. The tool produces only a table function.

B. The tool produces a table function linked to a graphical calculation view.

C. The tool requires a script-based calculation view as input.

D. The tool requires a graphical calculation view as input.

Correct Answer: B,C

Question 7

Which data provisioning tools can use SAP HANA adapters?
There are 2 correct answers to this question.

A. SDA

B. SDI
SRS

C. SDS

Correct Answer: A,B

Question 8

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:

A. Creating a report in SAP Crystal Reports for Enterprise

B. Creating a REST web service in the SAP HANA XS engine

C. Creating business intelligence content with SAP BusinessObjects Design Studio

D. Creating a composite provider in SAP BW

Correct Answer: B,C

Question 9

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

A. Check formulas in calculated columns

B. Check that attribute views have a key attribute specified

C. Check that graphical calculation views have no orphan nodes

D. Check that tables contain data

Correct Answer: B,C

Question 10

With which statement can you call a table function?
There are 2 correct answers to this question.
Response:

A. EXEC

B. INSERT INTO

C. SELECT

D. CALL

Correct Answer: A,C

Welcome to TestSimulate

SAP Certified Application Associate - SAP HANA 2.0 (SPS01) (C_HANAIMP_13) Free Practice Test