C_HANATEC_17 SAP Certified Technology Associate - SAP HANA 2.0 SPS05 Dumps

If you are looking for free C_HANATEC_17 dumps than here we have some sample question answers available. You can prepare from our SAP C_HANATEC_17 exam questions notes and prepare exam with this practice test. Check below our updated C_HANATEC_17 exam dumps.

DumpsGroup are top class study material providers and our inclusive range of C_HANATEC_17 Real exam questions would be your key to success in SAP SAP Certified Technology Associate Certification Exam in just first attempt. We have an excellent material covering almost all the topics of SAP C_HANATEC_17 exam. You can get this material in SAP C_HANATEC_17 PDF and C_HANATEC_17 practice test engine formats designed similar to the Real Exam Questions. Free C_HANATEC_17 questions answers and free SAP C_HANATEC_17 study material is available here to get an idea about the quality and accuracy of our study material.

Sample Question 4

Your customer has purchased a 1.5 TB SAP HANA license. To which value do you set theGLOBAL_ALLOCATION_LIMIT parameter when you have four 1TB nodes in an SAPHANA scale-out system with three worker and one standby nodes? Please choose thecorrect answer.

A. 375 GB
B. 1.5 TB
C. 512 GB
D. 1.0 TB

Sample Question 5

What is the minimum space requirement for the Data Volume? There are 2 correct answersto this question.

A. 3 * RAM (Appliance)
B. 1.2 * RAM (TDI)
C. Min. 1 * RAM
D. Min. 0.5 * RAM

Sample Question 6

Which privileges are assigned automatically when you create a technical user during theregister resource procedure in SAP HANA cockpit? There are 2 correct answers to thisquestion.

A. SELECT on the _SYS_TELEMETRY schema
B. RESOURCE ADMIN
C. SELECT on the _SYS_STATISTICS schema
D. CATALOG READ

Sample Question 7

Which of the following tools can be used for User Administration? There are 3 correct Answers to this question.

A. SAP NetWeaver Identity Management
B. hdbsql
C. Resident hdblcm
D. SAP HANA Cockpit

Sample Question 8

In which replication mode is the primary system blocked until the secondary system isavailable?

A. syncmem
B. full sync
C. async
D. sync

Sample Question 9

What do you need in a Multitenant Database Container (MDC) system to run queriesacross tenant databases? There are 2 correct answers to this question.

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

Sample Question 10

You need to update the location where a copy of the persistent data is saved. Which of thefollowing parameters do you change? Note: There are 2 correct answers.

A. basepathjogmirror
B. basespath_export
C. basepathjogbackup
D. basepath_databackup

Sample Question 11

Which database objects can you manipulate if you have the ALL PRIVILEGES activity?There are 2 correct answers to this question.

A. Procedures
B. Sequences
C. Tables
D. Views

Sample Question 12

Which user credentials are requested during the initial run of the configuration phase whenperforming the Database Migration Option (DMO) procedure to an SAP HANA 2.0database tenant? There are 3 correct answers to this question.

A. The DBACOCKPIT user of the tenant database
B. The S-user for the SAP Support Portal connection
C. The SYSTEM user of the system database
D. The DDIC user in client 000 of the A BAP system
E. The SAP user in client 000 of the ABAP system

Sample Question 13

In single-host SAP HANA systems, you can use plain attached storage devices, such asSmall Computers System Interface hard drives, solid-state drives (SSDs), or storage areanetworks (SANs).However, to build a multi-host system with failover capabilities, the storage must ensurewhich of the following conditions?There are 2 correct answers to this question.

A. SYSTEM users replaced by standby host
B. The failed worker host no longer has access to write to files
C. The standby host has file access
D. The standby host has access to write to files

Sample Question 14

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

A. DBA cockpit
B. SAP HANA application life cycle management (HDBLCM)
C. HDB command
D. SAP HANA cockpit
E. Sapcontrol

Sample Question 15

What are the two features of the storage engine in the SAP HANA index server that enabledata consistency and maintain durable changes? Please choose

A. Metadata Manager and Transaction Manager
B. Page Management and logge
C. Column Store and Row Store
D. Session Management and log Volumes

Sample Question 16

Which parameter do you set to protect an SAP HANA database system againstuncontrolled queries that consume excessive memory? There are 2 correct answers to thisquestion.

A. memory_tracking
B. statement_memory_limit
C. reject_memory_threshold
D. total_statement_memory_limit

Sample Question 17

Which backup types you can schedule using SAP Hana cockpit 2.0. There are 2 correctanswers to this question.

A. Delta Backup
B. Backup of Configuration files
C. Data Backup
D. Data Snapshot

Sample Question 18

Which tasks must you perform to convert a single database to a multitenant databasesystem? There are 2 correct answers to this question.

A. Set the password for the system database user.
B. Create an operating system user for the converted tenant database.
C. Trigger the conversion in the SAP HANA cockpit 2.0.
D. Generate the system database before the conversion.

Sample Question 19

What must you do to convert an SAP HANA 1.0 single database system to an SAP HANA2.0 multitenant database system?

A. Export/import application and customer data
B. Upgrade the SAP HANA database system
C. Execute the SUM database migration option with system move
D. Create the system database manually

Sample Question 20

Which connection types are allowed when you use system replication with the Active/Activeoption? There are 2 correct answers to this question.

A. Automatic round-robin statement routing
B. Explicit read and write on the secondary system
C. Explicit read only on the secondary system
D. Implicit hint-based statement routing

Sample Question 21

Which components of SAP HANA Indexserver allow clients to connect and communicatewith the SAP HANA database? Please choose the correct Answer:.

A. Request Processing and Execution Control
B. Relational Engines
C. External Interfaces
D. Storage Engine and Disk Storage

Sample Question 22

Your customer has security restrictions that prohibit direct SQL connections from your PCto the productive SAP HANA system.Which tools can you use to monitor the system alerts of the SAP HANA database from yourPC? There are 2 correct answers to this question.

A. SAP HANA studio
B. DBA Cockpit
C. SAP NANA cockpit 2.0
D. HDBSQL command line tool

Sample Question 23

You suspect an authorization issue while executing SAP HANA reports that containcalculation views. How do you configure the authorization trace? There are 2 correctanswers to this question.

A. Specify the name of the table/view.
B. Select INFO from the System Trace Level for the Indexserver component and thenselect AUTHORIZATION.
C. Specify the user as the database user.
D. Select INFO from the System Trace Level for the Preprocessor component and then select AUTHORIZATION.

Sample Question 24

Which backup scenarios are allowed in multitenant database containers? Note: There are 2correct answers.

A. The system database can initiate its own backup and the backup of tenant databases
B. A backup of a tenant database can be recovered to an SAP HANA single-containersystem
C. The system database should be recovered first in order to recover the tenant databases
D. A tenant database can initiate its own backup unless this is prohibited by the systemconfiguration

Sample Question 25

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

A. Feature Package Stack
B. Datacenter Service Point
C. Support Package
D. Support Package Stack

Sample Question 26

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

A. CATALOG READ
B. USER ADMIN
C. DATA ADM IN
D. ROLE ADMIN

Sample Question 27

What is a prerequisite before you can install SAP HANA Cockpit 2.0 as a central monitoringtool for productive SAP HANA databases?

A. A dedicated server with at least 16 GB RAM with SUSE Linux Enterprise Server (SLES)or Red Hat Enterprise Linux (RHEL)
B. A central SAP HANA database 2.0 with SAP HANA extended application services,advanced model (XS Advanced) installed
C. A central SAP HANA database 2.0 SPS05 multitenant database system with at least 16GB of RAM
D. SAP Netweaver 7.5x on SAP HANA 2.0 with ABAP Core Data Services (CDS) and SAPFiori installed

Sample Question 28

You need to rename a tenant database using the Manage Database app in the SAP HANAcockpit. Which prerequisite do you require? Note: There are 2 correct answers.

A. The tenant database must be on one host
B. The tenant database is stopped
C. You have the DATABASE ADMIN system privileges
D. The system database must be on the master node

Sample Question 29

What is the correct minimum requirement for log volume and/hana/shared/ file system foran SAP HANA database system? Please choose the correct answer.

A. For 256 GB system, Log volume = 128 GB,/hana/shared/ = 256 GB
B. For 512 GB system, Log volume = 512 GB,/hana/shared/ = 256 GB
C. For 1 TB system, Log volume = 1 TB,/hana/shared/ = 1TB
D. For 2 TB system, Log volume = 1 TB,/hana/shared/ = 1TB

Sample Question 30

Where is SDI used? There are 2 correct answers to this question.

A. Data transformation
B. Data cleansing
C. Data streaming
D. For data loading

Sample Question 31

Which best practices do you apply when you optimize the table distribution in a scale-outSAP HANA database?There are 2 correct answers to this question.

A. Table partitions can be distributed over all nodes.
B. The row store can be distributed over all nodes.
C. Cross-node joins must be avoided.
D. The columns of a table can be distributed over all nodes.

Sample Question 32

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

A. SQL Trace
B. Statement Monitor
C. SQL plan cache
D. Thread Monitor

Sample Question 33

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

A. Backup
B. Data
C. Log
D. Pages in-memory
E. Storage snapshot

Sample Question 34

Which actions are always recorded when auditing is active? Note: There are 2 correctanswers.

A. Disable auditing
B. Grant or revoke user
C. Modification of an audit policy
D. Create or drop user

Sample Question 35

Which properties can you adjust in SAP HANA Admission Control? There are 3 correctanswers to this question.

A. CPU threshold for rejecting requests
B. Maximum request queue size
C. Maximum parallel 10 requests
D. Memory limit for queuing requests
E. SQL statement request memory limit

Sample Question 36

Where are the R3load processes located when performing the Database Migration Option(DMO) procedure using the in-place migration? Please choose the correct answer.

A. On the Additional Application Server (AAS) host
B. On the source and target host
C. On the remote target database host
D. On the Primary Application Server (PAS) host

Sample Question 37

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

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

Sample Question 38

Reloading column tables in this way restores the database to a fully operational state morequickly. However, it does create performance overhead, and may not be necessary innonproductive systems, how can you deactivate the the reload feature? Please choose the correct answer.

A. Edit the indexserver.xml file by setting the reload_tables parameter in the sql section to false
B. Edit the indexserver.xml file by setting the reload_tables parameter in the sql section to false
C. Edit the indexserver.ini file by setting the reload_tables parameter in the sql section to true
D. Edit the indexserver.ini file by setting the reload_tables parameter in the sql section to false

Sample Question 39

You need to recover a tenant database backup from SAP HANA system 1 into SAPHANAsystem2. Which activities do you perform to restore the tenant? Note: There are 2correct answers.

A. Create the tenant in the target database
B. Recover the tenant with the Initialize Log Area option
C. Copy the transaction logs to the target database
D. Start the recovered tenant database

Sample Question 40

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

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

Sample Question 41

The data storage of your productive SAP HANA instance crashed, and you need to recoverthe database. The log storage is still intact. You have a full data backup that is 9 hours oldand an incremental backup that is 4 hours old. To which point in time can you recover tominimize the data loss? Please choose the correct answer.

A. The last full data backup
B. The latest log backup
C. The latest incremental backup
D. The last commited transaction

Sample Question 42

Which of the following users are able to start and stop a distributed SAP HANA DatabaseSystem? There are 2 correct Answers to this question.

A. ROOT user
B. ADM user
C. SYSTEM user

Sample Question 43

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

A. The active roadmap step
B. The content of log files via the log viewer
C. The memory consumption of SUM
D. A progress bar for the overall procedure

Sample Question 44

Which certificates do you require for a trusted secure communication between the clientand the SAP HANA database? Note: There are 2 correct answers.

A. User certificate
B. Server certificate
C. X.509 certificate
D. Root certificate

Exam Code: C_HANATEC_17

Exam Name: SAP Certified Technology Associate - SAP HANA 2.0 SPS05

Last Update: May 13, 2024

Questions: 270