DP-300 V1

Based on the PaaS prototype, which Azure SQL Database compute tier should you use?A . Business Critical 4-vCoreB . HyperscaleC . General Purpose v-vCoreD . ServerlessView AnswerAnswer: A Explanation: There are CPU and Data I/O spikes for the PaaS prototype. Business Critical 4-vCore is needed. Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/reserved-capacity-overview

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

HOTSPOT You have SQL Server on an Azure virtual machine that contains a database named DB1. The database reports a CHECKSUM error. You need to recover the database. How should you complete the statements? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth...

You have a Microsoft SQL Server 2019 database named DB1 that uses the following database-level and instance-level features. ✑ Clustered columnstore indexes ✑ Automatic tuning ✑ Change tracking ✑ PolyBase You plan to migrate DB1 to an Azure SQL database. What feature should be removed or replaced before DB1 can...

You have 20 Azure SQL databases provisioned by using the vCore purchasing model. You plan to create an Azure SQL Database elastic pool and add the 20 databases. Which three metrics should you use to size the elastic pool to meet the demands of your workload? Each correct answer presents...

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 ResearchSrvOLB . Deploy and configure an Azure Backup server.C . Configure the Advanced Data...

HOTSPOT You have an Azure SQL database that contains a table named Customer. Customer has the columns shown in the following table. You plan to implement a dynamic data mask for the Customer_Phone column. The mask must meet the following requirements: ✑ The first six numerals of each customer’s phone...

SIMULATION Task 4 You need to enable change data capture (CDC) for db1.View AnswerAnswer: To enable change data capture (CDC) for db1, you need to run the stored procedure sys.sp_cdc_enable_db in the database context. CDC is a feature that records activity on a database when tables and rows have been...

You have an Azure SQL database named DB3. You need to provide a user named DevUser with the ability to view the properties of DB3 from Microsoft SQL Server Management Studio (SSMS) as shown in the exhibit. (Click the Exhibit tab.) Which Transact-SQL command should you run?A . GRANT SHOWPLAN...

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 clauseB . CREATE USER and the FROM CERTIFICATE clauseC . CREATE USER and the FROM LOGIN clauseD ....