Note: This question-is part of a series of questions that present the same scenario. Each question-in the series contains a unique solution that might meet the stated goals. Some question-sets might have more than one correct solution, while others might…
Note: This question-is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question-in the series. Each question-is independent of the other questions in this series.…
You configure log shipping on two servers named SQL1 and SQL2 is in Standby mode. You configure backup and restore to occur every hour. A user generates a report from SQL2 and discovers that the report data is out-of-date. You…
You maintain Microsoft SQL Server instances named SVR1 and SVR2 that are hosted on two different servers. You configure log shipping between the two instances as follows: DB1 on SVR1 is configured as the primary database. DB1 on SVR2 is…
Note: This question-is part of a series of questions that present the same scenario. Each question-in the series contains a unique solution that might meet the stated goals. Some question-sets might have more than one correct solution, while others might…
You maintain a database named DB1 that has a nonpartitioned table. You create an index in the table. Automatic statistics updates are disabled. Users report that some Microsoft SQL Server Reporting Service (SSRS) queries take a long time to run.…
Note: This question-is part of a series of questions that present the same scenario. Each question-in the series contains a unique solution that might meet the stated goals. Some question-sets might have more than one correct solution, while others might…
DRAG DROP You are a database administrator for an organization. Members of the human resources department can add new employee records to the HR.Employees table. All members of the human resources department can add new employee records to the HR.Employees…
DRAG DROP You store Microsoft SQL Server backups at an off-site location that has no protection from unauthorized access. Your organization has not implemented hardware security modules (HSM). You need to implement a solution for encryption the SQL backups. Which…
DRAG DROP You manage a database named DB1 that uses the following filegroups: The database is configured to use full recovery model. Transaction logs are backed up to a backup set named TLogBackup. The PRIMARY and FG2 for DB1 are…