Valid DP-300 Dumps shared by PassLeader for Helping Passing DP-300 Exam! PassLeader now offer the newest DP-300 VCE dumps and DP-300 PDF dumps, the PassLeader DP-300 exam questions have been updated and ANSWERS have been corrected, get the newest PassLeader DP-300 dumps with VCE and PDF here: https://www.passleader.com/dp-300.html (204 Q&As Dumps –> 329 Q&As Dumps –> 374 Q&As Dumps)
BTW, DOWNLOAD part of PassLeader DP-300 dumps from Cloud Storage: https://drive.google.com/drive/folders/16H2cctBz9qiCdjfy4xFz728Vi_0nuYBl
NEW QUESTION 191
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).
Answer: A
Explanation:
https://docs.microsoft.com/en-us/azure/dms/tutorial-sql-server-to-managed-instance
NEW QUESTION 192
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
Answer: B
Explanation:
https://docs.microsoft.com/en-us/azure/azure-sql/migration-guides/database/sql-server-to-sql-database-overview
NEW QUESTION 193
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.
Answer: D
Explanation:
https://docs.microsoft.com/en-us/azure/azure-sql/database/migrate-to-database-from-sql-server#method-1-migration-with-downtime-during-the-migration
NEW QUESTION 194
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).
Answer: D
Explanation:
https://www.sqlshack.com/sql-varchar-data-type-deep-dive/
https://36chambers.wordpress.com/2020/06/18/nvarchar-everywhere-a-thought-experiment/
NEW QUESTION 195
You have an Azure virtual machine named VM1 on a virtual network named VNet1. Outbound traffic from VM1 to the internet is blocked. You have an Azure SQL database named SqlDb1 on a logical server named SqlSrv1. You need to implement connectivity between VM1 and SqlDb1 to meet the following requirements:
– Ensure that VM1 cannot connect to any Azure SQL Server other than SqlSrv1.
– Restrict network connectivity to SqlSrv1.
What should you create on VNet1?
A. a VPN gateway
B. a service endpoint
C. a private endpoint
D. an ExpressRoute gateway
Answer: C
Explanation:
A private endpoint is a network interface that uses a private IP address from your virtual network. This network interface connects you privately and securely to a service powered by Azure Private Link. By enabling a private endpoint, you’re bringing the service into your virtual network. The service could be an Azure service such as:
– Azure Storage.
– Azure Cosmos DB.
– Azure SQL Database.
– Your own service using a Private Link Service.
https://docs.microsoft.com/en-us/azure/private-link/private-endpoint-overview
NEW QUESTION 196
You have an Azure SQL database named db1 on a server named server1. The Intelligent Insights diagnostics log identifies queries that cause performance issues due to tempDB contention. You need to resolve the performance issues. What should you do?
A. Implement memory-optimized tables.
B. Run the dbcc flushprocindB command.
C. Replace the sequential index keys with nonsequential keys.
D. Run the dbcc dbreindex command.
Answer: A
Explanation:
https://docs.microsoft.com/en-us/azure/azure-sql/database/intelligent-insights-troubleshoot-performance#tempdb-contention
NEW QUESTION 197
You have an instance of SQL Server on Azure Virtual Machines that has a database named DB1. You plan to implement Azure SQL Data Sync for DB1. Which isolation level should you configure?
A. SERIALIZABLE
B. SNAPSHOT
C. READ UNCOMMITTED
D. READ COMMITTED
Answer: B
Explanation:
https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-data-sync-data-sql-server-sql-database
NEW QUESTION 198
You have an Azure SQL managed instance. You need to enable SQL Agent Job email notifications. What should you do?
A. Use the Agent XPs option.
B. Enable the SQL Server Agent.
C. Run the sp_configure command.
D. Run the sp set_agent properties command.
Answer: C
NEW QUESTION 199
You have four Azure subscriptions. Each subscription contains multiple Azure SQL databases. You need to update the column and index statistics for the databases. What should you use?
A. an Azure Automation runbook
B. a SQL Agent job
C. Azure SQL Analytics
D. automatic tuning in Azure SQL Database
Answer: A
Explanation:
https://www.sqlshack.com/automate-azure-sql-database-indexes-and-statistics-maintenance/
NEW QUESTION 200
You have a new Azure subscription. You create an Azure SQL Database instance named DB1 on an Azure SQL Database server named Server1. You need to ensure that users can connect to DB1 in the event of an Azure regional outage. In the event of an outage, applications that connect to DB1 must be able to connect without having to update the connection strings. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)
A. From the properties of DB1. configure geo-replication.
B. From the properties of Server1 add a failover group.
C. Create a new Azure SQL Database server named Server2.
D. From the properties of Server1 configure retention for DB1.
E. Create a new Azure SQL Database instance named DB2.
Answer: BC
Explanation:
https://docs.microsoft.com/en-us/azure/azure-sql/database/auto-failover-group-overview?tabs=azure-powershell#best-practices-for-sql-database
https://docs.microsoft.com/en-us/azure/azure-sql/database/failover-group-add-single-database-tutorial?tabs=azure-portal
NEW QUESTION 201
HotSpot
You plan to migrate on-premises Microsoft SQL Server databases to Azure. You need to identify which deployment and resiliency options meet the following requirements:
– Support user-initiated backups.
– Support multiple automatically replicated instances across Azure regions.
– Minimize administrative effort to implement and maintain business continuity.
What should you identify? (To answer, select the appropriate options in the answer area.)
Answer:
Explanation:
Box 1: SQL Server on Azure VMs. SQL Server on Azure Virtual Machines can take advantage of Automated Backup, which regularly creates backups of your database to blob storage. You can also manually use this technique.
Box 2: Active geo-replication. Geo-replication for services such as Azure SQL Database and Cosmos DB will create secondary replicas of your data across multiple regions. While both services will automatically replicate data within the same region, geo-replication protects you against a regional outage by enabling you to fail over to a secondary region.
https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/sql-server-on-azure-vm-iaas-what-is-overview
https://docs.microsoft.com/en-us/dotnet/architecture/cloud-native/infrastructure-resiliency-azure
NEW QUESTION 202
Drag and Drop
You have an Azure subscription that contains the resources shown in the following table:
You need to back up db1 to mysqlbackups, and then restore the backup to a new database named db2 that is hosted on SQL1. The solution must ensure that db1 is backed up to a stripe set. Which three Transact-SQL statements should you execute in sequence? (To answer, move the appropriate statements from the list of statements to the answer area and arrange them in the correct order.)
Answer:
Explanation:
https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/sql-server-backup-to-url?view=sql-server-ver15
NEW QUESTION 203
……
Get the newest PassLeader DP-300 VCE dumps here: https://www.passleader.com/dp-300.html (204 Q&As Dumps –> 329 Q&As Dumps –> 374 Q&As Dumps)
And, DOWNLOAD the newest PassLeader DP-300 PDF dumps from Cloud Storage for free: https://drive.google.com/drive/folders/16H2cctBz9qiCdjfy4xFz728Vi_0nuYBl