Weekend Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: pass65

  1. Home
  2. Huawei
  3. Huawei Certification
  4. H13-921_V1.5
  5. HCIP-GaussDB-OLTP V1.5 Questions and Answers

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

Questions 4

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

Options:

A.

True

B.

False

Buy Now
Questions 5

Which factors affect database performance?

Options:

A.

Hardware

B.

System scale

C.

Software environment

D.

Internal DB factors

Buy Now
Questions 6

What are the main advantages of the GaussDB (for MySQL) product?

Options:

A.

High reliability

B.

High scalability

C.

Ultra-high performance

D.

High compatibility

Buy Now
Questions 7

Which descriptions about session parameters are correct?

Options:

A.

max_connections: maximum allowed connections

B.

wait_timeout: max idle time for non-interactive connections

C.

interactive_timeout: max idle time for interactive connections

D.

connect_timeout: exception thrown if connection not established in time

Buy Now
Questions 8

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?

Options:

A.

max_connect_errors

B.

max_connections

C.

max_user_connections

D.

connect_timeout

Buy Now
Questions 9

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

Options:

A.

True

B.

False

Buy Now
Questions 10

Which are valid plan display formats?

Options:

A.

Normal

B.

Pretty

C.

Analyze

D.

Verbose

Buy Now
Questions 11

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

Buy Now
Questions 12

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.

Options:

A.

True

B.

False

Buy Now
Questions 13

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

Options:

A.

True

B.

False

Buy Now
Questions 14

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

Options:

A.

Use the “Space” function in Cloud DBA to clearly view the fragmentation rate

B.

Query information_schema.TABLES and check the data_free value

C.

Query performance_schema.TABLES and check the data_free value

D.

Use the command SHOW TABLE STATUS LIKE 'table_name' and check the data_free value

Buy Now
Questions 15

Which Huawei Cloud service is used to control external access operations to virtual machines?

Options:

A.

IAM

B.

VPN

C.

Security Group

D.

VPC

Buy Now
Questions 16

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

Options:

A.

True

B.

False

Buy Now
Questions 17

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

Buy Now
Questions 18

GaussDB (for MySQL) supports compute-storage separation.

Options:

A.

True

B.

False

Buy Now
Questions 19

Which methods can be used to find fragmented tables in GaussDB (for MySQL)?

Options:

A.

Cloud DBA “Space” function

B.

SHOW TABLES directly

C.

Query information_schema.TABLES

D.

SHOW TABLE STATUS LIKE 'table_name' and check Data_free

Buy Now
Questions 20

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

Buy Now
Questions 21

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

Buy Now
Questions 22

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

Options:

A.

True

B.

False

Buy Now
Questions 23

FETCH retrieves the current cursor row and moves to the next. If already at last row, overflow occurs.

Options:

A.

True

B.

False

Buy Now
Questions 24

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

Buy Now
Questions 25

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

Options:

A.

print

B.

select

C.

desc

D.

show

Buy Now
Questions 26

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

Options:

A.

2341

B.

3214

C.

2314

D.

3124

Buy Now
Questions 27

Which of the following statements is correct?

Options:

A.

EXPLAIN can show the effect of triggers, stored procedures, and user-defined functions on a query

B.

EXPLAIN considers cache

C.

EXPLAIN shows the database’s optimization operations during query execution

D.

The statistics produced by EXPLAIN are estimates, not exact values

Buy Now
Questions 28

Horizontal partitioning always improves query performance.

Options:

A.

True

B.

False

Buy Now
Questions 29

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

Options:

A.

True

B.

False

Buy Now
Questions 30

What are the core advantages of GaussDB (for MySQL)?

Options:

A.

Ultra-high performance

B.

High scalability

C.

High reliability

D.

NoSQL support

Buy Now
Questions 31

Which statements about field optimization in GaussDB (for MySQL) are correct?

Options:

A.

Choose efficient field types when possible

B.

Choose shorter field lengths when possible

C.

Match field type to business use (e.g., numeric for amounts)

D.

Design adequate length to avoid later schema changes

Buy Now
Questions 32

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

Options:

A.

True

B.

False

Buy Now
Questions 33

Which of the following statements about the VACUUM FULL operation isincorrect?

Options:

A.

Space from deleted rows is physically released back to the OS

B.

Allows concurrent operations during execution

C.

Should be run only when disk space usage nears a threshold

D.

Improves all operations based on the table after execution

Buy Now
Questions 34

Which of the following statements about PLOG objects in Log Stores are correct?

Options:

A.

Uses append-only storage

B.

Identified by a 24-byte unique ID

C.

Default 3 replicas, strong consistency on writes, read from any replica

D.

PLOG size limited to 10GB

Buy Now
Questions 35

Which window function can be used to generate group-based ranks with the same rank for identical values?

Options:

A.

ROW_NUMBER()

B.

RANK()

C.

DENSE_RANK()

D.

NTLITE()

Buy Now
Questions 36

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

Buy Now
Questions 37

Creating partitioned tables is a form of vertical partitioning.

Options:

A.

True

B.

False

Buy Now
Questions 38

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

Options:

A.

pg_roles

B.

pg_user

C.

pg_auth_members

D.

pg_authid

Buy Now
Questions 39

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

Options:

A.

Easier creation/management, no memory allocation overhead

B.

Easier creation/management, no merge overhead

C.

Fast context switching

D.

Misbehaving threads won’t affect the entire system

Buy Now
Questions 40

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

Options:

A.

Application statistics

B.

Operating system statistics

C.

Network statistics

D.

Database statistics

Buy Now
Questions 41

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

Options:

A.

True

B.

False

Buy Now
Questions 42

Which of the following isnota binary data type?

Options:

A.

BLOB

B.

RAW

C.

BYTEA

D.

TEXT

Buy Now
Questions 43

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

Options:

A.

4

B.

1

C.

2

D.

3

Buy Now
Questions 44

Which statements about distributed transactions are correct?

Options:

A.

Support distributed deadlock prevention

B.

Support global transaction info management

C.

Distributed transactions support ACID properties

D.

gs_clean cleans up residual transactions automatically

Buy Now
Questions 45

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

Buy Now
Questions 46

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

Options:

A.

Independent CPU/memory, each provides equal read performance

B.

Adding read-only nodes is fast, independent of data size

C.

Only metadata is exchanged with primary, minimal overhead

D.

No interaction between read-only nodes, scaling doesn’t affect others

Buy Now
Questions 47

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

Buy Now
Questions 48

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

Buy Now
Questions 49

Which of the following isnotan option of the EXPLAIN command?

Options:

A.

Performance

B.

Pretty

C.

Analyze

D.

Verbose

Buy Now
Questions 50

Which are advantages/features of GaussDB (for MySQL)?

Options:

A.

High performance: 7x native MySQL

B.

High scalability: up to 1 primary + 15 standbys, read/write separation, load balancing

C.

Massive storage: up to 128TB capacity

D.

Compute-storage separation: independently scalable resources

Buy Now
Questions 51

Which functions are provided by Huawei Cloud Data Replication Service (DRS)?

Options:

A.

Real-time sync

B.

Real-time migration

C.

Backup migration

D.

Data subscription

E.

Real-time disaster recovery

Buy Now
Questions 52

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

Buy Now
Questions 53

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

Options:

A.

COW

B.

ROW

C.

DTR

D.

CROW

Buy Now
Questions 54

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

Options:

A.

True

B.

False

Buy Now
Questions 55

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

Options:

A.

True

B.

False

Buy Now
Questions 56

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

Buy Now
Questions 57

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

Options:

A.

Storage layer asynchronously pushes logs in distributed fashion

B.

Storage up to 256TB, pay-as-you-go, no pre-planning

C.

Shared storage allows fast expansion by adding compute nodes only

D.

Binlog delay is eliminated, RTO is guaranteed

Buy Now
Questions 58

Which are common denormalization practices in DB design?

Options:

A.

Increase index count

B.

Recreate tables

C.

Add derived columns

D.

Add redundant columns

Buy Now
Questions 59

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

Buy Now
Questions 60

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

Options:

A.

Regular expressions

B.

Scheduler

C.

Cursor

D.

Trigger

Buy Now
Questions 61

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

Options:

A.

System Administrator

B.

DBA

C.

Security Administrator

D.

Regular User

Buy Now
Questions 62

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

Buy Now
Questions 63

If private IP cannot connect to GaussDB (for MySQL), bind an Elastic Public IP and connect via ECS or public host.

Options:

A.

True

B.

False

Buy Now
Questions 64

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

Options:

A.

Database users are primarily used to connect to and access database objects

B.

Roles have the ability to log in and execute SQL statements

C.

Databases use roles to organize and divide permissions

D.

Creating a role requires the user to have CREATE ROLE or CREATE USER permissions

Buy Now
Exam Code: H13-921_V1.5
Exam Name: HCIP-GaussDB-OLTP V1.5
Last Update: Sep 29, 2025
Questions: 214

PDF + Testing Engine

$63.52  $181.49
buy now H13-921_V1.5 pdf + testing engine

Testing Engine

$50.57  $144.49
buy now H13-921_V1.5 testing engine

PDF (Q&A)

$43.57  $124.49
buy now H13-921_V1.5 pdf