- All Exams Instant Download
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
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...
For each action, which option should you use?
HOTSPOT You manage a Microsoft SQL Server instance. You have a user named User1. You need to grant the minimum permissions necessary to allow User1 to review audit logs. For each action, which option should you use? To answer, select the appropriate options in the answer area. View AnswerAnswer: Explanation:...
How should you complete the Transact-SQL statement?
HOTSPOT You have a Microsoft SQL Server instance that hosts a database named DB1 that contains 800 gigabyte (GB) of data. The database is used 24 hours each day. You implement indexes and set the value of the Auto Update Statistics option set to True. Users report that queries take...
Which permission should you grant?
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. Information and details provided in a question...
Which server instance should you configure to perform each action?
HOTSPOT You are planning to deploy log shipping for Microsoft SQL Server and store all backups on a dedicated fileshare. You need to configure the servers to perform each log shipping step. Which server instance should you configure to perform each action? To answer, select the appropriate server instances in...
Does this meet the goal?
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 goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a...
How should you complete the Transact-SQL statement?
DRAG DROP 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 question presents a different goal and answer choices, but the text of the scenario is exactly the same in each question in...
Which Transact-SQL statement should you run?
You have a database named DB1 that stores more than 700 gigabyte (GB) of data and serves millions of requests per hour. Queries on DB1 are taking longer than normal to complete. You run the following Transact-SQL statement: SELECT * FROM sys.database_query_store_options You determine that the Query Store is in...
How should you complete the Transact-SQL statement?
DRAG DROP You have a test server that contains a database named DB1. Backups of the database are written to a single backup device. The backup device has a full, differential, and transaction log backup. You discover that the database is damaged. You restore the database to the point at...
Does the solution meet the goal?
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...
