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

examout.co

GaussDB (for MySQL) uses the same backup mechanism as community MySQL and supports xtrabackup for physical backups.

A.

True

B.

False

A database administrator received a "cannot connect" error. Diagnosis revealed that a new business caused client connections to exceed the preset limit. Which parameter should be adjusted to fix the error?

A.

max_connect_errors

B.

max_connections

C.

max_user_connections

D.

connect_timeout

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

A.

True

B.

False

Which parameter types can be used when writing stored procedures?

A.

OUTIN

B.

INOUT

C.

OUT

D.

IN

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

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

Which statements about the InnoDB engine in GaussDB (for MySQL) are correct?

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

Which are advantages/features of GaussDB (for MySQL)?

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

Which of the following VPC connection methods can achieve private IP communication between different VPCs in the same region?

A.

VPC Peering

B.

Virtual Private Network (VPN)

C.

Elastic Public IP (EIP)

D.

NAT Gateway

Which of the following methods cannot be used to view a table's fragmentation rate?

A.

Use the “Space” function in Cloud DBA to clearly view the fragmentation rate

B.

Query information_schema.TABLES and check the data_free value

C.

Query performance_schema.TABLES and check the data_free value

D.

Use the command SHOW TABLE STATUS LIKE 'table_name' and check the data_free value

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

A.

True

B.

False