Practice Free 250-608 Exam Online Questions
What are two key responsibilities of the gpinitsystem utility? (Choose two)
- A . Initializing the Greenplum system configuration
- B . Creating the data directories and segment layout
- C . Backing up user data before upgrade
- D . Starting the Greenplum web interface
What are two advantages of using hexagonal grids (H3) over square grids in spatial analysis? (Choose two)
- A . Equal distance to adjacent cells
- B . More accurate rendering in PostGIS maps
- C . Lower spatial distortion at poles
- D . Automatic color scaling for layers
Which utility is responsible for performing a full or incremental segment recovery?
- A . gprecoverseg
- B . gpsegment
- C . gpstop
- D . gpinitstandby
What are two primary benefits of Greenplum’s shared-nothing architecture? (Choose two)
- A . High performance scalability
- B . Simplified machine learning deployment
- C . Fault isolation between nodes
- D . Direct memory access sharing
In GPCC, the ___ tab displays a visual breakdown of query activity, including time spent in planning, execution, and data movement.
- A . Admin
- B . Workload
- C . Query Monitor
- D . System Status
Greenplum uses ___ operations such as Broadcast and Redistribute to move data between segments when needed.
- A . motion
- B . join
- C . spill
- D . fault
Which two file protocols can be used in the LOCATION clause of an external table in Greenplum? (Choose two)
- A . Gpfdist
- B . ftp
- C . http
- D . file
The ___ utility in Greenplum allows administrators to recover a failed primary segment using its corresponding mirror.
- A . gptransfer
- B . gpload
- C . gprecoverseg
- D . gpsegment
What is the primary purpose of segment mirroring in Greenplum?
- A . To improve query performance
- B . To replicate data between clusters
- C . To provide fault tolerance for segment node failures
- D . To enable external table backups
Which two data operations are supported by GPText’s JSON-based document format? (Choose two)
- A . Field-specific text searches
- B . Binary-to-ASCII conversion
- C . Faceted navigation and filtering
- D . Automatic CSV field alignment