919 お客様のコメント
質問 1：
How does Greenplum handle parallelism during ML model training using MADlib?
A. It runs models sequentially on the master node
B. It uses hash joins to improve accuracy
C. It distributes training data across segments
D. It offloads training to a single segment for consistency
正解：C
質問 2：
Which two types of objects can be stored within a schema in Greenplum?
(Choose two)
A. Master nodes
B. Segments
C. Indexes
D. Views
正解：C,D
質問 3：
The Greenplum Command Center relies on ___ to collect performance metrics and feed the UI with system statistics.
A. gptext
B. gpfdist
C. gprecoverseg
D. gpperfmon
正解：D
質問 4：
Which two query characteristics can lead to inefficient execution plans in Greenplum?
(Choose two)
A. Using partitioned tables with filters
B. Queries using WHERE clause on indexed columns
C. Large result sets with no LIMIT clause
D. Joins between non-co-located tables
正解：C,D
質問 5：
Which two geometry types are commonly used in PostGIS for spatial queries?
(Choose two)
A. POINT
B. CIRCLE
C. LINESTRING
D. ARRAY
正解：A,C
質問 6：
What is the primary purpose of Redistribute Motion node in a Greenplum query plan?
A. To manage container orchestration
B. To send tuples to a particular segment based on the hash value of the defined distribution column
C. To broadcast the tuples from each segment to all other segment
D. To gather tuples from the segments to the coordinator node
正解：B
How does Greenplum handle parallelism during ML model training using MADlib?
A. It runs models sequentially on the master node
B. It uses hash joins to improve accuracy
C. It distributes training data across segments
D. It offloads training to a single segment for consistency
正解：C
質問 2：
Which two types of objects can be stored within a schema in Greenplum?
(Choose two)
A. Master nodes
B. Segments
C. Indexes
D. Views
正解：C,D
質問 3：
The Greenplum Command Center relies on ___ to collect performance metrics and feed the UI with system statistics.
A. gptext
B. gpfdist
C. gprecoverseg
D. gpperfmon
正解：D
質問 4：
Which two query characteristics can lead to inefficient execution plans in Greenplum?
(Choose two)
A. Using partitioned tables with filters
B. Queries using WHERE clause on indexed columns
C. Large result sets with no LIMIT clause
D. Joins between non-co-located tables
正解：C,D
質問 5：
Which two geometry types are commonly used in PostGIS for spatial queries?
(Choose two)
A. POINT
B. CIRCLE
C. LINESTRING
D. ARRAY
正解：A,C
質問 6：
What is the primary purpose of Redistribute Motion node in a Greenplum query plan?
A. To manage container orchestration
B. To send tuples to a particular segment based on the hash value of the defined distribution column
C. To broadcast the tuples from each segment to all other segment
D. To gather tuples from the segments to the coordinator node
正解：B
Obata -
250-608とても見やすく内容もわかりやすい
効率的にまとまっている250-608参考書だと思います。