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?
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?
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?
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?
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?
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?
A database administrator is deploying a new PostgreSQL 15 cluster for an OLTP application that performs a high volume of small, random writes. The storage vendor recommends configuring the filesystem to avoid partial-page writes during power loss. Which filesystem configuration should the administrator verify is enabled before initializing the cluster?
A database administrator is deploying a high-traffic OLTP database. The server has 64 GB of RAM, and the database size is 500 GB. The administrator wants to optimize performance by configuring the database to cache frequently accessed data in memory while ensuring that memory is not over-allocated to the database process. Which configuration parameter should the administrator adjust?
An organization is deploying a SQL Server 2022 Always On availability group across two data centers. The database administrator must ensure that if the primary replica becomes unavailable, a synchronous secondary replica in the remote data center can be promoted without data loss, but the remote secondary must not be allowed to delay commits on the primary. Which configuration should the administrator apply?
A database administrator is planning the deployment of a new MongoDB 6.0 replica set to support a customer-facing application. The administrator must ensure that reads can be served from secondary members to distribute load, and that the deployment can survive the loss of a single data center. Which TWO deployment configurations should the administrator implement? (Choose two.)
A database administrator is deploying a new database that will be used for both OLTP and reporting workloads. To optimize performance, the administrator plans to implement a caching layer. Which TWO caching strategies are most appropriate for this mixed workload? (Choose two.)
A database administrator is deploying a MySQL 8.0 InnoDB cluster for a high-traffic web application. The application performs many short transactions and the administrator observes that disk I/O is the bottleneck during peak hours. The storage team confirms the disks are not saturated at the hardware level. Which InnoDB configuration change should the administrator make to reduce disk I/O by allowing transactions to commit without forcing a log flush to disk on every commit?
A team is deploying a MongoDB 7.0 replica set for a customer-facing application that must remain writable if a single data center becomes unavailable. The primary and two secondaries currently reside in one data center, with two additional secondaries planned for a second data center. Which write concern and read concern combination best balances durability with availability during a data center outage?
A database administrator is planning the deployment of a new PostgreSQL 15 cluster for a reporting application. The application will run complex analytical queries that scan large portions of tables and perform large sequential reads. Which storage configuration should the administrator choose to best support this workload?
A database administrator is planning the deployment of a new Oracle Database 19c instance that will support a global e-commerce application. The application must be available 24/7 and must support rolling upgrades with minimal downtime. The administrator needs to choose a high-availability architecture that allows patching and upgrades with no downtime. Which Oracle feature should the administrator implement?
A database administrator is deploying a new MySQL 8.0 instance that will store sensitive customer data. The compliance team requires that data be encrypted at rest and in transit, and that encryption keys be managed externally. Which TWO configurations should the administrator implement to meet these requirements? (Choose two.)
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?
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?
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?
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?
An administrator needs to improve the security posture of a newly deployed PostgreSQL database. Which TWO actions should be performed to harden the environment?
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?