DP-300 V1

You need to recommend a solution to ensure that the customers can create the database objects. The solution must meet the business goals. What should you include in the recommendation?A . For each customer, grant the customer ddl_admin to the existing schema. B. For each customer, create an additional schema...

You have an Azure subscription that contains the resources shown in the following table. You need to configure a connection between VM1 and MIL. The solution must meet the following requirements: • The connection must be encrypted. • Network latency must be minimized. What should you implement?A . virtual network...

You plan to move two 100-GB databases to Azure. You need to dynamically scale resources consumption based on workloads. The solution must minimize downtime during scaling operations. What should you use?A . An Azure SQL Database elastic pool B. SQL Server on Azure virtual machines C. an Azure SQL Database...

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you...

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.View AnswerAnswer: C Explanation: Scenario: SalesSQLDb1 uses database...

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

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

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

DRAG DROP You have a database named db1. The log for db1 contains the following entry. You need to ensure That db1 can process transactions. View AnswerAnswer:

Topic 4, Contoso Ltd Clothing Store You need to implement the surrogate key for the retail store table. The solution must meet the sales transaction dataset requirements. What should you create?A . a table that has a FOREIGN KEY constraint B. a table the has an IDENTITY property C. a...