SAP Certified Technology Associate - SAP HANA 2.0 SPS04 - C_HANATEC

QUESTION NO: 1
Which update methods can yo use to minimize the business downtime during the upgrade of an SAP HANA database? Note: There are 2 correct answers.

A. Database migration options of SUM B. Phases update C. Export/import using SAP Provisioning Manager D. Near Zero Downtime

Correct Answer: A,D

QUESTION NO: 2
Why does SAP HANA have a persistence storage layer that is disk-based? Note: There are 2 correct answers.

A. To enable database scale-up B. To allow a restart if the power fails C. To ensure maximum performance D. To persist in-memory data

Correct Answer: B,D

QUESTION NO: 3
You need to analyze the high CPU load of running thread in more detail in the Thread Monitor. Which parameters do you need to change? Note: There are 2 correct answers.

A. enable_tracking B. threshold_cpu_time C. load_monitor_granularity D. cpu_time_measurement_mode

Correct Answer: C,D

QUESTION NO: 4
Which system schema provides performance data and system alerts details to review in SAP HANA MiniChecks? Please choose the correct answer.

A. _SYS_TELEMETRY B. _SYS_WORKLOAD_REPLAY C. _SYS_STATISTICS D. _SYS_SQL_ANALYZER

Correct Answer: C

QUESTION NO: 5
What do you need in a Multitenant Database Container (MDC) system to run queries across tenant databases?
There are 2 correct answers to this question.

A. The cross-tenant database communication must be explicitly activate B. The user in the source system must be associated with a user in the target database C. The bidirectional communication channel must be whiteliste D. The user in the source system must have sufficient privileges in the target database

Correct Answer: A,D

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

A. Columns can be partitioned B. Data footprint is automatically reduced through compression C. They are optimized for high-volume read /write transactional processing D. Only the columns required are actually loaded to memory

Correct Answer: A,B,D

QUESTION NO: 7
What must you do to configure the data backup on a scale-out SAP HANA system? Note: There are 2 correct answers

A. Specify the individual backup destination on each node B. Verify that data and log backup destinations are valid throughout the system C. Change the backup configuration for each node D. Ensure the availability of shared backup storage

Correct Answer: B,D

QUESTION NO: 8
Which backup and recovery scenario is allowed in multitenant database containers?

A. A tenant database can initiate its own backup, but the system database executes the recovery. B. A backup of a tenant database can be recovered to the system database. C. After the recovery of a tenant database, the system database needs a backup. D. The system database should be recovered first in order to recover the tenant databases.

Correct Answer: A

QUESTION NO: 9
Which SAP HANA features can you use to manage the database peak load? There are 2 correct answers to this question.

A. Capture and replay B. Workload classes C. Admission control D. Thread throttling

Correct Answer: B,C

QUESTION NO: 10
Which user management tasks can be performed by a Lightweight Directory Access Protocol (LDAP) server?
There are 2 correct answers to this question.

A. Password policy configuration B. User creation C. Role assignment D. User mapping

Correct Answer: B,C

QUESTION NO: 11
Which file systems are supported for the SAP HANA database system? There are 2 correct answers to this question.

A. EXT3 B. GPFS C. MPFS D. Dxfs

Correct Answer: A,B

QUESTION NO: 12
How can you shorten the delta merge runtime of a table?

A. Fully load the delta store into memory B. Merge per column C. Perform memory-only delta merges D. Partition the table

Correct Answer: C,D

QUESTION NO: 13
You migrate an SAP HANA system using SUM database migration option. Which activities do you perform to activate the viewer mode for SAP support? Note: There are 2 correct answers.

A. Create the OS user <sid>obs on the application server B. Provide the SUM URL to SAP support C. Provide the sum observer URL to SAP support D. Create the database user <sid>obs on the application server

Correct Answer: A,C

QUESTION NO: 14
Which SAP HANA database service can you stop from the system database? There are 2 correct answers to this question

A. Compile server B. XS Engine C. Index server D. Preprocessor

Correct Answer: A,D

SAP Certified Technology Associate - SAP HANA 2.0 SPS04 - C_HANATEC_16 Exam Questions