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 have a Microsoft SQL Server instance that has a database named DB1. The database is used for reporting purposes. You plan to capture all queries for a specific table and save the data as a text file. You need…
You have five servers that run Microsoft SQL Server. Each server hosts multiple databases. You plat to implement fault tolerance. You need to implement a fault tolerance solution that meets the following requirements: Each database must use a separate fault…
Note: This question-is part of a series of questions that use the same scenario. For your convenience, the scenario is repeated in each question. Each questionpresents a different goal and answer choices, but the text of the scenario is exactly…
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 are a database administrator for Contoso, Ltd. You configure a Microsoft SQL Server failover cluster with four nodes by using Windows Server 2012 R2 Datacenter Edition and SQL Server 2016 Enterprise edition. A server in the datacenter needs to…
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 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 have a database named Saleshistory that records sales transactions for your organization. You create indexes in the database. The database has grown over time and now contains hundreds of indexes. You need to identify the indexes that are not…
You have the following Microsoft SQL Server instances: You have a database named DB1 that is hosted on SQL1. Users in the branch office must be able to access DB1 from SQL3. You need to configure an AlwaysOn Availability Group…