DP-300 V2

You have an Azure SQL database named DB1 that contains a private certificate named Sales. The private key for Sales is encrypted with a password. You need to change the password for the private key. Which Transact-SQL statement should you run? A) B) C) D) A . Option A B....

You have an on-premises Microsoft SQL Server 2019 instance named SQL1 that hosts a database named db1. You have an Azure subscription that contains an Azure SQL managed instance named MI1 and an Azure Storage account named storage1. You need to ensure that you can back up db1 to storage1....

You are designing a dimension table in an Azure Synapse Analytics dedicated SQL pool. You need to create a surrogate key for the table. The solution must provide the fastest query performance. What should you use for the surrogate key?A . an IDENTITY column B. a GUID column C. a...

Topic 3, ADatum Corporation This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that...

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