Practice Free 250-608 Exam Online Questions
Which two formats are valid output types for MADlib prediction functions? (Choose two)
- A . Probability values
- B . JSON-formatted model binaries
- C . Predicted labels
- D . PNG charts
Which extension must be enabled in Greenplum to use spatial functions such as ST_Distance or ST_Intersects?
- A . MADlib
- B . PostGIS
- C . PL/R
- D . HDFS
Which two functions does GPText provide when working with unstructured data? (Choose two)
- A . Tokenization and text normalization
- B . Automated schema migration
- C . Full-text search on document fields
- D . Database mirroring
In the context of Greenplum’s segment nodes, which two statements are true? (Choose two)
- A . Each segment runs its own PostgreSQL instance
- B . Segments share disk with other segments
- C . Segments execute parts of the query independently
- D . Segments cannot store replicated data
What type of data format is typically required for inserting text documents into GPText collections?
- A . CSV
- B . JSON
- C . Binary HEX
- D . Avro
Which function would you use to apply a trained MADlib model for prediction in Greenplum?
- A . madlib.predict()
- B . madlib.apply_model()
- C . madlib.logregr_predict()
- D . madlib_score()
In Greenplum, the ___ clause can significantly reduce the volume of data returned, thus improving performance in exploratory queries.
- A . GROUP BY
- B . ANALYZE
- C . LIMIT
- D . HAVING
Which two objects are required to create a basic table in Greenplum? (Choose two)
- A . Schema
- B . User role
- C . Tablespace
- D . Column definitions
Which utility in Greenplum is most commonly used for parallel data loading from external files?
- A . gpload
- B . gpfdist
- C . gptransfer
- D . gpbackup
Which two types of external tables are supported in Greenplum? (Choose two)
- A . Logical table
- B . Writable external table
- C . Readable external table
- D . Distributed mirror table