Microsoft DP-300 Exam Dumps PDF

Administering Relational Databases on Microsoft Azure

Total Questions: 227
Update Date: March 26, 2024

PDF + Test Engine $65
Test Engine $55
PDF $45

  • Last Update on March 26, 2024
  • 100% Passing Guarantee of DP-300 Exam
  • 90 Days Free Updates of DP-300 Exam
  • Full Money Back Guarantee on DP-300 Exam

DumpsFactory is forever best for your Microsoft DP-300 exam preparation.

For your best practice we are providing you free questions with valid answers for the exam of Microsoft, to practice for this material you just need sign up to our website for a free account. A large bundle of customers all over the world is getting advantages by our Microsoft DP-300 dumps. We are providing 100% passing guarantee for your DP-300 that you will get more high grades by using our material which is prepared by our most distinguish and most experts team.

Most regarded plan to pass your Microsoft DP-300 exam:

We have hired most extraordinary and most familiar experts in this field, who are so talented in preparing the material, that there prepared material can succeed you in getting the high grades in Microsoft DP-300 exams in one day. That is why DumpsFactory available for your assistance 24/7.

Easily accessible for mobile user:

Mobile users can easily get updates and can download the Microsoft DP-300 material in PDF format after purchasing our material and can study it any time in their busy life when they have desire to study.

Get Pronto Microsoft DP-300 Questions and Answers

By using our material you can succeed in Microsoft DP-300 exam in your first attempt because we update our material regularly for new questions and answers for Microsoft DP-300 exam.

Notorious and experts present Microsoft DP-300 Dumps PDF

Our most extraordinary experts are too much familiar and experienced with the behaviour of Microsoft Exams that they prepared such beneficial material for our users.

Guarantee for Your Investment

DumpsFactory wants that their customers increased more rapidly, so we are providing to our customer with the most demanded and updated questions to pass Microsoft DP-300 Exam. You can claim for your investment by using our money back policy if you have not been availed with our promised facilities for the Microsoft exams. For details visit to Refund Contract.

Question 1

You need to design a data retention solution for the Twitter feed data records. The solutionmust meet the customer sentiment analytics requirements.Which Azure Storage functionality should you include in the solution?

A. time-based retention 
B. change feed 
C. lifecycle management 
D. soft delete 

Answer: C

Question 2

You need to implement the surrogate key for the retail store table. The solution must meetthe sales transaction dataset requirements.What should you create?

A. a table that has a FOREIGN KEY constraint 
B. a table the has an IDENTITY property 
C. a user-defined SEQUENCE object 
D. a system-versioned temporal table 

Answer: B

Question 3

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. NOTE: Each correct selection is worth one point. 

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: B,C

Question 4

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. SQL Server on Azure Virtual Machines
 B. Azure SQL Database 
C. an Azure SQL Database elastic pool 
D. Azure SQL Managed Instance

Answer: A

Question 5

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. Hyperscale 
B. General Purpose
 C. Premium 
D. Business Critical 

Answer: A

Question 6

You have a 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. log shipping 
B. Always On availability groups 
C. Database Migration Assistant 
D. Backup and Restore 

Answer: A

Question 7

You have an Azure SQL managed instance named MI1. You need to implement automatic tuning for the databases of MI1. What should you do? 

A. Use the REST API to call the patch operation and modify the AutomaticTuningServerMode property. 
B. Use Transact-SQL to enable the force_last_good_plan option. 
C. From the Azure portal, configure automatic tuning. 

Answer: B

Question 8

Your on-premises network contains a server that hosts a 60-TB database named DB 1. The network has a 10-Mbps internet connection. You need to migrate DB 1 to Azure. The solution must minimize how long it takes to migrate the database. What should you use?

A. Azure Migrate 
B. Data Migration Assistant (DMA) 
C. Azure Data BOX 
D. Azure Database Migration Service 

Answer: D

Question 9

You have an instance of SQL Server on Azure Virtual Machine named SQL1. You need to monitor SQL1 and query the metrics by using Kusto query language. The solution must minimize administrative effort. Where should you store the metrics?

 A. a Log Analytics workspace 
B. Azure Event Hubs 
C. Azure SQL Database 
D. an Azure Blob storage container 

Answer: A

Question 10

You have two on-premises Microsoft SQL Server 2019 instances named SQL1 and SQL2. You need to migrate the databases hosted on SQL 1 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. an Azure SQL Database elastic pool 
C. SQL Server on Azure Virtual Machines 
D. Azure SQL Managed Instance 

Answer: D