Question 141

You configure a long-term retention policy for an Azure SQL database as shown in the exhibit. (Click the Exhibit tab.)

The first weekly backup occurred on January 4, 2020. The dates for the first 10 weekly backups are:
January 4, 2020
January 11, 2020
January 18, 2020
January 25, 2020
February 1, 2020
February 8, 2020
February 15, 2020
February 22, 2020
February 29, 2020
March 7, 2020
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.

Question 142

You have an Azure virtual machine named Server1 that has Microsoft SQL Server installed. Server1 contains a database named DB1.
You have a logical SQL server named ASVR1 that contains an Azure SQL database named ADB1.
You plan to use SQL Data Sync to migrate DB1 from Server! to ASVR1.
You need to prepare the environment for the migration. The solution must ensure that the connection from Server1 to ADB1 does NOT use a public endpoint.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Question 143

What should you implement to meet the disaster recovery requirements for the PaaS solution?
  • Question 144

    You have SQL Server 2019 on an Azure virtual machine that runs Windows Server 2019. The virtual machine
    has 4 vCPUs and 28 GB of memory.
    You scale up the virtual machine to 16 vCPUSs and 64 GB of memory.
    You need to provide the lowest latency for tempdb.
    What is the total number of data files that tempdb should contain?
  • Question 145

    Task 10
    You need to protect all the databases on sql37006S95 from SQL injection attacks.