DP-300 V1

A data engineer creates a table to store employee information for a new application. All employee names are in the US English alphabet. All addresses are locations in the United States. The data engineer uses the following statement to create the table. You need to recommend changes to the data...

You have SQL Server 2019 on an Azure virtual machine that runs Windows Server 2019. The virtual machine has 4 vCPUs and 28 GB of memory. You scale up the virtual machine to 16 vCPUSs and 64 GB of memory. You need to provide the lowest latency for tempdb. What...

You have a version-8.0 Azure Database for MySQL database. You need to identify which database queries consume the most resources. Which tool should you use?A . Query StoreB . MetricsC . Query Performance InsightD . AlertsView AnswerAnswer: A Explanation: The Query Store feature in Azure Database for MySQL provides a...

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

DRAG DROP You have a new Azure SQL database named DB1 on an Azure SQL server named AzSQL1. The only user who was created is the server administrator. You need to create a contained database user in DB1 who will use Azure Active Directory (Azure AD) for authentication. Which three...

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 deleteView AnswerAnswer: C Explanation: The lifecycle...

You have an Azure SQL Database managed instance named SQLMI1. A Microsoft SQL Server Agent job runs on SQLMI1. You need to ensure that an automatic email notification is sent once the job completes. What should you include in the solution?A . From SQL Server Configuration Manager (SSMS), enable SQL...

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

You have a new Azure SQL database. The database contains a column that stores confidential information. You need to track each time values from the column are returned in a query. The tracking information must be stored for 365 days from the date the query was executed. Which three actions...

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