DP-300 exam

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

You need to identify the event_flle target for monitonng DB3 after the migration to Azure SQL Database. The solution must meet the management requirements, What should you use as the event_file target?A . an Azure SQL databaseB . an Azure Blob Storage containerC . a SQL Server filegroupD . an...

You have an Always On availability group deployed to Azure virtual machines. The availability group contains a database named DB1 and has two nodes named SQL1 and SQL2. SQL1 is the primary replica. You need to initiate a full backup of DB1 on SQL2. Which statement should you run?A ....

You have an Azure SQL database. You discover that the plan cache is full of compiled plans that were used only once. You run the select * from sys.database_scoped_configurations Transact-SQL command and receive the results shown in the following table. You need relieve the memory pressure. What should you configure?A...

DRAG DROP You create all of the tables and views for ResearchDB1. You need to implement security for ResearchDB1. The solution must meet the security and compliance requirements. Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer...