Deployment Phases DS0-001 Practice Questions (Page 2)

Questions 6–10

1. 6expert · hard

   A DBA is provisioning a new PostgreSQL database for a multi-tenant SaaS application. Each tenant has different performance requirements, and the DBA needs to ensure that a high-usage tenant does not degrade performance for others. The database will be hosted on a single powerful server. Which provisioning strategy is most effective?

   • AUse a single database with a shared schema and rely on application-level throttling.
   • BCreate a separate tablespace for each tenant and set quotas.
   • CProvision a separate PostgreSQL instance for each tenant on the same server.
   • DCreate separate schemas for each tenant within the same database and use connection pooling.
   Reveal Solution Discussion Select an answer first
2. 7application · medium

   A company is provisioning a new SQL Server instance for a data warehouse workload. The database will be used for nightly ETL processes that load large volumes of data and for reporting queries during business hours. The DBA needs to allocate resources to ensure good performance for both workloads. Which provisioning action is most appropriate?

   • ASet the database to use the simple recovery model to reduce backup overhead.
   • BPlace the transaction log on the same disk as the data files to simplify management.
   • CEnable automatic shrinking of the database files to save disk space.
   • DConfigure the database with multiple data files on separate disks and set the initial size to accommodate expected growth.
   Reveal Solution Discussion Select an answer first
4. 8expert · hard

   A DBA is installing MySQL on a new Linux server that will host a database for a financial application. The application requires high availability and the DBA plans to set up replication later. The server has limited disk space, and the DBA wants to minimize the storage footprint during installation. Which installation decision is most appropriate?

   • AInstall MySQL with the default options and enable binary logging after replication is configured.
   • BInstall MySQL with a minimal data directory and add binary logging only if disk space becomes available.
   • CInstall MySQL with binary logging enabled from the start to support future replication.
   • DInstall MySQL without binary logging and use a different replication method that does not require it.
   Reveal Solution Discussion Select an answer first
5. 9foundation · easy

   During database provisioning, which of the following tasks is performed to prepare the database for use?

   • ACreating the database schema and initial user accounts
   • BTuning the query optimizer for specific queries
   • CDefining the backup retention policy
   • DMonitoring performance metrics in real time
   Reveal Solution Discussion Select an answer first
6. 10foundation · easy

   After installing a DBMS, an administrator wants to ensure that only specific applications can connect to the database server. Which configuration setting is most directly responsible for controlling client access?

   • AThe query optimizer settings
   • BThe backup schedule configuration
   • CAuthentication and authorization settings (e.g., user accounts, privileges)
   • DThe database's character set configuration
   Reveal Solution Discussion Select an answer first