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

Pass the Huawei Huawei Certification H13-921_V1.5 Questions and answers with CertsForce

Viewing page 6 out of 7 pages
Viewing questions 51-60 out of questions
Questions # 51:

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


Expert Solution
Questions # 52:

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

Options:

A.

True


B.

False


Expert Solution
Questions # 53:

The parameter innodb_log_buffer_size is used to set the size of the InnoDB log buffer, primarily to improve I/O performance for writing logs. What is the default size in a 16-core, 64GB GaussDB (for MySQL) instance?

Options:

A.

128MB


B.

256MB


C.

512MB


D.

1GB


Expert Solution
Questions # 54:

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

Options:

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


Expert Solution
Questions # 55:

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

Options:

A.

h+


B.

h-


C.

h*


D.

h


Expert Solution
Questions # 56:

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


Expert Solution
Questions # 57:

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%


Expert Solution
Questions # 58:

GaussDB (for MySQL) deployment supports both public cloud and hybrid cloud.

Options:

A.

True


B.

False


Expert Solution
Questions # 59:

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

Options:

A.

True


B.

False


Expert Solution
Questions # 60:

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?

Options:

A.

max_connect_errors


B.

max_connections


C.

max_user_connections


D.

connect_timeout


Expert Solution
Viewing page 6 out of 7 pages
Viewing questions 51-60 out of questions