← Back to exam page

70-765 – Provisioning SQL Databases

Loading demo links...

Showing 7–9 of 15 questions

Question 7 (Manage databases and instances)

You deploy a new Microsoft Azure SQL Database instance to support a variety of mobile applications and public websites.

You have the following requirements:

You must be able to replicate the database to Azure datacenters in other regions by using geo-replication.

Clients must only connect to the Azure SQL Database by using contained database users.

You must be able to move the database to other servers in the future.

Only applications in the 23.96.52.0-23.96.52.255 IP range are permitted to access the database. The firewall settings for the instance must not provide access to any other Azure services.

You need to configure the firewall settings for the environment.

Which three actions should you perform? Each correct answer presents part of the solution.

Select all that apply, then click Submit answer.

  • ○

    In the Azure portal, enable Allow access to Azure services for the Azure SQL Database server
  • ○

    Run the following Transact-SQL statement:
    EXECUTE sp_set_database_firewall_rule N'Applications', '23.96.52.0', '23.96.52.255'
  • ○

    Run the following Transact-SQL statement:
    EXECUTE sp_set_firewall_rule N'Allow Windows Azure', '0.0.0.0', '0.0.0.0'
  • ○

    Run the following Transact-SQL statement:
    EXECUTE sp_set_firewall_rule N'Applications', '23.96.52.0', '23.96.52.255'
  • ○

    Run the following Transact-SQL statement:
    EXECUTE sp_set_database_firewall_rule N'Allow Windows Azure', '0.0.0.0', '0.0.0.0'
  • ○

    In the Azure portal, disable Allow access to Azure services for the Azure SQL Database server
Question 8 (Manage databases and instances)

You have the databases configured as shown in the following table.

Which two databases can use the Stretch Database feature? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

Select all that apply, then click Submit answer.

  • ○

    DB1
  • ○

    DB2
  • ○

    DB3
  • ○

    DB4
Question 9 (Manage Storage)

You have just completed a new Microsoft SQL Server installation.

You need to configure a new SQL Server Agent alert to send an email to the DBA team for severity 20 errors. Which three actions should you perform? Each correct answer presents part of the solution. (Choose three.)

Select all that apply, then click Submit answer.

  • ○

    Set up SQL Mail.
  • ○

    Define an operator.
  • ○

    Configure a credential object.
  • ○

    Define the alert settings.
  • ○

    Configure a proxy.
  • ○

    Set up an External Events collector.
  • ○

    Set up Database Mail.