C_hanaimp_12 Actual Exam

By Author: David Milan
Total Articles: 19
Comment this article

Question: 1

You want to call a procedure in a SELECT statement (like a table function). Which clauses do you have to specify?
There are 2 correct answers to this question.
Response:

A. LANGUAGE SQLSCRIPT
B. WITH RESULTS VIEW
C. SEQUENTIAL EXECUTION
D. READS SQL DATA

Answer: BD

Question: 2

Which of the following are reasons you should use Core Data Services (CDS) to create a schema?
There are 2 correct answers to this question.
Response:

A. The database administrator might type the name wrong.
B. The database administrator should not get those privileges in the production system.
C. The focus is on the business requirements.
D. The focus is on the database administration requirements.

Answer: BC

Question: 3

Which technologies does SAP HANA use to load more data into memory?
There are 3 correct answers to this question.
Response:

A. Eliminate indices
B. Use RAR compression
C. Use dictionary compression
D. Store data in column tables
...
... E. Use multicore CPU parallelism

Answer: ACD

Question: 4

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

A. All row tables
B. All system tables
C. All partitions
D. Some column tables
E. Some row tables

Answer: ABD

Question: 5

For what type of data are SAP HANA calculation views of type dimension used?
Please choose the correct answer.
Response:

A. Transactional data
B. Master data
C. Materialized cube data
D. Calculated data

Answer: B

Question: 6

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:

A. Direct
B. Derived from table
C. Value help
D. Column

Answer: D

Question: 7

What happens when you activate an information model? ?
There are 2 correct answers to this question.
Response:

A. It generates a runtime object.
B. It reverts to the active version.
C. It checks the validation rules.
D. It exports an active version.

Answer: AC

Question: 8

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 Lumira
C. SAP Crystal Reports for Enterprise
D. SAP BusinessObjects Analysis, edition for Microsoft Office

Answer: AB

Question: 9

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

A. Full-text index
B. Fuzzy text search
C. Text analysis
D. Text mining

Answer: C

Question: 10

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 variable is not visible from another session.
Please choose the correct answer.
Response:

A. SET = ;
B. SET = ;
C. SET = ;
D. SET = ;

Answer: A

Question: 11

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. How can you achieve this?
Please choose the correct answer.
Response:

A. Refactor package Shops to another package.
B. Assign REPO.EXPORT only to package Shops.
C. Assign REPO.READ privilege only to package Regions.
D. Revoke analytic privileges for models in package Shops.

Answer: A

Question: 12

Which deployment scenario can you use to accelerate reporting from an old SAP R/3 4.6C system?
Please choose the correct answer.
Response:

A. SAP HANA as a database
B. SAP HANA as a platform
C. SAP HANA as a sidecar solution
D. SAP HANA multitenant database containers

Answer: C

Question: 13

You have logs from a website. How do you show the total number of website visitors that used a mobile phone?
There are 2 correct answers to this question.
Response:

A. Create a restricted column
B. Create an action
C. Create a filter expression
D. Create a rank column

Answer: AC

Question: 14

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. BINTEXT
D. CLOB
E. TEXT

Answer: BCE

Question: 15

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

A. Improving your modeling design
B. Translating
C. Transporting
D. Documenting

Answer: A