70-764

70-764 practice questions, page 9 of 14, with answer review and explanations.

Question 41

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:

Question 42

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:

Question 43

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 the dialog box in the answer area. Hot Area:

Question 44

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. Hot Area:

Question 45

You administer a Microsoft SQL Server database named Contoso. You create a stored procedure named Sales.ReviewInvoice by running the following Transact- SQL statement: You need to create a Windows-authenticated login named ContosoSearch and ensure that ContosoSearch can run the Sales.ReviewInvoices stored procedure. Which three Transact-SQL segments should you use to develop the solution? To answer, move the appropriate Transact-SQL segments from the list of Transact- SQL segments to the answer area and arrange them in the correct order. Select and Place: