Big Black Friday Sale 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: exams65

ExamsBrite Dumps

HCIP-GaussDB-OLTP V1.5 Question and Answers

HCIP-GaussDB-OLTP V1.5

Last Update Nov 30, 2025
Total Questions : 214

We are offering FREE H13-921_V1.5 Huawei exam questions. All you do is to just go and sign up. Give your details, prepare H13-921_V1.5 free exam questions and then go for complete pool of HCIP-GaussDB-OLTP V1.5 test questions that will help you more.

H13-921_V1.5 pdf

H13-921_V1.5 PDF

$36.75  $104.99
 Add to Cart
H13-921_V1.5 Engine

H13-921_V1.5 Testing Engine

$43.75  $124.99
 Add to Cart
H13-921_V1.5 PDF + Engine

H13-921_V1.5 PDF + Testing Engine

$57.75  $164.99
 Add to Cart
Questions 1

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

Options:

A.  

Behavior clues: support quick analysis across multiple dimensions

B.  

Session clues: analysis from time, DB user, client, etc.

C.  

Statement clues: various filters like time, risk level, IP, etc.

D.  

Slow SQL clues: support for user slow SQL queries and optimization advice

Discussion 0
Questions 2

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

Options:

A.  

Risk clues

B.  

Session clues

C.  

Detailed statement clues

D.  

User clues

Discussion 0
Questions 3

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

Options:

A.  

True

B.  

False

Discussion 0
Questions 4

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

Options:

A.  

Gauss<3

B.  

Gauss321

C.  

gauss<321

D.  

Gauss<321

Discussion 0
Questions 5

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?

Options:

A.  

Intranet connection

B.  

Public network connection

C.  

Navicat connection

D.  

DAS connection

Discussion 0
Questions 6

When declaring a user variable, which of the following formats is correct?

Options:

A.  

~variable_name

B.  

@variable_name

C.  

^variable_name

D.  

%variable_name

Discussion 0
Questions 7

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

Options:

A.  

True

B.  

False

Discussion 0
Questions 8

DRS real-time migration supports only public network, VPC, and VPN migration.

Options:

A.  

True

B.  

False

Discussion 0
Questions 9

The command show [session|global] status defaults to "global".

Options:

A.  

True

B.  

False

Discussion 0
Questions 10

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

Options:

A.  

128

B.  

360

C.  

356

D.  

732

Discussion 0
Questions 11

Which of the following isnotan option of the EXPLAIN command?

Options:

A.  

Performance

B.  

Pretty

C.  

Analyze

D.  

Verbose

Discussion 0
Questions 12

The delay between read-only and primary nodes mainly comes from which of the following?

Options:

A.  

Small data sync between hosts

B.  

Read-only nodes reading logs

C.  

Read-only nodes replaying WAL

D.  

Read-only nodes deleting WAL

Discussion 0
Questions 13

GaussDB (for MySQL) uses V5 CPU + Optane DC SSD + RDMA network hardware combo, ensuring stable and fast performance.

Options:

A.  

True

B.  

False

Discussion 0
Questions 14

Which factors should be considered when designing database objects?

Options:

A.  

Field length

B.  

Normalization design

C.  

Field types

D.  

Proper indexing

Discussion 0
Questions 15

The EXPLAIN command can be used to view the execution plan of SQL statements. In the execution plan, Type indicates the access method to the table. Which of the following is not a valid Type value?

Options:

A.  

ALL

B.  

Range

C.  

Full

D.  

NULL

Discussion 0
Questions 16

Which parameter types can be used when writing stored procedures?

Options:

A.  

OUTIN

B.  

INOUT

C.  

OUT

D.  

IN

Discussion 0
Questions 17

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

Options:

A.  

Slow SQL analysis

B.  

Full SQL analysis

C.  

Performance & disk analysis

D.  

Tablespace analysis

E.  

Large transaction analysis

Discussion 0
Questions 18

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?

Options:

A.  

"Show status like 'Com_insert';"

B.  

show variables Cominsert

C.  

"show variables like 'Com_insert'"

D.  

"show status Com_insert"

Discussion 0
Questions 19

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

Options:

A.  

wait_timeout

B.  

max_connections

C.  

interactive_timeout

D.  

connect_timeout

Discussion 0
Questions 20

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

Options:

A.  

Syntax compatibility with MySQL 8.0 and functions

B.  

Development ecosystem compatibility (e.g., Hibernate, MyBatis, Druid)

C.  

Tool compatibility (MySQL WorkBench, Navicat, MySQL Dumper, PL/SQL Developer)

D.  

Connector compatibility (MySQL JDBC, ODBC)

Discussion 0
Questions 21

Which of the following VPC connection methods can achieve private IP communication between different VPCs in the same region?

Options:

A.  

VPC Peering

B.  

Virtual Private Network (VPN)

C.  

Elastic Public IP (EIP)

D.  

NAT Gateway

Discussion 0
Questions 22

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

Options:

A.  

print status

B.  

select status

C.  

desc status

D.  

show status

Discussion 0
Questions 23

Which statements about session killing in a database are correct?

Options:

A.  

Killing sessions is risky and should be confirmed

B.  

Rollbacks during session kill consume resources, may worsen load

C.  

Long rollbacks delay session release, resources can’t be freed instantly

D.  

Killing sessions won’t worsen system load

Discussion 0
Questions 24

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

Options:

A.  

True

B.  

False

Discussion 0
Questions 25

What is the output of the following SQL statement?

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

Options:

A.  

[30, 40, 20]

B.  

[20, 10]

C.  

(30, 40, 20)

D.  

(20, 10)

Discussion 0
Questions 26

Which statements about the InnoDB engine in GaussDB (for MySQL) are correct?

Options:

A.  

Supports full-text indexing

B.  

Compared to MyISAM, InnoDB write performance is lower and uses more disk

C.  

Supports foreign keys

D.  

Provides transaction safety with commit, rollback, crash recovery

Discussion 0
Questions 27

Which of the following is a normal tenant creation process?

Options:

A.  

Add parent tenant

B.  

Add tenant

C.  

Plan resource management

D.  

Bind roles and tenant

Discussion 0
Questions 28

Hints are used when the user knows the optimal execution plan or to stabilize SQL execution plans for performance tuning.

Options:

A.  

True

B.  

False

Discussion 0
Questions 29

Which of the following is not an object included in a schema?

Options:

A.  

Table

B.  

View

C.  

User

D.  

Index

Discussion 0
Questions 30

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

Options:

A.  

Fault detection is handled by HA monitor component

B.  

Each node periodically outputs status (faults, CPU, memory, etc.)

C.  

HA monitor promotes standby on primary failure, recovers standby on fault

D.  

A node is marked faulty only after 3 consecutive failures to reduce false positives

Discussion 0
Questions 31

Which parameters can limit resources per user?

Options:

A.  

MAX_QUERIES_PER_HOUR

B.  

MAX_UPDATES_PER_HOUR

C.  

MAX_CONNECTIONS_PER_HOUR

D.  

MAX_USER_CONNECTIONS

Discussion 0
Questions 32

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

Options:

A.  

Specs are consistent with the cluster

B.  

No need to manage accounts/databases, sync from primary

C.  

Support creating and deleting databases

D.  

Provide performance monitoring

Discussion 0
Questions 33

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

Options:

A.  

Access port

B.  

Access protocol

C.  

Priority

D.  

Blacklist

Discussion 0
Questions 34

What is the snapshot type used by GaussDB (for MySQL)?

Options:

A.  

COW

B.  

ROW

C.  

DTR

D.  

CROW

Discussion 0
Questions 35

Horizontal partitioning always improves query performance.

Options:

A.  

True

B.  

False

Discussion 0
Questions 36

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

Options:

A.  

True

B.  

False

Discussion 0
Questions 37

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

Options:

A.  

True

B.  

False

Discussion 0
Questions 38

What are the features of Huawei Cloud’s Cloud Audit service?

Options:

A.  

Audit log recording

B.  

Audit log querying

C.  

Audit log dumping

D.  

Event file encryption

Discussion 0
Questions 39

GaussDB (for MySQL) uses snapshots for both full and incremental backups, with second-level creation efficiency.

Options:

A.  

True

B.  

False

Discussion 0
Questions 40

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

Options:

A.  

Inserting data: thread inserting data

B.  

Executing: thread executing statement

C.  

Killed: thread terminates after receiving kill signal

D.  

Creating table: thread creating a table

Discussion 0
Questions 41

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

Options:

A.  

True

B.  

False

Discussion 0
Questions 42

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

Options:

A.  

True

B.  

False

Discussion 0
Questions 43

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

Options:

A.  

DAS

B.  

DRS

C.  

DBSS

D.  

UGO

Discussion 0
Questions 44

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

Options:

A.  

Specs match the cluster

B.  

No need to manage accounts/databases, syncs from primary

C.  

Provide system performance monitoring

D.  

Can be manually promoted to primary

Discussion 0
Questions 45

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

Options:

A.  

Real-time migration

B.  

Backup migration

C.  

Real-time synchronization

D.  

Operation audit

Discussion 0
Questions 46

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

Options:

A.  

Page Stores: persist Pages

B.  

SAL (Storage Abstraction Layer): sharding, recovery, remote storage

C.  

SQL: transaction commit, based on MySQL 8.0, fully compatible

D.  

Log Stores: persist redo logs

Discussion 0
Questions 47

Which statements about storage engines are correct?

Options:

A.  

Different engines provide different mechanisms, indexes, lock levels, etc.

B.  

Storage engine is the DBMS’s bottom layer software responsible for creation, queries, updates

C.  

Storage engine determines data access mode, directly affecting read/write performance

D.  

Each storage engine has unique formats, scenarios, and limitations

Discussion 0
Questions 48

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

Options:

A.  

5s

B.  

10s

C.  

15s

D.  

20s

Discussion 0
Questions 49

GaussDB (for MySQL) uses the same backup mechanism as community MySQL and supports xtrabackup for physical backups.

Options:

A.  

True

B.  

False

Discussion 0
Questions 50

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

Options:

A.  

Separation of compute and storage, decoupled primary/secondary

B.  

Fault-tolerant, self-healing storage layer with shared access (1 write, many reads)

C.  

Full utilization of SSD random read performance

D.  

Adoption of new network technologies like RDMA

E.  

Log-intensive workloads handled by compute nodes (e.g., redo processing)

Discussion 0
Questions 51

When using “Full SQL Insight,” DAS must be enabled to collect all SQL. After enabling, what is the performance overhead within?

Options:

A.  

2%

B.  

3%

C.  

4%

D.  

5%

Discussion 0
Questions 52

GaussDB (for MySQL) automatically backs up incremental changes every 5 minutes after the last backup.

Options:

A.  

True

B.  

False

Discussion 0
Questions 53

What are the parameter types for stored procedures?

Options:

A.  

IN

B.  

OUT

C.  

INOUT

D.  

OUTIN

Discussion 0
Questions 54

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

Options:

A.  

Username

B.  

Host

C.  

Password

D.  

Max connections

Discussion 0
Questions 55

The Data Management Service (DAS) is used for logging into and operating cloud databases on Huawei Cloud. Which of the following versions isnotprovided by DAS?

Options:

A.  

Professional Edition: for business personnel

B.  

Standard Edition: for developers

C.  

Cloud DB

D.  

Enterprise Edition: for enterprise users

E.  

For DBAs and O&M personnel

Discussion 0
Questions 56

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?

Options:

A.  

128MB

B.  

256MB

C.  

512MB

D.  

1GB

Discussion 0
Questions 57

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

Options:

A.  

rdsAdmin

B.  

rdsRoot

C.  

rdsMetric

D.  

rdsBackup

Discussion 0
Questions 58

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

Options:

A.  

True

B.  

False

Discussion 0
Questions 59

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

Options:

A.  

True

B.  

False

Discussion 0
Questions 60

SQL statements exceeding slow_launch_time are recorded in the slow SQL log.

Options:

A.  

True

B.  

False

Discussion 0
Questions 61

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.

Options:

A.  

True

B.  

False

Discussion 0
Questions 62

Which statements about SQL execution process are correct?

Options:

A.  

Connector: manages connections, verifies permissions

B.  

Parser: generates execution plan, selects indexes

C.  

Executor: operates engine, returns results

D.  

Storage engine: stores data, provides read/write interface

Discussion 0
Questions 63

Log Store uses append-only storage. Like Page Store, it also produces holes.

Options:

A.  

True

B.  

False

Discussion 0
Questions 64

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

Options:

A.  

Stored procedures can end with ; or /, but not both

B.  

Functions return values and can be directly used

C.  

Procedures/functions without parameters can be called without parentheses

D.  

Parameters can be specified directly or with =>

Discussion 0