Winter Sale- Special Discount Limited Time 65% Offer - Ends in 0d 00h 00m 00s - Coupon code: netdisc

Activedumpsnet Logo
  1. Home
  2. Huawei
  3. Huawei Certification
  4. H13-921_V1.5
  5. H13-921_V1.5 - HCIP-GaussDB-OLTP V1.5

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

Page: 1 / 21
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

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

Question 2

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

Options:

A.

True

B.

False

Question 3

The regex function REGEXP_INSTR returns the starting index of a match. If return_option=1, it returns the last position.

Options:

A.

True

B.

False

Question 4

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

Options:

A.

Cross-region replication, cross-AZ disaster recovery

B.

Thousands of nodes in a single pool

C.

EB-level capacity, billions of objects per device

D.

Linear scaling of capacity and performance

Question 5

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

Options:

A.

h+

B.

h-

C.

h*

D.

h

Question 6

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 7

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 8

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 9

Which factors should be considered when designing database objects?

Options:

A.

Field length

B.

Normalization design

C.

Field types

D.

Proper indexing

Question 10

To elastically scale read capacity and reduce GaussDB (for MySQL) pressure, read-only nodes can be created. Which statements are correct?

Options:

A.

One cluster supports up to 15 read-only nodes

B.

Support data migration to read-only nodes

C.

Support creating and deleting databases

D.

No account creation allowed on read-only nodes (must be on primary)

Question 11

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)

Question 12

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

Question 13

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

Question 14

Which industries can GaussDB 100 be applied to?

Options:

A.

Power

B.

Finance

C.

Government

D.

Telecom

Question 15

In GaussDB (for MySQL), session and connection are the same concept.

Options:

A.

True

B.

False

Question 16

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 17

Which are common denormalization practices in DB design?

Options:

A.

Increase index count

B.

Recreate tables

C.

Add derived columns

D.

Add redundant columns

Question 18

Which roles exist in DAS Enterprise Edition?

Options:

A.

System Administrator

B.

DBA

C.

Business Owner role

D.

Regular User

Question 19

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

Options:

A.

MEMORY storage engine stores data in memory to provide fast access for queries and joins.

B.

MEMORY storage engine supports only B-tree indexes and not hash indexes.

C.

Data in MEMORY tables is lost if the mysqld daemon crashes.

D.

MEMORY storage engine uses fixed-length format for data, and does not support BLOB or TEXT types.

Question 20

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

Options:

A.

15s

B.

20s

C.

10s

D.

5s

Question 21

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 22

What are the main features of GaussDB 100?

Options:

A.

Extreme performance

B.

Simple and easy to use

C.

NoSQL database

D.

Secure and reliable

Question 23

Which strings can the regex 'x?z|food' (simplified from source) match?

Options:

A.

zood

B.

xood

C.

food

D.

z

Question 24

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

Options:

A.

True

B.

False

Question 25

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

Options:

A.

Ultra-high performance

B.

High scalability

C.

High reliability

D.

NoSQL support

Question 26

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 27

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 28

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

Options:

A.

SIMPLE

B.

COMPLEX

C.

PRIMARY

D.

SUBQUERY

Question 29

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 30

When executing stored procedures, which end delimiters are allowed?

Options:

A.

Using / and ;

B.

Using /

C.

Using ;

D.

Using newline as delimiter

Question 31

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

Question 32

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

Question 33

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

Options:

A.

Normal

B.

Creating

C.

Restarting

D.

Running

Question 34

GaussDB (for MySQL) supports compute-storage separation.

Options:

A.

True

B.

False

Question 35

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 36

What is the maximum number of read-only nodes that can be added to a GaussDB (for MySQL) cluster?

Options:

A.

12

B.

13

C.

14

D.

15

Question 37

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 38

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

Question 39

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

Question 40

Which SQL O&M features does Cloud DBA provide?

Options:

A.

Full SQL Insight

B.

SQL Diagnosis

C.

SQL Audit

D.

Slow SQL

Question 41

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

Options:

A.

Automatic backup

B.

Manual backup

C.

Incremental backup

D.

Full backup

Question 42

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

Options:

A.

Table

B.

View

C.

User

D.

Index

Question 43

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

Question 44

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

Question 45

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 46

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

Options:

A.

True

B.

False

Question 47

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 48

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

Options:

A.

True

B.

False

Question 49

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 50

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

Options:

A.

True

B.

False

Question 51

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

Options:

A.

True

B.

False

Question 52

In GaussDB (for MySQL), parameters can show whether the workload is mainly inserts/updates or queries, and the approximate SQL type ratio.

Options:

A.

True

B.

False

Question 53

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 54

An e-commerce platform is experiencing a surge in users and needs a database architecture with optimal parallel processing and scalability. Which architecture should be enabled?

Options:

A.

Shared-Disk

B.

Shared-Memory

C.

Shared-Everything

D.

Shared-Nothing

Question 55

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 56

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 57

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

Options:

A.

True

B.

False

Question 58

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 59

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 60

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

Options:

A.

True

B.

False

Question 61

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.

Options:

A.

True

B.

False

Question 62

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 63

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 64

Which of the following isnota binary data type?

Options:

A.

BLOB

B.

RAW

C.

BYTEA

D.

TEXT

Load More H13-921_V1.5 Questions 
Page: 1 / 21
Total 214 questions
Get H13-921_V1.5 Full Access Download H13-921_V1.5 PDF