Administering Relational Databases on
DP-300 Free Questions
You are designing a streaming data solution that will ingest variable volumes of data.
You need to ensure that you can change the partition count after creation.
Which service should you use to ingest the data?
A. Azure Event Hubs Standard
B. Azure Stream Analytics
C. Azure Data Factory
D. Azure Event Hubs Dedicated
You have 50 Azure SQL databases.
You need to notify the database owner when the database settings, such as the database
size and pricing tier, are modified in Azure.
What should you do?
A. Create a diagnostic setting for the activity log that has the Security log enabled.
B. For the database, create a diagnostic setting that has the InstanceAndAppAdvanced
C. Create an alert rule that uses a Metric signal type.
D. Create an alert rule that uses an Activity Log signal type.
You have an Azure SQL database.
Users report that the executions of a stored procedure are slower than usual. You suspect that a
regressed query is causing the performance issue.
You need to view the query execution plan to verify whether a regressed query is causing the issue.
The solution must minimize effort.
What should you use?
A. Performance Recommendations in the Azure portal
B. Extended Events in Microsoft SQL Server Management Studio (SSMS)
C. Query Store in Microsoft SQL Server Management Studio (SSMS)
D. Query Performance Insight in the Azure portal
You have SQL Server on an Azure virtual machine that contains a database named DB1. DB1
contains a table named CustomerPII.
You need to record whenever users query the CustomerPII table.
Which two options should you enable? Each correct answer presents part of the solution. NOTE:
Each correct selection is worth one point.
A. server audit specification
B. SQL Server audit
C. database audit specification
D. a server principal
You have SQL Server on Azure