Broadcom 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

答えを確認する

正解: