H13-921_V1.5 Sample Questions Answers

Which command can GaussDB (for MySQL) use to view server status information?

Which of the following are core functions of the UGO database migration tool?

Which of the following isnota functional module of Cloud Audit?

Which features does DFV (Data Function Virtualization) provide for elastic scaling?

A company platform has 29 categories of products. If partitioning tables based on products, which partitioning method is recommended?

With shared storage, GaussDB (for MySQL) can expand by adding compute nodes, completed within minutes regardless of data size.

In a 16-core, 64GB GaussDB (for MySQL) instance, what is the default size of the innodb_log_buffer_size parameter?

Performance can be measured against a baseline. Ideally, what should a performance baseline include?

During SQL execution, which component generates the execution plan?

DRS provides complete heterogeneous database migration to the cloud, ensuring smooth business cutover.

Which command in GaussDB (for MySQL) is used to view server status information?

Which regex pattern is used to match one or more ‘h’ characters?

When using security group functionality, which of the following is not a configurable setting?

GaussDB (for MySQL) deployment supports both public cloud and hybrid cloud.

Which statements about GaussDB (for MySQL) read-only nodes are correct?

What is the impossible return value of SELECT FLOOR(7 + (RAND()*5));?

What is the output of the following SQL statement?

SELECT JSON_EXTRACT(10, 20, [30, 40], "$$"$$11);

What are the parameter types for stored procedures?

GaussDB (for MySQL) is 100% compatible with MySQL ecosystem, applications can migrate to cloud without modification.

Which of the following are part of GaussDB (for MySQL)'s Cloud Native design philosophy?

Which of the following are Huawei Cloud’s database management tools?

To facilitate management, DAS Enterprise Edition includes several user roles. Which of the following isnotamong them?

Which are Huawei Cloud security services?

Database instance status refers to the running status of the DB instance. Which of the following is NOT a valid status for GaussDB (for MySQL)?

EXPLAIN cannot show the impact of triggers, stored procedures, or user-defined functions.

The parameter max_user_connections can limit user connections per instance, and can differ per user.

When using hints, different scopes apply. Which scope descriptions are correct?

Which methods can be used during requirements investigation?

In GaussDB (for MySQL), user variables are session variables that can be saved and shared across sessions.

Which statements about slow query logs are correct?

Which factors should be considered when designing database objects?

Which are common denormalization practices in DB design?

GaussDB (for MySQL) currently only supports the InnoDB storage engine.

Object Storage Service (OBS) is a massive, secure, reliable, and low-cost storage service.

Using SHOW PROCESSLIST provides session-related info. Which of the following are common thread statuses?

Which of the following are GaussDB (for MySQL) thread statuses?

Which SQL O&M features does Cloud DBA provide?

Which of the following is the correct sequence for connecting to a GaussDB (for MySQL) instance via the internet?

In GaussDB (for MySQL), the default failover priority is “0”, where “0” is the highest. It can be manually modified.

What is the maximum number of read-only nodes that can be added to a GaussDB (for MySQL) cluster?

Which statements about SQL execution process are correct?

Which steps belong to the overall installation process?

GaussDB (for MySQL) supports bidirectional scalability for compute nodes and 1 read-write node. What is the maximum number of read-only nodes it supports?

Which of the following statements about GaussDB (for MySQL) compatibility are correct?

Which functions can database security auditing provide?

Which roles exist in DAS Enterprise Edition?

If an administrator finds that the InnoDB read cache hit rate is low in GaussDB (for MySQL), what should be optimized first?

User sessions correspond to user connection threads — one session equals one connection thread.

GaussDB (for MySQL) is a single-process, multi-threaded database. What are the advantages of threads?

Which parameter types can be used when writing stored procedures?

For composite indexes, B+ tree is built left-to-right.

In the EXPLAIN command output of GaussDB (for MySQL), which Select_type values are valid?

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

What is the impossible result of executing: SELECT FLOOR(8 + (RAND()* 5));?

Using DAS → Space tab → “Database Space”, users can search by DB name to view size and fragmentation rate.

Which type of tree does the InnoDB engine use by default to store index information?

When creating a GaussDB (for MySQL) instance, the system automatically creates system accounts (usable by users) to support backend O&M. Which are these accounts?

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

A database administrator received a "cannot connect" error. Diagnosis revealed that a new business caused client connections to exceed the preset limit. Which parameter should be adjusted to fix the error?

In the failover process of GaussDB (for MySQL), when can the new host officially start providing write operations to clients?

Which of the following is a supported storage engine in GaussDB (for MySQL)?