Deployment Phases DS0-001 Practice Questions (Page 3)

Questions 11–15

1. 11application · medium

   A DBA is configuring a new MySQL instance for a high-traffic web application. The application performs many small, frequent read and write operations. The DBA wants to optimize the database for this workload. Which configuration change is most likely to improve performance?

   • AIncrease the size of the InnoDB buffer pool to cache more data in memory.
   • BDisable binary logging to reduce disk write overhead.
   • CSet the max_connections parameter to a very high value to allow more concurrent connections.
   • DSet the query cache size to a large value to cache all query results.
   Reveal Solution Discussion Select an answer first
2. 12foundation · easy

   A database administrator needs to change the default port that a DBMS listens on to avoid a conflict with an existing application. Which configuration file or setting is typically used for this purpose?

   • AThe firewall rules on the server
   • BThe operating system's hosts file
   • CThe DBMS's main configuration file (e.g., my.cnf, postgresql.conf)
   • DThe database's data dictionary
   Reveal Solution Discussion Select an answer first
4. 13application · medium

   A company is deploying a new Oracle Database for an ERP system. The application requires that all database connections use encrypted network traffic. The DBA is configuring the database after installation. Which configuration is required?

   • AConfigure Oracle Net Services to use TCPS with a valid certificate.
   • BSet the AUDIT_TRAIL parameter to DB.
   • CEnable the database's built-in data encryption feature.
   • DSet the REMOTE_LOGIN_PASSWORDFILE parameter to EXCLUSIVE.
   Reveal Solution Discussion Select an answer first
5. 14expert · hard

   A DBA is installing Oracle Database on a server that will also run a critical application. The server has limited memory, and the DBA needs to minimize the memory footprint of the database. The application requires the database to be available 24/7. Which installation option is most appropriate?

   • AInstall Oracle without any memory management and let the database use as much memory as needed.
   • BInstall Oracle with Automatic Memory Management (AMM) and set a low memory target.
   • CInstall Oracle with the default memory settings and rely on the operating system to manage memory.
   • DInstall Oracle with manual memory management and allocate all available memory to the database.
   Reveal Solution Discussion Select an answer first
6. 15foundation · easy

   Which of the following is an example of allocating resources during database provisioning?

   • AScheduling a nightly backup job
   • BAssigning a specific amount of memory and disk space to the database instance
   • CCreating an index on a frequently queried column
   • DWriting a stored procedure for a business rule
   Reveal Solution Discussion Select an answer first