Search test library by skills or roles
⌘ K

Adaface Sample SQL Server Questions

Here are some sample SQL Server questions from our premium questions library (10273 non-googleable questions).

Skills

🧐 Question

Medium

Backup Strategy
Backups
Troubleshooting
Solve
As a DBA, you receive an alert notifying you that the production database has gone offline due to a severe issue. Fortunately, you have a proper backup strategy in place. The backups are performed as follows:
            
            1. Full database backup every Sunday at 2:00 AM.
            2. Differential backup every day at 2:00 AM, except Sunday.
            3. Transaction log backup every hour.
Today is Wednesday, and the failure occurred at 10:15 AM. You have the following backup files available:
            
            1. Full backup: Full_Backup_Sun.bak taken on Sunday 2:00 AM.
            2. Differential backups: Diff_Backup_Mon.bak, Diff_Backup_Tue.bak, Diff_Backup_Wed.bak taken at 2:00 AM on their respective days.
            3. Transaction log backups: Hourly backups from Sunday 3:00 AM until Wednesday 10:00 AM, like TLog_Backup_Wed_09.bak, TLog_Backup_Wed_10.bak.
Given the RPO (Recovery Point Objective) of 15 minutes, which of the following sequences of restore operations would ensure minimal data loss?
A: Full_Backup_Sun.bak, Diff_Backup_Wed.bak, then all Transaction Log backups from Wednesday.
            
            B: Full_Backup_Sun.bak, Diff_Backup_Tue.bak, then all Transaction Log backups from Tuesday and Wednesday.
            
            C: Full_Backup_Sun.bak, Diff_Backup_Wed.bak, then Transaction Log backups from Wednesday 2:00 AM to 10:00 AM.
            
            D: Full_Backup_Sun.bak, then all Transaction Log backups from Sunday to Wednesday 10:00 AM.
            
            E: Full_Backup_Sun.bak, Diff_Backup_Mon.bak, Diff_Backup_Tue.bak, Diff_Backup_Wed.bak, then Transaction Log backups from Wednesday 2:00 AM to 10:00 AM.

Medium

Transaction Log Management
Performance Tuning
Log Management
Solve
You are a DBA at a large company managing an SQL Server database which is crucial for daily operations. The database is configured with the Full recovery model. The database is experiencing considerable transaction log growth during business hours, which is impacting the disk space and performance.
            
            The following operations are performed on this database:
            
            1. A large ETL process that runs every night, which transforms and loads data into several tables.
            2. A data archiving job that runs every night, which removes old data from several tables.
            3. Frequent read/write operations during the day as part of normal business operations.
            
            Given this scenario, which of the following strategies could help manage the transaction log growth effectively?
A: Switch to the Simple recovery model.
            B: Schedule frequent log backup and cleanups during business hours.
            C: Shrink the transaction log file size during business hours.
            D: Increase the database file size.
🧐 Question🔧 Skill

Medium

Backup Strategy
Backups
Troubleshooting
3 mins
SQL Server
Solve

Medium

Transaction Log Management
Performance Tuning
Log Management
3 mins
SQL Server
Solve
🧐 Question🔧 Skill💪 Difficulty⌛ Time
Backup Strategy
Backups
Troubleshooting
SQL Server
Medium3 mins
Solve
Transaction Log Management
Performance Tuning
Log Management
SQL Server
Medium3 mins
Solve

Adaface questions are trusted by enterprises globally

Amazon Morgan Stanley Vodafone United Nations HCL PayPal Bosch WeWork Optimum Solutions Deloitte Microsoft NCS Doubtnut Sokrati J&T Express Capegemini

We evaluated several of their competitors and found Adaface to be the most compelling. Great default library of questions that are designed to test for fit rather than memorization of algorithms.


Swayam Narain, CTO, Affable

hashtag image heart icon Swayam
customers across world
Join 1200+ companies in 75+ countries.
Probieren Sie noch heute das Tool für die Bewertung von Kandidaten für freundliche Fähigkeiten aus.
g2 badges
Ready to streamline your recruitment efforts with Adaface?
Ready to streamline your recruitment efforts with Adaface?
logo
40 min tests.
No trick questions.
Accurate shortlisting.
ada
Ada
● Online
Previous
Score: NA
Next
✖️