DP-300 V3

DRAG DROP You have SQL Server 2019 on an Azure virtual machine that contains an SSISDB database. A recent failure causes the master database to be lost. You discover that all Microsoft SQL Server integration Services (SSIS) packages fail to run on the virtual machine. Which four actions should you...

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

DRAG DROP Your company analyzes images from security cameras and sends alerts to security teams that respond to unusual activity. The solution uses Azure Databricks. You need to send Apache Spark level events, Spark Structured Streaming metrics, and application metrics to Azure Monitor. Which three actions should you perform in...

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 . two Azure SQL Databases in an elastic pool B. two databases hosted in SQL Server on an Azure...

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 FORCED B. PARAMETERIZATION to SIMPLE C. Delayed Durability to Forced D. READ_COMMITTED_SNAPSHOT to ONView...

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

HOTSPOT You have an Azure subscription. You need to deploy an Azure SQL managed instance that meets the following requirements: • Optimize latency. • Maximize the memory-to-vCore ratio. Which service tier and hardware generation should you use? To answer, select the apocopate options in the answer area. NOTE: Each correct...

You have an Azure SQL database. The database contains a table that uses a columnstore index and is accessed infrequently. You enable columnstore archival compression. What are two possible results of the configuration? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.A . Queries...

You have an Azure SQL database. You discover that the plan cache is full of compiled plans that were used only once. You run the select * from sys.database_scoped_configurations Transact-SQL command and receive the results shown in the following table. You need relieve the memory pressure. What should you configure?A...

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