SK0-005 Practice Test 2 — 10 Questions

Question 1

A SQL Server database administrator wants to backup a large database (500 GB) with minimal impact on transaction log growth and recovery time. Which TWO backup strategies should the administrator implement? (Choose two.)

Accepted Answer

Perform weekly full backups. Options A and D are correct. A: A full backup copies the entire database, and is needed as a base. D: Transaction log backups control log growth and allow point-in-time recovery. Option B is wrong because differential backups depend on a recent full backup. Option C is wrong because copy-only backups do not affect the log sequence, but they don't control log growth. Option E is wrong because tail-log backups are taken just before disaster recovery, not regularly.

Answer

Perform a tail-log backup before each full backup

Answer

Perform daily differential backups

Answer

Perform hourly copy-only backups

Question 2

You are a server administrator at a mid-sized company that hosts its own on-premises Exchange server and file server. The infrastructure consists of three racks: Rack A contains the core switches and firewalls, Rack B contains the Exchange server (Dell PowerEdge R740) and the file server (HP ProLiant DL380 Gen10), and Rack C contains backup devices and a tape library. The data center cooling is provided by a raised-floor system with perforated tiles. Recently, the file server has been experiencing random shutdowns during peak usage hours (10 AM to 2 PM). The shutdowns are preceded by system event log warnings indicating that the CPU temperature has exceeded the threshold. The ambient temperature around the rack is 20°C (68°F) as measured by a handheld thermometer. Other servers in Rack B do not exhibit this behavior. The file server is a 2U server with two Xeon processors, 128 GB RAM, and six hot-swap SATA drives. It runs Windows Server 2019. The server has been in service for three years with no prior issues. The data center manager has noted that the perforated tiles are clear of obstructions. You have verified that the fans in the file server are spinning and the internal air filters are clean. Which of the following is the MOST likely cause of the overheating issue?

Accepted Answer

The perforated tile under the file server has insufficient airflow due to cable blockage below the raised floor.. Option B is correct because the file server's shutdowns occur during peak hours when cooling load is highest. If the server is located in a spot with inadequate underfloor airflow (e.g., a tile blocked by cables or a misaligned tile), it will not receive enough cool air, leading to CPU overheating despite the ambient reading. Option A is incorrect because the fans are verified to be spinning and filters clean. Option C is unlikely because the ambient is normal and other servers are fine. Option D is possible but not as specific to peak hours; a failing PSU usually causes power loss, not CPU thermal events.

Answer

The ambient temperature sensor in the data center is reporting incorrectly and the actual temperature is higher.

Answer

The internal fans are not operating at full speed due to a failed fan controller.

Answer

The file server's power supply is failing and causing voltage drops that affect fan performance.

Question 3

A company operates a Windows Server 2019 machine that functions as a domain controller and file server. Over the past week, the server has randomly rebooted several times, often during periods of heavy file access. The administrator reviews the System event log and finds multiple Event ID 41 (Kernel-Power) entries with no preceding critical errors. The server is connected to an uninterruptible power supply (UPS) that reports stable input voltage. The server room temperature sensors indicate normal ambient temperature (22°C / 72°F). The server hardware is three years old and has not had any recent changes. The administrator has already run a full antivirus scan with no threats found. Which of the following should the administrator do NEXT to diagnose the issue?

Accepted Answer

Inspect and clean the CPU and chassis fans, and check for dust buildup. Option C is correct because random reboots with Kernel-Power 41 often indicate overheating due to failing fans or dust buildup, even if ambient temperature is normal. Option A is wrong because the power supply is likely not the issue given the UPS stability. Option B is wrong because a BIOS update is unlikely to solve hardware overheating. Option D is wrong because disabling automatic restart only hides the symptom and does not prevent the reboots.

Answer

Update the server's BIOS to the latest version

Answer

Replace the power supply unit

Answer

Disable the automatic restart feature in System Properties

Question 4

A company is migrating a legacy line-of-business application from Windows Server 2012 R2 to a new Windows Server 2022 server that is a member of an Active Directory domain. The application runs as a Windows service under a domain service account named CORP\svc_app. The service account has been granted the 'Log on as a service' user right on the old server, and the application is configured to listen on a static TCP port 8443. After installing the application on the new server and configuring it with the same service account and port, the application fails to start. The administrator checks the Windows Event Viewer and sees two errors in the System log: 'The CORP\svc_app service failed to start due to the following error: The service did not start due to a logon failure' and 'The service cannot bind to the designated port 8443'. The administrator has already verified that the service account's password is correct and has not expired, that the account is enabled, that the port 8443 is not being used by another service, and that the Windows Firewall has an inbound rule allowing traffic on port 8443. The application's configuration file correctly points to port 8443. What should the administrator do to resolve the issue?

Accepted Answer

Grant the 'Log on as a service' user right to the CORP\svc_app account via Local Security Policy or Group Policy.. The correct answer is B. The 'Log on as a service' user right is a security policy setting that must be explicitly assigned to a service account on each individual server. Even though the account had this right on the old server, it does not automatically carry over to the new server. Without this right, the service cannot start, and the 'logon failure' error is a classic symptom. Option A is incorrect because the password was already verified as correct. Option C is incorrect because the application requires a static port (port 8443) and changing to a dynamic port would break client connectivity. Option D is incorrect because restarting the server does not assign the missing user right and will not resolve the logon failure.

Answer

Restart the Windows Server 2022 server to apply any pending policy changes.

Answer

Configure the application to use a dynamic port instead of the static port 8443.

Answer

Reset the service account password and update the service configuration.

Question 5

A server administrator is restoring a file server from a full backup taken 7 days ago and incremental backups taken daily. The restoration fails with an error about missing catalog files. What is the most likely cause?

Accepted Answer

The incremental backup chain is broken. Restoring from incremental backups requires a complete chain from the last full backup. If any incremental backup in the chain is missing or corrupted, the restore will fail. Corrupted full backup media would cause a different error. OS compatibility issues would likely appear earlier. Hard drive failure would be a hardware error.

Answer

The hard drive on the file server has failed

Answer

The backup software is not compatible with the current OS version

Answer

The full backup media is corrupted

Question 6

A RAID 5 array is degraded due to a failed disk. What is the best practice for recovery?

Accepted Answer

Replace the failed disk and allow the array to rebuild automatically. Option C is correct because replacing the failed disk and allowing automatic rebuild utilizes the array's redundancy and minimizes downtime. Option A destroys the existing configuration. Option B and D are unnecessary if the array can rebuild.

Answer

Replace the failed disk and restore from backup

Answer

Replace the failed disk and perform a manual rebuild from backup

Answer

Delete the logical drive and recreate the array

Question 7

A technician is troubleshooting a server that is experiencing high disk I/O wait times. The disk queue length is consistently above 10. Which of the following is the MOST likely cause?

Accepted Answer

Insufficient RAM. Insufficient RAM can cause excessive paging to disk, leading to high disk I/O wait times and long queue lengths.

Answer

Disk fragmentation

Answer

Slow network link

Answer

Overloaded CPU

Question 8

A medium-sized company uses a backup strategy that includes a full backup every Sunday at 2:00 AM and differential backups Monday through Saturday at 2:00 AM. The backups are written to a network-attached storage (NAS) device. On Thursday morning, the company experiences a ransomware attack that encrypts all data on the file server, including the NAS. The administrator needs to restore the file server with minimal data loss. The last successful full backup was from the previous Sunday, and differential backups were successful on Monday, Tuesday, and Wednesday. However, Thursday's differential was not completed because the attack occurred before the scheduled time. The administrator attempts to restore using the Sunday full backup and Thursday's differential, but the restore fails because the differential backup on the NAS is also encrypted. Which of the following is the best course of action?

Accepted Answer

Restore from the Sunday full backup and Wednesday's differential backup. The most recent clean backup set is Sunday's full plus Wednesday's differential, as both were taken before the ransomware attack. Restoring from these will recover data as of Wednesday's backup, minimizing data loss. Using only Wednesday's differential requires the full backup first. Paying the ransom is not recommended and may not work. Reinstalling the OS and restoring from cloud would not apply because cloud was not mentioned.

Answer

Pay the ransom to decrypt the differential backup

Answer

Reinstall the operating system and restore files from cloud storage

Answer

Restore using only Wednesday's differential backup

Question 9

A technician is troubleshooting a server that fails to boot. The server displays a 'Boot Device Not Found' error. The technician verifies that the hard drives are spinning and appear in the RAID controller's BIOS. What should the technician check next?

Accepted Answer

Boot order in BIOS. Option B is correct because boot order is a common cause of 'Boot Device Not Found' when drives are detected. Option A is wrong because if drives are spinning and detected, cables are likely fine. Option C is wrong because missing OS files typically produce a different error. Option D is wrong because the array status is already verified as healthy.

Answer

Operating system files

Answer

SATA cable connections

Answer

RAID array status

Question 10

Refer to the exhibit. A server is running slowly. Based on the memory statistics, what is the MOST likely issue?

Accepted Answer

Insufficient physical memory. With only 1 GB of available physical memory out of 16 GB, the server is heavily dependent on paging, leading to slow performance.

Answer

Memory leak in an application

Answer

Virtual memory is misconfigured

Answer

Page file is too small