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

DumpsWrap Logo

Huawei H13-921_V1.5 Dumps

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

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

Options:

A.

True

B.

False

Question 2

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 =>

Question 3

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 4

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 5

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 6

Horizontal partitioning always improves query performance.

Options:

A.

True

B.

False

Question 7

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 8

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

Question 9

Which parameter types can be used when writing stored procedures?

Options:

A.

OUTIN

B.

INOUT

C.

OUT

D.

IN

Question 10

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 11

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 12

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 13

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

Question 14

Which of the following are DAS Enterprise Edition user roles?

Options:

A.

DBA

B.

Developer

C.

System Administrator

D.

Regular User

Question 15

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

Options:

A.

True

B.

False

Question 16

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 17

For composite indexes, B+ tree is built left-to-right.

Options:

A.

True

B.

False

Question 18

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

Options:

A.

True

B.

False

Question 19

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 20

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

Question 21

GaussDB (for MySQL) has a strong access control system. Which permissions cannot currently be modified?

Options:

A.

CREATE TABLESPACE

B.

SUPER

C.

FILE

D.

TRIGGER

Question 22

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 23

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

Question 24

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 25

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 26

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 27

Which types of backup does Huawei Cloud provide?

Options:

A.

Automatic backup

B.

Manual backup

C.

Full backup

D.

Incremental backup

Question 28

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 29

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

Options:

A.

True

B.

False

Question 30

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 31

In GaussDB (for MySQL), which of the following is offloaded to the storage node for execution?

Options:

A.

Transaction

B.

Buffer Pool

C.

SQL Parse

D.

Log Write

Question 32

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

Options:

A.

True

B.

False

Question 33

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

Options:

A.

%

B.

*

C.

~

D.

(Blank)

Question 34

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 35

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 36

When executing stored procedures, which end delimiters are allowed?

Options:

A.

Using / and ;

B.

Using /

C.

Using ;

D.

Using newline as delimiter

Question 37

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 38

GaussDB (for MySQL) supports compute-storage separation.

Options:

A.

True

B.

False

Question 39

Which factors affect database performance?

Options:

A.

Hardware

B.

System scale

C.

Software environment

D.

Internal DB factors

Question 40

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 41

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

Options:

A.

True

B.

False

Question 42

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

Options:

A.

True

B.

False

Question 43

What is the maximum number of read-only nodes that can be created in one GaussDB (for MySQL) cluster?

Options:

A.

13

B.

12

C.

15

D.

14

Question 44

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 45

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

Question 46

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

Options:

A.

True

B.

False

Question 47

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 48

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

Options:

A.

DAS

B.

DRS

C.

DBSS

D.

UGO

Question 49

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 50

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 51

Which statements about slow query logs are correct?

Options:

A.

Time waiting for initial table locks is excluded

B.

Slow logs record SQL affecting performance for later tuning

C.

Record order may differ from execution order

D.

Logs are written after execution and all locks are released

Question 52

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 53

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

Question 54

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 55

To facilitate management, DAS Enterprise Edition includes several user roles. Which of the following isnotamong them?

Options:

A.

Regular User

B.

DBA

C.

Business Owner

D.

System Administrator

Question 56

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

Question 57

Slow query logs in GaussDB (for MySQL) are controlled by slow_query_log. 0/OFF disables, 1/ON enables.

Options:

A.

True

B.

False

Question 58

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 59

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 60

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

Options:

A.

7

B.

8

C.

11

D.

12

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

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 63

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

Question 64

Which of the following statements about GaussDB (for MySQL) instances is incorrect?

Options:

A.

An instance contains multiple background threads

B.

An instance includes continuous memory regions

C.

An instance contains various files

D.

An instance corresponds one-to-one with a database

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