合格させるPostgreSQL-Essentials試験一発合格保証100%カバー率でリアル試験問題 [2025年12月]
有効なPostgreSQL-Essentialsテスト解答EnterpriseDB PostgreSQL-Essentials試験PDF問題を試そう
EnterpriseDB PostgreSQL-Essentials 認定試験の出題範囲：
| トピック | 出題範囲 |
|---|---|
| トピック 1 |
|
| トピック 2 |
|
| トピック 3 |
|
| トピック 4 |
|
| トピック 5 |
|
質問 # 54
PostgreSQL supports SQL dump backup. You have configured a nightly backup of a database in plain SQL dump format. Due to database corruption, you need to restore your database using the SQL dump backup.
Which of the following commands can be used to restore a SQL dump?
- A. psql -f sqldumpfilename --all -d databasename -U username
- B. psql -f sqldumpfilename -quiet -d databasename -U username
- C. psql -f sqldumpfilename -1 -d databasename -U username
- D. psql -f sqldumpfilename --tuples -d databasename -U username
正解：C
質問 # 55
Which directory in the PostgreSQL data directory contains the Write-Ahead Log files?
- A. wal_files
- B. pg_xlog
- C. pg_log
- D. pg_wal
正解：D
質問 # 56
Which utility is used to take a backup of all databases in a PostgreSQL cluster including roles and tablespaces?
- A. pg_dumpall
- B. pg_clusterbackup
- C. pg_dump
- D. pg_backup
正解：A
質問 # 57
You need to take a backup of only the edbuser schema from the edbstore database. Which pg_dump option should you use?
- A. -n edbuser
- B. Both B and C
- C. --schema edbuser
- D. -s edbuser
正解：B
質問 # 58
You are connected to a PostgreSQL database. After executing a complex query an error message is displayed.
You want to edit and rerun the previously executed query. Which command can be used to edit the query buffer?
- A. e
- B. \l
- C. \e
- D. \r
正解：C
質問 # 59
You want to set the maximum time to complete client authentication to 10 seconds. Which parameter should you configure?
- A. client_timeout = 10s
- B. connection_timeout = 10s
- C. auth_timeout = 10s
- D. authentication_timeout = 10s
正解：D
質問 # 60
You are working as a Postgres DBA. Due to an increase in transactional load on your Postgres instance, the server is experiencing frequent checkpoints. You have decided to increase the WAL area size. You have also decided to upgrade your database instance to PostgreSQL 13. While initializing your database cluster in PostgreSQL 13, you have decided to increase the WAL segment size. Which of the following options can be used with the initdb command to set a custom WAL segment size?
- A. --waldir
- B. -x
- C. --wal-segsize
- D. No such option is available in PostgreSQL
正解：C
質問 # 61
Which PostgreSQL configuration parameter controls the amount of memory used for sorting operations before writing to temporary disk files?
- A. temp_buffers
- B. work_mem
- C. maintenance_work_mem
- D. shared_buffers
正解：B
質問 # 62
In PostgreSQL, archiving can be enabled for hot backups. During recovery, all the archive logs can be played on the restored backup and Point-in-Time Recovery can be performed. Which of the following parameters directly influences Mean Time to Recovery and is also used to control the size of the WAL area?
- A. wal_level
- B. wal_size
- C. checkpoint_timeout
- D. max_wal_size
正解：D
質問 # 63
Which pg_dump option creates a backup that can be restored using pg_restore?
- A. -Ft (tar format)
- B. -Fc (custom format)
- C. Both B and C
- D. -Fp (plain text format)
正解：C
質問 # 64
Which parameter sets the number of autovacuum worker processes?
- A. autovacuum_workers
- B. max_autovacuum_workers
- C. autovacuum_max_workers
- D. vacuum_workers
正解：C
質問 # 65
You need to restore a database from a compressed format backup file created with pg_dump -Fc option.
Which utility should you use?
- A. psql
- B. pg_basebackup
- C. pg_dump
- D. pg_restore
正解：D
質問 # 66
Which parameter controls the amount of memory allocated for maintenance operations like VACUUM and CREATE INDEX?
- A. work_mem
- B. maintenance_work_mem
- C. vacuum_mem
- D. temp_buffers
正解：B
質問 # 67
In PostgreSQL, which view provides information about currently running queries?
- A. pg_current_queries
- B. pg_active_sessions
- C. pg_running_queries
- D. pg_stat_activity
正解：D
質問 # 68
Which PostgreSQL backup utility can create backups in custom compressed format?
- A. psql
- B. pg_dump with -Fc option
- C. pg_basebackup
- D. pg_restore
正解：B
質問 # 69
You need to reload the PostgreSQL configuration without restarting the server. Which function should you use?
- A. reload_configuration()
- B. pg_restart_conf()
- C. pg_reload_conf()
- D. refresh_config()
正解：C
質問 # 70
Which of the following options can be used to view a Query Plan in pgAdmin4?
- A. Right Click on the database and Click View Query Plan
- B. Open Query Tool, Copy/Paste the query and press F7
- C. Open Query Tool, Copy/Paste the query and Click Debug Plan button
- D. Right Click on the database and Click Explain button
正解：B
質問 # 71
In PostgreSQL, what does VACUUM do?
- A. Compresses the database
- B. Creates database backups
- C. Optimizes query execution plans
- D. Reclaims storage occupied by dead tuples
正解：D
質問 # 72
Which command rebuilds an index that is performing slowly for better performance?
- A. REBUILD INDEX indexname;
- B. VACUUM INDEX indexname;
- C. REINDEX INDEX indexname;
- D. ANALYZE INDEX indexname;
正解：C
質問 # 73
......
PostgreSQL-Essentials試験問題にて有効なPostgreSQL-Essentials問題集PDF：https://www.passtest.jp/EnterpriseDB/PostgreSQL-Essentials-shiken.html
検証済みPostgreSQL-Essentials問題集と解答で合格保証：https://drive.google.com/open?id=10FRpXcPb1Uf4gwU36zRE63TizjPfXL3r