DP-300 exam

You have an Azure Databricks resource. You need to log actions that relate to changes in compute for the Databricks resource. Which Databricks services should you log?A . clusters B. jobs C. DBFS D. SSH E. workspaceView AnswerAnswer: E Explanation: Cloud Provider Infrastructure Logs. Databricks logging allows security and admin...

HOTSPOT You have an Azure SQL database. You have a query and the associated execution plan as shown in the following exhibit. Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one...

You manage an enterprise data warehouse in Azure Synapse Analytics. Users report slow performance when they run commonly used queries. Users do not report performance changes for infrequently used queries. You need to monitor resource utilization to determine the source of the performance issues. Which metric should you monitor?A ....

Topic 2, Contoso Ltd Case study This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to...

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

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 an Azure SQL managed instance. You need to enable SQL Agent Job email notifications. What should you do?A . Use the Agent XPs option. B. Enable the SQL Server Agent. C. Run the sp_configure command. D. Run the sp set_agent properties command.View AnswerAnswer: C

DRAG DROP You have an Azure subscription. You plan to deploy a new Azure virtual machine that will host a Microsoft SQL Server instance. You need to configure the disks on the virtual machine. The solution must meet the following requirements: • Minimize latency for transaction logs. • Minimize the...

HOTSPOT You have an Azure subscription that is linked to a hybrid Azure Active Directory (Azure AD) tenant. The subscription contains an Azure Synapse Analytics SQL pool named Pool1. You need to recommend an authentication solution for Pool1. The solution must support multi-factor authentication (MFA) and database-level authentication. Which authentication...

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