DP-300 exam

HOTSPOT You have an Azure data factory that has two pipelines named PipelineA and PipelineB. PipelineA has four activities as shown in the following exhibit. PipelineB has two activities as shown in the following exhibit. You create an alert for the data factory that uses Failed pipeline runs metrics for...

You have an Azure SQL database named DB1. You need to display the estimated execution plan of a query by using the query editor in the Azure portal. What should you do first?A . Run the set showplan_all Transact-SQL statement. B. For DB1, set QUERY_CAPTURE_MODE of Query Store to All....

HOTSPOT You have an Azure subscription that contains a resource group named RG1. RG1 contains an instance of SQL Server on Azure Virtual Machines named SQL You need to use PowerShell to enable and configure automated patching for SQL. The solution must include both SQL Server and Windows security updates....

You plan to move two 100-GB databases to Azure. You need to dynamically scale resources consumption based on workloads. The solution must minimize downtime during scaling operations. What should you use?A . An Azure SQL Database elastic pool B. SQL Server on Azure virtual machines C. an Azure SQL Database...

Based on the PaaS prototype, which Azure SQL Database compute tier should you use?A . Business Critical 4-vCore B. Hyperscale C. General Purpose v-vCore D. 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

HOTSPOT You need to implement the monitoring of SalesSQLDb1. The solution must meet the technical requirements. How should you collect and stream metrics? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Box 1: The server, the elastic...

You have an Azure SQL database named DB1. You need to display the estimated execution plan of a query by using the query editor in the Azure portal. What should you do first?A . Run the set showplan_all Transact-SQL statement. B. For DB1, set QUERY_CAPTURE_MODE of Query Store to All....

You create five Azure SQL Database instances on the same logical server. In each database, you create a user for an Azure Active Directory (Azure AD) user named User1. User1 attempts to connect to the logical server by using Azure Data Studio and receives a login error. You need to...

HOTSPOT You need to design an analytical storage solution for the transactional data. The solution must meet the sales transaction dataset requirements. What should you include in the solution? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation:...

HOTSPOT You have an Azure Synapse Analytics dedicated SQL pool named Pool1 and an Azure Data Lake Storage Gen2 account named Account1. You plan to access the files in Account1 by using an external table. You need to create a data source in Pool1 that you can reference when you...