Free preview mode
Enjoy the free questions and consider upgrading to gain full access!
DP-300
Free trial
Verified
Question 26
HOTSPOT -
You have the following Azure Resource Manager template.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:
Question 27
HOTSPOT -
You have an on-premises Microsoft SQL Server 2019 instance that hosts a database named DB1.
You plan to perform an online migration of DB1 to an Azure SQL managed instance by using the Azure Database Migration Service.
You need to create a backup of DB1 that is accessible to the Azure Database Migration Service.
What should you run for the backup and where should you store the backup? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Question 28
HOTSPOT -
You have an Azure subscription.
You plan to deploy an Azure SQL database by using an Azure Resource Manager template.
How should you complete the template? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Question 29
You have an on-premises Microsoft SQL Server 2019 server that hosts a database named DB1.
You have an Azure subscription that contains an Azure SQL managed instance named SQLMI1 and a virtual network named VNET1. SQLMI1 resides on VNET1.
The on-premises network connects to VNET1 by using an ExpressRoute connection.
You plan to migrate DB1 to SQLMI1 by using Azure Database Migration Service.
You need to configure VNET1 to support the migration.
What should you do?
- A: Configure service endpoints.
- B: Configure virtual network peering.
- C: Deploy an Azure firewall.
- D: Configure network security groups (NSGs).
Question 30
You have an on-premises Microsoft SQL server that uses the FileTables and Filestream features.
You plan to migrate to Azure SQL.
Which service should you use?
- A: Azure SQL Database
- B: SQL Server on an Azure Virtual Machine
- C: Azure SQL Managed Instance
- D: Azure Database for MySQL
Question 31
You need to migrate an on-premises Microsoft SQL Server database to Azure SQL Database. The solution must minimize downtime.
What should you do?
- A: Configure Transaction Log Shipping.
- B: Implement Always On availability groups.
- C: Configure transactional replication.
- D: Import a BACPAC.
Question 32
You have an Azure SQL database named DB1.
You have a table name Table1 that has 20 columns of type CHAR(400). Row compression for Table1 is enabled.
During a database audit, you discover that none of the fields contain more than 150 characters.
You need to ensure that you can apply page compression to Table1.
What should you do?
- A: Configure the columns as sparse.
- B: Change the column type to NVARCHAR(MAX).
- C: Change the column type to VARCHAR(MAX).
- D: Change the column type to VARCHAR(200).
Question 33
You have an on-premises Microsoft SQL Server named SQL1 that hosts five databases.
You need to migrate the databases to an Azure SQL managed instance. The solution must minimize downtime and prevent data loss.
What should you use?
- A: Always On availability groups
- B: Backup and Restore
- C: log shipping
- D: Database Migration Assistant
Question 34
You have a Microsoft SQL Server 2019 database named DB1 that uses the following database-level and instance-level features.
✑ Clustered columnstore indexes
✑ Automatic tuning
✑ Change tracking
✑ PolyBase
You plan to migrate DB1 to an Azure SQL database.
What feature should be removed or replaced before DB1 can be migrated?
- A: Clustered columnstore indexes
- B: PolyBase
- C: Change tracking
- D: Automatic tuning
Question 35
You have an Azure subscription that contains an Azure SQL database. The database contains a table named tablet that uses partitioned columnstores.
You need to configure table1 to meet the following requirements:
• Each partition must be compressed.
• The compression ratio must be maximized.
• You must be able to index the compressed data.
What should you use?
- A: page compression
- B: columnstore compression
- C: GZIP compression
- D: columnstore archival compression
Question 36
You have an Azure subscription linked to an Azure Active Directory (Azure AD) tenant. The subscription contains 10 virtual machines that run Windows Server 2019 and host Microsoft SQL Server 2019 instances.
You need to ensure that you can manage the SQL Server instances by using a single user account.
What should you do first?
- A: Enable a user-assigned managed identity on each virtual machine.
- B: Deploy an Azure Active Directory Domain Services (Azure AD DS) domain and join the virtual machines to the domain.
- C: Enable a system-assigned managed identity on each virtual machine.
- D: Join the virtual machines to the Azure AD tenant.
Question 37
DRAG DROP
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 the impact on IO throughput of the virtual machine.
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.
Question 38
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.
- A: Increase the maximum storage of the elastic pool.
- B: Delete data from a database.
- C: Remove a database from the pool.
- D: Enable data compression.
- E: Shrink individual databases.
Question 39
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?
- A: --name, --edition, and --capacity
- B: --name, --tier, and --min-capacity
- C: --name, --resource-group, and --server
- D: --name, --licence-type, and --capacity
Question 40
HOTSPOT
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.
Question 41
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?
- A: a single Azure SQL database
- B: SQL Server on Azure Virtual Machines
- C: Azure SQL Managed Instance
- D: an Azure SQL Database elastic pool
Question 42
HOTSPOT
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.
Question 43
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?
- A: From the SQL Server Installation Center on SQLVM1, run the Edition Upgrade wizard.
- B: From SQLVM1, uninstall the SQL Server instance.
- C: From the SQL Server Installation Center on SQLVM1, run the Repair wizard.
- D: From the Azure portal, reconfigure SQLVM1.
Question 44
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?
- A: Business Critical
- B: Hyperscale
- C: General Purpose
- D: Premium
Question 45
You have a Microsoft SQL Server 2019 instance in an on-premises datacenter. The instance contains a 4-TB database named DB1.
You plan to migrate DB1 to an Azure SQL Database managed instance.
What should you use to minimize downtime and data loss during the migration?
- A: distributed availability groups
- B: database mirroring
- C: Always On Availability Group
- D: Azure Database Migration Service
Question 46
You have an Azure subscription.
You need to deploy an Azure SQL database. The solution must meet the following requirements:
• Dynamically scale CPU resources.
• Ensure that the database can be paused to reduce costs.
What should you use?
- A: the Business Critical service tier
- B: the serverless compute tier
- C: an elastic pool
- D: the General Purpose service tier
Question 47
HOTSPOT
You have an Azure subscription.
You need to deploy an Azure SQL managed instance that meets the following requirements:
• Optimize latency.
• Maximize the memory-to-vCore ratio.
Which service tier and hardware generation should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Question 48
You have a Microsoft SQL Server 2017 server.
You need to migrate the server to Azure. The solution must meet the following requirements:
• Ensure that the latest version of SQL Server is used.
• Support the SQL Server Agent service.
• Minimize administrative effort.
What should you use?
- A: an Azure SQL Database elastic pool
- B: Azure SQL Database
- C: SQL Server on Azure Virtual Machines
- D: Azure SQL Managed Instance
Question 49
HOTSPOT
You have a Microsoft SQL Server 2017 server that hosts five databases.
You plan to migrate the databases to Azure.
You need to recommend a solution that meets the following requirements:
• Automatically scales compute based on the workload demand
• Provides per-second billing
What should you include in the recommendation? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Question 50
You have an on-premises Microsoft SQL Server 2019 database named SQL1 that uses merge replication.
You need to migrate SQL1 to Azure.
Which service should you use?
- A: Azure SQL Edge
- B: Azure SQL Database
- C: SQL Server on Azure Virtual Machines
- D: Azure SQL Managed Instance
Free preview mode
Enjoy the free questions and consider upgrading to gain full access!