Free Microsoft 70-764 Exam Dumps Questions & Answers

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 wilt not appear in the review screen.
You have a database named db1 that contains a table named Table1.
You need to audit all updates to Table.
Solution: From Local Group Policy Editor, you configure auditing for object access.
Does this meet the goal?

• A.  Yes
• B.  No

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 support an application that stores data in a Microsoft SQL Server database. You have a query that returns data for a report that users run frequently.
The query optimizer sometimes generates a poorly-performing plan for the query when certain parameters are used. You observe that this is due to the distribution of data within a specific table that the query uses.
You need to ensure that the query optimizer always uses the query plan that you prefer.
Solution: You force the desired plan.
Does the solution meet the goal?

• A.  Yes
• B.  No

You have two servers named SQL1 and SQL2 that have SQL Server 2012 installed.
SQL1 contains a database that is mirrored asynchronously to SQL2. The database contents are updated once a month.
You need to upgrade the database to SQL Server 2014. The solution must minimize downtime. Which upgrade steps should you recommend? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Correct Answer:

Explanation

References:https://docs.microsoft.com/en-us/sql/database-engine/database-mirroring/upgrading-mirrored-instanc

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 have a data warehouse that stores sales data. One fact table has 100 million rows.
You must reduce storage needs for the data warehouse.
You need to implement a solution that uses column-based storage and provides real-time analytics for the operational workload.
Solution: You remove any clustered indexes and load the table for processing.
Does the solution meet the goal?

• A.  Yes
• B.  No

You are designing a SQL Server database for an order fulfillment system. You create a table named Sales.Orders by using the following script:

Each order is tracked by using one of the following statuses:
* Fulfilled
* Shipped
* Ordered
* Received
You need to design the database to ensure that you can retrieve the status of an order on a given date.
The solution must ensure that new statuses can be added in the future.
What should you do? More than one answer choice may achieve the goal. Select the BEST answer.

• A.  Create a new table named Sales.OrderStatus that contains three columns named OrderID, StatusDate, and Status. Insert new rows into the table as the order status changes.
• B.  To the Sales.Orders table, add three columns named FulfilledDate, ShippedDate, and ReceivedDate.
  Update the value of each column from null to the appropriate date as the order status changes.
• C.  Implement change data capture on the Sales.Orders table.
• D.  To the Sales.Orders table, add a column named Status that will store the order status. Update the Status column as the order status changes.