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

Huawei H13-921_V1.5 - HCIP-GaussDB-OLTP V1.5

Huawei H13-921_V1.5 Premium Access     Download Demo    
Page: 3 / 7
Total 214 questions

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?

A.

Shared-Disk

B.

Shared-Memory

C.

Shared-Everything

D.

Shared-Nothing

What is the output of the following SQL statement?

SELECT JSON_EXTRACT(10, 20, [30, 40], "$$"$$11);

A.

[30, 40, 20]

B.

[20, 10]

C.

(30, 40, 20)

D.

(20, 10)

Which of the following are common SQL tuning practices?

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

Which statements about session killing in a database are correct?

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

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

A.

True

B.

False

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

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

User sessions correspond to user connection threads — one session equals one connection thread.

A.

True

B.

False

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

A.

1

B.

3

C.

2

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

A.

True

B.

False

In execution plans, the id indicates SELECT sequence number. Larger IDs execute first; same IDs execute top to bottom.

A.

True

B.

False