Database Planning And Deployment

A data architect is designing a schema for a high-concurrency e-commerce system. They decide to use a surrogate key instead of a natural key for the Orders table to ensure join performance and data integrity. What is the primary advantage of this design choice?

A database developer is implementing a partitioning strategy for a large table containing historical financial records. The requirement is to allow for efficient archival of data older than five years. Which partitioning strategy should be chosen?

During the pre-deployment phase, a team needs to estimate the hardware resources required for a new Oracle Database installation. Which tool should be used to simulate database workload and forecast resource consumption?

You are deploying a database to a cloud environment and need to ensure that data at rest is encrypted according to organizational security policy. Which deployment configuration ensures transparent encryption of the database files?

Before finalizing a database deployment, the team must ensure high availability. Which configuration allows for automatic failover to a standby server with zero data loss in a SQL Server environment?

A database administrator is defining the data lifecycle policy for a new deployment. What is the final step in the data lifecycle for records that have exceeded their retention period and are no longer required for regulatory compliance?

During database testing, a developer finds that a specific query is performing poorly due to a lack of statistics. What action should be taken to update the database optimizer's knowledge of the table data distribution?

A company is planning to migrate a legacy on-premises database to the cloud. Which assessment should be conducted to ensure the application compatibility with the target managed database service?

A database architect is tasked with choosing a database model for a system that requires highly variable, semi-structured data storage (e.g., JSON documents). Which model provides the best flexibility for this requirement?

In the context of database deployment, what is the primary purpose of a staging environment?

An administrator is deploying a new database and needs to ensure that the backup strategy complies with the '3-2-1' backup rule. What does the '1' in this rule represent?

Which document is essential to create during the database planning phase to define the specific requirements, constraints, and business rules of the proposed system?

During a database deployment, the administrator needs to ensure that audit logs are captured for all privileged user actions. Which component should be configured?

Which database feature is used to automatically maintain data integrity by ensuring that a value in a child table exists as a primary key in a parent table?

When planning database capacity, you calculate the projected growth of a table based on transaction volume and row size. What does 'database bloat' refer to in this context?

An organization is deploying a database that requires a Recovery Time Objective (RTO) of less than one minute. Which backup and recovery strategy is most appropriate?

A database administrator is deploying a production environment and needs to restrict network access to the database server. Which tool or setting is the first line of defense at the network layer?

What is the primary role of a Data Dictionary in a database management system?

A database administrator is evaluating storage subsystems for a mission-critical database. The database uses random I/O patterns for most operations. Which storage performance metric is most critical for this workload?

You are deploying a database that requires compliance with FIPS 140-2. What must be configured to ensure the database meets this security standard?

Which of the following activities is performed during the 'Testing' phase of a database deployment to ensure the system meets its performance targets?

A database is configured with an 'Asynchronous Commit' replication mode. What is the potential risk during a primary server failure?

Which THREE factors should be considered when choosing between a traditional RDBMS and a NoSQL database for a new project?

Which TWO tasks are critical before performing a major database schema upgrade?

Which TWO settings should be configured in a database deployment to improve performance for heavy read-intensive reporting workloads?

Which THREE database configuration settings help ensure data security and regulatory compliance?

Which TWO indicators should be monitored when testing a database deployment to ensure it is correctly sized for performance?

Which THREE items should be included in a standard database deployment checklist to ensure consistency across environments?

Which TWO database features are best used to handle massive volumes of data while maintaining fast query speeds for historical analytics?

Which TWO of the following are examples of logical database design tasks?

Which THREE of the following are benefits of implementing a standardized database schema migration process?

Which THREE factors are critical to consider when configuring a database for disaster recovery (DR)?

A database administrator is planning a new SQL Server deployment and needs to ensure that the tempdb system database does not become a bottleneck during high-concurrency operations. Which configuration step should be performed during the initial setup?

A company is designing a distributed NoSQL database deployment using MongoDB. They need to ensure high availability and automatic failover in the event that a primary node becomes unreachable. What must the architect configure to achieve this?

You are migrating an on-premises Oracle database to Oracle Cloud Infrastructure (OCI) using a tool that requires the least amount of downtime while keeping the source and destination databases in sync. Which method should you select?

You are deploying a MySQL database on Linux and want to ensure that the database files are isolated from system logs for performance reasons. Which MySQL configuration variable should you modify to specify the data directory location?

During the testing phase of a database deployment, you discover that the database is not accepting external connections. You have verified that the database service is running. What is the most likely culprit?

An administrator is verifying the storage requirements for a new PostgreSQL database installation. Which configuration parameter in the postgresql.conf file directly impacts the amount of memory allocated for shared buffers?

You are planning the disk layout for a SQL Server production database. Which THREE best practices should you follow to optimize storage performance?

An administrator needs to improve the security posture of a newly deployed PostgreSQL database. Which TWO actions should be performed to harden the environment?

When preparing a database deployment plan, what THREE factors must be considered to ensure successful capacity planning?

A database administrator is deploying a new PostgreSQL 16 cluster for an online transaction processing (OLTP) application. The application must survive the loss of any single server in the primary data center without manual intervention, and the administrator wants the cluster to automatically promote a standby if the primary fails. The administrator has three servers available and wants to minimize the risk of split-brain. Which deployment approach should the administrator use?

A database administrator is planning the deployment of a new Microsoft SQL Server 2022 instance for a financial application. The application requires that committed transactions survive a power loss and that the storage subsystem provide the lowest possible write latency. The administrator must choose the appropriate recovery model and disk configuration. Which combination best meets these requirements?

A database administrator is deploying a new online transaction processing (OLTP) database on a four-socket server with 512 GB of RAM and a storage area network (SAN) that uses solid-state drives. The application performs many small, random reads and writes. The administrator needs to configure the database instance to minimize physical I/O and improve response time. Which configuration should the administrator implement?

A database administrator is deploying a new database that will store sensitive customer data. The organization requires that all data at rest be encrypted using AES-256. The database supports Transparent Data Encryption (TDE). After enabling TDE, what additional step must be performed to ensure that the encryption keys are protected and can be recovered in case of a disaster?

A database administrator is deploying a new PostgreSQL 15 cluster on Linux and wants to protect against data loss if a single disk in the data volume fails. The server has four identical 1 TB SSDs available. Which RAID level should the administrator configure for the PostgreSQL data directory?

A database administrator is deploying a new PostgreSQL database cluster that must support a read-intensive reporting workload. The reporting queries are long-running and scan large tables. The administrator wants to avoid blocking write transactions on the primary server. Which deployment approach should the administrator use?

A database administrator is planning the deployment of a new database server. The organization requires that the database be able to recover from a failure with minimal data loss, and the Recovery Point Objective (RPO) is 5 minutes. Which backup strategy should the administrator implement?

A data engineer is deploying a new MySQL 8.0 instance that will store customer records for users in the European Union. The compliance team requires that all data at rest be encrypted and that encryption keys be managed separately from the database server. Which action should the engineer take?

A database administrator is deploying a new PostgreSQL 15 instance that will store customer PII. The security policy requires that all data at rest be encrypted, and the platform team wants encryption tied to the host's Trusted Platform Module without managing passphrases. Which deployment approach best satisfies this requirement?

A database administrator is deploying a new database instance that will store sensitive customer information. The organization must comply with PCI DSS requirements for encryption of data at rest and in transit. Which TWO configurations should the administrator implement to meet these requirements? (Choose two.)

A database administrator is planning a new SQL Server 2022 deployment that must support a read-only reporting workload without impacting the primary OLTP workload. The reporting queries are long-running and scan large tables. Which two features should the administrator implement to meet this requirement? (Choose two.)

An organization is deploying a new MySQL 8.0 database for an order-entry application. The team needs the database to enforce referential integrity so that an order row cannot reference a customer that does not exist. Which deployment step accomplishes this?

A database administrator is deploying a new database on a cloud platform. The organization requires that the database automatically scale storage capacity as data grows, without manual intervention, and that it maintain high availability across multiple availability zones. Which cloud database deployment option should the administrator choose?

A data warehouse team is deploying a partitioned fact table in SQL Server 2022 that will hold seven years of sales data. Most queries filter on the order date, and the team wants the oldest year moved to cheaper storage while remaining queryable. Which deployment design best meets these goals?

A database administrator is deploying a new Oracle 19c database and needs to ensure that if the production server's power fails, no committed transactions are lost. The storage array has a write-back cache with a battery-backed unit. Which configuration should the administrator verify?

A database administrator is preparing to deploy a new Oracle Database 19c instance that will store regulated financial data. The compliance team requires that all data at rest be encrypted and that encryption keys be managed outside the database to satisfy separation-of-duties controls. Which deployment approach should the administrator use?

A database administrator is deploying a new database server and needs to ensure that the database software starts automatically when the operating system boots. On a Linux system, which of the following should the administrator use to manage the database service?

A database administrator is deploying a PostgreSQL 15 cluster that will serve a global application with users in North America, Europe, and Asia. The requirement is that reads be served with low latency from each region while writes are accepted in only one region. Which deployment architecture should the administrator choose?

A database administrator is preparing the deployment plan for a new transactional database that must support point-in-time recovery and minimize data loss after a storage failure. The organization has approved additional storage for this purpose. Which TWO deployment measures best meet these requirements? (Choose two.)

A database administrator is planning the deployment of a new PostgreSQL 15 cluster that will support a high-volume web application. The application's workload is expected to be read-heavy, with a read-to-write ratio of approximately 10:1. The primary server has 64 GB of RAM, and the database size is estimated at 500 GB. To improve read performance and provide high availability, the administrator plans to implement streaming replication. Which configuration should the administrator implement to best meet these requirements?

A database administrator is deploying a new MongoDB 6.0 replica set to store product catalog data. The business requires that the database remain available for reads and writes even if a single data center becomes unreachable, and that writes be acknowledged by a majority of replica set members before returning success. Which deployment topology and write concern should the administrator configure?

A database administrator is deploying a new Microsoft SQL Server 2022 instance that will host a mission-critical OLTP database. The business requires zero data loss and automatic failover to a secondary server in a different subnet within the same data center. The administrator needs to configure a high-availability solution that supports automatic failover and synchronous commit. Which solution should the administrator implement?