HOTSPOT -You manage a Microsoft-SQL Server database named sales Orders.You need to verify the integrity of the database and attempt to repair any errors that are found. Repair must not cause any data to be lost in the database.How should you complete the DBCC command? To answer, select the appropriate options in the answer area.Hot Area:
HOTSPOT -You manage a Microsoft SQL Server environment. You have a database named salesOrders that includes a table named Table1.Table1 becomes corrupt. You repair the table.You need to verify that all the data in Table1 complies with the schema.How should you complete the Transact-SQL code statement? To answer, select the appropriate Transact-SQL code segments in the dialog box in the answer area.Hot Area:
DRAG DROP -You are configuring a new Microsoft SQL Server Always On Availability Group. You plan to configure a shared network location at \\DATA-CI1\SQL.You need to create an availability group listener named AGL1 on port 1433.In which order should you perform the actions? To answer, move all actions from the list of actions to the answer area and arrange them in the correct order.Select and Place:
HOTSPOT -You are configuring log shipping for a Microsoft SQL Server database named salesOrders.You run the following Transact-SQL script:You need to determine the changes that the script has on the environment.How does the script affect the environment? To answer, select the appropriate options in the answer area.NOTE: Each correct selection is worth one point.Hot Area:
HOTSPOT -You are planning the deployment of two new Always On Failover Cluster Instances (FCIs) of Microsoft SQL Server to a single Windows Server Cluster with three nodes. The planned configuration for the cluster is shown in the Server Layout exhibit. (Click the Exhibit button.)The SAN team has configured storage for the cluster and sent the configuration to you in the email shown in the SAN Team Email exhibit. (Click the Exhibit button.)Each node of the cluster has identical local storage available as shown in the Local Storage exhibit. (Click the Exhibit button.)All local storage is on SSD.You need to plan specific configurations for the new cluster.For each of the following statement, select Yes if the statement is true. Otherwise, select No.Hot Area:
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 not have a correct solution.After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.You need to configure a Microsoft SQL Server instance to ensure that a user named Mail1 can send mail by using Database Mail.Solution: You add the DatabaseMailUserRole to Mail1 in the tempdb database.Does the solution meet the goal?
