DP-300 V0

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 an Azure SQL database that contains a table named Employees. Employees contains a column named Salary. You need to encrypt the Salary column. The solution must prevent database administrators from reading the data in the Salary column and must provide the most secure encryption. Which three...

Topic 4, Contoso Ltd Clothing Store You need to design a data retention solution for the Twitter feed data records. The solution must meet the customer sentiment analytics requirements. Which Azure Storage functionality should you include in the solution?A . time-based retentionB . change feedC . lifecycle managementD . soft...

You have an Azure SQL Database server named sqlsrv1 that hosts 10 Azure SQL databases. The databases perform slower than expected. You need to identify whether the performance issue relates to the use of tempdb on sqlsrv1. What should you do?A . Run Query Store-based queriesB . Review information provided...

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

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 50 Azure SQL databases. You need to notify the database owner when the database settings, such as the database size and pricing tier, are modified in Azure. What should you do?A . Create a diagnostic setting for the activity log that has the Security log enabled.B . For...

You have 10 Azure virtual machines that have SQL Server installed. You need to implement a backup strategy to ensure that you can restore specific databases to other SQL Server instances. The solution must provide centralized management of the backups. What should you include in the backup strategy?A . Automated...

You deploy a database to an Azure SQL Database managed instance. You need to prevent read queries from blocking queries that are trying to write to the database. Which database option should set?A . PARAMETERIZATION to FORCEDB . PARAMETERIZATION to SIMPLEC . Delayed Durability to ForcedD . READ_COMMITTED_SNAPSHOT to ONView...

HOTSPOT You have SQL Server on an Azure virtual machine that contains a database named Db1. You need to enable automatic tuning for Db1. How should you complete the statements? To answer, select the appropriate answer in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer:...