최신 ValueOps 250-608 무료샘플문제:

1. You are asked to load a 10GB CSV file into Greenplum in the shortest possible time. You want to leverage Greenplum's parallelism and avoid unnecessary file duplication. What should you do?

A) Load the file into a replicated table using INSERT INTO
B) Use psql with COPY and load the entire file on the master node
C) Create an external readable table pointing to the CSV file and query it directly
D) Transfer the file to all segments manually and use gpload in non-parallel mode

2. When using gptext_insert, which two options are typically required for document ingestion?
(Choose two)

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

3. The ___ utility is used to safely shut down the entire Greenplum Database cluster.
Response:

A) gpclose
B) gpstop
C) gpkill
D) gpdown

4. How does Greenplum ensure high availability of its master node?

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

5. What is the role of segments in Greenplum?

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

질문과 대답: