250-608 実際試験問題と解答 - 模擬練習 - 受験自信を増やす

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

A.VARCHAR
B.BYTEA
C.GEOMETRY
D.XML

正解:

Question No : 2
Which of the following algorithms is available in the MADlib library?

A.Convolutional Neural Network (CNN)
B.Logistic Regression
C.Long Short-Term Memory (LSTM)
D.YOLOv3

正解:

Question No : 3
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

正解:

Question No : 4
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

正解:

Question No : 5
When performing segment recovery using gprecoverseg, which two modes are available? (Choose two)

A.Offline full recovery
B.Online incremental recovery
C.Logical standby recovery
D.Master-only recovery

正解:

Question No : 6
What are two key differences between gpbackup and pg_dump when used in Greenplum? (Choose two)

A.gpbackup supports multi-segment parallelism
B.pg_dump is exclusive to append-only tables
C.gpbackup supports incremental backups natively
D.gpbackup is optimized for Greenplum’s distributed architecture

正解:

Question No : 7
Which two tasks can be performed using the gpstart utility? (Choose two)

A.Start only the master node
B.Start the entire Greenplum cluster
C.Start a specific user’s session
D.Start standby master if configured

正解:

Question No : 8
Which user interface component of GPCC allows visualization of disk I/O, memory, and CPU usage across the cluster?

A.Query Editor
B.Resource Metrics Dashboard
C.Backup Control Panel
D.Security Audit Log

正解:

Question No : 9
What is the function of gpfdist in the Greenplum data loading process?

A.It transfers tables between databases
B.It is a Python library for in-database analytics
C.It acts as a lightweight data server to stream external files to segments
D.It backs up files before loading

正解:

Question No : 10
What are two characteristics of hash-distributed tables in Greenplum that enhance query performance? (Choose two)

A.Supports automatic compression
B.Enables co-location of related rows
C.Reduces segment-level locking
D.Evenly distributes data across segments

正解:

Question No : 11
What is the role of segments in Greenplum?

A.They manage user authentication and permissions
B.They act as backup nodes for data recovery
C.They store portions of the data and execute parts of a query in parallel
D.They handle UI rendering and reporting

正解:

Question No : 12
Which two GPText administrative actions require using the gptext-control utility? (Choose two)

A.Restarting the Solr engine
B.Monitoring collection query usage
C.Deploying Solr config sets
D.Purging index cache from disk

正解:

Question No : 13
Which Greenplum component is primarily responsible for generating an efficient execution plan based on query cost?

A.Master Scheduler
B.Query Optimizer
C.Segment Dispatcher
D.Resource Queue Manager

正解:

Question No : 14
How does Greenplum ensure high availability of its master node?

A.By replicating data across all segment nodes
B.By automatically restarting failed services
C.Through the use of a standby master node
D.Through a distributed file system

正解:

Question No : 15
Which two Greenplum utilities are most commonly used during a host failure recovery scenario? (Choose two)

A.gpload
B.gprecoverseg
C.gpinitstandby
D.gpstop

正解:

Broadcom 250-608 問題練習