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

Huawei H13-922 HCIP-GaussDB-OLAP V1.0 Exam Practice Test

Demo: 22 questions
Total 152 questions

HCIP-GaussDB-OLAP V1.0 Questions and Answers

Question 1

What are the ACID characteristics of transaction

Options:

A.

Atomic

B.

Consistency

C.

Isolation

D.

Persistence

Question 2

Which of the following components does the user service use to access the GaussDB 200 database?

Options:

A.

DN

B.

GTM

C.

CM

D.

CN

Question 3

(Judgment) When there are too many catalog files for gds import data, you can use the form of regular expression to specify the LOCATION of the appearance, so as to select the file to be imported.

Options:

A.

TRUE

B.

FALSE

Question 4

SQL tuning does not pay attention to the use of resources, as long as it can achieve the best performance.

Options:

A.

True

B.

False

Question 5

Which of the following are the basic functions of dual cluster disaster recovery?

Options:

A.

Master and standby cluster roles swap

B.

Display the current cluster role

C.

Show master cluster synchronization progress

D.

Cancel the standby cluster relationship

Question 6

Are the following control operators?

Options:

A.

HashJoin

B.

Append

C.

Agg

D.

RecursiveUnoin

Question 7

Principles for selecting distribution columns in table design include

Options:

A.

As distributed as possible

B.

Select the related conditions in the query as the columns

C.

Try to select fields that have a filter condition of col = 10001 in the query

Question 8

GuassDB 200 implements logical cluster management to realize the division of a cluster into multiple small logical clusters in an existing MPPDB physical cluster to achieve isolation of computing and storage resources between logical clusters. Industry backup users cannot access data tables across clusters.

Options:

A.

T

B.

F

Question 9

Which of the following are high-risk operations for disabled databases?

Options:

A.

Modify the file name in the data directory. Authority

B.

Delete database system tables

C.

Modify the node host name

D.

Manually modify the port number directly in the configuration file

Question 10

What is wrong about the logical cluster description?

Options:

A.

GaussDB 200 only supports the physical expansion mode, and the human physical cluster is directly expanded to the logical cluster.

B.

GaussDB 200 supports physical expansion mode, supports elastic cluster expansion to logical cluster

C.

When the amount of data storage required by the business decreases, in order to avoid wasting resources, the logical cluster or elastic cluster can be scaled down

D.

When the nodes of the logical cluster change or the logical cluster capacity is not redistributed, you need to manually perform data redistribution on the logical cluster.

Question 11

Does GuassDB 200 upgrade support online upgrade?

Options:

A.

True

B.

False

Question 12

Which of the following types of logs records the final status of a transaction?

Options:

A.

System Log

B.

Performance Log

C.

pg_xlog

D.

pg_clog

Question 13

(Judgment) After CN failure, the entire cluster will still be able to execute DDL statements.

Options:

A.

TRUE

B.

FALSE

Question 14

Which of the following is a client management tool?

Options:

A.

gs_cgroup

B.

gsql

C.

gs_check

Question 15

FQS means that the CN completely pushed down the statement to execute on the DN?

Options:

A.

TRUE

B.

FALSE

Question 16

The tool used to clean up residual transactions is called

Options:

A.

gs_clean

B.

gs_guc

C.

gs_dump

D.

gs_ctl

Question 17

Which of the following options is correct regarding active / standby switching?

Options:

A.

Ordinary active / standby switchover is suitable for high pressure scenarios with huge business volume

B.

Fast standby switchover is suitable for high pressure scenarios with huge business volume

C.

Ordinary active / standby switchover is applicable to general scenarios

D.

There are two modes of fast active / standby switchover: single group DN active / standby instance and all GTM switchover.

Question 18

Database utilization for deadlock detection

Options:

A.

DAG

B.

RPC

C.

WFG

D.

DLC

Question 19

Which of the following are the status of CLOG records

Options:

A.

Committed

B.

Aborted

C.

Sub-Committed

D.

Inprogress

Question 20

Which of the following options is correct in the description of expansion and reduction

Options:

A.

Support DDL operations in user concurrent transaction blocks during capacity expansion

B.

User concurrent transaction blocks are not supported during expansion to create Temp tables.

C.

Physical clusters support scaling

D.

For logical cluster scaling, it can be performed with only one DN

Question 21

In the query set operation, the intersection is

Options:

A.

INTERSECT

B.

MINUS

C.

EXEPT

D.

UNION

Question 22

Benefits of Partitioning

Options:

A.

Improve query performance

B.

If one partition fails, other partition data is still available

C.

Can balance IO and map different partitions to different disks

Demo: 22 questions
Total 152 questions