[Jan 27, 2022] SAP C-HANATEC-17 Real Exam Questions and Answers FREE
Pass SAP C-HANATEC-17 Exam Info and Free Practice Test
SAP HANATEC 17 Certification Exam Topics:
| Topic Areas | Topic Details, Courses, Books | Weighting |
|---|---|---|
| SAP HANA Database Administration | Performing the daily SAP HANA database administration tasks using SAP HANA cockpit. HA200 (SAP HANA 2.0 SPS05) | > 12% |
| SAP HANA Monitoring and Troubleshooting | Monitor and analyze the performance of SAP HANA systems, and be able to troubleshoot problems and perform Root Cause Analysis using the SAP HANA cockpit tools. HA200 (SAP HANA 2.0 SPS05) | 8% - 12% |
| SAP HANA Installation, Configuration and Upgrade | Performing installation, update and post-installation configuration tasks of the SAP HANA 2.0 database system. HA200 (SAP HANA 2.0 SPS05) | > 12% |
| SAP HANA Backup and Recovery | Configure and execute SAP HANA database system backups and restores in single host and system replication setups. HA200 (SAP HANA 2.0 SPS05) | 8% - 12% |
| SAP HANA Database Security | Understand the SAP HANA database system security concepts, create SAP HANA users and roles and setup audit policies. HA200 (SAP HANA 2.0 SPS05) | 8% - 12% |
| SAP HANA High Availability and Disaster Recovery | Install, configure and monitor SAP HANA database systems that are setup in a scale-out or in system replication configuration. HA200 (SAP HANA 2.0 SPS05) | > 12% |
| Database Migration Options for SAP HANA | Be able to perform database migrations from AnyDB to SAP HANA using the Database Migration Option (DMO) of SUM. HA100 (SAP HANA 2.0 SPS05) | 8% - 12% |
| SAP HANA Architecture and Deployment Options | Describing the SAP HANA database system architecture and the different deployment options. HA100 (SAP HANA 2.0 SPS05) | 8% - 12% |
SAP C-HANATEC-17 Exam Description:
The "SAP Certified Technology Associate - 'SAP HANA 2.0 SPS05" certification exam verifies that the candidate possesses the required knowledge in the area of the SAP HANA 2.0 (SPS05) for the profile of an SAP HANA technology consultant. This certificate builds on the basic knowledge gained through related SAP HANA training and preferably refined by practical experience within an SAP HANA project team, whereby the consultant applies the acquired knowledge practically in projects. Furthermore, the "SAP Certified Technology Associate - SAP HANA 2.0" certification exam verifies, that the candidate has the knowledge of installing SAP HANA required by the profile of an SAP HANA technology consultant.
NEW QUESTION 125
Which of the following elements are required for implementing a database copy? There are 2 correct answers to this question.
- A. Source and target databases can have different number and types of services.
- B. The target database must have a the same or higher version than the source database.
- C. You don't have to be concerned about disk space and memory of the target database.
- D. A data backup (file-based backups or backups using a third-party backup tool) or a storage snapshot of the source system is available.
Answer: B,D
NEW QUESTION 126
Which SAP HANA features can you use to manage the database peak load? There are 2 correct answers to this question.
- A. Thread throttling
- B. Capture and replay
- C. Workload classes
- D. Admission control
Answer: C,D
NEW QUESTION 127
Which tasks must you perform to convert a single database to a multitenant database system? There are 2 correct answers to this question.
- A. Generate the system database before the conversion.
- B. Create an operating system user for the converted tenant database.
- C. Trigger the conversion in the SAP HANA cockpit 2.0.
- D. Set the password for the system database user.
Answer: C,D
NEW QUESTION 128
What do you do to prepare the database migration option of a Software Update Manager procedure? Note:
There are 3 correct answers.
- A. Extract the SAP HANA Client installation archive
- B. Move the stack.xml update file into the download folder
- C. Move the R3trans update archive into the download folder
- D. Move the SPAM update archive into the download folder
- E. Extract the SAP HANA database installation archive
Answer: A,B,D
NEW QUESTION 129
How can you optimize the Database Migration Option (DMO) procedure downtime for a production system?
There are 2 correct answers to this question.
- A. Use the benchmarking option to find the optimal throughput during the DMO procedure.
- B. Use the Test Cycle opt on to find the optimal number of R31oad processes in a test run.
- C. Set the optimal number of R31oad processes during benchmarking and the DMO procedure
- D. Provide the measured table migration duration data for optimal table sequencing during benchmarking.
Answer: C,D
NEW QUESTION 130
Which properties can you adjust in SAP HANA Admission Control? There are 3 correct answers to this question.
- A. Maximum parallel 10 requests
- B. Maximum request queue size
- C. SQL statement request memory limit
- D. CPU threshold for rejecting requests
- E. Memory limit for queuing requests
Answer: B,D,E
NEW QUESTION 131
What do you require to perform a migration using the SUM database migration option? Note: There are 2 correct answers.
- A. Stack.xml file
- B. OS/DB certified consultant
- C. Migration check Services
- D. Migration key
Answer: A,D
NEW QUESTION 132
You plan to migrate a non-SAP database to SAP HANA using the database migration option (DMO) of the Software Update Manager. Which advanced DMO options can you adjust to speed up the migration? There are
2
correct answers to this question.
- A. SAPup processes
- B. SQL processes
- C. TP processes
- D. R3trans processes
Answer: B,D
NEW QUESTION 133
SAP HANA, in the context of user management, allows you to do which of the following? There are 3 correct answers to this question.
- A. Lock and unlock users
- B. Assign a user to a user group
- C. Create a restricted user
- D. Create and delete users
Answer: A,C,D
NEW QUESTION 134
Which of the following privileges allow read access to data in SAP HANA information models depending on certain values or combination of values?
- A. Package Privileges
- B. Analytic Privileges
- C. System Privileges
- D. Object Privileges
Answer: B
NEW QUESTION 135
Which tool do you use to investigate an SAP HANA system that is started but can't be reached using SQL?
There are 2 correct answers to this question.
- A. HANASitter
- B. HDBAdmin
- C. hdbcons
- D. Sapcontrol
Answer: C,D
NEW QUESTION 136
You perform an SAP HANA migration to a scale-out landscape. When do you setup the table distribution?
- A. Before table creation
- B. After the migration
- C. Before the migration
- D. After table creation
Answer: C
NEW QUESTION 137
Which update methods can yo use to minimize the business downtime during the upgrade of an SAP HANA database? Note: There are 2 correct answers.
- A. Export/import using SAP Provisioning Manager
- B. Database migration options of SUM
- C. Phases update
- D. Near Zero Downtime
Answer: B,D
NEW QUESTION 138
What are the advantages of the DMO procedure? There are 3 correct answers to this question.
- A. DMO combines several steps into one procedure.
- B. DMO allows a lower target release on SAP HANA database.
- C. DMO is an inplace procedure by default, keeping the application server host.
- D. DMO allows an easy reset during the procedure.
Answer: A,C,D
NEW QUESTION 139
You need to recover a tenant database backup from SAP HANA system 1 into SAP HANAsystem2. Which activities do you perform to restore the tenant? Note: There are 2 correct answers.
- A. Start the recovered tenant database
- B. Copy the transaction logs to the target database
- C. Recover the tenant with the Initialize Log Area option
- D. Create the tenant in the target database
Answer: B,C
NEW QUESTION 140
What is a characteristic of the Delta Data Shipping operation mode in SAP HANA system replication? There are 2 correct answers to this question.
- A. Delta data shipping takes place every 5 minutes.
- B. Delta data shipping takes place in addition to continuous log replay.
- C. Delta data shipping takes place in addition to continuous log shipping.
- D. Delta data shipping takes place with continuous read-only access to the secondary system.
Answer: B,C
NEW QUESTION 141
Your customer wants to know when the productive SAP HANA system was updated and to which version.
Where do you find this information? There are 2 correct answers to this question
- A. In the General Information app of SAP HANA cockpit 2.0
- B. In the SAP HANA database explorer for SAP HANA cockpit 2.0
- C. In the administration editor of the SAP HANA studio
- D. In the catalog view of the SAP HANA Web-based Development Workbench
Answer: C,D
NEW QUESTION 142
Which parameter do you set to protect an SAP HANA database system against uncontrolled queries that consume excessive memory? There are 2 correct answers to this question.
- A. reject_memory_threshold
- B. memory_tracking
- C. total_statement_memory_limit
- D. statement_memory_limit
Answer: C,D
NEW QUESTION 143
You register a new resource in SAP HANA cockpit 2.0. What prerequisite does the resource require?
- A. A multitenant configuration with SYSTEMDB
- B. The target database on SAP HANA 2.0 SPS00 or higher
- C. A user with CATALOG READ privileges and SELECT on _SYS_STATISTICS schema
- D. A user with DATA ADMIN privileges and SELECT on _SYS_TELEMETRY schema
Answer: C
NEW QUESTION 144
In which SAP HANA configuration file can you view the assignments of hosts to their scale-out role?
- A. Multidb.ini
- B. Indexserve.ini
- C. Nameserver.ini
- D. Sapprofile.ini
Answer: C
NEW QUESTION 145
For which scenarios is it mandatory to define the authorizations at HANA Level? There are 2 correct answers to this question.
- A. Web-based native applications based on XS
- B. SAP S/4HANA
- C. Business Suite on HANA
- D. SAP HANA Live for SAP Business Suite
Answer: A,D
NEW QUESTION 146
Which database objects can you manipulate if you have the ALL PRIVILEGES activity? There are 2 correct answers to this question.
- A. Procedures
- B. Views
- C. Tables
- D. Sequences
Answer: A,B
NEW QUESTION 147
Which system privilege must you have to redistribute tables across the hosts in your scale-out system?
- A. DATA ADMIN
- B. WORKLOAD ADMIN
- C. RESOURCE ADMIN
- D. OPTIMIZER ADMIN
Answer: C
NEW QUESTION 148
......
Latest C-HANATEC-17 Exam Dumps SAP Exam: https://www.dumpstillvalid.com/C-HANATEC-17-prep4sure-review.html
