DP-300 V1

What should you implement to meet the disaster recovery requirements for the PaaS solution?A . Availability ZonesB . failover groupsC . Always On availability groupsD . geo-replicationView AnswerAnswer: B Explanation: Scenario: In the event of an Azure regional outage, ensure that the customers can access the PaaS solution with minimal...

You need to recommend a solution that will enable remote developers to access DB1 and DB2. The solution must support the planned changes and meet the secunty requirements. What should you include in the recommendation?A . a public endpoint via a database-level firewall ruleB . a private endpointC . a...

You have 10 Azure virtual machines that have SQL Server installed. You need to implement a backup strategy to ensure that you can restore specific databases to other SQL Server instances. The solution must provide centralized management of the backups. What should you include in the backup strategy?A . Automated...

You need to identify the cause of the performance issues on SalesSQLDb1. Which two dynamic management views should you use? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.A . sys.dm_pdw_nodes_tran_locksB . sys.dm_exec_compute_node_errorsC . sys.dm_exec_requestsD . sys.dm_cdc_errorsE . sys.dm_pdw_nodes_os_wait_statsF . sys.dm_tran_locksView AnswerAnswer: AE...

HOTSPOT You need to recommend which service and target endpoint to use when migrating the databases from SVR1 to Instance1. The solution must meet the availability requirements. What should you recommend? To answer, select the appropriate options in the answer area. NOTE Each correct selection is worth one point. View...

SIMULATION Task 10 You need to protect all the databases on sql37006S95 from SQL injection attacks.View AnswerAnswer: SQL injection attacks are a type of cyberattack that exploit a vulnerability in the application code that interacts with the database. An attacker can inject malicious SQL statements into the user input, such...

HOTSPOT You have an Azure SQL database named DB1 that contains two tables named Table1 and Table2. Both tables contain a column named a Column1. Column1 is used for joins by an application named App1. You need to protect the contents of Column1 at rest, in transit, and in use....

HOTSPOT You have SQL Server on an Azure virtual machine. You review the query plan shown in the following exhibit. For each of the following statements, select yes if the statement is true. Otherwise, select no. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Reference: https://docs.microsoft.com/en-us/sql/relational-databases/performance/monitoring-performance-by-using-the-query-store

DRAG DROP 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. View AnswerAnswer: Explanation:...

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...