Unique Top-selling C_HANATEC_17 Exams - New 2021 SAP Pratice Exam
SAP Certified Technology Associate Dumps C_HANATEC_17 Exam for Full Questions - Exam Study Guide
NEW QUESTION 30
Which trace do you use to create a graphical representation of an individual SQL Statement?
- A. Expensive statements trace
- B. SQL trace
- C. Plan trace
- D. Performance trace
Answer: D
NEW QUESTION 31
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. Troubleshoot unresponsive system
- C. Open blocked transactions
- D. Overall database status
Answer: B,D
NEW QUESTION 32
Once you start the SAP HANA cockpit 2.0, From the Aggregated Health Monitor, navigate to the SAP HANA system overview pag This page displays the detailed status of the selected SAP HANA system. Which of the following options are listed? There are 3 correct answers to this question.
- A. Resource Management
- B. Monitoring and Administration
- C. Memory Management
- D. Security
- E. Performance Management
Answer: B,D,E
NEW QUESTION 33
What can you check with the SAP HANA Hardware Configuration Check Tool (HWCCT)? There are 2 correct answers to this question.
- A. Memory configuration
- B. Kernel settings
- C. Missing OS patches
- D. Network configuration
Answer: A,B
NEW QUESTION 34
How can the system database administrator disable tenant database functionalities? Please choose the correct answer.
- A. Using the hdbuserstore tool
- B. Using the Manage Blacklisted Parameter app
- C. Using the resident hdblcm tool
- D. Using the Manage Restricted Features app
Answer: B
NEW QUESTION 35
Which removal statuses allow you to remove a host from an SAP HANA scale-out landscape Note: There are
2 correct answers.
- A. Reorg active
- B. Reorg pending
- C. Reorg not required
- D. Reorg finished
Answer: C,D
NEW QUESTION 36
Which system schema provides performance data and system alerts details to review in SAP HANA MiniChecks? Please choose the correct answer.
- A. _SYS_SQL_ANALYZER
- B. _SYS_TELEMETRY
- C. _SYS_STATISTICS
- D. _SYS_WORKLOAD_REPLAY
Answer: C
NEW QUESTION 37
Which activities do you have to carry out to configure your Multiple Database Container (MDC) System to a higher database isolation between tenant databases on the operating system (OS) level? There are 3 correct answers to this question.
- A. Remove the <sid> adm OS user from the sapsys group.
- B. Create dedicated tenant OS users for each tenant.
- C. Add dedicated tenant OS users to the sapsys group.
- D. users to the <sid> shm group.
- E. Lock the adm OS user \/ O Add dedicated tenant
Answer: B,C,D
NEW QUESTION 38
You define the parameters for the password policy of an SAP HANA tenant database. Where are these parameters stored?
- A. global.ini
- B. indexserver.ini
- C. nameserver.ini
- D. multidb.ini
Answer: B
NEW QUESTION 39
Which rules should you consider when creating a table distribution plan for SAP Business Suite on SAP HANA to get the best possible results? There are 2 correct answers to
- A. Keep the number of key columns low.
- B. Keep the number of partitioned tables low.
- C. Keep the number of partitions per table high.
- D. Keep all partitions on different hosts.
Answer: A,C
NEW QUESTION 40
Which certificates do you require for a trusted secure communication between the client and the SAP HANA database? Note: There are 2 correct answers.
- A. X.509 certificate
- B. Root certificate
- C. User certificate
- D. Server certificate
Answer: A,D
NEW QUESTION 41
What is a prerequisite before you can install SAP HANA Cockpit 2.0 as a central monitoring tool 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. SAP Netweaver 7.5x on SAP HANA 2.0 with ABAP Core Data Services (CDS) and SAP Fiori installed
- C. A central SAP HANA database 2.0 with SAP HANA extended application services, advanced model (XS Advanced) installed
- D. A central SAP HANA database 2.0 SPS05 multitenant database system with at least 16 GB of RAM
Answer: A
NEW QUESTION 42
What software innovations did SAP deliver with SAP HANA? There are 2 correct answers to this question.
- A. Compression and Decompression.
- B. Row and Delta store.
- C. Partitioning.
- D. Insert only on Column store.
Answer: B,C
NEW QUESTION 43
For which scenarios is it mandatory to define the authorizations at HANA Level? There are 2 correct answers to this question.
- A. Business Suite on HANA
- B. Web-based native applications based on XS
- C. SAP S/4HANA
- D. SAP HANA Live for SAP Business Suite
Answer: B,D
NEW QUESTION 44
Which is the relationship between the user group operators and the user groups? There are 2 correct answers to this question.
- A. Multiple user groups per user group operator
- B. Only one user group per user group operator
- C. Multiple user group operators per user group
- D. Only one user group operator per user group
Answer: A,D
NEW QUESTION 45
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. R3trans processes
- B. SAPup processes
- C. SQL processes
- D. TP processes
Answer: A,C
NEW QUESTION 46
How are hosts assigned to the shared storage in an SAP HANA scale-out system? There are 2 correct answers to this question.
- A. The standby server is assigned to the master data volume.
- B. The slave servers are assigned to their own data volumes.
- C. The master server is assigned to all data volumes.
- D. The master name server is assigned to its master data volume.
Answer: B,D
NEW QUESTION 47
Which of the following system privileges can you assign to an SAP HANA database user? Note: There are 3 correct answers.
- A. CREATE SCHEMA
- B. EXECUTE
- C. EXPORT
- D. CREATE ANY
- E. DEVELOPMENT
Answer: A,C,D
NEW QUESTION 48
What can you do to shorten the startup time of an SAP HANA system after a reboot?
- A. Set the savepoint interval to a lower value.
- B. Set the preload column value in the Tables system table to FULL.
- C. Flag all columnar tables for preload.
- D. Partition the row store across nodes.
Answer: A
NEW QUESTION 49
Which role do you need in order to assign users to groups in SAP HANA cockpit? Please choose the correct answer.
- A. Cockpit User
- B. Cockpit Resource Administrator
- C. Cockpit Administrator
- D. Cockpit User Administrator
Answer: C
NEW QUESTION 50
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 row store can be distributed over all nodes.
- B. The columns of a table can be distributed over all nodes.
- C. Table partitions can be distributed over all nodes.
- D. Cross-node joins must be avoided.
Answer: A,C
NEW QUESTION 51
What are prerequisites for changing the SSFS Master Keys? There are 2 correct answers to this question.
- A. You have the system privilege I IN I FILE ADMIN
- B. You have the server root privilege INIFILE ADMIN
- C. You have the credentials of the Operating system user <sid>adm that was created when the system was installed
- D. You have the credentials of the SYSTEM user
Answer: A,C
NEW QUESTION 52
What are the two features of the storage engine in the SAP HANA index server that enable data consistency and maintain durable changes? Please choose
- A. Session Management and log Volumes
- B. Metadata Manager and Transaction Manager
- C. Column Store and Row Store
- D. Page Management and logge
Answer: D
NEW QUESTION 53
......
Best way to practice test for SAP C_HANATEC_17: https://www.fast2test.com/C_HANATEC_17-premium-file.html