DP-300 exam

You have 40 Azure SQL databases, each for a different customer. All the databases reside on the same Azure SQL Database server. You need to ensure that each customer can only connect to and access their respective database. Which two actions should you perform? Each correct answer presents part of...

HOTSPOT You have an Azure SQL database named db1. You need to retrieve the resource usage of db1 from the last week. How should you complete the statement? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Box...

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

You have an Azure data solution that contains an enterprise data warehouse in Azure Synapse Analytics named DW1. Several users execute adhoc queries to DW1 concurrently. You regularly perform automated data loads to DW1. You need to ensure that the automated data loads have enough memory available to complete quickly...

HOTSPOT You have an Azure SQL database named DB1. The automatic tuning options for DB1 are configured as shown in the following exhibit. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation:...

Topic 4, Misc. Questions You are designing an enterprise data warehouse in Azure Synapse Analytics that will contain a table named Customers. Customers will contain credit card information. You need to recommend a solution to provide salespeople with the ability to view all the entries in Customers. The solution must...

DRAG DROP You need to configure user authentication for the SERVER1 databases. 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 area and arrange them in the correct...

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

What should you do after a failover of SalesSQLDb1 to ensure that the database remains accessible to SalesSQLDb1App1?A . Configure SalesSQLDb1 as writable.B . Update the connection strings of SalesSQLDb1App1.C . Update the firewall rules of SalesSQLDb1.D . Update the users in SalesSQLDb1.View AnswerAnswer: C Explanation: Scenario: SalesSQLDb1 uses database...

HOTSPOT You need to recommend a configuration for ManufacturingSQLDb1 after the migration to Azure. The solution must meet the business requirements. What should you include in the recommendation? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Scenario:...