250-608 Exam Training Practice Tests (Broadcom Tanzu Greenplum v7 Technical Specialist)]

Question 1

The PostGIS function ___ is used to return the geometric centroid of a polygon.

A. ST_Centroid B. ST_Center C. ST_Pivot D. ST_Midpoint

Correct Answer: A

Question 2

The ___ utility is used to safely shut down the entire Greenplum Database cluster.
Response:

A. gpdown B. gpstop C. gpkill D. gpclose

Correct Answer: B

Question 3

What are two advantages of using GPCC over command-line monitoring tools?
(Choose two)

A. Centralized visualization of cluster activity B. Higher privileges for OS-level configuration C. Real-time query tracking and cancellation D. Ability to write raw SQL directly to disk

Correct Answer: A,C

Question 4

How can VACUUM ANALYZE help improve query performance in Greenplum?

A. By compressing indexes for faster access B. By removing all user data C. By converting heap tables to append-only tables D. By updating table statistics used by the optimizer

Correct Answer: D

Question 5

Which feature in Greenplum enables recovery from a master node failure?

A. Segment replication B. Standby master C. Segment mirroring D. Distributed checkpointing

Correct Answer: B

Question 6

Which two geometry types are commonly used in PostGIS for spatial queries?
(Choose two)

A. POINT B. CIRCLE C. ARRAY D. LINESTRING

Correct Answer: A,D

Question 7

What is the default behavior of Greenplum when a segment mirror is down but the primary is still available?

A. The database shuts down to protect data integrity B. The system automatically fails over to the standby C. The system continues running in a degraded mode D. Queries are blocked until the mirror is recovered

Correct Answer: C

Question 8

Which two query characteristics can lead to inefficient execution plans in Greenplum?
(Choose two)

A. Using partitioned tables with filters B. Joins between non-co-located tables C. Queries using WHERE clause on indexed columns D. Large result sets with no LIMIT clause

Correct Answer: B,D

Broadcom Tanzu Greenplum v7 Technical Specialist - 250-608 Exam Practice Test