H13-921_V1.5 Exam Dumps - Huawei Certification Questions and Answers

During SQL execution, which component generates the execution plan?

Which window function generates a ranking within groups, where the same value gets the same rank?

In GaussDB (for MySQL), which parameter is used to control the maximum idle time for interactive connections?

Which are common performance bottlenecks in database servers?

Compared with physical backup, logical backup has the advantage of faster backup and recovery.

When looping over cursors, overflow can occur if end-of-data isn’t checked. Which handlers can be used to control execution properly?

If read hit ratio is below 99%, lowering innodb_buffer_pool_size can improve cache hit rate.

To elastically scale read capacity and reduce GaussDB (for MySQL) pressure, read-only nodes can be created. Which statements are correct?

UGO (DB & App Migration) is a professional cloud service for heterogeneous DB structure migration and SQL conversion.

In execution plans, the id indicates SELECT sequence number. Larger IDs execute first; same IDs execute top to bottom.