Free VMware 250-608 Exam Dumps Questions & Answers

Which two metrics are commonly visualized in GPCC to evaluate cluster performance?
(Choose two)

• A.Query execution time
• B.Network broadcast domains
• C.CPU utilization
• D.Number of PostgreSQL extensions

Which two statements about Greenplum table partitioning are true?
(Choose two)

• A.Partitions are automatically replicated across all segments
• B.You can define subpartitions within a partition
• C.Partitioned tables cannot be analyzed using EXPLAIN
• D.Partitioning allows the database to prune unnecessary data during queries

How does Greenplum ensure high availability of its master node?

• A.By replicating data across all segment nodes
• B.Through the use of a standby master node
• C.Through a distributed file system
• D.By automatically restarting failed services

How does Greenplum ensure data consistency during backups?

• A.By using transaction snapshots
• B.By locking all user tables
• C.By creating immediate binary copies of each segment
• D.By replicating data to external storage

You are asked to load a 10GB CSV file into Greenplum in the shortest possible time. You want to leverage Greenplum's parallelism and avoid unnecessary file duplication. What should you do?

• A.Transfer the file to all segments manually and use gpload in non-parallel mode
• B.Use psql with COPY and load the entire file on the master node
• C.Load the file into a replicated table using INSERT INTO
• D.Create an external readable table pointing to the CSV file and query it directly