Online Access Free 250-608 Exam Questions

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

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

What happens if an external table in Greenplum references an incorrect data format definition?

• A.The query auto-corrects the format
• B.The query fails with a data format error
• C.The table gets converted to an internal table
• D.Greenplum falls back to using default formatting

What access method is used to launch GPCC in a browser?

• A.REST API via command-line
• B.SSH session to master node
• C.HTTP/HTTPS to the GPCC server URL
• D.Serial console access to the host

Which utility in Greenplum is most commonly used for parallel data loading from external files?

• A.gptransfer
• B.gpfdist
• C.gpbackup
• D.gpload

How can VACUUM ANALYZE help improve query performance in Greenplum?

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