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

Huawei H13-921_V1.5 HCIP-GaussDB-OLTP V1.5 Exam Practice Test

Page: 1 / 21
Total 214 questions

HCIP-GaussDB-OLTP V1.5 Questions and Answers

Testing Engine

  • Product Type: Testing Engine
$37.5  $124.99

PDF Study Guide

  • Product Type: PDF Study Guide
$33  $109.99
Question 1

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 2

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

Question 3

Under the performance tab, in which module can users view server uptime, connection information, and buffer pool status?

Options:

A.

Historical Performance

B.

Real-time Performance

C.

Real-time Diagnostics

D.

Performance Trend Comparison

Question 4

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 5

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

Options:

A.

Automatic backup

B.

Manual backup

C.

Incremental backup

D.

Full backup

Question 6

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

Question 7

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

Question 8

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 9

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

Question 10

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

Options:

A.

COW

B.

ROW

C.

DTR

D.

CROW

Question 11

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

Question 12

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

Options:

A.

InnoDB storage engine

B.

Memory storage engine

C.

MyISAM storage engine

D.

ARCHIVE storage engine

Question 13

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

Question 14

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

Options:

A.

15s

B.

20s

C.

10s

D.

5s

Question 15

When creating a user in GaussDB (for MySQL), which symbol represents all hosts?

Options:

A.

%

B.

*

C.

~

D.

(Blank)

Question 16

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)

Question 17

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

Question 18

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 19

Which of the following isnotan option of the EXPLAIN command?

Options:

A.

Performance

B.

Pretty

C.

Analyze

D.

Verbose

Question 20

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

Options:

A.

Table

B.

View

C.

User

D.

Index

Question 21

When using hints, different scopes apply. Which scope descriptions are correct?

Options:

A.

Global: affects entire statement

B.

Query block: affects a specific query block

C.

Table-level: affects a table in a block

D.

Index-level: affects an index in a table

Question 22

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

Options:

A.

True

B.

False

Question 23

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

Options:

A.

Key Partitioning

B.

Range Partitioning

C.

List Partitioning

D.

Hash Partitioning

Question 24

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 25

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 26

When creating a GaussDB (for MySQL) instance, the system automatically creates system accounts (usable by users) to support backend O&M. Which are these accounts?

Options:

A.

rdsAdmin

B.

rdsRepl

C.

rdsBackup

D.

rdsMetric

Question 27

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

Options:

A.

True

B.

False

Question 28

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 29

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

Question 30

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 31

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

Question 32

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

Options:

A.

True

B.

False

Question 33

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 34

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

Question 35

Which are valid plan display formats?

Options:

A.

Normal

B.

Pretty

C.

Analyze

D.

Verbose

Question 36

GaussDB (for MySQL) allows backup policy configuration in Huawei Cloud Console. Which of the following cannot be modified?

Options:

A.

Retention days

B.

Backup time window

C.

Automatic backup switch

D.

Backup cycle

Question 37

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

Options:

A.

hiuuuu

B.

uuuuhi

C.

hiuuu

D.

uuuhi

Question 38

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

Question 39

Which factors should be considered when designing database objects?

Options:

A.

Field length

B.

Normalization design

C.

Field types

D.

Proper indexing

Question 40

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

Question 41

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 42

When executing select * from processlist; to view instance-related information in GaussDB (for MySQL), which database should be used?

Options:

A.

sys

B.

mysql

C.

information_schema

D.

performance_schema

Question 43

When creating a GaussDB (for MySQL) instance, system accounts are automatically created. Which of the following are such accounts?

Options:

A.

rdsRepl — replication account

B.

rdsAdmin — admin account with superuser privileges

C.

rdsBackup — backup account

D.

rdsMetric — monitoring account

Question 44

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

Question 45

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

Options:

A.

print

B.

select

C.

desc

D.

show

Question 46

Which industries can GaussDB 100 be applied to?

Options:

A.

Power

B.

Finance

C.

Government

D.

Telecom

Question 47

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)

Question 48

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

Question 49

Horizontal partitioning always improves query performance.

Options:

A.

True

B.

False

Question 50

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 51

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 52

Which methods can be used during requirements investigation?

Options:

A.

Questionnaire survey

B.

Interviews with business personnel

C.

Sample data collection and analysis

D.

Review “User Requirements Specification”

Question 53

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

Options:

A.

True

B.

False

Question 54

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

Options:

A.

True

B.

False

Question 55

What is the impossible return value of SELECT FLOOR(7 + (RAND()*5));?

Options:

A.

7

B.

8

C.

11

D.

12

Question 56

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

Options:

A.

True

B.

False

Question 57

When performance drops sharply, Cloud DBA’s SQL module can quickly identify problematic SQL for diagnosis.

Options:

A.

True

B.

False

Question 58

The frequency of flushing logs from the buffer to disk is related to the parameter innodb_flush_log_at_trx_commit. Which value means "write log buffer data to log file and flush to disk every second"?

Options:

A.

1

B.

3

C.

2

Question 59

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

Options:

A.

True

B.

False

Question 60

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

Question 61

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

Question 62

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 63

Which of the following isnota functional module of Cloud Audit?

Options:

A.

Audit log recording

B.

Audit log query

C.

Event file encryption

D.

Event file desensitization

Question 64

In GaussDB (for MySQL), the Log Store is responsible for persisting logs. What is the size of the unique ID used to identify Log Store?

Options:

A.

12 bytes

B.

24 bytes

C.

48 bytes

Page: 1 / 21
Total 214 questions