Deployment Phases DS0-001 Practice Questions (Page 5)

Questions 21–24

1. 21application · medium

   A DBA is installing PostgreSQL on a Windows Server for a new application. The application requires the database to listen on a specific IP address (192.168.10.5) and accept connections from the application server on the same subnet. After installation, which configuration change is necessary?

   • ASet the port parameter in postgresql.conf to a non-default value.
   • BEdit postgresql.conf to set listen_addresses = '192.168.10.5' and restart the service.
   • CCreate a new user in PostgreSQL with superuser privileges.
   • DModify pg_hba.conf to allow all connections from any IP address.
   Reveal Solution Discussion Select an answer first
2. 22application · medium

   A DBA is installing SQL Server on a Windows Server that will host multiple databases for different applications. The DBA wants to ensure that each database has predictable performance and that a heavy workload on one database does not affect others. Which installation or configuration option should be used?

   • AInstall SQL Server with the default instance and create all databases in it.
   • BPlace all database files on the same disk to simplify management.
   • CConfigure Resource Governor to limit CPU and memory usage for each database.
   • DSet the max degree of parallelism (MAXDOP) to 1 for the entire server.
   Reveal Solution Discussion Select an answer first
4. 23foundation · easy

   Which of the following activities is part of scalability validation?

   • AUpdating the database's documentation
   • BChanging the database's default character set
   • CReviewing the database's error logs for syntax errors
   • DRunning load tests with increasing numbers of concurrent users
   Reveal Solution Discussion Select an answer first
5. 24expert · hard

   A company has a MySQL database that is expected to grow from 100 GB to 1 TB over the next year. The DBA needs to validate that the database can handle this growth without significant performance degradation. The database is currently on a single server with 32 GB of RAM. Which approach is most appropriate for scalability validation?

   • AEnable query caching to improve performance for repeated queries.
   • BIncrease the server's RAM to 64 GB and assume the database will scale.
   • CLoad test the database with a simulated dataset of 1 TB and monitor performance metrics.
   • DReview the database schema and optimize indexes to reduce query times.
   Reveal Solution Discussion Select an answer first