[Jan-2022] C-HANATEC-17 Pre-Exam Practice Tests | Exam Questions and Answers for SAP Certified Technology Associate Study Guide
SAP Certified Technology Associate - SAP HANA 2.0 SPS05 Certification Sample Questions
NEW QUESTION 77
Which backup types you can schedule using SAP Hana cockpit 2.0. There are 2 correct answers to this question.
- A. Delta Backup
- B. Backup of Configuration files
- C. Data Backup
- D. Data Snapshot
Answer: A,C
NEW QUESTION 78
The design-time version of a security role can contain which of the following information? There are 2 correct answers to this question.
- A. The role name
- B. The users assigned by default to this role
- C. The users assigned to the role
- D. The privileges assigned to the role
Answer: A,D
NEW QUESTION 79
Which technology does the SAP DBA Cockpit use to store the performance indicators? Please choose the correct answer.
- A. SAP Business Intelligence
- B. SAP Adaptive Server Enterprise
- C. SAP Analytics Cloud
- D. SAP Intelligent Query
Answer: A
NEW QUESTION 80
Which of the following are characteristics of SAP HANA Smart Data Streaming?
- A. It is a standalone product for use with any target system.
- B. It provides reports and analysis on the received data.
- C. It acts based on combinations of events.
- D. It uses databases queries.
Answer: C
NEW QUESTION 81
Why do we still need a persistent layer? There are 2 correct answers to this question.
- A. To store data that is frequently used
- B. To hold the delta store for newly arrived records
- C. To store data that has been unloaded from memory
- D. To enable full database recovery if we have a power failure
Answer: C,D
NEW QUESTION 82
The Add System Archive Link is a new feature that allows users to connect to multiple SAP HANA systems.
From which method one user can manage the list of all systems in a centrally-accessible archive (with read only link to other user)?
- A. File Export Landscape SAP HANA
- B. File archive SAP HANA Export
- C. File archive SAP HANA Landscape
- D. File Export SAP HANA Landscape
Answer: D
NEW QUESTION 83
Which tool shows the difference of tables and indexes between your ABAP dictionary and your SAP HANA database?
- A. hdblcm
- B. SAP HANA cockpit
- C. hdbsql
- D. DBA Cockpit
Answer: D
NEW QUESTION 84
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 remote target database host
- B. On the Primary Application Server (PAS) host
- C. On the Additional Application Server (AAS) host
- D. On the source and target host
Answer: B
NEW QUESTION 85
You define the parameters for the password policy of an SAP HANA tenant database. Where are these parameters stored?
- A. indexserver.ini
- B. global.ini
- C. nameserver.ini
- D. multidb.ini
Answer: A
NEW QUESTION 86
Which system privileges do you require to view roles that are granted to other users? Note: There are 2 correct answers.
- A. USER ADMIN
- B. ROLE ADMIN
- C. DATA ADM IN
- D. CATALOG READ
Answer: C,D
NEW QUESTION 87
Which information is stored in the SYSTEMDB of an SAP HANA multitenant database container system?
Note: There are 2 correct answers.
- A. Landscape topology data on the system as a whole
- B. Monitoring data in the SYSTEMDB and all tenant databases
- C. Topology data on the location of tables and table partitions
- D. Users and authorizations of the SYSTEMDB and all tenant databases
Answer: A,B
NEW QUESTION 88
Which of the following recovery types is not supported for delta backups?
- A. Recover the database to a specific data backup.
- B. Recover the database to a specific point in time.
- C. Recover the database to its most recent state.
Answer: A
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 setting to restrict CPU usage
- B. A long savepoint duration
- C. A wrong role of a service in a failover situation
- D. An issue with the delta merge
Answer: A,B
NEW QUESTION 90
Where is the name server running in a multitenant database container system? Please choose the correct answer.
- A. Standby node
- B. Master node
- C. SYSTEMDB
Answer: C
NEW QUESTION 91
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 92
Which steps can be combined in a DMO procedure, targeting an AS ABAP 7.50 based SAP system? There are
2 correct answers to this question.
- A. Performing a Unicode conversion
- B. Migrating to a target database, g. SAP HANA
- C. Performing a database upgrade of the source database
- D. Performing an SAP software update
Answer: B,D
NEW QUESTION 93
Which information is provided via the SUM Ul? There are 3 correct answers to this question.
- A. The content of log files via the log viewer
- B. A progress bar for the overall procedure
- C. The memory consumption of SUM
- D. The active roadmap step
Answer: A,B,D
NEW QUESTION 94
Which authentication method can you configure for single sign-on in a middleware/application server scenario.
- A. SAML
- B. JSON web token
- C. X.509 certificate
- D. Kerberos
Answer: D
NEW QUESTION 95
USER A grants a privilege to USER B, and USER B grants the same to USER C afterwards. What happens if you drop USER B from the HANA database?
- A. The privilege is revoked from USER C, but not USER A.
- B. The privilege is revoked from both USER A and USER C.
- C. The privilege is revoked from USER A, but not USER C.
- D. The privilege remains assigned to both USER A and USER C.
Answer: A
NEW QUESTION 96
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 97
After you start the SAP HANA database, what does the system do to ensure that it is in a consistent mode?
- A. It determines and rolls forward aborted transactions
- B. It reloads a savepoint with the restored consistent state of the database
- C. It rolls back write transactions that were open when the database was stopped
- D. It rolls back changes of committed transactions that were NOT written to the data area
Answer: C
NEW QUESTION 98
What must you do to configure the data backup on a scale-out SAP HANA system? Note: There are 2 correct answers
- A. Ensure the availability of shared backup storage
- B. Specify the individual backup destination on each node
- C. Change the backup configuration for each node
- D. Verify that data and log backup destinations are valid throughout the system
Answer: A,D
NEW QUESTION 99
......
SAP HANATEC 17 Certification Exam Topics:
| Topic Areas | Topic Details, Courses, Books | Weighting |
|---|---|---|
| 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 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 HANA Database Administration | Performing the daily SAP HANA database administration tasks using SAP HANA cockpit. 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 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 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% |
| 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 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 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 Exam Practice Test To Gain Brilliante Result: https://www.pass4training.com/C-HANATEC-17-pass-exam-training.html
