The correct answer is D. The continuity of operations policy. CompTIA DataSys+ emphasizes that when an unexpected system failure occurs-especially during critical activities such as database migrations-the primary concern is restoring services, minimizing downtime, and ensuring data availability. The continuity of operations policy (often aligned with business continuity and disaster recovery planning) provides documented guidance on how to respond to system outages and operational disruptions.
A continuity of operations policy outlines procedures, roles, and responsibilities for maintaining or rapidly restoring essential systems after an incident. This includes steps for failover, rollback procedures, recovery prioritization, communication protocols, and escalation paths. During a migration-related crash, administrators rely on this policy to determine whether to restore from backups, revert to a previous database version, activate standby systems, or follow defined recovery time objectives (RTOs) and recovery point objectives (RPOs). DataSys+ highlights these policies as critical for ensuring predictable and coordinated responses during system failures.
Option A, the data retention policy, focuses on how long data must be stored and when it can be archived or deleted. It does not provide operational guidance for handling system crashes. Option B, the access control policy, governs authentication and authorization rules and is unrelated to recovery actions. Option C, the database compliance policy, addresses regulatory and audit requirements but does not define technical recovery procedures during an outage.
CompTIA DataSys+ clearly distinguishes governance and security policies from operational resilience policies. When a database crashes during a migration, the administrator's priority is service restoration and data integrity, both of which are addressed by continuity of operations planning.
Therefore, the systems administrator should refer to the continuity of operations policy, making option D the correct and fully verified answer.

The approach that the administrator should use when conducting the stress test is to capture business logic, check the performance of codes, and report findings. This will help the administrator to evaluate how well the application handles high volumes of data and transactions, identify any bottlenecks or errors in the code, and provide feedback to the development team on how to improve the application's efficiency and reliability. The other options are either too narrow or too broad in scope, and do not address the specific needs of an application that uses the Entity Framework. References: CompTIA DataSys+ Course Outline, Domain 4.0 Data and Database Security, Objective 4.3 Given a scenario, monitor database performance and security.

The correct answer is C. Client-side. CompTIA DataSys+ explains that client-side scripting refers to code that is executed directly within the user's web browser, rather than on a backend server or operating system shell. The most common and widely recognized client-side scripting language is JavaScript, which runs natively in modern web browsers and is used to enhance interactivity, validate input, and dynamically update content on web pages.
Client-side scripts execute after a web page is delivered to the user's browser. This allows for immediate feedback, such as form validation, dynamic content updates, and interactive user interfaces, without requiring a round trip to the server. DataSys+ highlights client-side scripting as an important concept when discussing web applications that interact with databases, particularly because improper client-side controls can introduce security risks if not reinforced by server-side validation.
Option A, server-side scripting, runs on the web server rather than in the browser. Examples include PHP, Python, Ruby, and server-side JavaScript (such as Node.js). These scripts handle tasks like database queries, authentication, and business logic and are never executed in the browser itself. Option B, PowerShell, is a scripting and automation language used primarily in Windows environments for system and database administration tasks and cannot run inside a web browser. Option D, command-line scripting, refers to scripts executed in a terminal or shell environment, not within a browser context.
CompTIA DataSys+ emphasizes the distinction between client-side and server-side execution models because of their impact on performance, security, and data handling. Understanding where code executes is critical for protecting databases from exposure and enforcing proper validation controls.
Therefore, the type of scripting that can be executed in a web browser is client-side scripting, making option C the correct and fully verified answer.

The service that is responsible for assigning, managing, and reclaiming IP addresses on a TCP/IP-based network is DHCP. DHCP, or Dynamic Host Configuration Protocol, is a service that automatically assigns IP addresses and other network configuration parameters, such as subnet mask, default gateway, DNS server, etc., to computers or devices on a network. DHCP helps simplify the administration and management of IP addresses on a network, as well as avoid conflicts or errors caused by manual or duplicate assignments.
DHCP also allows computers or devices to release or renew their IP addresses when they join or leave the network. The other options are either different services or not related to IP addresses at all. For example, DNS, or Domain Name System, is a service that translates domain names into IP addresses and vice versa; LDAP, or Lightweight Directory Access Protocol, is a service that provides access to directory information such as users, groups, or devices on a network; ISMTP is not a valid acronym or service. References: CompTIA DataSys+ Course Outline, Domain 2.0 Database Deployment, Objective 2.1 Given a scenario, select an appropriate database deployment method.

The two resources that are best for monitoring potential server issues are CPU usage and memory usage. CPU usage is the percentage of time that the processor (CPU) of the server is busy executing instructions or processes. CPU usage indicates how much workload the server can handle and how fast it can process requests. High CPU usage may affect the performance or availability of the server and cause delays or errors.
Memory usage is the amount of physical memory (RAM) or virtual memory (swap space) that the server uses to store data or run applications. Memory usage indicates how much space the server has to store temporary or intermediate data or results. High memory usage may affect the performance or availability of the server and cause swapping or paging. The other options are either not relevant or not direct indicators of server health. For example, user connections are the number of users who are connected to a database server at any given time; firewall usage is the amount of data that passes through a firewall device or software; index usage is the frequency or efficiency of using indexes on tables to speed up queries; query execution is the process of running SQL statements on a database server. References: CompTIA DataSys+ Course Outline, Domain 3.0 Database Management and Maintenance, Objective 3.2 Given a scenario, monitor database performance.