H13-921_V1.5 HCIP-GaussDB-OLTP V1.5 Questions and Answers

GaussDB (for MySQL) and GaussDB (openGauss) are both relational databases.

Which of the following are advanced features of GaussDB (for MySQL)?

Regarding users, roles, and permissions, which of the following descriptions isincorrect?

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

Which strings can the regex 'x?z|food' (simplified from source) match?

When creating a user in GaussDB (for MySQL), which info must be specified?

When executing stored procedures, which end delimiters are allowed?

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

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

Which of the following are correct about read-only nodes?

Which of the following isnota binary data type?

During SQL execution, which component generates the execution plan?

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

Huawei Cloud's recycle bin policy is enabled by default and cannot be turned off. What is the default retention period in days?

What does GaussDB (for MySQL) use in stored procedures to implement the effect of dynamic SQL updates?

The regex function REGEXP_INSTR returns the starting index of a substring matching the regex. If return_option=1, it returns the last matched position.

Xiao Hai deployed an application on an Elastic Cloud Server that resides in the same region and VPC as the GaussDB (for MySQL) instance. What is the best way to connect the application to the database in this scenario?

What is the result of the SQL command: SELECT RPAD('hi', 5, 'u');?

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

Which methods can be used during requirements investigation?

GaussDB (for MySQL) permissions are project-level. When authorizing, the scope must be set to a project in the selected region, and only applies there.

The MyISAM engine supports tables with different storage formats. Which are supported?

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

Which SQL O&M features does Cloud DBA provide?

In DRS, backup migration means reading local backup files and restoring to target DB.

GaussDB (for MySQL) supports compute node bidirectional scaling: vertical (1 write, 15 reads) and horizontal (elastic online scaling, pay-as-you-go).

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

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

Which of the following services provides a dedicated public IP resource, including public IP address and outbound bandwidth?

Which types of backup does GaussDB (for MySQL) support?

Splitting common and uncommon fields into separate storage is called vertical partitioning.

After executing CREATE USER user1@'100.%' IDENTIFIED BY 'Database_123';, user1 can connect from any host.

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

Which of the following operationscannotbe performed on a diagnostic report?

Which of the following is NOT a system built-in user in GaussDB (for MySQL)?

Huawei Cloud DB Security Audit supports analyzing SQL behavior by risk levels, SQL injection, blacklist statements, and unauthorized operations.

The frequency of flushing the log from buffer to disk is related to the parameter innodb_flush_log_at_trx_commit. If you want to flush the log buffer and write it to disk every time a transaction is committed, what should the parameter value be?

Which of the following methods cannot be used to view a table's fragmentation rate?

In GaussDB (for MySQL), which of the following is offloaded to the storage node for execution?

The parameter innodb_log_buffer_size is used to set the size of the InnoDB log buffer, primarily to improve I/O performance for writing logs. What is the default size in a 16-core, 64GB GaussDB (for MySQL) instance?

When purchasing GaussDB (for MySQL), storage space must be pre-planned in addition to CPU, to avoid later expansion.

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

Which of the following isnotan option of the EXPLAIN command?

In GaussDB (for MySQL), what is the default slow SQL threshold in seconds?

The Com_insert and similar Com_xx parameters are used to monitor the number of different operations executed in a database instance. Which of the following commands correctly retrieves this parameter?

The DAS Cloud DBA module can diagnose GaussDB (for MySQL) instances. Which dimensions are included in reports?

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

In GaussDB (for MySQL), what is the default value of the long_query_time parameter (i.e., the slow log threshold)?

In regex, a* matches 0 or more “a” characters.

Which statements about SQL execution process are correct?

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

An e-commerce platform is experiencing a surge in users and needs a database architecture with optimal parallel processing and scalability. Which architecture should be enabled?

In GaussDB (for MySQL), session and connection are the same concept.

Which of the following isnota feature provided by the Data Replication Service (DRS)?

Which of the following are entities?

Which are Huawei Cloud security services?

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

Which of the following statements about stored procedures and functions are correct?

GaussDB for MySQL adopts a compute-storage separation design. What is its greatest value?

Which are common performance bottlenecks in database servers?

In DAS → Sessions tab → “Real-time Sessions”, users can kill system account rdsRepl.