New Year Sale Special - Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: sntaclus

examout.co

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

A.

7

B.

8

C.

11

D.

12

To meet data reliability requirements, GaussDB (for MySQL) can retain automatic backup recovery for up to how many days?

A.

128

B.

360

C.

356

D.

732

Read-only nodes replay WAL and read Page Store to sync with the primary node’s memory state, including active transactions and buffer pool.

A.

True

B.

False

DAS Enterprise Edition defines three types of user roles. Which of the following isnota role in DAS Enterprise Edition?

A.

System Administrator

B.

DBA

C.

Security Administrator

D.

Regular User

Which statements about GaussDB (for MySQL) primary-standby replication are correct?

A.

Read-only nodes use Log

B.

No latency exists between primary and read-only nodes

C.

Read-only nodes replay WAL and read Pages

D.

Primary and read-only share storage

Which statements about field optimization in GaussDB (for MySQL) are correct?

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

Which of the following are part of GaussDB (for MySQL)'s Cloud Native design philosophy?

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)

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

A.

True

B.

False

When using security group functionality, which of the following is not a configurable setting?

A.

Access port

B.

Access protocol

C.

Priority

D.

Blacklist

Which window function can be used to generate group-based ranks with the same rank for identical values?

A.

ROW_NUMBER()

B.

RANK()

C.

DENSE_RANK()

D.

NTLITE()