CertsTopics Logo

Weekend Sale 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Free and Premium Huawei H13-921_V1.5 Dumps Questions Answers

Page: 1 / 16
Total 214 questions
Get H13-921_V1.5 Full Access Download H13-921_V1.5 PDF

HCIP-GaussDB-OLTP V1.5 Questions and Answers

Question 1

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

Buy Now
Question 2

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

Options:

A.

Application SQL migration

B.

Database schema migration

C.

Migration workload assessment

D.

Target database selection & spec recommendation

Question 3

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

Options:

A.

True

B.

False

Question 4

Hints in GaussDB (for MySQL) mainly include which categories?

Options:

A.

Specify index

B.

Specify join tables

C.

Specify optimization strategy

D.

Specify column names

Question 5

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

Question 6

Which of the following are entities?

Options:

A.

Pilot

B.

Student

C.

Height

D.

Gender

Question 7

Huawei Cloud DAS (Cloud DBA) provides intelligent monitoring, diagnostics, and optimization to ensure stable DB operation.

Options:

A.

True

B.

False

Question 8

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"

Question 9

Which SQL O&M features does Cloud DBA provide?

Options:

A.

Full SQL Insight

B.

SQL Diagnosis

C.

SQL Audit

D.

Slow SQL

Question 10

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

Question 11

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

Options:

A.

IAM

B.

VPN

C.

Security Group

D.

VPC

Question 12

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

Question 13

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

Options:

A.

DEPENDENT UNION: subsequent SELECTs in a UNION

B.

DERIVED: derived table SELECT (subquery in FROM)

C.

UNION RESULT: result of UNION

D.

PRIMARY: outermost SELECT in query with subqueries

Question 14

Which metrics can be displayed in real-time performance?

Options:

A.

Slow queries

B.

DML execution count

C.

QPS

D.

Network traffic

Question 15

Which of the following are key operations supported by Cloud Audit (CTS) for GaussDB (for MySQL) instances?

Options:

A.

Modify DB port

B.

Create read-only instance

C.

Modify parameter template

D.

Delete DB user

Question 16

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

Options:

A.

True

B.

False

Question 17

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

Options:

A.

True

B.

False

Question 18

Which type of backup in GaussDB (for MySQL) isretained even afterthe instance is deleted?

Options:

A.

Incremental backup

B.

Manual backup

C.

Full backup

D.

Automatic backup

Question 19

Which of the following are common SQL tuning practices?

Options:

A.

Always use SELECT statements

B.

Minimize use of GROUP BY

C.

Use LIMIT when querying a single record

D.

For large data inserts, drop indexes and constraints first

Question 20

Which statements about Schema are correct?

Options:

A.

Equivalent to user, separates object ownership

B.

Collection of DB objects, logical grouping for management

C.

Search order is based on creation time

D.

Forms a namespace to avoid naming conflicts

Question 21

GaussDB (for MySQL) supports compute-storage separation.

Options:

A.

True

B.

False

Question 22

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

Question 23

Which are valid plan display formats?

Options:

A.

Normal

B.

Pretty

C.

Analyze

D.

Verbose

Question 24

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

Question 25

Which of the following descriptions about Hint optimization strategies isincorrect?

Options:

A.

JOIN_PREFIX: uses the specified table order as thelastjoin order

B.

JOIN_FIXED_ORDER: uses the FROM clause's table order as the join order

C.

JOIN_ORDER: uses the specified table order as the join order

D.

MAX_EXECUTION_TIME: limits the statement execution time

Question 26

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

Question 27

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

Options:

A.

True

B.

False

Question 28

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

Question 29

Which window function generates a ranking within groups, where the same value gets the same rank?

Options:

A.

DENS

B.

RANK()

C.

PERCENT_RANK()

D.

ROW_NUMBER()

Question 30

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

Options:

A.

Dynamic tables

B.

Compressed tables

C.

Temporary tables

D.

Static tables

Question 31

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

Question 32

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

Options:

A.

8

B.

10

C.

12

D.

13

Question 33

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

Options:

A.

True

B.

False

Question 34

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

Options:

A.

True

B.

False

Question 35

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

Options:

A.

Compatible with MySQL client

B.

Reduces deployment costs and server requirements

C.

Maintains open-source control

D.

Distributes data access load before server startup, allowing fast server switch during failures

Question 36

Which of the following window functions are supported by GaussDB (for MySQL)?

Options:

A.

LEAD()

B.

MIDDLE_VALUE()

C.

FIRST_VALUE()

D.

LAG()

Question 37

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

Question 38

Which of the following statements are incorrect?

Options:

A.

Page Store persists Pages and SQL reads pages

B.

Slice is independent and max size is 1GB

C.

Log Store defaults to multi-replica sync

D.

Log Store uses append-only

Question 39

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

Question 40

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%

Question 41

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

Options:

A.

True

B.

False

Question 42

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

Question 43

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

Options:

A.

True

B.

False

Question 44

MD5(str) returns a 128-bit checksum as a 40-character hex string.

Options:

A.

True

B.

False

Question 45

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

Options:

A.

True

B.

False

Question 46

What are the parameter types for stored procedures?

Options:

A.

IN

B.

OUT

C.

INOUT

D.

OUTIN

Question 47

Which of the following isnotan option of the EXPLAIN command?

Options:

A.

Performance

B.

Pretty

C.

Analyze

D.

Verbose

Question 48

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

Options:

A.

Table

B.

View

C.

User

D.

Index

Question 49

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

Options:

A.

True

B.

False

Question 50

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

Question 51

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

Question 52

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

Options:

A.

True

B.

False

Question 53

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

Question 54

Which industries can GaussDB 100 be applied to?

Options:

A.

Power

B.

Finance

C.

Government

D.

Telecom

Question 55

Which are common performance bottlenecks in database servers?

Options:

A.

Improper memory allocation

B.

High CPU usage

C.

Network problems

D.

Slow physical I/O

Question 56

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

Options:

A.

After standby is promoted to primary

B.

After manage-vip is successfully bound

C.

After manage-vip is successfully unbound

D.

After data-vip is successfully bound

Question 57

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

Options:

A.

VPC

B.

VPN

C.

OBS

D.

EIP

Question 58

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

Options:

A.

True

B.

False

Question 59

In Cloud DBA’s performance module, “Slow SQL” includes which functions?

Options:

A.

Slow log description

B.

Slow log trend

C.

Slow log statistics

D.

Slow log details

Question 60

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

Options:

A.

True

B.

False

Question 61

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

Options:

A.

128MB

B.

256MB

C.

512MB

D.

1024MB

Question 62

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

Options:

A.

print

B.

select

C.

desc

D.

show

Question 63

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

Question 64

Response time calculation model = network transmission time (request) + server processing time (one or more layers) + network transmission time (response) + frontend parsing time.

Options:

A.

True

B.

False

Exam Detail
Vendor: Huawei
Certification: Huawei Certification
Exam Code: H13-921_V1.5
Exam Name: HCIP-GaussDB-OLTP V1.5
Last Update: Oct 5, 2025
H13-921_V1.5 Question Answers
Page: 1 / 16
Total 214 questions
Get H13-921_V1.5 Full Access Download H13-921_V1.5 PDF