A company is provisioning a new PostgreSQL database for a customer relationship management (CRM) system. The database will store sensitive customer data and must be encrypted at rest. The DBA is using the cloud provider's managed PostgreSQL service. Which provisioning step is necessary to meet the encryption requirement?

Configure the database to use SSL for client connections.

Set the data_checksums parameter to on.

Enable encryption at rest using the provider's key management service.

Install a third-party encryption plugin on the database server.

Which of the following is a key consideration when installing a DBMS on a Windows server?

The DBMS must be installed on the C: drive only

The installation requires a graphical user interface (GUI) to complete

The DBMS must be installed on a domain controller

The installation must be run with administrative privileges

A company is deploying a new MySQL database on a Linux server for a line-of-business application. The application requires the database to use the InnoDB storage engine and to store data files on a dedicated high-performance volume mounted at /data. During installation, the DBA runs the package installer. Which step is essential to ensure the database uses the intended storage location?

Create a symbolic link from /var/lib/mysql to /data after the service is running.

Install MySQL using the platform package manager and then move the data directory manually.

Set the datadir parameter in the MySQL configuration file to /data before starting the service.

Format the /data volume with the ext4 filesystem and mount it at /var/lib/mysql.

A company has a PostgreSQL database that is experiencing performance degradation during peak hours. The DBA suspects that the database is not using the available system resources efficiently. Which validation step would best confirm whether the database can scale to handle the increased load?

Check the size of the database and compare it to the server's memory.

Review the PostgreSQL configuration file to ensure all parameters are set to their maximum values.

Verify that all indexes are being used by running EXPLAIN on common queries.

Run a benchmark that gradually increases the number of concurrent connections while monitoring CPU, memory, and I/O usage.

A database administrator is installing a DBMS on a Linux server. Which of the following is the most common method to install the DBMS from a package repository?

Running a Windows installer executable

Using the package manager (e.g., yum, apt) to install the DBMS package

Copying the DBMS binary files to the server via FTP

Compiling the DBMS from source code manually

CompTIADataSys+

Domain 2Objective 3

Deployment Phases DS0-001 Practice Questions (Page 1)

Part of the Database deployment domain, which accounts for 16% of the DS0-001 exam. CompTIA does not publish an official question count, but from its 90-minute exam (~35–60 total, ~6–10 in this domain), expect 2–3 from this objective — we provide 24 practice questions to prepare you well beyond it. (estimate)

24questions here

5free pages

4concepts

16%of the exam

Questions 1–5

1application · medium
A company is provisioning a new PostgreSQL database for a customer relationship management (CRM) system. The database will store sensitive customer data and must be encrypted at rest. The DBA is using the cloud provider's managed PostgreSQL service. Which provisioning step is necessary to meet the encryption requirement?
Select an answer first
2foundation · easy
Which of the following is a key consideration when installing a DBMS on a Windows server?
Select an answer first
3application · medium
A company is deploying a new MySQL database on a Linux server for a line-of-business application. The application requires the database to use the InnoDB storage engine and to store data files on a dedicated high-performance volume mounted at /data. During installation, the DBA runs the package installer. Which step is essential to ensure the database uses the intended storage location?
Select an answer first
4application · medium
A company has a PostgreSQL database that is experiencing performance degradation during peak hours. The DBA suspects that the database is not using the available system resources efficiently. Which validation step would best confirm whether the database can scale to handle the increased load?
Select an answer first
5foundation · easy
A database administrator is installing a DBMS on a Linux server. Which of the following is the most common method to install the DBMS from a package repository?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DS0-001

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by CompTIA. “DS0-001” is a trademark of its owner, used for identification only.

Deployment Phases DS0-001 Practice Questions (Page 1)

Questions 1–5

Which of the following is a key consideration when installing a DBMS on a Windows server?

A company has a PostgreSQL database that is experiencing performance degradation during peak hours. The DBA suspects that the database is not using the available system resources efficiently. Which validation step would best confirm whether the database can scale to handle the increased load?

A database administrator is installing a DBMS on a Linux server. Which of the following is the most common method to install the DBMS from a package repository?

Keep studying — Database deployment