DP-300 exam

DRAG DROP You plan to create a table in an Azure Synapse Analytics dedicated SQL pool. Data in the table will be retained for five years. Once a year, data that is older than five years will be deleted. You need to ensure that the data is distributed evenly across...

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

HOTSPOT You have an Azure SQL database named that contains a table named Table1. You run a query to bad data into Table1. The performance Of Table1 during the load operation are shown in exhibit. View AnswerAnswer:

Topic 5, Misc. Questions You have an Azure SQL database named DB1. You need to encrypt DB1. The solution must meet the following requirements: • Encrypt data in motion. • Support comparison operators. • Provide randomized encryption. What should you include in the solution?A . Always Encrypted B. column-level encryption...

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

HOTSPOT You configure a long-term retention policy for an Azure SQL database as shown in the exhibit. (Click the Exhibit tab.) The first weekly backup occurred on January 4, 2020. The dates for the first 10 weekly backups are: ✑ January 4, 2020 ✑ January 11, 2020 ✑ January 18,...

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

You have SQL Server on an Azure virtual machine. You need to add a 4-TB volume that meets the following requirements: ✑ Maximizes IOPs ✑ Uses premium solid state drives (SSDs) What should you do?A . Attach two mirrored 4-TB SSDs. B. Attach a stripe set that contains four 1-TB...

HOTSPOT You have an Azure SQL database named db1 on a server named server1. You use Query Performance Insight to monitor db1. You need to modify the Query Store configuration to ensure that performance monitoring data is available as soon as possible. Which configuration setting should you modify and which...