Microsoft Azure Database Administrator Associate (DP-300)

B is correct.

Explanation: With SA, you can bring your own license (BYOL) when you deploy a VM that doesn't contain a preconfigured SQL Server instance. You must report the license usage to Microsoft by using the License Mobility verification form within 10 days of implementing the VM. You can install SQL Server manually from media or upload a VM image.

A is incorrect: A Marketplace image with a preconfigured SQL Server uses the pay-per-minute model. The SQL Server license cost is included in the VM cost, so it doesn't apply your existing license.

C is incorrect: A one-to-three-year VM reservation is a cost-saving option for persistent workloads. It doesn't license SQL Server.

D is incorrect: Azure Hybrid Benefit applies Windows Server licenses that you already own. It doesn't apply a SQL Server license.

B is correct.

Explanation: Enabling the public endpoint takes two steps by two separate roles. The database administrator runs the PowerShell script. A network administrator with permissions in scope Microsoft.Network/* opens port 3342 on the NSG and provides a UDR route to avoid asymmetric routing.

A is incorrect: Port 1433 is not the port that the public endpoint uses. Port 1433 outbound is a transactional replication requirement when the publisher or distributor is on a managed instance and the subscriber is on-premises.

C is incorrect: Port 445 outbound provides access to the Azure file share that transactional replication uses. It does not open the public endpoint.

D is incorrect: The database administrator role is scoped to Microsoft.Sql/managedInstances/*, which does not include network permissions. Separation of duties requires a separate network administrator for the NSG and route changes.

A is correct.

Explanation: An elastic pool shares CPU, memory, and storage among the databases in the pool. It is a good fit for multitenant databases where each tenant has its own database. A database that needs more resources can use them, up to the set limits. Balance the workload across databases so that one database doesn't use most of the pool's resources.

B is incorrect: Each single database has its own dedicated resources, even on the same logical server. You scale and manage each database individually, so resources aren't shared.

C is incorrect: Hyperscale addresses large database size and independent scaling of compute and storage. It adds a per terabyte storage cost and doesn't address sharing resources across tenant databases.

D is incorrect: SQL Managed Instance is described as the best option for most migration scenarios. This is a new application, and the requirement is to share resources across databases in a pool.

D is correct.

Explanation: A Resource Manager template gives you the most granular control over your resources. Microsoft hosts Resource Manager templates in the Azure-Quickstart-Templates GitHub repository, and you can reference them in your deployments.

A is incorrect: The portal wizard is a manual process, and its default compute setting is Gen5, 2 vCore, with 32 GB of storage. It isn't the method that provides the most granular control.

B is incorrect: PowerShell can create a server, database, and firewall rule, but the evidence identifies Resource Manager templates, not individual cmdlets, as the method with the most granular control.

C is incorrect: The Azure CLI can deploy a database from a script, but the evidence identifies Resource Manager templates as the method with the most granular control and the source of published templates.

C is correct.

Explanation: SQL Server on Azure Virtual Machines is an IaaS offering. It gives you access to the operating system, virtual storage, virtual networking, and any software you install in the VM. It also supports Active Directory authentication. You are responsible for OS patching and for SQL Server installation and configuration.

A is incorrect: Azure SQL Database is a PaaS offering. Direct access to the operating system isn't supported in a PaaS model, so the vendor installer can't run.

B is incorrect: Azure SQL Managed Instance is also a PaaS offering. Microsoft manages the operating system, and direct operating system access isn't supported.

D is incorrect: Azure Arc-enabled SQL Server extends Azure management to on-premises or multicloud SQL Servers. It is not a deployment option for moving an application to Azure.

D is correct.

Explanation: An FCI provides high availability for an entire instance in a single region. It requires shared storage, which you can provide with shared file storage or Storage Spaces Direct on Windows Server. An FCI doesn't provide disaster recovery unless you combine it with another feature such as availability groups or log shipping.

A is incorrect: The unit of failover for an availability group is a group of databases, not the entire instance. Availability groups are preferred for newer deployments, but they don't protect the whole instance.

B is incorrect: Azure Site Recovery performs block-level replication of a VM. It is best used for stateless environments, and with SQL Server you must set a higher recovery point, which means potential data loss.

C is incorrect: An availability set places VMs on different servers and racks in a data center. It doesn't provide instance-level failover for SQL Server.

A is correct.

Explanation: SqlPackage is recommended for optimal scale and performance in production environments, and it is faster than the Azure portal. You can scale the database to a higher service tier and compute size during the import, and then scale down to the size you need.

B is incorrect: The Azure portal import is slower than SqlPackage. A low compute size also limits the resources available to the import.

C is incorrect: Transactional replication is a separate migration method. It does not import a .bacpac file.

D is incorrect: Scaling up after the import does not speed up the import. Scale up before the import starts, and scale down after it completes.

A is correct.

Explanation: For a SQL Server instance that is enabled by Azure Arc, discovery and readiness reports run automatically every weekend. You can also trigger an assessment manually at any time. The assessment evaluates feature compatibility and identifies potential migration blockers.

B is incorrect: The weekend run is the automatic schedule, but it is not the only option. A manual assessment can run at any time.

C is incorrect: The assessment identifies migration blockers and provides right-sized recommendations for the target configuration. Starting the migration without current results leaves those items unchecked.

D is incorrect: Assessing the source instance is the first stage. Selecting the target is the second stage, so the assessment does not depend on it.

C is correct.

Explanation: Once a database is converted to Hyperscale, it can't be reverted to a standard Azure SQL Database. Confirm that Hyperscale meets your requirements before you convert.

A is incorrect: Reverting a converted database to a standard Azure SQL Database isn't possible.

B is incorrect: Hyperscale backups use file snapshots stored in Azure Blob storage. The time for backups and scaling operations doesn't depend on data volume.

D is incorrect: The cost of Hyperscale is similar to Azure SQL Database, but there is an extra per terabyte storage cost.

B and D are correct.

Explanation: Pooled Premium disks increase IOPS and storage capacity. Data files should be in their own pool with read caching on the Azure disks. Transaction log files don't benefit from that caching, so they should be in their own pool without caching.

A is incorrect: The temporary disk is for data that doesn't need to be durable. Transaction log files stored there are lost during VM maintenance or a reboot.

C is incorrect: Standard HDD is best for backups and non-critical workloads. It has the lowest maximum IOPS and throughput of the disk types, so it doesn't fit a performance-sensitive workload.