DP-300 Exam Dumps and Practice Questions

To deploy an Azure SQL database using Azure CLI, three required parameters are typically needed, though the specific options (A, B, C, D) are not visible in the question. Generally, the three required parameters for az sql db create are: resource-group, server, and name (database name). These specify which resource group and SQL server will host the database, and what the database should be named. Without seeing the actual options provided, the correct answer would be whichever combination includes these three essential parameters.

https://docs.microsoft.com/en-us/sql/relational-databases/performance/query-store-usage-scenarios

Implement a private endpoint connection. Here's why:

• Encryption - Connections through private endpoints are inherently encrypted using Azure's internal network infrastructure, preventing exposure over the public internet
• Minimizes latency - Private endpoints connect to managed instances through Azure's private network backbone, providing lower and more consistent latency than public endpoints
• Network isolation - VM1 connects to the managed instance through the Azure private network without traversing the public internet, improving both security and performance
• No additional configuration needed - Unlike VPN or ExpressRoute, private endpoints require minimal setup while meeting both requirements

This is superior to public endpoints (not encrypted at the transport layer and higher latency) and more straightforward than VPN solutions for this scenario.

An auditing policy can be defined for a specific database or as a default server policy in Azure (which hosts SQL Database or Azure Synapse):

A server policy applies to all existing and newly created databases on the server.

If server auditing is enabled, it always applies to the database. The database will be audited, regardless of the database auditing settings.

Enabling auditing on the database, in addition to enabling it on the server, does not override or change any of the settings of the server auditing. Both audits will exist side by side.

Note:

The Server Audit Specification object belongs to an audit.

A Database Audit Specification defines which Audit Action Groups will be audited for the specific database in which the specification is created.

https://docs.microsoft.com/en-us/azure/azure-sql/database/auditing-overview