SAP Certified Technology Associate - SAP HANA 2.0 SPS05 (C_HANATEC_17) Free Practice Test

Question 1

Which tools are integrated into the SAP HANA cockpit?
There are 3 correct answers to this question.

A. SQL Analyzer

B. HDB Admin

C. HANA Sitter

D. SQL Console

E. Database Explorer

Correct Answer: A,D,E

Question 2

Which rules should you consider when creating a table distribution plan for SAP Business Suite on SAP HANA to get the best possible results? There are 2 correct answers to

A. Keep the number of key columns low.

B. Keep the number of partitions per table high.

C. Keep all partitions on different hosts.

D. Keep the number of partitioned tables low.

Correct Answer: A,B

Question 3

What is the correct minimum requirement for log volume and/hana/shared/ file system for an SAP HANA database system? Please choose the correct answer.

A. For 1 TB system, Log volume = 1 TB,/hana/shared/ = 1TB

B. For 256 GB system, Log volume = 128 GB,/hana/shared/ = 256 GB

C. For 2 TB system, Log volume = 1 TB,/hana/shared/ = 1TB

D. For 512 GB system, Log volume = 512 GB,/hana/shared/ = 256 GB

Correct Answer: B

Question 4

Which actions take place during a database migration option (DMO) procedure when performing an in-place migration?
There are 2 correct answers to this question.

A. TABART is considered for the creation of R3load control files.

B. One table is migrated per R3load pair.

C. De-pooling of tables is done during the procedure.

D. SAP up decides which tables to split.

Correct Answer: C,D

Question 5

How do you ensure that Web-based applications send HTTPS requests to specific databases in an SAP HANA multiple-container system? Note: There are 2 correct answers.

A. Configure an alias hostname for every tenant database

B. Configure an SAP Web Dispatcher for every tenant databases

C. Check the hostnames mapping to internal HTTPS ports

D. Check that all requests with physical hostnames are forwarded to tenant databases

Correct Answer: A,B

Question 6

Which information can you collect by running the fullSystemlnfoDump.py script when the SQL connection is available? Please choose the correct answer:.

A. A selection of .trc files

B. A selection of .log files

C. A selection of rows of schema _SYS_XS

D. A selection of rows of schema SAP<SID>

Correct Answer: A

Question 7

One of your systems show the internal Disk Full (Alert 30) alert. What is the root cause of this alert?

A. Writing to the /hana/data/<sid> volume is NOT possible

B. Runing out of free space on the /hana/shared volume

C. Reading from the /hana/log/<sid> volume is NOT possible

D. Exceeding system quota on the /usr/sap volume

Correct Answer: B

Question 8

Which tools can you use to start and stop tenants in an SAP HANA database? Note: There are 2 correct answers.

A. sapcontrol

B. SAP HANA cockpit 2.0 - Manage Databases

C. hdbsql

D. SAP HANA Studio - System view

Correct Answer: B,C

Question 9

Which components of SAP HANA Indexserver allow clients to connect and communicate with the SAP HANA database? Please choose the correct answer:.

A. Request Processing and Execution Control

B. Storage Engine and Disk Storage

C. Relational Engines

D. External Interfaces

Correct Answer: D

Question 10

What are advantages of column store tables? There are 3 correct answers to this question.

A. Data footprint is automatically reduced through compression

B. They are optimized for high-volume read /write transactional processing

C. Only the columns required are actually loaded to memory

D. Columns can be partitioned

Correct Answer: A,C,D

Question 11

Which authentication method can you configure for single sign-on in a middleware/application server scenario.

A. X.509 certificate

B. Kerberos

C. SAML

D. JSON web token

Correct Answer: B

Welcome to TestSimulate

SAP Certified Technology Associate - SAP HANA 2.0 SPS05 (C_HANATEC_17) Free Practice Test