H13-922-ENU exam

Which of the following is the GaussDB200 database instance type?A . CNB . DNC . WLMD . GTMView AnswerAnswer: A B C D

Are the following data distributed that do not belong to GaussDB200 OLAP?A . HashB . ReplicationC . PartitionD . SortView AnswerAnswer: C D

Which of the following options is correct in the description of expansion and reductionA . Support DDL operations in user concurrent transaction blocks during capacity expansionB . User concurrent transaction blocks are not supported during expansion to create Temp tables.C . Physical clusters support scalingD . For logical cluster scaling,...

(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 *) * /View...

Any user can create table spaces.A . TrueB . FalseView AnswerAnswer: B

What types of execution engines are included?A . Line execution engineB . Vectorized execution engineC . Row and column hybrid execution engineD . None of the aboveView AnswerAnswer: A B C

Which of the following options is not the process of expanding the physical cluster to the logical cluster?A . Node preprocessingB . Data redistributionC . Add nodes to the elastic clusterD . Capacity verificationView AnswerAnswer: C

Which of the following are important statistics for the execution of the statementA . Number of tuples in the tableB . Field widthC . NULL record ratioD . ISTINCT valueE . MCV value (Most common value)F . HB valueView AnswerAnswer: A B C D E F

FULL JOIN and CROSS JOIN results are equivalentA . TRUEB . FALSEView AnswerAnswer: B

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 . TB . FView AnswerAnswer: A