Online Access Free 250-608 Exam Questions

Which two operations are supported by the Greenplum utility gpbackup?
(Choose two)

• A.Backup compression
• B.Cluster mirroring
• C.Segment failover
• D.Table-level selective backup

How can GPCC assist in identifying problematic queries?

• A.By highlighting queries with high resource usage in real time
• B.By automatically terminating all long-running queries
• C.By removing queries from system logs
• D.By exporting query results to external CSV files

What is the purpose of the gpinitstandby utility in Greenplum?

• A.Sets up a standby segment node
• B.Initializes a standby master host
• C.Initializes WAL archiving
• D.Reassigns segment IDs

A geospatial analyst is building a query in Greenplum to identify all stores within a 5 km radius of each customer location. The coordinates are stored as geometry points.
Which PostGIS function should they use in the WHERE clause?

• A.ST_Buffer(store_geom, 5) = customer_geom
• B.ST_Contains(customer_geom, store_geom)
• C.ST_DWithin(customer_geom, store_geom, 5000)
• D.ST_Area(store_geom) < 5000

The ___ utility in Greenplum allows administrators to recover a failed primary segment using its corresponding mirror.

• A.gptransfer
• B.gpsegment
• C.gpload
• D.gprecoverseg