Exam4Training

Huawei H13-922-ENU HCIP-GaussDB-OLAP V1.0 Online Training

Question #1

Create Database Suggestions

  • A . Object name does not exceed 64 bytes
  • B . Use UTF-8 as the database default encoding set
  • C . Don’t use multiple characters for object names

Reveal Solution Hide Solution

Correct Answer: B C
Question #2

FULL JOIN and CROSS JOIN results are equivalent

  • A . TRUE
  • B . FALSE

Reveal Solution Hide Solution

Correct Answer: B
Question #3

Are the following execution methods of Stream operator?

  • A . Sorted
  • B . Broadcast
  • C . Gather
  • D . Hashed

Reveal Solution Hide Solution

Correct Answer: B C
Question #4

Which of the following options is not the process of expanding the physical cluster to the logical cluster?

  • A . Node preprocessing
  • B . Data redistribution
  • C . Add nodes to the elastic cluster
  • D . Capacity verification

Reveal Solution Hide Solution

Correct Answer: C
Question #5

Which two steps are involved in a two-phase transaction submission

  • A . Transaction verification phase
  • B . Transaction pre-commit phase
  • C . Transaction back stage
  • D . Global commit phase

Reveal Solution Hide Solution

Correct Answer: B D
Question #6

When using the Migration Tool under Linux to migrate, entering the file permission setting process will cause the process to be terminated due to security issues

  • A . T
  • B . F

Reveal Solution Hide Solution

Correct Answer: A
Question #7

Which of the following modules guarantees high availability through active-standby replication?

  • A . CN
  • B . DN
  • C . GTM
  • D . CM Server

Reveal Solution Hide Solution

Correct Answer: B
Question #8

When the cluster status is Degraded: The cluster is available, but the data is not redundantly backed up. The DN master has one and only one exits abnormally. The GTM has only one host and the highest available mode. The CN has and only partially exits abnormally.

  • A . True
  • B . False

Reveal Solution Hide Solution

Correct Answer: A
Question #9

Which part of the overall installation process does the "planning data" belong to?

  • A . Preparation before installation
  • B . Software installation and deployment
  • C . Inspection after installation
  • D . System configuration

Reveal Solution Hide Solution

Correct Answer: A
Question #10

What other optimizations can be made to the audit function?

  • A . Visualization (web graphics, reports)
  • B . Security alarm
  • C . Deep Security Analysis
  • D . All of the above are correct

Reveal Solution Hide Solution

Correct Answer: A B C

Question #11

Are the following data distributed that do not belong to GaussDB200 OLAP?

  • A . Hash
  • B . Replication
  • C . Partition
  • D . Sort

Reveal Solution Hide Solution

Correct Answer: C D
Question #12

Any user can create table spaces.

  • A . True
  • B . False

Reveal Solution Hide Solution

Correct Answer: B
Question #13

(Which of the following Hints cannot specify the result set of table t1 as 5 rows?

  • A . /* + row (t1% 5) * /
  • B . /* + rows (t1 # 5) * /
  • C . /* + rows (t1 # 5 t1)
  • D . /* + rows (t1 t2 *) * /

Reveal Solution Hide Solution

Correct Answer: A C D
Question #14

The following values can be expressed as Boolean "true"

  • A . TRUE
  • B . "t"
  • C . "true"
  • D . "y"

Reveal Solution Hide Solution

Correct Answer: A B C D
Question #15

What are the types of redistribution

  • A . Slow redistribution
  • B . Fast read-only redistribution
  • C . Fast online redistribution
  • D . Slow online redistribution

Reveal Solution Hide Solution

Correct Answer: A B C
Question #16

(Multiple choices) Which databases does GaussDB 200 database system initially include?

  • A . template1
  • B . postgres
  • C . GaussDB 200
  • D . template0

Reveal Solution Hide Solution

Correct Answer: A B D
Question #17

The main function of the execution engine is to parse the SQL query entered by the user. Generate execution plan

  • A . TRUE
  • B . FALSE

Reveal Solution Hide Solution

Correct Answer: B
Question #18

What kind of logs can be used for recovery in the event of a system crash

  • A . System Log
  • B . Performance Log
  • C . pg_xlog
  • D . pg_clog

Reveal Solution Hide Solution

Correct Answer: C
Question #19

What types of execution engines are included?

  • A . Line execution engine
  • B . Vectorized execution engine
  • C . Row and column hybrid execution engine
  • D . None of the above

Reveal Solution Hide Solution

Correct Answer: A B C
Question #20

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

  • A . DN
  • B . GTM
  • C . CM
  • D . CN

Reveal Solution Hide Solution

Correct Answer: D

Question #21

In the logical cluster mode, if a user needs to perform SQL operations across a logical cluster, the system can be configured to reserve resources for the purpose of resource control.

  • A . T
  • B . F

Reveal Solution Hide Solution

Correct Answer: A
Question #22

Which of the following are important statistics for the execution of the statement

  • A . Number of tuples in the table
  • B . Field width
  • C . NULL record ratio
  • D . ISTINCT value
  • E . MCV value (Most common value)
  • F . HB value

Reveal Solution Hide Solution

Correct Answer: A B C D E F
Question #23

What are the technical characteristics of GuassDB 200 database products?

  • A . Low cost
  • B . High performance
  • C . High reliability
  • D . Support massive data

Reveal Solution Hide Solution

Correct Answer: A B C D
Question #24

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

  • A . WHERE clause
  • B . HAVING clause
  • C . LIMIT clause
  • D . ORDER BY clause

Reveal Solution Hide Solution

Correct Answer: B
Question #25

Table space that can be viewed when the view is modified

  • A . TRUE
  • B . FALSE

Reveal Solution Hide Solution

Correct Answer: B
Question #26

What are the implementation strategies of the Agg operator?

  • A . 4
  • B . 3
  • C . 2
  • D . 1

Reveal Solution Hide Solution

Correct Answer: B
Question #27

The lock mode used by the insert transaction is

  • A . AccessShareLock
  • B . RowExclusiveLock
  • C . ShareUpdateExlusiveLock
  • D . ExclusiveLock

Reveal Solution Hide Solution

Correct Answer: B
Question #28

Which of the following is the GaussDB200 database instance type?

  • A . CN
  • B . DN
  • C . WLM
  • D . GTM

Reveal Solution Hide Solution

Correct Answer: A B C D
Question #29

DBMD_JOB is mainly used to handle large object types

  • A . TRUE
  • B . FALSE

Reveal Solution Hide Solution

Correct Answer: B
Question #30

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

  • 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

Reveal Solution Hide Solution

Correct Answer: B
Exit mobile version