[Dec 17, 2021] C_HANATEC_17 Dumps PDF and Test Engine Exam Questions - SurePassExams
Verified C_HANATEC_17 exam dumps Q&As with Correct 272 Questions and Answers
C_HANATEC_17 Exam Certification Details:
| Cut Score: | 61% |
| Duration: | 180 mins |
| Sample Questions: | SAP C_HANATEC_17 Exam Sample Question |
| Level: | Associate |
NEW QUESTION 59
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.
- A. Delete all Backup schedules with the SAP HANA cockpit 1.0
- B. Create new backup schedules after the upgrade
- C. Export the backup jobs history from SAP HANA 1.0 and import the history after the upgrade
- D. Convert all SAP HANA 1.0 backup schedules to SAP HANA 2.0 backup schedules
Answer: A,B
NEW QUESTION 60
In which circumstances do you create a column store table? There are 3 correct answers to this question.
- A. When accessing complete records
- B. When the table has a large number of columns
- C. When aggregations or fast search is required
- D. When the calculations are based on a small number of columns
Answer: B,C,D
NEW QUESTION 61
Which migration features are supported when using the Database Migration Option (DMO) feature of SAP Software Update Manager (SUM)? There are 2 correct answers to this question.
- A. The source system is Application Server (AS) Java-base
- B. The source and target database system are of the same type
- C. The target database is SAP Adaptive Server Enterprise (ASE)
- D. The Primary Application Server can be moved to a target system Landscape
Answer: C,D
NEW QUESTION 62
What must you do to configure the data backup on a scale-out SAP HANA system? Note: There are 2 correct answers
- A. Specify the individual backup destination on each node
- B. Change the backup configuration for each node
- C. Ensure the availability of shared backup storage
- D. Verify that data and log backup destinations are valid throughout the system
Answer: C,D
NEW QUESTION 63
Which SUM database migration option utility do you use to check and monitor table splitting?
- A. R3load utilization
- B. Table comparison
- C. Log tail Viewer
- D. R3ta
Answer: B
NEW QUESTION 64
Which system schema provides performance data and system alerts details to review in SAP HANA MiniChecks? Please choose the correct answer.
- A. _SYS_WORKLOAD_REPLAY
- B. _SYS_TELEMETRY
- C. _SYS_STATISTICS
- D. _SYS_SQL_ANALYZER
Answer: C
NEW QUESTION 65
Which parameters are mandatory when using the hdblcm tool in batch mode? There are 2 correct answers to this question.
- A. Installation path
- B. SAP HANA System ID (SID)
- C. Password of the user sapadm
- D. Data and Log path
Answer: B,C
NEW QUESTION 66
Your customer has security restrictions that prohibit direct SQL connections from your PC to the productive SAP HANA system.
Which tools can you use to monitor the system alerts of the SAP HANA database from your PC? There are 2 correct answers to this question.
- A. DBA Cockpit
- B. SAP NANA cockpit 2.0
- C. HDBSQL command line tool
- D. SAP HANA studio
Answer: A,B
NEW QUESTION 67
Which of the following users are able to start and stop a distributed SAP HANA Database System? There are 2 correct Answers to this question.
- A. ADM user
- B. ROOT user
- C. SYSTEM user
Answer: A,B
NEW QUESTION 68
Which tool do you use during the Database Migration Option (DMO) procedure to monitor table splitting?
Please choose the correct answer.
- A. The Observer Monitor
- B. The Log viewer
- C. The Process Bucket monito
- D. The R3LDCTL
Answer: B
NEW QUESTION 69
Your customer has purchased a 1.5 TB SAP HANA license. To which value do you set the GLOBAL_ALLOCATION_LIMIT parameter when you have four 1TB nodes in an SAP HANA scale-out system with three worker and one standby nodes? Please choose the correct answer.
- A. 375 GB
- B. 512 GB
- C. 1.0 TB
- D. 1.5 TB
Answer: B
NEW QUESTION 70
Your SAP HANA database is locked down. Which action can you still perform?
- A. Check database license
- B. Check session memory
- C. Configure system properties
- D. Check overall database status
Answer: A
NEW QUESTION 71
Which tasks must you perform to convert a single database to a multitenant database system? There are 2 correct answers to this question.
- A. Set the password for the system database user.
- B. Generate the system database before the conversion.
- C. Trigger the conversion in the SAP HANA cockpit 2.0.
- D. Create an operating system user for the converted tenant database.
Answer: A,C
NEW QUESTION 72
How can you ensure that a consistent database status is saved using data snapshots? Please choose the correct answer.
- A. Trigger a save point.
- B. Execute the hdbbackupdiag tool.
- C. Create an internal database snapshot.
- D. Create a fullback snapshot.
Answer: C
NEW QUESTION 73
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 answer:
- A. Recover the system database first and then recover the affected tenant.
- B. Recover the system database. The affected tenant is recovered automatically.
- C. Recover the affected tenant. The system database is NOT recovered.
- D. Recover the affected tenant first and then recover the system database.
Answer: B
NEW QUESTION 74
Why does SAP HANA have a persistence storage layer that is disk-based? Note: There are 2 correct answers.
- A. To persist in-memory data
- B. To enable database scale-up
- C. To allow a restart if the power fails
- D. To ensure maximum performance
Answer: A,C
NEW QUESTION 75
Which backup and recovery scenario is allowed in multitenant database containers?
- A. A backup of a tenant database can be recovered to the system database.
- B. After the recovery of a tenant database, the system database needs a backup.
- C. The system database should be recovered first in order to recover the tenant databases.
- D. A tenant database can initiate its own backup, but the system database executes the recovery.
Answer: D
NEW QUESTION 76
What are advantages of column store tables? There are 3 correct answers to this question.
- A. They are optimized for high-volume read /write transactional processing
- B. Columns can be partitioned
- C. Only the columns required are actually loaded to memory
- D. Data footprint is automatically reduced through compression
Answer: B,C,D
NEW QUESTION 77
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.
- A. Manage full system information dumps
- B. Open blocked transactions
- C. Troubleshoot unresponsive system
- D. Overall database status
Answer: C,D
NEW QUESTION 78
How do you trigger a savepoint in an SAP HANA database?
- A. Perform a soft shutdown
- B. Commit a transaction
- C. Execute a delta merge
- D. Start a log backup
Answer: A
NEW QUESTION 79
Which SAP HANA database system usage types are automatically assigned to tiles in the SAP HANA cockpit? There are 3 correct answers to this question.
- A. Custom
- B. Production
- C. Development
- D. Sandbox
- E. Test
Answer: B,C,E
NEW QUESTION 80
You investigate a hung SAP HANA database, and you CANNOT identify the blocking transactions. What causes could lead to this behavior? Note: There are 2 correct answers.
- A. A wrong role of a service in a failover situation
- B. A setting to restrict CPU usage
- C. An issue with the delta merge
- D. A long savepoint duration
Answer: B,D
NEW QUESTION 81
......
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.
SAP C_HANATEC_17 Test Engine PDF - All Free Dumps: https://certmagic.surepassexams.com/C_HANATEC_17-exam-bootcamp.html