New Year Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Free and Premium Huawei H13-922 Dumps Questions Answers

Page: 1 / 6
Total 152 questions

HCIP-GaussDB-OLAP V1.0 Questions and Answers

Question 1

(Multiple choice) GaussDB200 default user has permissions

Options:

A.

Login to the database

B.

Creating the database

C.

Creating users

Buy Now
Question 2

Which of the following is the overall installation process?

Options:

A.

Preparation before installation

B.

software installation and deployment

C.

Inspection after installation

D.

System configuration

Question 3

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 4

(Multiple choice) What input file formats does Migration Tool currently support?

Options:

A.

csv

B.

sql

C.

perl

D.

txt

Question 5

(Judgment) GaussDB 200 supports running on general-purpose servers, and only supports general-purpose servers based on x86_64 architecture.

Options:

A.

TRUE

B.

FALSE

Question 6

Whether the GTM and DN instance status of the instance active / standby switchover is normal.

Options:

A.

T

B.

F

Question 7

Which of the following is the use scenario of the tenant function?

Options:

A.

When the database system load is high, resources exist between tasks

B.

Some tasks have higher priorities, ensuring that higher priority tasks can obtain sufficient resources to complete the operation.

C.

When multiple users use the database, achieve resource isolation

D.

Isolation of computing and storage resources

Question 8

Can the query name execution process containing the numbers created by the following use cases be pushed down to the DN for execution?

Options:

A.

Yes

B.

No

C.

Not sure

Question 9

(Which of the following clauses is dedicated to the condition filtering function in GROUP BY operation

Options:

A.

WHERE clause

B.

HAVING clause

C.

LIMIT clause

D.

ORDER BY clause

Question 10

Which of the following is not a tenant parameter configuration item

Options:

A.

CPU quota

B.

CPU priority

C.

Memory

D.

Permanent table space

Question 11

(Multiple choice) Which of the following components can the Stream operator be executed on?

Options:

A.

CN

B.

GTM

C.

DN

D.

OM

Question 12

What other optimizations can be made to the audit function?

Options:

A.

Visualization (web graphics, reports)

B.

Security alarm

C.

Deep Security Analysis

D.

All of the above are correct

Question 13

Which of the TOAST data storage strategies allow compression?

Options:

A.

PLAIN (p)

B.

EXTENDED (x)

C.

EXTERNAL (e)

D.

MAIN (m)

Question 14

The column storage engine is more suitable for OLAP big data statistical analysis scenarios.

Options:

A.

T

B.

F

Question 15

Which of the following is the syntax for creating stored procedures in GaussDB 200?

Options:

A.

CREATE EXTENSION

B.

CREATE FUNCTION

C.

CREATE PROCEDURE

D.

CREATE SCHEMA

Question 16

The entire system network of GaussDB 200 is divided into planes?

Options:

A.

2

B.

3

C.

4

D.

5

Question 17

The promotion and distribution of CSN are managed in ()

Options:

A.

GTM

B.

CN

C.

DN

D.

CM_SERVER

Question 18

Restrictions on size reduction?

Options:

A.

The cluster is a logical cluster / elastic cluster

B.

Before performing the operation, you must confirm that the status of the large cluster is Normal and the distribution status is DN

C.

When the nodes included in the logical cluster to be reduced contain CMServer, GTM, and ETCD components, the logical cluster / elastic cluster cannot be reduced.

D.

When installing a cluster or installing the MPPDB service, if the ring information and the number of rings are customized, scaling down is not supported.

Question 19

Creating a database can specify compatible parameters

Options:

A.

Mysql

B.

Ora

C.

TD

D.

SQL Server

Question 20

(Which of the following is not a binary type

Options:

A.

BLOB

B.

RAW

C.

BYTEA

D.

TEXT

Question 21

A large enterprise will divide the batch operation into the logical cluster lc_1 and the real-time query service into the logical cluster lc_2

Divide sub-tenant t1_1 in lc_1 and bind to u1.

Divide sub-tenant t2_1 in lc_2 and bind to u3

Options:

A.

The table created by user u1 will be created in lc_1, and the table 3 created by user u3 will be created in c_2

B.

If user u1 needs to access lc_2's table, user u1 needs to be bound to a database object permission that can access lc_2

C.

User u1 can only operate on the table in lc_1, but cannot operate on the table in lc_2

D.

User u1 can operate on both the lc_1 table object and the lc_2 table

Question 22

The following statement about logical clusters is correct

Options:

A.

The same DN can belong to multiple logical clusters at the same time

B.

In the logical cluster mode, user-created tables can only be distributed on the nodes of a logical cluster

C.

Tables in the same database can belong to multiple logical clusters

D.

Under the logical cluster, grant ordinary table users the role of table creation permissions, then users can create tables under the logical cluster

E.

In a logical cluster, the same tenant can create multiple users. These users' job resources are limited by user resources.

Page: 1 / 6
Total 152 questions