HCIP-GaussDB-OLTP V1.5 (H13-921_V1.5) Practice Test

Questions # 41:

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:

ALL

Range

Full

NULL

Questions # 42:

Which are common denormalization practices in DB design?

Options:

Increase index count

Recreate tables

Add derived columns

Add redundant columns

Questions # 43:

Regarding users, roles, and permissions, which of the following descriptions isincorrect?

Options:

Database users are primarily used to connect to and access database objects

Roles have the ability to log in and execute SQL statements

Databases use roles to organize and divide permissions

Creating a role requires the user to have CREATE ROLE or CREATE USER permissions

Questions # 44:

GaussDB (for MySQL) allows backup policy configuration in Huawei Cloud Console. Which of the following cannot be modified?

Options:

Retention days

Backup time window

Automatic backup switch

Backup cycle

Questions # 45:

Which factors affect database performance?

Options:

Hardware

System scale

Software environment

Internal DB factors

Questions # 46:

Which of the following is NOT a feature of a read-only node?

Options:

Can quickly delete a read-only node

Handles some write requests

Can quickly be promoted to primary node

Can quickly add a read-only node

Questions # 47:

Which factors should be considered when designing database objects?

Options:

Field length

Normalization design

Field types

Proper indexing

Questions # 48:

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

Options:

True

False

Questions # 49:

Which methods can be used during requirements investigation?

Options:

Questionnaire survey

Interviews with business personnel

Sample data collection and analysis

Review “User Requirements Specification”

Questions # 50:

The DAS Cloud DBA module can diagnose GaussDB (for MySQL) instances. Which dimensions are included in reports?

Options:

Slow SQL analysis

Full SQL analysis

Performance & disk analysis

Tablespace analysis

Large transaction analysis

Viewing page 5 out of 7 pages

Viewing questions 41-50 out of questions

Spring Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = getmirror

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

Exam H13-921_V1.5 Premium Access

Options:

Options:

Options:

Options:

Options:

Options:

Options:

Options:

Options:

Options:

TOP CODES