Question 281
Open question ↗What should you use to migrate the PostgreSQL database?
- A.Azure Data Box
- B.AzCopy
- C.Azure Database Migration Service
- D.Azure Site Recovery
DP-300 Practice Questions — Page 29
Question 282
Open question ↗You need to implement a solution to notify the administrators. The solution must meet the monitoring requirements.
What should you do?
- A.Create an Azure Monitor alert rule that has a static threshold and assign the alert rule to an action group.
- B.Add a diagnostic setting that logs QueryStoreRuntimeStatistics and streams to an Azure event hub.
- C.Add a diagnostic setting that logs Timeouts and streams to an Azure event hub.
- D.Create an Azure Monitor alert rule that has a dynamic threshold and assign the alert rule to an action group.
Question 283
Open question ↗You need to implement statistics maintenance for SalesSQLDb1. The solution must meet the technical requirements.
Which four 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:
Question 284
Open question ↗You need to provide an implementation plan to configure data retention for ResearchDB1. The solution must meet the security and compliance requirements.
What should you include in the plan?
- A.Configure the Deleted databases settings for ResearchSrv01.
- B.Deploy and configure an Azure Backup server.
- C.Configure the Advanced Data Security settings for ResearchDB1.
- D.Configure the Manage Backups settings for ResearchSrv01.
Question 285
Open question ↗What should you do after a failover of SalesSQLDb1 to ensure that the database remains accessible to SalesSQLDb1App1?
- A.Configure SalesSQLDb1 as writable.
- B.Update the connection strings of SalesSQLDb1App1.
- C.Update the firewall rules of SalesSQLDb1.
- D.Update the users in SalesSQLDb1.
Question 286
Open question ↗What should you implement to meet the disaster recovery requirements for the PaaS solution?
- A.Availability Zones
- B.failover groups
- C.Always On availability groups
- D.geo-replication
Question 287
Open question ↗You need to implement authentication for ResearchDB1. The solution must meet the security and compliance requirements.
What should you run as part of the implementation?
- A.CREATE LOGIN and the FROM WINDOWS clause
- B.CREATE USER and the FROM CERTIFICATE clause
- C.CREATE USER and the FROM LOGIN clause
- D.CREATE USER and the ASYMMETRIC KEY clause
- E.CREATE USER and the FROM EXTERNAL PROVIDER clause
Question 288
Open question ↗You are planning the migration of the SERVER1 databases. The solution must meet the business requirements.
What should you include in the migration plan? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Question 289
Open question ↗You need to recommend the appropriate purchasing model and deployment option for the 30 new databases. The solution must meet the technical requirements and the business requirements.
What should you recommend? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Question 290
Open question ↗You need to configure user authentication for the SERVER1 databases. The solution must meet the security and compliance requirements.
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:
