Your business users are complaining about longer-than-usual query runtimes and you want to get an
overview of long-running queries.
Where do you activate the expensive statements trace?
There are 2 correct answers to this question.
Response:
A. SAP HANA studio diagnosis mode
B. SAP HANA cockpit 2.0
C. SAP HANA database explorer for SAP HANA cockpit
D. SAP HANA Web-based Development Workbench
Which combination of source and target systems is allowed when you perform a database copy in a scale-
out scenario?
Please choose the correct answer
Response:
A. The source system can have 4 hosts.
The target system can have 2 hosts.
B. The source system can have 4 index servers. The target system can have 2 index servers.
C. The source system can have 2 hosts. The target system can have 4 hosts.
D. The source system can have 2 index servers. The target system can have 4 index servers.
What are advantages of column store tables? There are 3 correct answers to this question. Response:
A. Data footprint is automatically reduced through compression
B. Only the columns required are actually loaded to memory
C. Columns can be partitioned
D. They are optimized for high-volume read / write transactional processing
According to SAP Best Practices, what should you do with the SYSTEM user?
Please choose the correct answer.
Response:
A. Delete the user.
B. Exempt the user from locking.
C. Revoke granted roles.
D. Deactivate the user.
What do you have to ensure during the downtime phases of SUM? There are 3 correct answers to this question.
Response:
A. The source database must be stopped
B. End users can not log on to the SAP system
C. Batch jobs from daily business can not start
D. Interfaces from other SAP systems can not log on to the SAP system
You install SAP HANA for productive usage, but the installation stops because the hardware check failed.
How do you resolve this issue?
Please choose the correct answer.
Response:
A. Use SAP HANA database lifecycle manager (HDBLCM) to edit the configuration.
B. Use a hardware configuration listed in the Product Availability Matrix.
C. Run the HanaHwCheck.py script before resuming the installation.
D. Use the hdbinst command to install the SAP HANA database directly.
The SAP HANA memory pool CANNOT satisfy the memory requests for new queries. Where does the
SAP HANA database request additional memory?
Please choose the correct answer.
Response:
A. Virtual memory
B. Physical memory
C. Standby memory
D. Resident memory
You need to install multiple identically configured SAP HANA systems in batch mode. Which installation
parameter is mandatory when you use a configuration file?
Please choose the correct answer.
Response:
A. sid
B. system_usage
C. components
D. number
Which are tuning methods for the database migration, using DMO of SUM?
There are 3 correct answers to this question.
Response:
A. Adapt the number of parallel R3load processes
B. Using the Near Zero Downtime Maintenance capabilities of SUM (NZDM)
C. Using the table migration duration files from a previous run
D. Performing a benchmark using the benchmarking options of SUM
You need to set up an SAP HANA system where several companies share the same SAP HANA instance. You have to provide each company a dedicated share of the instance for its data, configuration and user management.
Which deployment scenario do you use? Please choose the correct answer. Response:
A. Multitenant database containers (MDC)
B. Technical co-deployment (TCD)
C. Multiple Components on One Database (MCOD)
D. Multiple Components on One System (MCOS)
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only SAP exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your C_HANATEC_14 exam preparations and SAP certification application, do not hesitate to visit our Vcedump.com to find your solutions here.