2021 Updated Verified C_HANATEC_17 dumps Q&As - Pass Guarantee or Full Refund
C_HANATEC_17 PDF Questions and Testing Engine With 272 Questions
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 Certification Exam Topics:
| Topic Areas | Topic Details, Courses, Books |
|---|---|
| SAP HANA Architecture and Deployment Options 8% - 12% | Describing the SAP HANA database system architecture and the different deployment options. |
| SAP HANA Monitoring and Troubleshooting 8% - 12% | 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. |
| SAP HANA Database Security 8% - 12% | Understand the SAP HANA database system security concepts, create SAP HANA users and roles and setup audit policies. |
| Database Migration Options for SAP HANA 8% - 12% | Be able to perform database migrations from AnyDB to SAP HANA using the Database Migration Option (DMO) of SUM. |
| SAP HANA Database Administration > 12% | Performing the daily SAP HANA database administration tasks using SAP HANA cockpit. |
| SAP HANA High Availability and Disaster Recovery > 12% | Install, configure and monitor SAP HANA database systems that are setup in a scale-out or in system replication configuration. |
NEW QUESTION 86
Where is the name server running in a multitenant database container system? Please choose the correct answer.
- A. Standby node
- B. SYSTEMDB
- C. Master node
Answer: B
NEW QUESTION 87
Which option do you choose to protect your SAP HANA scale-out system using host autofailover?
- A. Standby node
- B. Storage replication
- C. Automatic savepoint
- D. System replication
Answer: A
NEW QUESTION 88
What software innovations did SAP deliver with SAP HANA? There are 2 correct answers to this question.
- A. Row and Delta store.
- B. Insert only on Column store.
- C. Partitioning.
- D. Compression and Decompression.
Answer: A,C
NEW QUESTION 89
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 90
Which of the following actions are audited by default in SAP HANA? There are 2 correct answers to this question.
- A. Changes to system configuration
- B. Deletion of audit entries from the audit trail
- C. Changes to system configuration
- D. Installation of SAP HANA license
- E. Creation, modification or deletion of audit policies
Answer: B,E
NEW QUESTION 91
Which application do you use to reset the memory statistics before you analyze a tenant database using SAP HANA cockpit?
- A. Manage Databases
- B. Performance Monitor
- C. Resource Directory
- D. Manage Services
Answer: D
NEW QUESTION 92
You installed an SAP Netweaver-based application on an SAP HANA database. What is the default secure user store to store the password of the SAP<schema-id> user?
- A. hdbuserstore
- B. Secure store in file system (SSFS)
- C. xuser
- D. ABAP secure store file system (SSFS)
Answer: A
NEW QUESTION 93
Which features are provided by the Manage Full System Information Dumps app in SAP HANA cockpit?
There are 2 correct answers to this question.
- A. End-to-end Trace
- B. Runtime environment
- C. SAP HANA minichecks
- D. Diagnosis information
Answer: B,D
NEW QUESTION 94
You define the parameters for the password policy of an SAP HANA tenant database. Where are these parameters stored?
- A. global.ini
- B. multidb.ini
- C. nameserver.ini
- D. indexserver.ini
Answer: D
NEW QUESTION 95
How can you ensure that the critical database system properties CANNOT be changed by tenant database administrators?
- A. Set up cross-database access control
- B. Assign internal communication ports
- C. Set database isolation levels to high
- D. Edit the configuration change blacklist
Answer: D
NEW QUESTION 96
Which of the following tasks can you perform using the resident SAP HANA database lifecycle manager (HDBLCM)? Note: There are 3 correct answers.
- A. Transport application changes
- B. Remove host roles
- C. Uninstall the individual components
- D. Rename the SAP HANA database system
- E. Rename the SAP HANA Database hostname
Answer: B,C,D
NEW QUESTION 97
SQL statements are rejected by the Workload Admission Control application, and you need to investigate the reason. Which parameters do you adjust to manage the event log? There are 2 correct answers to this question.
- A. queue_wait_time_threshold
- B. recordjimit
- C. queue_timeout
- D. max_queue_size
Answer: A,B
NEW QUESTION 98
Which scale-out roles can you assign to the hosts in the nameserver.ini file? There are 2 correct answers to this question.
- A. MASTER 1
- B. STANDBY
- C. SLAVE
- D. WORKER
Answer: B,D
NEW QUESTION 99
Which best practices do you apply when you optimize the table distribution in a scale-out SAP HANA database?
There are 2 correct answers to this question.
- A. The columns of a table can be distributed over all nodes.
- B. The row store can be distributed over all nodes.
- C. Table partitions can be distributed over all nodes.
- D. Cross-node joins must be avoided.
Answer: B,C
NEW QUESTION 100
Which of the following privileges allow read access to data in SAP HANA information models depending on certain values or combination of values?
- A. Object Privileges
- B. System Privileges
- C. Package Privileges
- D. Analytic Privileges
Answer: D
NEW QUESTION 101
What do you do to prepare the database migration option of a Software Update Manager procedure? Note:
There are 3 correct answers.
- A. Move the SPAM update archive into the download folder
- B. Extract the SAP HANA database installation archive
- C. Extract the SAP HANA Client installation archive
- D. Move the R3trans update archive into the download folder
- E. Move the stack.xml update file into the download folder
Answer: A,C,E
NEW QUESTION 102
A logical error occurred in one tenant of you SAP HANA DATABASE what action do you perform to make tenant consistent again Please choose the correct answer.
- A. recover the affected tenant with the initialize log area option
- B. restore the database and recover the affected tenant upto moment of the problem
- C. recover the affected tenant upto moment of the problem
- D. recover the system database and the affected tenant with the initialize log area option
Answer: B
NEW QUESTION 103
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 104
Why does SAP HANA have a persistence storage layer that is disk-based? There are 2 correct answers to this question.
- A. To persist in-memory data
- B. To allow row store operations
- C. To generate indexes for the column store
- D. To enable data recovery if the power fails
Answer: A,D
NEW QUESTION 105
Which of the following statements are true about SAP HANA Live? There are 2 correct answers to this question.
- A. SAP HANA Live for SAP Business Suite is a Rapid Deployment Solution.
- B. SAP HANA Live for SAP Business Suite focuses on Enterprise Data Warehouse cases, and not on live operational reporting.
- C. SAP HANA Live for SAP Business Suite comprises of an Analytical Model.
- D. SAP HANA Live for SAP Business Suite comes with a comprehensive set of predefined models from across the SAP Business Suite.
- E. SAP HANA Live for SAP Business Suite is an accelerator.
Answer: C,D
NEW QUESTION 106
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.
- A. When the log segment is full.
- B. When the time threshold is exceeded.
- C. When a commit occurs.
- D. When the log buffer is full.
Answer: A,B
NEW QUESTION 107
A technical user is required when you register an SAP HANA system as a resource in SAP HANA cockpit 2.0.
Which system privileges do you assign to the technical user account on the target system?
- A. USER ADMIN
- B. MONITOR ADMIN
- C. DATA ADMIN
- D. CATALOG READ
Answer: D
NEW QUESTION 108
What can you directly assign to a user with the Manage Users app in SAP HANA cockpit? There are 2 correct answers to this question.
- A. Role collections
- B. Scopes
- C. Privileges
- D. Roles
Answer: C,D
NEW QUESTION 109
......
Exam Engine for C_HANATEC_17 Exam Free Demo & 365 Day Updates: https://www.examsreviews.com/C_HANATEC_17-pass4sure-exam-review.html