Broadcom Tanzu Greenplum v7 Technical Specialist

QUESTION NO: 1
Which two query characteristics can lead to inefficient execution plans in Greenplum?
(Choose two)

A. Large result sets with no LIMIT clause B. Queries using WHERE clause on indexed columns C. Joins between non-co-located tables D. Using partitioned tables with filters

Correct Answer: A,C

QUESTION NO: 2
Which open-source framework is integrated into Greenplum to support in-database machine learning?

A. PyTorch B. Apache Spark C. TensorFlow D. MADlib

Correct Answer: D

QUESTION NO: 3
What are two advantages of using GPCC over command-line monitoring tools?
(Choose two)

A. Centralized visualization of cluster activity B. Ability to write raw SQL directly to disk C. Real-time query tracking and cancellation D. Higher privileges for OS-level configuration

Correct Answer: A,C

QUESTION NO: 4
What are two key advantages of using writable external tables in Greenplum?
(Choose two)

A. Supports pushing updates to replicated tables B. Enables real-time backups of running queries C. Allows exporting query results to flat files D. Facilitates integration with downstream data pipelines

Correct Answer: C,D

QUESTION NO: 5
A data scientist at a media firm needs to analyze thousands of social media posts for keywords related to public sentiment. The documents are ingested into a GPText collection named social_streams.
Which solution enables the fastest search for posts containing the keyword "privacy"?

A. Use SELECT * FROM social_streams WHERE text LIKE '%privacy%' B. Create a stored procedure that loops through each row manually C. Export the data to Apache Kafka and process it using Flink D. Use gptext_search('social_streams', 'text:privacy') to query indexed content

Correct Answer: D

QUESTION NO: 6
In Greenplum, which of the following is true about a schema?

A. It refers to a complete physical database B. It manages user session variables C. It is used to distribute data across segments D. It organizes database objects logically within a database

Correct Answer: D

QUESTION NO: 7
When using gptext_insert, which two options are typically required for document ingestion?
(Choose two)

A. Collection name B. External trigger script C. Document ID (unique) D. Database firewall exception

Correct Answer: A,C

Broadcom Tanzu Greenplum v7 Technical Specialist - 250-608 Exam Questions