DP-300 Online Practice Questions and Answers
You are evaluating the business goals.
Which feature should you use to provide customers with the required level of access based on their service agreement?
A. dynamic data masking
B. Conditional Access in Azure
C. service principals
D. row-level security (RLS)
You need to implement a solution to notify the administrators. The solution must meet the monitoring requirements. What should you do?
A. Create an Azure Monitor alert rule that has a static threshold and assign the alert rule to an action group.
B. Add a diagnostic setting that logs QueryStoreRuntimeStatistics and streams to an Azure event hub.
C. Add a diagnostic setting that logs Timeouts and streams to an Azure event hub.
D. Create an Azure Monitor alert rule that has a dynamic threshold and assign the alert rule to an action group.
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 answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You have an Azure Data Lake Storage account that contains a staging zone.
You need to design a daily process to ingest incremental data from the staging zone, transform the data by executing an R script, and then insert the transformed data into a data warehouse in Azure Synapse Analytics.
Solution: You schedule an Azure Databricks job that executes an R notebook, and then inserts the data into the data warehouse.
Does this meet the goal?
A. Yes
B. No
You have SQL Server on an Azure virtual machine that contains a database named DB1.
You view a plan summary that shows the duration in milliseconds of each execution of query 1178902 as shown in the following exhibit:
What should you do to ensure that the query uses the execution plan which executes in the least amount of time?
A. Force the query execution plan for plan 1221065.
B. Run the DBCC FREEPROCCACHE command.
C. Force the query execution plan for plan 1220917.
D. Disable parameter sniffing.
You have an Azure virtual machine named VM1 on a virtual network named VNet1. Outbound traffic from VM1 to the internet is blocked.
You have an Azure SQL database named SqlDb1 on a logical server named SqlSrv1.
You need to implement connectivity between VM1 and SqlDb1 to meet the following requirements:
1.
Ensure that VM1 cannot connect to any Azure SQL Server other than SqlSrv1.
2.
Restrict network connectivity to SqlSrv1. What should you create on VNet1?
A. a VPN gateway
B. a service endpoint
C. a private endpoint
D. an ExpressRoute gateway
You have an Azure SQL managed instance named MI1.
You need to implement automatic tuning for the databases of MI1.
What should you do?
A. Use the REST API to call the patch operation and modify the AutomaticTuningServerMode property.
B. Use Transact-SQL to enable the force_last_good_plan option.
C. From the Azure portal, configure automatic tuning.
You have an Azure virtual machine named VM1 that runs Windows Server 2022 and hosts a Microsoft SQL Server 2019 instance named SQL1. You need to configure SQL! to use mixed mode authentication. Which procedure should you run?
A. sp_addremoteIogin
B. xp_instance_regwrite
C. sp_cnarge_users_login
D. xp_grant_login
You have an Azure subscription.
You plan to deploy an instance of SQL Server on Azure Virtual Machines by using an Azure Marketplace image.
You need to register the SQL Server IaaS Agent extension (SqlIaasExtension). The solution must meet the following requirements:
1.
Install critical updates for SQL Server automatically.
2.
Minimize performance impact on the virtual machine. Which management mode should you select?
A. full
B. lightweight
C. NoAgent
HOTSPOT
You have an Azure SQL database named that contains a table named Table1.
You run a query to bad data into Table1.
The performance Of Table1 during the load operation are shown in exhibit.
Hot Area:
HOTSPOT
You have an Azure SQL database named DB1 in the General Purpose service tier.
You need to monitor DB1 by using SQL Insights.
What should you include in the solution? To answer, select the appropriate options in the answer area.
Hot Area:
