QUESTION 46
In what two situations would the Greenplum optimizer choose a broadcast motion during a join?
(Choose two)

QUESTION 47
What is the impact of using indexes on frequently filtered columns in Greenplum?

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

QUESTION 49
When working with GPText, what is a “collection”?

QUESTION 50
Which Greenplum component provides distributed full-text search and indexing capabilities?

QUESTION 51
Greenplum’s ___ utility checks disk, memory, and network performance between hosts, aiding in system validation before expansion.

QUESTION 52
In Greenplum, the ___ SQL clause is typically used to filter test data after training a model with MADlib.

QUESTION 53
What is the function of gpfdist in the Greenplum data loading process?

QUESTION 54
Which two statements are true regarding the ST_DWithin function in PostGIS?
(Choose two)

QUESTION 55
In the context of Greenplum’s segment nodes, which two statements are true?
(Choose two)

QUESTION 56
A data architect is designing a Greenplum database for an e-commerce company handling large datasets with frequent joins on customer_id. To optimize performance and ensure even data distribution across segments, what should the architect do?

QUESTION 57
Which two configuration steps are required to use GPCC in a secured production environment?
(Choose two)

QUESTION 58
When creating an external table, which clause is essential for defining the data source location?

QUESTION 59
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?

QUESTION 60
How does the ST_Within function behave in a spatial query?

QUESTION 61
What are two key differences between gpbackup and pg_dump when used in Greenplum?
(Choose two)

QUESTION 62
Which statement is true about using gpload for loading data into Greenplum?