Updated SAP Certified Technology Associate - SAP HANA 2.0 SPS05 C_HANATEC_17 Exam Questions

Updated SAP Certified Technology Associate – SAP HANA 2.0 SPS05 C_HANATEC_17 Exam Questions

Regina2021-12-15T06:40:03+00:00

It is highly recommended to choose the online C_HANATEC_17 exam questions to prepare for SAP Certified Technology Associate – SAP HANA 2.0 SPS05 test well. The certified experts and specialists of ITExamShop have designed all the SAP C_HANATEC_17 exam questions to ensure you succeed in achieving the SAP Certified Technology Associate – SAP HANA 2.0 SPS05 certification on the maiden try. The most updated C_HANATEC_17 exam questions of ITExamShop contain an optimum number of to-the-point and relevant SAP C_HANATEC_17 questions along with their correct answers. We are up to date on the latest changes that occur in the syllabus or structure of the C_HANATEC_17 exam and update C_HANATEC_17 practice test according to reflecting the alternations.

SAP Certification C_HANATEC_17 Free Questions Are Recommended To Read

Page 1 of 3

1. Which of the following database resources can be monitored at the DBA Cockpit Current Status Overview monitor? There are 3 correct answers to this question.

Memory and CPU consumption from the SAP HANA database.

Disk consumption from the SAP HANA database.

Connection statistics about open connections.

The time at which the database was started.

2. In which circumstances do you create a column store table? There are 3 correct answers to this question.

When the calculations are based on a small number of columns

When aggregations or fast search is required

When accessing complete records

When the table has a large number of columns

3. What cryptographic libraries are supported in SAP HANA by default? There are 2 correct answers to this question.

LibgCrypt

OpenSSL

Common Cryptolib

WolfCrypt

4. In an SAP HANA database system running in log mode "normal", in which situation does the system automatically execute a regular log backup? There are 2 correct answers to this question.

When the log buffer is full.

When the time threshold is exceeded.

When the log segment is full.

When a commit occurs.

5. Your customer has purchased a 3 TB SAP HANA license.

To which value do you set the GLOBAL_ALLOCATION_LIMIT parameter when you have four 2TB nodes in an SAP HANA scale-out system with three worker and one standby nodes? Please choose the correct answer.

1TB

0.5 TB

3 TB

1.5 TB

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

Critical

Auto

Hard

Smart

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

Performance trace

Expensive statements trace

SQL trace

Plan trace

8. For which scenarios is it mandatory to define the authorizations at HANA Level? There are 2 correct answers to this question.

Business Suite on HANA

SAP HANA Live for SAP Business Suite

SAP S/4HANA

Web-based native applications based on XS

9. Which operating system process takes care of starting the SAP HANA database system services?

Please choose the correct answer.

hdbrsutil

hdbdaemon

apstartsrv

sapstart

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

Perform data recovery

Schedule backups

Delete backups

Configure backup settings

Page 2 of 3

11. What additional action do you need to perform after you created a new tenant in an SAP HANA system replication configuration? Please choose the correct answer.

Back up tenant database

Copy tenant database.

Start tenant database.

Restart secondary system.

12. Which products do you use for SAP HANA administration? There are 2 correct answers to this question.

SAP Solution Manager

SAP Web IDE for SAP HANA

SAP HANA cockpit

SAP Master Data Governance

13. Which system privilege must you have to manage black listed parameters in SAP HANA cockpit? Please choose the correct answer.

DATABASE ADMIN

WORKLOAD ADMIN

INIFILE ADMIN

RESOURCEADMIN

14. What do you require to perform a migration using the SUM database migration option? Note: There are 2 correct answers.

OS/DB certified consultant

Migration check Services

Migration key

Stack.xml file

15. You need to update the location where a copy of the persistent data is saved .

Which of the following parameters do you change? Note: There are 2 correct answers.

basepathjogmirror

basespath_export

basepathjogbackup

basepath_databackup

16. You are performing a database migration option (DMO) procedure and applying SAP support packages in combination as in-place migration .

Which steps take place during downtime? There are 2 correct answers to this question.

Activation of dictionary objects in phase ACT_UPG

XPRaS execution in phase XPRAS_AIMMRG

Migration of application tables in phase EU_CLONE_MIG_DT_RUN

Creation of application tables in the target database in phase EU_CLONE_MIG_DT_CREATE

17. You must design a high-availability SAP HANA database system with 8 hosts (6 worker and 2 standby) that also uses multitenant database containers .

Which rules apply? There are 2 correct answers to this question.

The system database must run on the standby host.

The system database instance must run on all hosts (worker and standby).

The tenant databases must be able to be scaled out to all hosts (worker and standby).

The tenant databases must run on the worker hosts.

18. Which tool shows you information about the list of tables to be pre-loaded during an SAP HANA system start? Please choose the correct answer.

hdbcons

RecoverStateCheckerpy

sap control

HDBAdmin

19. 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

20. When you use the database migration option reset procedure as a fallback scenario, which of the changes made during the migration are NOT reset? There are 3 correct answers to this question.

The SAP ABAP kernel on the application server

The DBACOCKPIT user on the SAP HANA database

The updated BRTOOLS on the non-SAP database

The deleted SAP BusinessObjects Business Intelligence data on the non-SAP database

The shadow schema on the non-SAP database

Page 3 of 3

21. When can you load and unload individual tables and table columns manually in an SAP HANA tenant database? There are 2 correct answers to this question.

When you need to extend the scale-out memory

When you need to optimize the standby node memory.

When you need to measure total memory

When you need to actively free up memory.

22. What can you assign to a user with the User Management app in SAP HANA cockpit? There are 2 correct answers to this question.

LDAP identity provider

Scopes

User group

LDAP authorization mode

23. What do you have to consider when you perform a Tailored Data Center Integration (TDI) installation for a productive SAP HANA database system? There are 2 correct answers to this question.

Having the data and log volumes on the different disks.

Obtaining the hardware certification from SAP for the existing hardware you are going to use.

Obtaining C_HANATEC_XX Certification.

Having 10 GBit/s for storage zone and 1 GBit/s for internal zone for network connectivity.

24. 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

25. SAP HANA system replication is configured and active between two SAP HANA systems.

After which action must you perform manual steps to synchronize the systems? Please choose the correct answer.

A restart of the primary system

A restart of the secondary system

An upgrade of the secondary system

An upgrade of the primary system

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

Admission control

Capture and replay

Thread throttling

Workload classes

27. What is the first node limit for planning an SAP S/4HANA scale-out system? There are 2 correct answers to this question.

>= 6TB

>= 8TB

>= 8cpu

>= 12cpu

28. 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.

threshold_cpu_time

cpu_time_measurement_mode

load_monitor_granularity

enable_tracking

Welcome To Choose Required IT Certification Exams Online

Updated SAP Certified Technology Associate – SAP HANA 2.0 SPS05 C_HANATEC_17 Exam Questions

SAP Certification C_HANATEC_17 Free Questions Are Recommended To Read

Author