Tanzu Greenplum v7 Technical Specialist (250-608) Free Practice Test

Question 1

What does the Greenplum Master host primarily manage?

A. User connections, query planning, and dispatching

B. Storage and memory allocation

C. Parallel processing of queries across segments

D. Execution of machine learning models

Correct Answer: A

Question 2

Greenplum uses the ___ library to support scalable, in-database machine learning for structured datasets.

A. pandas

B. sklearn

C. keras

D. MADlib

Correct Answer: D

Question 3

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

A. Slower query performance due to overhead

B. Faster lookups and improved query performance

C. Unpredictable data distribution

D. Increased chance of deadlocks

Correct Answer: B

Question 4

To load data into Greenplum from a directory served by gpfdist, the file path must start with the ___ protocol in the LOCATION clause.

A. http://

B. gpfdist://

C. postgres://

D. file://

Correct Answer: B

Question 5

Which two tasks can be performed using the gpstart utility?
(Choose two)

A. Start standby master if configured

B. Start only the master node

C. Start a specific user's session

D. Start the entire Greenplum cluster

Correct Answer: A,D

Question 6

Which two functions does GPText provide when working with unstructured data?
(Choose two)

A. Tokenization and text normalization

B. Database mirroring

C. Full-text search on document fields

D. Automated schema migration

Correct Answer: A,C

Question 7

In PostGIS, what is the typical data type used to store spatial shapes like points, lines, and polygons?

A. VARCHAR

B. GEOMETRY

C. BYTEA

D. XML

Correct Answer: B

Question 8

Which Greenplum features support workload balancing and query parallelism?
(Choose two)

A. Query optimizer

B. Interconnect fabric

C. Tuple movement

D. Segment mirroring

Correct Answer: A,B

Question 9

What are two key responsibilities of the gpinitsystem utility?
(Choose two)

A. Creating the data directories and segment layout

B. Initializing the Greenplum system configuration

C. Backing up user data before upgrade

D. Starting the Greenplum web interface

Correct Answer: A,B

Welcome to TestSimulate

Broadcom Tanzu Greenplum v7 Technical Specialist (250-608) Free Practice Test