Latest [Mar 29, 2023] SAP C-HANATEC-18 Exam Practice Test To Gain Brilliante Result [Q45-Q67]

Share

Latest [Mar 29, 2023] SAP C-HANATEC-18 Exam Practice Test To Gain Brilliante Result

Take a Leap Forward in Your Career by Earning SAP C-HANATEC-18


SAP C-HANATEC-18 Exam Syllabus Topics:

TopicDetails
Topic 1
  • Performing the daily SAP HANA database administration tasks using SAP HANA cockpit
  • SAP HANA Database Administration
Topic 2
  • SAP HANA High Availability and Disaster Recovery
  • Install, configure and monitor SAP HANA database systems
Topic 3
  • Monitor and analyze the performance of SAP HANA systems
  • SAP HANA Monitoring and Troubleshooting
Topic 4
  • Understand the SAP HANA database system security concepts
  • perform Root Cause Analysis using the SAP HANA cockpit
Topic 5
  • SAP HANA using the Database Migration Option (DMO) of SUM
  • Sizing, Installation, update and post-installation tasks for SAP HANA
Topic 6
  • Configure and execute SAP HANA database system backups
  • Describing the SAP HANA database system architecture and the different deployment options

 

NEW QUESTION 45
How can you ensure that a consistent database status is saved using data snapshots?

  • A. Create a fallback snapshot
  • B. Execute the hdbbackupdiag tool
  • C. Trigger a savepoint.
  • D. Create an internal database snapshot

Answer: D

 

NEW QUESTION 46
Which system privilege do you need to redistribute tables across the hosts in a scale-out system?

  • A. workload admin
  • B. optimizer admin
  • C. resource admin
  • D. data admin

Answer: C

 

NEW QUESTION 47
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/<SID>
  • C. /usr/sap/hostctrl >/
  • D. /hana/log/<SID>

Answer: A,D

 

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

  • A. Scopes
  • B. LDAP authorization mode
  • C. User group
  • D. LDAP identity provider

Answer: B,C

 

NEW QUESTION 49
Which system privilege must you have to restrict features for tenant databases in the SAP HANA cockpit?

  • A. RESOURCE ADMIN
  • B. INFILE ADMIN
  • C. WORKLOAD ADMIN
  • D. DATABASE ADMIN

Answer: B

 

NEW QUESTION 50
Which SAP HANA trace must you activate to analyze performance issues with systems where third-party software cannot be installed?

  • A. Kernel profiler
  • B. SQL
  • C. User-specific
  • D. End-to-end

Answer: B

 

NEW QUESTION 51
You are performing a database migration option (DMO) procedure and applying SAP support packages in combination as an in-place migration. Which steps take place during downtime? Note: There are 2 correct answers to this question.

  • A. Migration of application tables in phase EL) CLONE MIG DT RUN
  • B. Activation of dictionary objects in phase ACT UPG
  • C. Creation of application tables in the target database in phase EU CLONE MIG DT CREATE
  • D. XPRAS execution in phase XPRAS AIMMRG

Answer: A,D

 

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

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

Answer: B,C,E

 

NEW QUESTION 53
Which SAP HANA security tasks can be performed in combination with a Lightweight Directory Access Protocol (LDAP) server? Note: There are 2 correct answers to this question.

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

Answer: B,D

 

NEW QUESTION 54
How are savepoints triggered?
Note: There are 2 correct answers to this question.

  • A. By performing a database backup
  • B. By issuing a transactional commit
  • C. By a database soft shutdown
  • D. By performing a delta merge

Answer: A,C

 

NEW QUESTION 55
In which scenario do need SAP expert sizing? Note: There are 2 correct answers to this question.

  • A. Consolidating multiple SAP ERP source systems into one SAP ERP system on SAP HANA
  • B. Carving out SAP ERP functionality from the source system to the SAP ERP system on SAP HANA
  • C. When migrating existing SAP ERP systems from AnyDB to run on SAP HANA
  • D. Customer is new to SAP ERP applications and the SAP HANA database system

Answer: A,B

 

NEW QUESTION 56
Which actions are performed during the database migration option (DMO) procedure when you select the 'Do not compare table contents' option?
Note: There are 2 correct answers to this question

  • A. The clustered tables are declustered.
  • B. The content comparison is performed for repository tables.
  • C. A row count is executed for the migrated tables
  • D. A check sum is generated every 10000 rows

Answer: A,C

 

NEW QUESTION 57
Which tasks can you perform when using the SAP HANA database lifecycle manager (HDBLCM) from the SAP HANA installation media? Note: There are 2 correct answers to this question.

  • A. Uninstall the SAP HANA database system and its components
  • B. Extract the SAP HANA database system components.
  • C. Update the SAP HANA database system and its components.
  • D. Rename the SAP HANA database system.

Answer: B,C

 

NEW QUESTION 58
Which characteristics describe an SAP HANA multitenant database container (MDC) system? Note: There are 3 correct answers to this question.

  • A. Database isolation increases the isolation between tenant databases on operating system level
  • B. Each tenant database runs its own compile server and the preprocessor server.
  • C. The name server provides index server functionality for the system database.
  • D. A multitenant database container system is identified by a single system ID (SID).
  • E. The name server owns information about the location of tables and table partitions in databases.

Answer: A,C,D

 

NEW QUESTION 59
When performing a standard SAP HANA database system installation, which users Will be created or validated during that installation?
Note: There are 2 correct answers to this question.

  • A. <sid>crypt
  • B. sapadm
  • C. SAP<SID>
  • D. SYSTEM

Answer: B,D

 

NEW QUESTION 60
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. Persistent memory (PMEM) required for backups
  • C. DRAM required for the static data memory area
  • D. Total disk space required for the log volume

Answer: C,D

 

NEW QUESTION 61
Which SAP HANA cockpit application can you use to investigate a system offline situation?

  • A. Troubleshoot unresponsive system
  • B. Out-of-memory event monitor
  • C. Full system information dumps
  • D. CPU usage monitor

Answer: C

 

NEW QUESTION 62
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. The DMO pro e hasn't reached downtime yet
  • B. The source database is up and running
  • C. The SUM folder needs to exist
  • D. cleanup has already been triggered.

Answer: B,C

 

NEW QUESTION 63
You are registering an SAP HANA database resource using SAP HANA cockpit manager. Which privileges are automatically assigned when you initially create the COCKPIT MONITOR technical user? Note: There are 2 correct answers to this question.

  • A. CATALOG RAED
  • B. SELECT on the SYS TELEMETRY schema
  • C. SELECT on the SYS STATISTICS schema
  • D. DATABASE ADMIN

Answer: A,C

 

NEW QUESTION 64
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. SYNCMEM
  • B. ASYNC
  • C. SYNC
  • D. FULL SYNC

Answer: A,C

 

NEW QUESTION 65
What cryptographic libraries are supported in SAP HANA by default? Note: There are 2 correct answers to this question.

  • A. CommonCryptoLib
  • B. wolfCrypt
  • C. Libgcrypt
  • D. OpenSSL

Answer: A,D

 

NEW QUESTION 66
You are running a database migration option (DMO) procedure using in-place migration Where are the reading and writing R3load processes located during the actual migration?

  • A. The reading processes run on the primary application server (PAS) host; the writing processes run on the target database host.
  • B. All of the reading and writing processes run on the target database host
  • C. All of the reading and writing processes run on the primary application server (PAS) host.
  • D. The reading processes run on the source database host; the writing processes run on the target database host.

Answer: C

 

NEW QUESTION 67
......

Authentic Best resources for C-HANATEC-18 Online Practice Exam: https://testking.vceprep.com/C-HANATEC-18-latest-vce-prep.html