Exclusive Black Friday Deal: 70% Off All Exam Bundles! Use coupon code below to unlock your savings! - Ends in 0d 00h 00m 00s - Coupon code: Friday70

Free HCIP-GaussDB-OLTP V1.5 Practice Questions

Question # 11

What is the snapshot type used by GaussDB (for MySQL)?

Options:

A.  

COW

B.  

ROW

C.  

DTR

D.  

CROW

Discussion 0
Question # 12

Object Storage Service (OBS) is a massive, secure, reliable, and low-cost storage service.

Options:

A.  

True

B.  

False

Discussion 0
Question # 13

Which descriptions of important modules in GaussDB (for MySQL) architecture are correct?

Options:

A.  

Page Stores: persist Pages

B.  

SAL (Storage Abstraction Layer): sharding, recovery, remote storage

C.  

SQL: transaction commit, based on MySQL 8.0, fully compatible

D.  

Log Stores: persist redo logs

Discussion 0
Question # 14

Which type of backup in GaussDB (for MySQL) isretained even afterthe instance is deleted?

Options:

A.  

Incremental backup

B.  

Manual backup

C.  

Full backup

D.  

Automatic backup

Discussion 0
Question # 15

Which metrics can be displayed in real-time performance?

Options:

A.  

Slow queries

B.  

DML execution count

C.  

QPS

D.  

Network traffic

Discussion 0
Question # 16

Splitting common and uncommon fields into separate storage is called vertical partitioning.

Options:

A.  

True

B.  

False

Discussion 0
Question # 17

What is the impossible result of executing: SELECT FLOOR(8 + (RAND()* 5));?

Options:

A.  

8

B.  

10

C.  

12

D.  

13

Discussion 0
Question # 18

Which of the following statements about PLOG objects in Log Stores are correct?

Options:

A.  

Uses append-only storage

B.  

Identified by a 24-byte unique ID

C.  

Default 3 replicas, strong consistency on writes, read from any replica

D.  

PLOG size limited to 10GB

Discussion 0
Question # 19

Which of the following statements is correct?

Options:

A.  

EXPLAIN can show the effect of triggers, stored procedures, and user-defined functions on a query

B.  

EXPLAIN considers cache

C.  

EXPLAIN shows the database’s optimization operations during query execution

D.  

The statistics produced by EXPLAIN are estimates, not exact values

Discussion 0
Question # 20

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

Options:

A.  

Slow SQL analysis

B.  

Full SQL analysis

C.  

Performance & disk analysis

D.  

Tablespace analysis

E.  

Large transaction analysis

Discussion 0

H13-921_V1.5 PDF

H13-921_V1.5 PDF (Printable)
$46.5
$154.99

H13-921_V1.5 Testing Engine

H13-921_V1.5 PDF (Printable)
$51
$169.99

H13-921_V1.5 PDF + Testing Engine

H13-921_V1.5 PDF (Printable)
$63.9
$212.99

Free Exams Sample Questions