You maintain a Microsoft SQL Server database named DB1. You create a maintenance plan to run the DBCC CHECKDB command regularly to identify possible database corruption. DB1 has the following table: Filegroup FG1 is read-only. You set FG1 to read-only…
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,…
HOTSPOT You have a database named DB1. Users report that queries that use a specific table take a long time to complete. You suspect an issue with how often checkpoints are issued. You need to create an Extended Events session…
You are a database administrator for an organization. You must allow the members of the human resources department to add new employee records to the HR.Employees table. All members of the human resources department are assigned the HumanResources database only.…
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,…
HOTSPOT A company has an on-premises Microsoft SQL Server environment and Microsoft Azure SQL Database instances. The environment hosts several customer databases. You configure instances for a specific customer as an Always On Availability Group. The primary replica is located…
HOTSPOT You are a database administrator for an organization. You manage a mission-critical database named DB1 that is hosted on a server named LON-SQL1. An audit record for transactions that occur in DB1 are written to a file every five…
HOTSPOT You manage Microsoft SQL Server databases for an organization. You need to configure the databases to meet the following requirements: Encrypt the data at rest. Ensure that unencrypted values for specific columns can only be viewed by using a…
HOTSPOT Your organization is developing a web application. The application will access data from a Microsoft SQL Server database. You must implement a security solution that meets the following requirements: All user logins must be associated with an Active Directory…
HOTSPOT You manage a Microsoft SQL Server environment with a database named DB1. You notice that queries take longer to complete than they did a year ago. You increase the file size for the database named tempdb, but it does…