← Back to exam page

70-765 – Provisioning SQL Databases

Loading demo links...

Showing 10–12 of 15 questions

Question 10 (Manage Storage)

You have a database named DB1 that contains a table named Table1. Table1 has a non-clustered index named index1.

You discover that index1 is corrupt.

You need to repair index1.

Which statement should you execute?

Select an option, then click Submit answer.

  • ○

    DBCC CHECKDB ('db1', REPAIR_FAST)
  • ○

    ALTER INDEX indx1 ON table1 REBUILD WITH (ONLINE-ON)
  • ○

    ALTER INDEX index1 ON table1 REORGANIZE
  • ○

    DBCC CHECKDB ('db1', DATA_PURITY)
Question 11 (Implementing SQL in Azure)

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 are migrating an on-premises Microsoft SQL Server instance to SQL Server on a Microsoft Azure virtual machine. The instance has 30 databased that consume a total of 2 TB of disk space. The instance sustains more than 30,000 transactions per second.

You need to provision storage for the virtual machine. The storage must be able to support the same load as the on-premises deployment.

Solution: You create 30 storage accounts that each has one container. You create a VHD in each container.

Does this meet the goal?

Select an option, then click Submit answer.

  • ○

    Yes
  • ○

    No
Question 12 (Manage databases and instances)

You have Microsoft SQL Server on a Microsoft Azure virtual machine.

You discover that queries take longer than expected to execute. You also find that the top wait type for the SQL Server instance is ASYNC_NETWORK_IO.

You need to resolve the performance issue.

What should you do?

Select an option, then click Submit answer.

  • ○

    Increase the number of processor cores for the virtual machine
  • ○

    Create any missing indexes
  • ○

    Modify the application code to remove row-by-row processing
  • ○

    Allocate more memory to the SQL Server instance