Exam4Training

SAP C_HANATEC_18 SAP Certified Technology Associate – SAP HANA 2.0 SPS06 Online Training

Question #1

Which replication modes keep the primary system waiting until a timeout is exceeded when the secondary system is not available? Note: There are 2 correct answers to this question.

  • A . ASYNC
  • B . SYNCMEM
  • C . FULL SYNC
  • D . SYNC

Reveal Solution Hide Solution

Correct Answer: B,D
Question #2

Which actions can you perform using the SAP HANA platform lifecycle management web user interface? Note: There are 2 correct answers to this question.

  • A . Configure the system landscape directory registration.
  • B . Manage the full system information dumps.
  • C . Update the SAP HANA database system
  • D . Stop and start the SAP HANA database system

Reveal Solution Hide Solution

Correct Answer: A,C
Question #3

CORRECT TEXT

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

  • A . One table is migrated per R3load pair
  • B . De-pooling of tables is done during the procedure.
  • C . TABART is considered for the creation of R3load control files.
  • D . SAP up decides which tables to split.

Reveal Solution Hide Solution

Correct Answer: A, D
Question #4

Which feature do you use to dynamically manage SAP HANA database workloads per client session?

  • A . Workload classes
  • B . Admission control
  • C . Parallel execution of SQL statements
  • D . Non-Uniform Memory Access (NUMA)

Reveal Solution Hide Solution

Correct Answer: A
Question #5

Which prerequisites must be fulfilled before adding hosts to an SAP HANA scale-out system? Note: There are 2 correct answers to this question.

  • A . The SAP HANA system installation is on a shared file system
  • B . The additional host is placed in a different data center
  • C . The SAP HANA database server IS shut down.
  • D . The host has access to the Installation directories

Reveal Solution Hide Solution

Correct Answer: A,D
Question #6

Which feature do you configure to prevent the whole SAP HANA database system from reaching physical processing limits?

  • A . Workload classes
  • B . Capture and replay
  • C . Performance trace
  • D . Admission control

Reveal Solution Hide Solution

Correct Answer: D
Question #7

How are hosts assigned to the shared storage in the SAP HANA scale-out system? Note: There are 2 correct answers to this question.

  • A . The master node is assigned to its own data volume.
  • B . The master node is assigned to all log volumes
  • C . The worker nodes are assigned to their own log volumes
  • D . The standby node is assigned to the worker data volume.

Reveal Solution Hide Solution

Correct Answer: BD
Question #8

Which file systems are supported for the data and log volumes of the SAP HANA 2.0 database system? Note: There are 2 correct answers to this question.

  • A . Btrfs
  • B . OCFS2
  • C . GPFS
  • D . xfs

Reveal Solution Hide Solution

Correct Answer: C,D
Question #9

You are running an SAP HANA database in log mode "normal"

Under what circumstances does the database automatically execute a regular log backup? Note: There are 2 correct answers to this question.

  • A . When the log segment is full
  • B . When a commit occurs
  • C . When the time threshold is exceeded
  • D . When the log buffer is full

Reveal Solution Hide Solution

Correct Answer: A,C
Question #10

Which prerequisites have to be fulfilled before you reset a database migration option (DMO) procedure? Note: There are 2 correct answers to this question.

  • A . cleanup has already been triggered.
  • B . The SUM folder needs to exist
  • C . The DMO pro e hasn’t reached downtime yet
  • D . The source database is up and running

Reveal Solution Hide Solution

Correct Answer:   AD

Question #11

What are the merge methods that are triggered by the SAP HANA system? Note: There are 2 correct answers to this question.

  • A . Smart
  • B . Critical
  • C . Forced
  • D . Auto

Reveal Solution Hide Solution

Correct Answer: B,D
Question #12

What is a characteristic of the delta data shipping operation mode in SAP HANA system replication?

  • A . It takes place in addition to continuous log replay.
  • B . It takes place in addition to continuous log shipping
  • C . It takes place every 5 minutes
  • D . It takes place with continuous read-only access to the secondary system

Reveal Solution Hide Solution

Correct Answer: B
Question #13

You are planning an SAP S/4HANA scale-out system

What are the minimal size requirements for CPU and memory?

  • A . RAM: >= 4TB, CPU: > = 8
  • B . RAM: >= 6TB, CPU: >=8
  • C . RAM: >= 8TB, CPU: > = 12
  • D . RAM: >= 6TB, CPU: > = 12

Reveal Solution Hide Solution

Correct Answer: B
Question #14

What is the recommended size for the log volume file system for a 512 GB SAP HANA database system?

  • A . 614 GB
  • B . 256 GB
  • C . 512 GB
  • D . 427 GB

Reveal Solution Hide Solution

Correct Answer: B
Question #15

Which file system locations do need to specify when installing the SAP HANA multi-host database system using the default settings? Note: There are 2 correct answers to this question.

  • A . /hana/shared
  • B . /usr/sap/hostctrl >/
  • C . /hana/log/<SID>
  • D . /usr/sap/<SID>

Reveal Solution Hide Solution

Correct Answer: AD
Question #16

You are checking and monitoring SAP HANA system replication

Which status indicates a temporary connection loss of the secondary system?

  • A . Unknown
  • B . Error
  • C . Initializing
  • D . Syncing

Reveal Solution Hide Solution

Correct Answer: A
Question #17

During the delta merge process, to which memory areas is data inserted? Note: There are 2 correct answers to this question.

  • A . Main 2
  • B . Main 1
  • C . Delta 2
  • D . Delta 1

Reveal Solution Hide Solution

Correct Answer: A,C
Question #18

You want to perform the database migration option (DMO) procedure.

Which components have to be updated if they are not on the right version level? Note: There are 2 correct answers to this question.

  • A . SAP Host Agent
  • B . SPAM/SAINT
  • C . ST-PI
  • D . ABAP Kernel

Reveal Solution Hide Solution

Correct Answer: AD
Question #19

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

  • A . SQL Analyzer
  • B . HDBAdmin
  • C . HANASitter
  • D . SQL Console
  • E . Database Explorer

Reveal Solution Hide Solution

Correct Answer: A,D,E
Question #20

Which types of backups can you use to copy an SAP HANA tenant database? Note: There are 2 correct answers to this question.

  • A . Full database backup
  • B . Data snapshot
  • C . Delta database backup
  • D . Fallback snapshot

Reveal Solution Hide Solution

Correct Answer: A,B

Question #21

What can you check with the SAP HANA hardware and cloud measurement tools (HCMT)? Note: There are 2 correct answers to this question.

  • A . Cloud connector status
  • B . Linux kernel information
  • C . NUMA memory bandwidth test
  • D . CPU states

Reveal Solution Hide Solution

Correct Answer:   BC
Question #22

Which table holds the data used for the dynamic management of partitions and locations?

  • A . TABLE GROUP
  • B . UPDATE LANDSCAPE CONFIGURATION
  • C . TABLE PLACEMENT
  • D . EFFECTIVE TABLE PLACEMENT

Reveal Solution Hide Solution

Correct Answer:   D
Question #23

Which backup types can you schedule using the backup scheduler in the SAP HANA cockpit? Note: There are 2 correct answers to this question.

  • A . Delta backup
  • B . Full backup
  • C . Fallback snapshot
  • D . Data snapshot

Reveal Solution Hide Solution

Correct Answer: A,B
Question #24

Which hardware KPIs do you need to size before performing a tailored data center integration (TDI) installation for a productive SAP HANA database system? Note: There are 2 correct answers to this question.

  • A . Network bandwidth for the storage zone
  • B . Total disk space required for the log volume
  • C . Persistent memory (PMEM) required for backups
  • D . DRAM required for the static data memory area

Reveal Solution Hide Solution

Correct Answer:  AD
Question #25

How can the system database administrator disable tenant database functionalities? Note: There are 2 correct answers to this question.

  • A . Using the resident hdblcm tool
  • B . Using the Manage Restricted Features app
  • C . Using the Manage Database Configuration app
  • D . Using the hdbuserstore tool

Reveal Solution Hide Solution

Correct Answer:   BC
Exit mobile version