DP-300 practice questions 351–354

1. Question 351 · 354 in bank

   HOTSPOT - You have two Azure virtual machines named VM1 and VM2 that run Windows Server 2019. VM1 and VM2 each host a default Microsoft SQL Server 2019 instance. VM1 contains a database named DB1 that is backed up to a file named D:\DB1.bak. You plan to deploy an Always On availability group that will have the following configurations: ✑ VM1 will host the primary replica of DB1. ✑ VM2 will host a secondary replica of DB1. You need to prepare the secondary database on VM2 for the availability group. How should you complete the Transact-SQL statement? To answer, select the appropriate options in the answer area. 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: RESTORE - Use RESTORE WITH NORECOVERY for every restore operation. BOX 2: NORECOVERY - Reference: https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/manually-prepare-a-secondary-database-for-an-availability-group-sql-server? view=sql-server-ver15

   Source: Adapted from community discussion — txustopo

   

   Next question

2. Question 352 · 354 in bank

   DRAG DROP - You have an Azure Active Directory (Azure AD) tenant named contoso.com that contains a user named user1@contoso.com and an Azure SQL managed instance named SQLMI1. You need to ensure that user1@contoso.com can create logins in SQLMI1 that map to Azure AD service principals. 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. Select and Place:

   

   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: Grant SQLMI1 read access to Azure AD Give required permission. Box 2: Run CREATE LOGIN.. Create a login. Box 3: RUN ALTER SERVER.. Add a user to the login created in step 2. Reference: https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/aad-security-configure-tutorial

   References

   • Microsoft Learn
   • Microsoft Learn

   

   Next question

3. Question 353 · 354 in bank

   What should you use to migrate the PostgreSQL database?

   • AAzure Data Box
   • BAzCopy
   • CAzure Database Migration Service
   • DAzure Site Recovery

   Show answer

   Answer: C

   Explanation

   Database Migration Service is a fully managed service designed to enable seamless migrations from multiple database sources to Azure data platforms with minimal downtime (online migrations). You can use Azure Database Migration Service to migrate the databases from an on-premises PostgreSQL instance to Azure Database for PostgreSQL with minimal downtime to the application. Note: The on-premises datacenter contains a PostgreSQL server that has a 50-TB database. Move the PostgreSQL database to Azure Database for PostgreSQL during the next six months. Downtime during the PostgreSQL database migration must be minimized. Reference: https://docs.microsoft.com/en-us/azure/dms/dms-overview https://docs.microsoft.com/en-us/azure/dms/tutorial-postgresql-azure-postgresql-online-portal

   Source: Adapted from community discussion — amazonalex

   References

   • Microsoft Learn
   • Microsoft Learn

   Next question

4. Question 354 · 354 in bank

   You need to implement a solution to notify the administrators. The solution must meet the monitoring requirements. What should you do?

   • ACreate an Azure Monitor alert rule that has a static threshold and assign the alert rule to an action group.
   • BAdd a diagnostic setting that logs QueryStoreRuntimeStatistics and streams to an Azure event hub.
   • CAdd a diagnostic setting that logs Timeouts and streams to an Azure event hub.
   • DCreate an Azure Monitor alert rule that has a dynamic threshold and assign the alert rule to an action group.

   Show answer

   Answer: D

   References

   • Microsoft Learn

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

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