SAP C_HANATEC_16 SAP Certified Technology Associate - SAP HANA 2.0 SPS04 Online Training

Exam4Training has a huge IT industry elite team. They all have high authority in the IT area. They use professional knowledge and experience to provide SAP C_HANATEC_16 SAP Certified Technology Associate – SAP HANA 2.0 SPS04 Online Training for people ready to participate in SAP C_HANATEC_16 exam. The accuracy rate of SAP C_HANATEC_16 SAP Certified Technology Associate – SAP HANA 2.0 SPS04 Online Training provided by Exam4Training is very high and they can 100% guarantee you pass the SAP Certified Technology Associate – SAP HANA 2.0 SPS04 exam successfully for one time. Besides, we will provide you a free one-year update service.

Page 1 of 4

1. You register a new resource in SAP HANA cockpit 2.0.

What prerequisite does the resource require?

A user with CATALOG READ privileges and SELECT on _SYS_STATISTICS schema

A user with DATA ADMIN privileges and SELECT on _SYS_TELEMETRY schema

A multitenant configuration with SYSTEMDB

The target database on SAP HANA 2.0 SPS00 or higher

2. What happens when you rename a tenant in an SAP HANA database Note: There are 2 correct answers.

The database is renamed

The directories are renamed

The backups are renamed

The logs are renamed

3. Which system privileges do you require to view roles that are granted to other users? Note: There are 2 correct answers.

CATALOG READ

USER ADMIN

DATA ADM IN

ROLE ADMIN

4. Which information is provided by the backup catalog. Please choose the correct answer.

Backup destination

Progress of a backup

Backup configuration

Backup ID

5. The design-time version of a security role can contain which of the following information? There are 2 correct answers to this question.

The role name

The privileges assigned to the role

The users assigned to the role

The users assigned by default to this role

6. Which SAP recommendations do you follow to create an optimal table partitioning plan for SAP Business Suite powered by SAP HANA? Note: There are 2 correct answers.

Have a high number of partitions per table

Have a low number of keys

Have partitions of a table on the same host

Have a high number of partitioned tables

7. Which activity must you perform before you can replay a workload using the Capture and Replay Application? Note: There are 2 correct answers.

Restore the source tenant backup into the target tenant

Start the replayer on the source system

Create the replayer user in the control system

Create a secure store key on the control system host

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

JSON web token

SAML

Kerberos

509 certificate

9. Which encryption services can you activate in SAP HANA? Note: There are 3 correct answers.

Backup

Data

Log

Pages in-memory

Storage snapshot

10. Which preparation tasks do you need to perform before starting the copy and move process for a tenant database? There are 3 correct answers to this question.

Create credentials for authenticated access to the source system.

Create a tenant on the target system identical to the source system.

Back up the source tenant database.

Configure a secure connection from target system to source system.

Create credentials for authenticated access to the target system.

Page 2 of 4

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

Delta 2

Main 2

Delta 1

Main 1

12. Which tool shows the difference of tables and indexes between your ABAP dictionary and your SAP HANA database?

DBA Cockpit

hdblcm

hdbsql

SAP HANA cockpit

13. You switched the SAP HANA database to normal log mode. When does the system perform a regular log backup? Note: There are 2 correct answers.

When a savepoint occurs

When the log buffer is full

After the configured time threshold has been exceeded

When the log segment is full

14. Which tools can you use to monitor the response time of individual SQL queries? Note: There are 2 correct answers.

SQL Trace

Statement Monitor

SQL plan cache

Thread Monitor

15. You administer a single-host system with 100GB physical memory. The global allocation limit and the individual service allocation limit are set to 90%. Three services are running-Service 1 has 25 GB of memory allocated and service 2 has 40 GB allocated.

What is the effective allocation limit of service 3?

100 GB

90 GB

35 GB

25 GB

16. You plan to set up an SAP HANA2.0 system on intel-based hardware platform.

Which of the following operating systems can you use ? Note: There are 2 correct answers

Red Hat Enterprise Linux for SAP HANA (RHEL for SAP HANA) 7.2

SUSE Linux Enterprise Server (SLES) for SAP Applications 12 SP1

SUSE Linux Enterprise Server (SLES) for SAP Applications 11 SP1

Red Hat Enterprise Linux for SAP HANA (RHEL for SAP HANA) 6.5

17. Which kinds of patches are available in the SAP HANA2.0 revision strategy? Note: There are 2 correct answers.

Feature Package Stack

Datacenter Service Point

Support Package

Support Package Stack

18. Which application do you use to reset the memory statistics before you analyze a tenant database using SAP HANA cockpit?

Manage Databases

Manage Services

Resource Directory

Performance Monitor

19. You upgrade an SAP HANA 1.0 system to SAP HANA 2.0.

Which of the following activities are required to avoid compatibility issues after the upgrade? Note: There are 2 correct answers.

Export the backup jobs history from SAP HANA 1.0 and import the history after the upgrade

Delete all Backup schedules with the SAP HANA cockpit 1.0

Create new backup schedules after the upgrade

Convert all SAP HANA 1.0 backup schedules to SAP HANA 2.0 backup schedules

20. How can you minimize the database migration option (DMO) downtime?

Run the benchmarking tool parallel to the DMO to automatically adjust the number of R3 load processes

Use the benchmarking tool for a productive database migration with the DMO procedure

Provide the measured table migration duration for table sequencing during benchmarking

Adjust the number of R3load processes during benchmarking and the DMO procedure

Page 3 of 4

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

SAP HANA cockpit 2.0 - Manage Databases

hdbsql

SAP HANA Studio - System view

sapcontrol

22. What can a user do when the backup operator system privileges is assigned?

Perform data recovery

Schedule backups

Delete backups

Configure backup settings

23. What is a prerequisite before you can install SAP HANA Cockpit 2.0 as a central monitoring

tool for productive SAP HANA databases?

A dedicated server with at least 16 GB RAM with SUSE Linux Enterprise Server (SLES) or Red Hat Enterprise Linux (RHEL)

A central SAP HANA database 2.0 with SAP HANA extended application services, advanced model (XS Advanced) installed

A central SAP HANA database 2.0 SPS02 multitenant database system with at least 16 GB of RAM

SAP Netweaver 7.5x on SAP HANA 2.0 with ABAP Core Data Services (CDS) and SAP Fiori installed

24. Which prerequisites of the primary system and the secondary system are mandatory before you can activate the SAP HANA system replication with the read-enabled mode? Note: There are 2 correct answers.

The same number of active hosts and standby hosts must be installed

Both must have the same SAP HANA version

An explicit read-only connection between both systems must be available

The CPU architecture must be identical

25. logical error occurred in one tenant of your SAP HANA database.

What action do you perform to make the tenant consistent again? Please choose the correct a nswer

Recover the affected tenant. The system database is NOT recovered.

Recover the system database first and then recover the affected tenant.

Recover the affected tenant first and then recover the system database.

Recover the system database. The affected tenant is recovered automatically.

26. Which diagnostic file can you use to monitor the status of database recovery?

backint.log

backup.log

sapstartsrv.log

available.log

27. After you start the SAP HANA database, what does the system do to ensure that it is in a consistent mode?

It determines and rolls forward aborted transactions

It rolls back write transactions that were open when the database was stopped

It reloads a savepoint with the restored consistent state of the database

It rolls back changes of committed transactions that were NOT written to the data area

28. Which tool do you use to backup the root encryption keys?

rsecssfx

hdbuserstore

dbacockpit

hdbnsutil

29. Which of the following system privileges can you assign to an SAP HANA database user? Note: There are 3 correct answers.

CREATE ANY

EXPORT

EXECUTE

CREATE SCHEMA

DEVELOPMENT

30. Which trace do you use to create a graphical representation of an individual SQL Statement?

Performance trace

Expensive statements trace

SQL trace

Plan trace

Page 4 of 4

31. One of your systems show the internal Disk Full (Alert 30) alert.

What is the root cause of this alert?

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

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

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

Exceeding system quota on the /usr/sap volume

32. Which information is provided via the SUM Ul? There are 3 correct answers to this question.

The active roadmap step

The content of log files via the log viewer

The memory consumption of SUM

A progress bar for the overall procedure

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

Columns can be partitioned

Only the columns required are actually loaded to memory

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

Data footprint is automatically reduced through compression

34. Once you start the SAP HANA cockpit 2.0, From the Aggregated Health Monitor, navigate to the SAP HANA system overview pag This page displays the detailed status of the selected SAP HANA system.

Which of the following options are listed? There are 3 correct answers to this question.

Monitoring and Administration

Performance Management

Resource Management

Security

Memory Management

35. Your SAP HANA database is locked down.

Which action can you still perform?

Check database license

Check overall database status

Check session memory

Configure system properties

36. Which role do you need in order to assign users to groups in SAP HANA cockpit? Please choose the correct answer.

Cockpit User Administrator

Cockpit User

Cockpit Resource Administrator

Cockpit Administrator

37. Which steps can be combined in a DMO procedure, targeting an AS ABAP 7.50 based SAP system? There are 2 correct answers to this question.

Migrating to a target database, g. SAP HANA

Performing an SAP software update

Performing a Unicode conversion

Performing a database upgrade of the source database

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

SYNCMEM

FULL SYNC

SYNC

ASYNC

39. Which scale-out roles can you assign to the hosts in the nameserver.ini file? There are 2 correct answers to this question.

SLAVE

STANDBY

WORKER

MASTER 1

40. The SAP HANA database is NOT reachable, and the root cause is unclear.

Which SAP HANA cockpit functions allow you to investigate this situation? Note: There are 2 correct answers.

Troubleshoot unresponsive system

Overall database status

Manage full system information dumps

Open blocked transactions

Latest C_HANATEC_16 Dumps Valid Version with 183 Q&As

Latest And Valid Q&A | 90 Days Free Update | Once Fail, Full Refund

Get Valid C_HANATEC_16 Exam

Latest C_HANATEC_16 Dumps Valid Version with 183 Q&As

Leave a Reply Cancel reply