×

Special Offer! November Sale at DumpsCity! Get 20% Off on All Certification Exam Questions. Use Code: DC20OFF

Free Microsoft DP-300 Exam Questions

Try our Free Demo Practice Tests for Comprehensive DP-300 Exam Preparation

  • Microsoft DP-300 Exam Questions
  • Provided By: Microsoft
  • Exam: Administering Microsoft Azure SQL Solutions
  • Certification: Microsoft Azure
  • Total Questions: 454
  • Updated On: Nov 13, 2024
  • Rated: 4.9 |
  • Online Users: 908
Page No. 1 of 91
Add To Cart
  • Question 1
    • You have an Azure subscription that contains the resources shown in the following table.


      App1 experiences transient connection errors and timeouts when it attempts to access db1 after extended periods of inactivity.

      You need to modify db1 to resolve the issues experienced by App1 as soon as possible, without considering immediate costs.

      What should you do?


      Answer: D
  • Question 2
    • You have two on-premises Microsoft SQL Server 2019 instances named SQL1 and SQL2.

      You need to migrate the databases hosted on SQL1 to Azure. The solution must meet the following requirements:

      • The service that hosts the migrated databases must be able to communicate with SQL2 by using linked server connections.

      • Administrative effort must be minimized.

      What should you use to host the databases?


      Answer: C
  • Question 3
    • To optimize resource consumption for different types of workloads in Azure SQL Database, what should you configure?

      Answer: B
  • Question 4
    • You are building a database backup solution for a SQL Server database hosted on an Azure virtual machine.

      In the event of an Azure regional outage, you need to be able to restore the database backups. The solution must minimize costs.

      Which type of storage accounts should you use for the backups?


      Answer: D
  • Question 5
    • You have an on-premises datacenter that contains a 14-TB Microsoft SQL Server database.

      You plan to create an Azure SQL managed instance and migrate the on-premises database to the new instance.

      Which three service tiers support the SQL managed instance? Each correct answer presents a complete solution.

      NOTE: Each correct selection is worth one point.


      Answer: A,B,C
PAGE: 1 - 91
Add To Cart

© Copyrights Dumpscity 2024. All Rights Reserved

We use cookies to ensure your best experience. So we hope you are happy to receive all cookies on the Dumpscity.