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

Which statements about distributed transactions are correct?

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

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

Using the EXPLAIN command in GaussDB (for MySQL), which of the following isnota valid Select_type?

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

Which descriptions of important modules in GaussDB (for MySQL) architecture are correct?

Which factors should be considered when designing database objects?

GaussDB (for MySQL) enforces password complexity rules for new users. Which of the following passwords donotcomply?

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

Which statements about GaussDB (for MySQL)'s high reliability and scalability are correct?

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

Which methods can be used during requirements investigation?

Frequent UPDATE operations can cause page splits, leading to severe fragmentation.

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

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

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

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

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

Which of the following is NOT a function included in user behavior audit?

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

When executing stored procedures, which end delimiters are allowed?

In GaussDB (for MySQL), roles cannot log in but can execute SQL statements.

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.

To meet data reliability requirements, GaussDB (for MySQL) can retain automatic backup recovery for up to how many days?

DAS Enterprise Edition supports export tasks: data only, structure only, or both, in SQL or CSV format.

System tables and views record metadata for DB objects and users. Which system table or viewcannotbe used to query user information?

In GaussDB (for MySQL), the optimizer generates execution plans, which are executed by the executor.

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

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

GaussDB (for MySQL) log management supports viewing DB-level logs, including error logs and slow SQL logs.

Which of the following descriptions about GaussDB (for MySQL) CPU and memory expansion isincorrect?

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.

Which of the following isnotan option of the EXPLAIN command?

Which of the following isnota functional module of Cloud Audit?

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

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

What is the maximum number of read-only nodes that can be created in one GaussDB (for MySQL) cluster?

Which are Huawei Cloud security services?

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?

Which parameters can limit resources per user?

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

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

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

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

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

Which of the following descriptions about the MEMORY storage engine is incorrect?

Using DROP USER must be cautious because deleted objects cannot be recovered even if interrupted.

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)?

Compared to RDS for MySQL, GaussDB (for MySQL) has no standby nodes; all read-only are active and handle read traffic, improving utilization.

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

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

Which functions can database security auditing provide?

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

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

Which factors affect database performance?

A connection is a physical concept: a client establishes a network connection to GaussDB (for MySQL), which creates one or more threads in the instance.

Which of the following are DAS Enterprise Edition user roles?

For multidimensional clue analysis in data security auditing, which clues are supported by Huawei Cloud?

Trigger events specify the statements that activate triggers. Which are included?

Which metrics can be displayed in real-time performance?

DAS Enterprise Edition defines three types of user roles. Which of the following isnota role in DAS Enterprise Edition?