DP-300 practice questions 51–60

1. Question 51 · 354 in bank

   You have an on-premises Microsoft SQL Server 2019 database named SQL1 that uses merge replication. You need to migrate SQL1 to Azure. Which service should you use?

   • AAzure SQL Edge
   • BAzure SQL Database
   • CSQL Server on Azure Virtual Machines
   • DAzure SQL Managed Instance

   Show answer

   Answer: C

   Explanation

   C. SQL Server on Azure Virtual Machines Here's why this option is suitable: SQL Server on Azure Virtual Machines: This option is essentially IaaS (Infrastructure as a Service), which means you get a full virtual machine with full control over the SQL Server instance. It supports SQL Server features just like an on-premises server would, including merge replication. This allows for a smoother migration of databases that rely on specific SQL Server features that are not supported by PaaS (Platform as a Service) options. The other options have limitations regarding merge replication: A. Azure SQL Edge: This service is designed for edge computing scenarios and IoT devices, not for general database hosting. B. Azure SQL Database: This is a PaaS offering that does not support SQL Server's merge replication. D. Azure SQL Managed Instance: While it is the PaaS offering that comes closest to the full capabilities of SQL Server, it still does not support merge replication as of my last update in April 2023.

   Source: Adapted from community discussion — [Removed]

   References

   • Microsoft Learn
   • Microsoft Learn

   Next question

2. Question 52 · 354 in bank

   You have an on-premises datacenter that contains a 2-TB Microsoft SQL Server 2019 database named DB1. You need to recommend a solution to migrate DB1 to an Azure SQL managed instance. The solution must minimize downtime and administrative effort. What should you include in the recommendation?

   • ALog Replay Service (LRS)
   • Blog shipping
   • Ctransactional replication
   • DSQL Data Sync

   Show answer

   Answer: A

   Explanation

   B. Log shipping: While log shipping could be used for migration and would involve less administrative effort than some other methods, it typically incurs more downtime during the cutover to the new environment because it is not as seamless as LRS. C. Transactional replication: Transactional replication is generally used for keeping data synchronized across SQL Server instances. It is not designed for one-time database migrations and can be complex to set up for this purpose. D. SQL Data Sync: This service is used to synchronize data across multiple SQL databases and is not optimized for one-time migrations of large databases, as it can be slower and less reliable than LRS for this use case.

   Source: Adapted from community discussion — [Removed]

   References

   • Microsoft Learn
   • Microsoft Learn

   Next question

3. Question 53 · 354 in bank

   You have an Azure subscription. You plan to deploy an instance of SQL Server on Azure Virtual Machines that supports Write Accelerator. Which virtual machine series should you use?

   • AE-series
   • BG-series
   • CH-series
   • DM-series

   Show answer

   Answer: D

   Explanation

   Write Acceleration is a disk feature that is only available for the M-Series Virtual Machines (VMs). The purpose of write acceleration is to improve the I/O latency of writes against Azure Premium Storage when you need single digit I/O latency due to high volume mission critical OLTP workloads or data warehouse environments. https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/storage-configuration?view=azuresql&tabs=windows2016

   Source: Adapted from community discussion — igorclapa

   References

   • Microsoft Learn
   • azure.microsoft.com documentation
   • Microsoft Learn

   Next question

4. Question 54 · 354 in bank

   You have an on-premises Microsoft SQL Server 2019 instance that hosts a database named DB1. You have an Azure subscription that contains an Azure SQL database named SQLDB1. You need to replicate DB1 to SQLDB1. Which type of replication should you use?

   • Atransactional
   • Bpeer-to-peer
   • Csnapshot
   • Dmerge

   Show answer

   Answer: A

   Explanation

   You can configure an Azure SQL Database as the push subscriber in a one-way transactional or snapshot replication topology. https://learn.microsoft.com/en-us/azure/azure-sql/database/replication-to-sql-database?view=azuresql

   Source: Adapted from community discussion — igorclapa

   References

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   Next question

5. Question 55 · 354 in bank

   HOTSPOT - You have two on-premises servers that run Windows Server 2019 and host a Microsoft SQL server 2017 Always On availability group named AG1. AG1 contains a single database named DB1. You have an Azure subscription. The subscription contains a virtual machine named VM1 that runs Linux. You need to migrate DB1 to a SQL Server 2019 instance on VM1. The solution must minimize the downtime of DB1 during the migration. What should you do? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one-point.

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   Disregard my previous discussion, Answer that makes sense here is 1) Create a SQL 2019 AG on VM1 and then use 2) Distributed availability group for actual cutover/migration

   Source: Adapted from community discussion — bsk1983

   References

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   

   Next question

6. Question 56 · 354 in bank

   DRAG DROP - You have an Azure SQL database named DB1. You need to create a partitioned table in DB1. Which three objects should you create in sequence? To answer, move the appropriate objects from the list of objects to the answer area and arrange them in the correct order.

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   A partition function A partition scheme A table. I think you need to have partioned table created before creating an aligned index. As its Azure sql database, it DOESNOT support multiple filegroup's. I believe above is the correct sequence

   Source: Adapted from community discussion — bsk1983

   References

   • Microsoft Learn
   • Microsoft Learn

   

   Next question

7. Question 57 · 354 in bank

   HOTSPOT - You have an on-premises Microsoft SQL Server 2016 server named Server1 that contains a database named DB1. You need to perform an online migration of DB1 to an Azure SQL Database managed instance by using Azure Database Migration Service. How should you configure the backup of DB1? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area:

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   Box 1: Full and log backups only Make sure to take every backup on a separate backup media (backup files). Azure Database Migration Service doesn't support backups that are appended to a single backup file. Take full backup and log backups to separate backup files. Box 2: WITH CHECKSUM - Azure Database Migration Service uses the backup and restore method to migrate your on-premises databases to SQL Managed Instance. Azure Database Migration Service only supports backups created using checksum. Incorrect Answers: NOINIT Indicates that the backup set is appended to the specified media set, preserving existing backup sets. If a media password is defined for the media set, the password must be supplied. NOINIT is the default. UNLOAD - Specifies that the tape is automatically rewound and unloaded when the backup is finished. UNLOAD is the default when a session begins. Reference: https://docs.microsoft.com/en-us/azure/dms/known-issues-azure-sql-db-managed-instance-online

   

   Next question

8. Question 58 · 354 in bank

   DRAG DROP - You have an Azure subscription that contains an instance of SQL Server on Azure Virtual Machines named SQLVM1 and a virtual machine named Server1 that runs Windows Server. SQLVM1 and Server1 are joined to an Active Directory Domain Services (AD DS) domain. Server1 hosts a file share named Share1. You need to ensure that a SOL Server Agent job step on SQLVM1 can access the files in Share1. The solution must use the principle of least privilege. Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   References

   • Microsoft Learn

   

   Next question

9. Question 59 · 354 in bank

   You have an Azure subscription. You need to deploy an instance of SQL Server on Azure Virtual Machines. The solution must meet the following requirements: • Custom performance configuration, such as IOPS, capacity, and throughout, must be supported. • Costs must be minimized. Which type of disk should you include in the solution?

   • APremium SSD v2
   • BPremium SSD
   • CStandard SSD
   • DUltra SSD

   Show answer

   Answer: A

   Explanation

   https://learn.microsoft.com/en-us/azure/virtual-machines/disks-types performance-sensitive workloads that consistently require low latency and high IOPS and throughput and less cost than Ultra disk is Premium SSD v2. Also, ultra disk is mostly for IO-intensive workloads.

   Source: Adapted from community discussion — yyc585

   References

   • Microsoft Learn

   Next question

10. Question 60 · 354 in bank

    Select 3

    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.

    • AGeneral Purpose Standard
    • BBusiness Critical Memory Optimized Premium
    • CGeneral Purpose Premium
    • DBusiness Critical Premium
    • EBusiness Critical Standard

    Show answer

    Answer: ABC

    Explanation

    Answer is correct. Only Memory optimized premium-series in Business Critical tier supports up to 16TB, unlike all three series for General Purpose. https://learn.microsoft.com/en-us/sql/ssms/agent/create-a-sql-server-agent-proxy?view=sql-server-ver16

    Source: Adapted from community discussion — MJamesP

    References

    • Microsoft Learn
    • Microsoft Learn
    • azure.microsoft.com documentation

    Next question

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

DP-300 practice, question 51. 354 questions available.