Cisco®
Oracle
CompTIA
Checkpoint
ISC
EC-Council
EXIN
Fortinet
ITIL®
Juniper
Microsoft
VMware
Avaya
SAP
Google
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk®
All Vendors
  2. Home
  3. Exams
  4. Microsoft
  5. DP-300

Free Microsoft DP-300 Exam Questions (page: 5)

Page 5 of 54
PDF with 418 Questions

DRAG DROP (Drag and Drop is not supported)

You have an Azure subscription.

You plan to deploy a new Azure virtual machine that will host a Microsoft SQL Server instance.

You need to configure the disks on the virtual machine. The solution must meet the following requirements:

Minimize latency for transaction logs.

Minimize VM allowed IO.

Which type of disk should you use for each workload? To answer, drag the appropriate disk types to the correct workloads. Each disk type may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

Note: Each correct selection is worth one point.

Select and Place:

  1. See Explanation section for answer.

Answer(s): A

Explanation:





Box 1: Premium SSD

Storage: Performance best practices for SQL Server on Azure VMs. Place tempdb on the local ephemeral SSD (default D:\) drive for most SQL Server workloads that are not part of Failover Cluster Instance (FCI) after choosing the optimal VM size.

Select Premium SSD instead of Standard SSD for better performance.

Box 2: Ultra Disk
For the log drive plan for capacity and test performance versus cost while evaluating the premium P30 - P80 disks
If submillisecond storage latency is required, use Azure ultra disks for the transaction log. For M-series virtual machine deployments consider write accelerator over using Azure ultra disks.


Reference:

https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/performance-guidelines-best- practices-storage



You have an Azure SQL Database elastic pool that contains 10 databases.

You receive the following alert.

Msg 1132, Level 16, state 1, Line 1
The elastic pool has reached its storage limit. The storage used for the elastic pool cannot exceed (76800) MBs.

You need to resolve the alert. The solution must minimize administrative effort.

Which three actions can you perform? Each correct answer presents a complete solution.

Note: Each correct selection is worth one point.

  1. Increase the maximum storage of the elastic pool.
  2. Delete data from a database.
  3. Remove a database from the pool.
  4. Enable data compression.
  5. Shrink individual databases.

Answer(s): A,D,E



You have an Azure subscription.

You need to deploy a new Azure SQL database by using Azure Command-Line Interface (CLI).

Which three parameters are required?

  1. --name, --edition, and --capacity
  2. --name, --tier, and --min-capacity
  3. --name, --resource-group, and --server
  4. --name, --licence-type, and --capacity

Answer(s): C

Explanation:

az sql db create
Create a database
Syntax: az sql db create --name
--resource-group
--server
Plus many additonal optional parameters.
Required Parameters
--name -n
Name of the Azure SQL Database.
--resource-group -g
Name of resource group. You can configure the default group using az configure --defaults group=<name>.
--server -s
Name of the Azure SQL Server. You can configure the default using az configure --defaults sql- server=<name>.
Example:
echo "Creating $database on $server..."
az sql db create --resource-group $resourceGroup --server $server --name $database --sample-name AdventureWorksLT --edition GeneralPurpose --family Gen5 --capacity 2 --zone-redundant true # zone redundancy is only supported on premium and business critical service tiers


Reference:

https://learn.microsoft.com/en-us/cli/azure/sql/db



HOTSPOT (Drag and Drop is not supported)

You have an Azure subscription.

You plan to migrate 10 on-premises Microsoft SQL Server instances to Azure.

You need to ensure that the migrated environment can be managed by using multiserver administration and supports master/target (MSX/TSX) jobs.

The solution must minimize administrative effort.

Which SQL deployment options should you select as the master server (MSX) and the target server (TSX)? To answer, select the appropriate options in the answer area.

Note: Each correct selection is worth one point.

Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:





Box 1: SQL Managed Instance
MSX

Make a Master Server
Applies to: SQL Server, Azure SQL Managed Instance
On Azure SQL Managed Instance, most, but not all SQL Server Agent features are currently supported.

To make a master server
1. Connect to the Database Engine.

2. From the Standard bar, click New Query.

3. Copy and paste the following example into the query window and click Execute. This example enlists the current server into the AdventureWorks1 master server. The location for the current server is Building 21, Room 309, Rack 5.

USE msdb ;
GO

EXEC dbo.sp_msx_enlist N'AdventureWorks1',
N'Building 21, Room 309, Rack 5' ;
GO

Box 2: SQL Managed Instance

TSX

Make a Target Server
Applies to: SQL Server, Azure SQL Managed Instance
On Azure SQL Managed Instance, most, but not all SQL Server Agent features are currently supported.


Reference:

https://learn.microsoft.com/en-us/sql/ssms/agent/make-a-master-server https://learn.microsoft.com/en-us/sql/ssms/agent/make-a-target-server



You have two on-premises Microsoft SQL Server 2019 instances named SQL1 and SQL2.

You need to migrate the databases hosted on SQL1 to Azure. The solution must meet the following requirements:

The service that hosts the migrated databases must be able to communicate with SQL2 by using linked server connections.
Administrative effort must be minimized.

What should you use to host the databases?

  1. a single Azure SQL database
  2. SQL Server on Azure Virtual Machines
  3. Azure SQL Managed Instance
  4. an Azure SQL Database elastic pool

Answer(s): C

Explanation:

Linked servers enable the SQL Server Database Engine and Azure SQL Managed Instance to read data from the remote data sources and execute commands against the remote database servers (for example, OLE DB data sources) outside of the instance of SQL Server.
Linked servers are available in SQL Server Database Engine and Azure SQL Managed Instance. They are not enabled in Azure SQL Database singleton and elastic pools.


Reference:

https://learn.microsoft.com/en-us/sql/relational-databases/linked-servers/linked-servers-database-engine



HOTSPOT (Drag and Drop is not supported)

You have an on-premises Microsoft SQL Server 2016 instance that hosts a database named db1. You have an Azure subscription that contains an Azure SQL managed instance named MI1.

You plan to perform an online migration of db1 to MI1 by using Azure Database Migration Service.

You need to create the backups for the migration. The solution must minimize the number of backup files created.

Which type of backups should you create, and how should you store the backups? To answer, select the appropriate options in the answer area.

Note: Each correct selection is worth one point.

Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:





Box 1: Full and transaction log
Known issues/migration limitations with online migrations to Azure SQL Managed Instance

Backup requirements
Backup media

Make sure to take every backup on a separate backup media (backup files). Azure Database Migration Service doesn't support backups that are appended to a single backup file. Take full, differential and log backups to separate backup files.

Box 2: Write each backup to a separate file


Reference:

https://learn.microsoft.com/en-us/azure/dms/known-issues-azure-sql-db-managed-instance-online



You have a SQL Server on Azure Virtual Machines instance named SQLVM1 that was deployed by using an Azure Marketplace SQL Server 2019 Enterprise image.

You need to change the Microsoft SQL Server instance on SQLVM1 to the Standard edition. The solution must ensure licensing compliance.

What should you do first?

  1. From the SQL Server Installation Center on SQLVM1, run the Edition Upgrade wizard.
  2. From SQLVM1, uninstall the SQL Server instance.
  3. From the SQL Server Installation Center on SQLVM1, run the Repair wizard.
  4. From the Azure portal, reconfigure SQLVM1.

Answer(s): B

Explanation:

In-place change of SQL Server edition on Azure VM
The edition of SQL Server is determined by the product key, and is specified during the installation process using the installation media. The edition dictates what features are available in the SQL Server product. You can change the SQL Server edition with the installation media and either downgrade to reduce cost or upgrade to enable more features.
Downgrade an edition
To downgrade the edition of SQL Server, you need to completely uninstall SQL Server, and reinstall it again with the desired edition setup media.
1. Back up all databases, including the system databases.
2. Move system databases (master, model, and msdb) to a new location.
3. Completely uninstall SQL Server and all associated services.
4. Restart the virtual machine.
5. Install SQL Server by using the media with the desired edition of SQL Server.
6. Install the latest service packs and cumulative updates.
7. Replace the new system databases that were created during installation with the system databases that you previously moved to a different location.
8. After the SQL Server edition is downgraded, modify the edition property of the SQL Server virtual machine in the Azure portal. This will update the metadata and billing associated with this VM.


Reference:

https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/change-sql-server-edition



Your on-premises network contains a Microsoft SQL Server 2016 server that hosts a database named db1.

You have an Azure subscription.

You plan to migrate db1 to an Azure SQL managed instance.

You need to create the SQL managed instance. The solution must minimize the disk latency of the instance.

Which service tier should you use?

  1. Business Critical
  2. Hyperscale
  3. General Purpose
  4. Premium

Answer(s): A

Explanation:

Service tier characteristics
SQL Managed Instance has two service tiers: General Purpose and Business Critical.
Storage IO latency (approximate)
General Purpose: 5-10 ms
Business Critical: 1-2 ms
Incorrect:
Not B: The Hyperscale service tier is currently only available for Azure SQL Database, and not Azure SQL Managed Instance.


Reference:

https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/resource-limits https://learn.microsoft.com/en-us/azure/azure-sql/database/service-tier-hyperscale



Viewing page 5 of 54



Post your Comments and Discuss Microsoft DP-300 exam prep with other Community members:

DP-300 Exam Discussions & Posts