Try Free HCIP-GaussDB-OLAP V1.0 H13-922-ENU Dumps

test2022-05-07T06:05:31+00:00

By test H13-922-ENU Dumps, HCIP-GaussDB-OLAP V1.0 0 Comments

You may have read the great H13-922-ENU dumps for your HCIP-GaussDB-OLAP V1.0 exam. It must be clear that the H13-922-ENU dumps have been updated with accurate dumps questions and answers for good preparation. The most updated H13-922-ENU dumps contain 152 practice questions and answers, you can practice them again and again to make sure that you can learn HCIP-GaussDB-OLAP V1.0 exam well and pass H13-922-ENU exam successfully.

Now is a great time to take a free practice test to see how well you know yourself!

Page 1 of 4

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

WHERE clause

HAVING clause

LIMIT clause

ORDER BY clause

2. CREATE TABLE AS to create a table, you need to add the query type

INSERT

UPDATE

SELECT

DELETE

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

GTM

CM Server

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

Modify the file name in the data directory. Authority

Delete database system tables

Modify the node host name

Manually modify the port number directly in the configuration file

5. Which of the following advantages does a partitioned table have over an ordinary table?

Improve query performance; queries on partitioned objects can search only the partitions that they care about to improve retrieval efficiency.

Enhance availability; if one partition of a partitioned table fails, the table data is still available in other partitions.

Easy maintenance; if a partition of the partition table fails. Need to repair the data, just repair the partition.

Balance I / O; you can map different partitions to different disks to balance I / O and improve the overall system performance.

6. The following statement about logical clusters is correct

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

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

Tables in the same database can belong to multiple logical clusters

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

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

7. What are the types of redistribution

Slow redistribution

Fast read-only redistribution

Fast online redistribution

Slow online redistribution

8. Does the distributed forest execution framework use a Producer-Consumer model?

TRUE

FALSE

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

Preparation before installation

Software installation and deployment

Inspection after installation

System configuration

10. Which of the following types of indexes only supports equivalence queries?

Btree index

Hsah Index

Gin index

Gist index

Page 2 of 4

11. Which of the following are typical deployment scenarios for logical clusters?

A deploys the data that needs to be queried in a logical cluster

B. Deploy a logical cluster of data to be queried in real time

C. Logical clusters that require resources for business

D. Deploy frequently updated data in a logical cluster

12. What are the ACID characteristics of transaction

Atomic

Consistency

Isolation

Persistence

13. To cascade delete database objects such as user-created tables, use the key word

STRICT

CASCADE

USAGE

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

Yes

Not sure

15. (Judgment) Window functions are used with the OVER statement. The OVER statement is used to group data and sort elements in the group; window functions are used to generate sequence numbers for the values in the group.

TRUE

FALSE

16. Benefits of Partitioning

Improve query performance

If one partition fails, other partition data is still available

Can balance IO and map different partitions to different disks

17. When the host group is backed up, the main line and column files are backed up, and the log files may not be backed up

True

False

18. (Multiple choices). The following description about the selection of the distribution column is correct?

Normally, the primary key of the table is selected as the distribution column.

Columns with fewer values are suitable as distribution columns, which can ensure that the data distribution is relatively concentrated.

The filter condition of the query is name = 'wang five', so the name column should be used as the distribution column.

Join conditions in queries are more suitable as distribution columns.

19. Which of the following is part of the Manager?

Active and standby OMS nodes

Multiple Agent Nodes

DataNode

CN node

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

System Log

Performance Log

pg_xlog

pg_clog

Page 3 of 4

21. Plan Hint will directly affect the generation of the execution plan, so errors in Hint will also affect the execution of the statement

22. The lock mode used by the insert transaction is

AccessShareLock

RowExclusiveLock

ShareUpdateExlusiveLock

ExclusiveLock

23. In the query set operation, the intersection is

INTERSECT

MINUS

EXEPT

UNION

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

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

GTM

26. What is the correct statement about resource quota among tenants?

After "CPU Quota" is set. The system will allocate CPU execution time to the current tenant in proportion to the "CPU quota"

After the CPU quota parameter is set, the system will assign an exclusive number of CPU cores to the current tenant according to the "CPU quota" ratio. Other tenants can use it flexibly when the load is high

"CPU quota" and "CPU quota" can take effect at the same time

The storage space size of the tenant persistent data table space corresponds to an actual physical storage space size, which is specified by the parent tenant. The total storage used by all child tenants cannot exceed the total storage specified by the parent tenant

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

Transaction verification phase

Transaction pre-commit phase

Transaction back stage

Global commit phase

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

Number of tuples in the table

Field width

NULL record ratio

ISTINCT value

MCV value (Most common value)

HB value

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

template1

postgres

GaussDB 200

template0

30. Does GuassDB 200 upgrade support online upgrade?

True

False

Page 4 of 4

31. Which of the following compilation parameters are needed when compiling a dynamic library using C language numbers?

-fpic

-shared

-static

-wall

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

/* + row (t1% 5) * /

/* + rows (t1 # 5) * /

/* + rows (t1 # 5 t1)

/* + rows (t1 t2 *) * /

33. (Which of the following is not a binary type

BLOB

RAW

BYTEA

TEXT

34. What are the technical characteristics of GuassDB 200 database products?

Low cost

High performance

High reliability

Support massive data

35. The cluster status check description is correct

Normal: The cluster is available and the data is redundantly backed up. All processes are running and the master-backup relationship is normal

Degraded: The cluster is available, but the data is not redundantly backed up. DN master and slave have exited with only one exception, GTM has and only the highest available mode of the host, CNE has and only partially exited with exception

Unavailable: The cluster is unavailable. Two or more DN master and slaves exit abnormally, GTM master and slave all exit abnormally, all CNs exit abnormally

Unknow: The cluster status is unknown

36. Which of the following is not a tenant parameter configuration item

CPU quota

CPU priority

Memory

Permanent table space

37. What types of execution engines are included?

Line execution engine

Vectorized execution engine

Row and column hybrid execution engine

All of the above

38. SSL technology can prevent man-in-the-middle attacks and network monitoring.

Try Free HCIP-GaussDB-OLAP V1.0 H13-922-ENU Dumps

Try Free HCIP-GaussDB-OLAP V1.0 H13-922-ENU Dumps

Share this post

Author

Leave a Reply Cancel reply

Related Posts