← Back to exam page

70-765 – Provisioning SQL Databases

Loading demo links...

Showing 13–15 of 15 questions

Question 13 (Implementing SQL in Azure)

You create a new Microsoft Azure subscription.

You need to create a group of Azure SQL databases that share resources.

Which cmdlet should you run first?

Select an option, then click Submit answer.

  • ○

    New-AzureRmAvailabilitySet
  • ○

    New-AzureRmLoadBalancer
  • ○

    New-AzureRmSqlDatabaseSecondary
  • ○

    New-AzureRmSqlElasticPool
  • ○

    New-AzureRmVM
  • ○

    New-AzureRmSqlServer
  • ○

    New-AzureRmSqlDatabaseCopy
  • ○

    New-AzureRmSqlServerCommunicationLink
Question 14 (Implementing SQL in Azure)

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 apply only to that question.

You have deployed several GS-series virtual machines (VMs) in Microsoft Azure. You plan to deploy Microsoft SQL Server in a development environment. Each VM has a dedicated disk for backups.

You need to backup a database to the local disk on a VM. The backup must be replicated to another region.

Which storage option should you use?

Select an option, then click Submit answer.

  • ○

    Premium P10 disk storage
  • ○

    Premium P20 disk storage
  • ○

    Premium P30 disk storage
  • ○

    Standard locally redundant disk storage
  • ○

    Standard geo-redundant disk storage
  • ○

    Standard zone redundant blob storage
  • ○

    Standard locally redundant blob storage
  • ○

    Standard geo-redundant blob storage
Question 15 (Manage Storage)

You have an on-premises SQL Server database named DB1 that contains a table named TB1. TB1 is stretched to Microsoft Azure.

A catastrophic hardware failure occurs on the on-premises SQL server.

You deploy a new on-premises server and restore all databases to the new server.

You need to resume Stretch Database operations to Azure.

Which statements should you execute?

Select an option, then click Submit answer.

  • ○

    Option A
  • ○

    Option B
  • ○

    Option C
  • ○

    Option D