Database Planning And Deployment

A database administrator is planning to normalize a flat-file database containing customer orders. The administrator identifies that customer contact information is repeated for every order record. Which normalization form should the administrator implement to move this contact information to a separate table?

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?

An organization is deploying a new SQL Server database. The storage administrator needs to ensure that the transaction logs are stored on a separate physical volume from the data files to improve performance and recoverability. Which configuration step accomplishes this?

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 database administrator needs to implement Row-Level Security (RLS) to ensure that users can only view records belonging to their specific department. Which database component must be created to enforce this logic?

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?

You are reviewing a deployment plan for a multi-tenant database. To ensure security, you want to ensure that each tenant's data is logically isolated. Which strategy is most effective for this?

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?

A database is experiencing high lock contention on a specific table during batch update processes. What is the most effective way to resolve this issue without changing the application code?

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 TWO of the following are essential components of a robust database backup plan?

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

Which TWO database deployment configurations help mitigate the impact of a hardware failure on the primary storage controller?

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?

A database architect is setting up an Always On Availability Group in SQL Server. To ensure that the secondary replica can be used for read-only workloads without impacting the primary node's performance, how should the 'Readable Secondary' property be configured?

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?