SAP SAP Certifications C_HANATEC_17 Questions & Answers

• Question 111:

  What tool must you use to add an additional host to an SAP HANA scale-out system? Please choose the correct answer Response:

  A. hdbnsutil

  B. hdbinst

  C. hdblcm

  D. hdbparam

  Correct Answer: C

• Question 112:

  Which action do you perform when SAP HANA Database is running out of space Please choose the correct answer. Response:

  A. Create a new tenant database

  B. extend the file system size on the operating system level

  C. create a new databse volume

  D. extend the size of database volume

  Correct Answer: C

• Question 113:

  You need to install multiple identically configured SAP HANA systems in batch mode. Which installation parameter is mandatory when you use a configuration file? Please choose the correct answer. Response:

  A. sid

  B. system_usage

  C. components

  D. number

  Correct Answer: A

• Question 114:

  During uptime migration, which information can you receive in the Charts Control Center, via the Utilities of the SUM UI? There are 3 correct answers to this question. Response:

  A. The configured maximum number of parallel R3load processes

  B. The actual number of running R3load processes

  C. The memory consumption of the target database

  D. The process buckets being processed

  Correct Answer: ABD

• Question 115:

  Which SAP HANA features ensure that committed data is NOT lost if there is a power failure? There are 2 correct answers to this question. Response:

  A. Automatic savepoints

  B. Persisted redo logs

  C. Delta merge

  D. Undo logs

  Correct Answer: AB

• Question 116:

  Which partitioning type must you use to produce an equal distribution of rows in the SAP HANA database?

  Please choose the correct answer

  Response:

  A. Round-robin

  B. Aging

  C. Hash-range

  D. Range

  Correct Answer: A

• Question 117:

  Which of the following actions can be audited by SAP HANA? There are 2 correct answers to this question. Response:

  A. Changes to system configuration.

  B. Upgrade of an SAP HANA database instance.

  C. Create or drop user, and create or drop role.

  Correct Answer: AC

• Question 118:

  Your business users are complaining about longer-than-usual query runtimes and you want to get an overview of long-running queries.

  Where do you activate the expensive statements trace? There are 2 correct answers to this question

  Response:

  A. SAP HANA studio diagnosis mode

  B. SAP HANA cockpit 2.0

  C. SAP HANA database explorer for SAP HANA cockpit

  D. SAP HANA Web-based Development Workbench

  Correct Answer: BC

• Question 119:

  In SAP HANA Studio, what would you find in a Package? There are 3 correct answers to this question. Response:

  A. Calculation Views

  B. Analytic Privileges

  C. Procedures

  D. Tables

  Correct Answer: ABC

• Question 120:

  Which security settings can you monitor in SAP HANA cockpit 2.0? There are 2 correct answers to this question. Response:

  A. Data Storage Security

  B. Password Policy

  C. Manage Database Backups

  D. Manage Users

  Correct Answer: AB