Microsoft DP-300 Dumps Questions Answers

Microsoft DP-300 Dumps

Dumps4download providing 100% reliable Exam dumps that are verified by experts panel. Our Dumps4download DP-300 study material are totally unique and exam questions are valid all over the world. By using our DP-300 dumps we assure you that you will pass your exam on first attempt. You can easily score more than 97%.

100% exam passing Guarantee on your purchased exams.

100% money back guarantee if you will not clear your exam.

Microsoft DP-300 Practice Test Helps You Turn Dreams To Reality!

IT Professionals from every sector are looking up certifications to boost their careers. Microsoft being the leader certification provider earns the most demand in the industry.

The Microsoft Certification is your short-cut to an ever-growing success. In the process, Dumps4download is your strongest coordinator, providing you with the best DP-300 Dumps PDF as well as Online Test Engine. Let’s steer your career to a more stable future with interactive and effective DP-300 Practice Exam Dumps.

Many of our customers are already excelling in their careers after achieving their goals with our help. You can too be a part of that specialized bunch with a little push in the right direction. Let us help you tread the heights of success.

Apply for the DP-300 Exam right away so you can get certified by using our Microsoft Dumps.

Bulk Exams Package

Dumps4download Leads You To A 100% Success in First Attempt!

Our DP-300 Dumps PDF is intended to meet the requirements of the most suitable method for exam preparation. We especially hired a team of experts to make sure you get the latest and compliant DP-300 Practice Test Questions Answers. These questions are been selected according to the most relevance as well as the highest possibility of appearing in the exam. So, you can be sure of your success in the first attempt.

Interactive & Effective DP-300 Dumps PDF + Online Test Engine

Aside from our Microsoft DP-300 Dumps PDF, we invest in your best practice through Online Test Engine. They are designed to reflect the actual exam format covering each topic of your exam. Also, with our interactive interface focusing on the exam preparation is easier than ever. With an easy-to-understand, interactive and effective study material assisting you there is nothing that could go wrong. We are 100% sure that our DP-300 Questions Answers Practice Exam is the best choice you can make to pass the exam with top score.

How Dumps4download Creates Better Opportunities for You!

Dumps4download knows how hard it is for you to beat this tough Microsoft Exam terms and concepts. That is why to ease your preparation we offer the best possible training tactics we know best. Online Test Engine provides you an exam-like environment and PDF helps you take your study guide wherever you are. Best of all, you can download DP-300 Dumps PDF easily or better print it. For the purpose of getting concepts across as easily as possible, we have used simple language. Adding explanations at the end of the DP-300 Questions and Answers Practice Test we ensure nothing slips your grasp.

The exam stimulation is 100 times better than any other test material you would encounter. Besides, if you are troubled with anything concerning Administering Relational Databases on Microsoft Azure Exam or the DP-300 Dumps PDF, our 24/7 active team is quick to respond. So, leave us a message and your problem will be solved in a few minutes.

Get an Absolutely Free Demo Today!

Dumps4download offers an absolutely free demo version to test the product with sample features before actually buying it. This shows our concern for your best experience. Once you are thoroughly satisfied with the demo you can get the Administering Relational Databases on Microsoft Azure Practice Test Questions instantly.

24/7 Online Support – Anytime, Anywhere

Have a question? You can contact us anytime, anywhere. Our 24/7 Online Support makes sure you have absolutely no problem accessing or using Administering Relational Databases on Microsoft Azure Practice Exam Dumps. What’s more, Dumps4download is mobile compatible so you can access the site without having to log in to your Laptop or PC.

Features to use Dumps4download DP-300 Dumps:

• Thousands of satisfied customers.
• Good grades are 100% guaranteed.
• 100% verified by Experts panel.
• Up to date exam data.
• Dumps4download data is 100% trustworthy.
• Passing ratio more than 99%
• 100% money back guarantee.

Microsoft DP-300 Frequently Asked Questions

Microsoft DP-300 Sample Questions

Question # 1

You have an Azure SQL database named SOL1. You need to implement a disaster recovery solution for SQL1. The solution must minimize the following: • The recovery point objective JRPO) • The recovery time objective (RTO) • Administrative effort What should you include in the solution?

A. auto failover groups 
B. Azure Site Recovery 
C. availability groups 
D. active geo - replication 

Show Answer

---

Question # 2

You have an on-premises Microsoft SQL Server 2019 instance that hosts a database named DB1. You have an Azure subscription that contains an Azure SQL database named SQLDB1. You need to replicate DB1 to SQlDC1. Which type of replication should you use? 

A. peer-to-pec 
B. merge 
C. transactional 
D. snapshot 

Show Answer

---

Question # 3

You have an Azure subscription. You need to deploy an Instance of SQL Server on Azure Virtual Machines. The solution must meet the following 'requirements: • Custom performance configuration. such as lCPS. capacity, and throughout, must be supported. • Costs must be minimized Which type of disk should you include in the solution?

A. Premium SSD v2 
B. Premium SSD 
C. Ultra SSD 
D. Standard SSD 

Show Answer

---

Question # 4

You have a single availability set that contains two SQL Server on Azure Virtual Machines instances. The instances were deployed by using an Azure Marketplace SQL Server 2019 Enterprise image that has the latest cumulative updates applied. The instances are configured as the nodes of a failover cluster instance (FCI) named FCI1. You need to ensure that client applications can connect to FCI1. The solution must meet the following requirements: • Provide an availability SLA • Minimize costs. What should you create?

A. a virtual network name (VNN) resource 
B. a Basic Azure Load Balancer 
C. a distributed network name (DNN) resource 
D. an Azure Standard Load Balancer 

Show Answer

---

Question # 5

You have an instance of SQL Server on Azure Virtual Machines. You need to ensure that a user named User1 can configure proxy accounts for SQL Server Agent jobs. The solution must use the principle of least privilege. Which role should you assign to User1? 

A. sysadmin 
B. SQLAgentUserRole 
C. SQLAgentReaderRole 
D. SQLAgentOperatorRole 

Show Answer

---

Question # 6

You have an Azure subscription that contains two instances of SQL Server on Azure Virtual Machines named VM1 and VM2. Both instances run Microsoft SQL Server 2019 CU8. You need to deploy a failover cluster instance (FCI) to VM1 and VM2. The solution must eliminate the need for the following: • A distributed network name (DNN) • A load balancer What should you do?

A. Deploy VM1 and VM2 to a single proximity placement group. 
B. Deploy VM1 and VM2 to different proximity placement groups in the same Azure region. 
C. Connect VM1 and VM2 to a single subnet. 
D. Connect VM1 and VM2 to different subnets on a single virtual network. 

Show Answer

---

Question # 7

You have an Azure subscription that contains an Azure SQL database named SQL1. SQL1 is in an Azure region that does not support availability zones. You need to ensure that you have a secondary replica of SQLI in the same region. What should you use? 

A. log shipping 
B. auto-failover groups 
C. active geo-replication 
D. Microsoft SQL Server failover clusters 

Show Answer

---

Question # 8

You have 25 Azure SQL databases. You need to implement a centralized database management solution that uses TransactSQL What should you include in the solution?

A. elastic jobs 
B. an Azure Automation runbook 
C. Azure Functions 
D. Azure Logic Apps 

Show Answer

---

Question # 9

You have an Azure subscription that contains an instance of SQL Server on an Azure virtual machine named VM1 and a Microsoft Entra Domain Services domain that contains two users named User1 and User2. On the default instance of SQL Server on VM1, you create a credential named Credentiall for User1. You need to ensure that User2 can create a SQL Server Agent proxy that will use Credential1. The solution must use the principle of least privilege. Which role should you assign to User2?

A. sysadmin 
B. SQLAgentUserRole 
C. SQLAgentOperatorRole 
D. SQLAgentReaderRole 

Show Answer

---

Question # 10

You deploy an instance of SQL Server on Azure Virtual Machines named SQL1 that hosts multiple databases. You configure the full recovery model for all the databases. You perform a full backup of the master database on SQL1. You need to a perform an additional backup of the master database on SQL1. The solution must minimize how long it takes to perform the backup. Which type of backup should you perform?

A. tail-log 
B. differential 
C. full 
D. log 

Show Answer

---

Question # 11

You have an Azure subscription that contains 20 Azure SQL databases. You create a Transact-SQL statement to perform index maintenance on a database. You need to schedule the statement to run once daily against each database by using Transact-SQL commands. What should you use to schedule the statement?

A. Azure Automation 
B. an elastic job 
C. a SQL Server Agent job 
D. an Azure function 

Show Answer

---

Question # 12

You manage 100 Azure SQL managed instances located across 10 Azure regions. You need to receive voice message notifications when a maintenance event affects any of the 10 regions. The solution must minimize administrative effort. What should you do? 

A. From the Azure portal, create a service health alert. 
B. From the Azure portal, create an Azure Advisor operational excellence alert. 
C. From Microsoft SQL Server Management Studio (SSMS), configure a SQL Server agent job.
 D. From the Azure portal, configure an activity log alert. 

Show Answer

---

Question # 13

You have an Azure subscription that contains the following resources: • 10 Azure SQL databases • Five Azure SQL managed instances • Five instances of SQL Server on Azure Virtual Machines You need to implement a centralized monitoring solution for all the Azure SQL resources. The solution must minimize administrative effort. What should you include in the solution?

A. Log Analytics 
B. Azure SQL Analytics 
C. Query Performance Insight 
D. SQL Insights 

Show Answer

---

Question # 14

You have an Azure virtual machine named Server1 that runs Windows Server 2022. Server! contains an instance of Microsoft SQL Server 2022 named SQL1 and a database named DB1. You create a master key in the master database of SQL1. You need to create an encrypted backup of DB1. What should you do?

A. Create a symmetric key in DB1. 
B. Enable visualization-based security (VBS) on Server1. 
C. Create a certificate in DB1. 
D. Create a certificate in the master database of SQLl. 

Show Answer

---

Question # 15

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 

Show Answer

---

Question # 16

You have an Azure SQL database. You need to implement a disaster recovery solution that meets the following requirements: • Minimizes how long it takes to recover the database if a datacenter fails • Minimizes administrative effort What should you include in the solution?

A. Azure Backup 
B. active geo-replication 
C. Azure Site Recovery 
D. auto-failover groups 

Show Answer

---

Question # 17

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. 

Show Answer

---

Question # 18

You plan to deploy two instances of SQL Server on Azure virtual machines in a highly available configuration that will use an Always On availability group. You need to recommend a deployment solution that meets the following requirements: • Provides a Service Level Agreement (SLA) of at least 99.95% • Replicates databases in the same group synchronously • Minimizes the latency of database writes What should you recommend?

A. Create a proximity group and an availability set. Deploy each virtual machine to the availability set Add both virtual machines to the proximity group. 
B. Create two proximity groups and a single availability set. Deploy both virtual machines to the availability set. Add one virtual machine to each proximity group. 
C. Create two proximity groups and two availability sets. Deploy each virtual machine to a unique availability set. Add one virtual machine to each proximity group. 
D. Create a proximity group and two availability sets. Deploy each virtual machine to a unique availability set. Add both virtual machines to the proximity group. 

Show Answer

---

Question # 19

You have an Azure subscription that contain an Azure SQL managed instance named SQLMI1 and a Log Analytics workspace named Workspace1. You need to collect performance metrics for SQLMI1 and stream the metrics to Workspace1.

A. Create the private endpoint connection on SQLMI1. 
B. Configure Azure SQL Analytics to use Workspace1. 
C. Modify the Computer + storage settings for SQLMI1. 
D. Modify the diagnostic settings for SQLMI1.

Show Answer

---

Question # 20

You have a Microsoft SQL Server 2019 database named DB1 and an Azure SQL managed instance named SQLMI1. You need to move a SQL Server Agent job from DB1 to SQLMI1. Which job attribute is unsupported in SQLMI1? 

A. log to table 
B. email notifications 
C. schedules 
D. output files 

Show Answer

---

Question # 21

You have an Azure subscription that contains an Azure SQL database named db1. You need to implement SQL insights for db1. Which two resources should you create first? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point

A. an Azure logic app 
B. a virtual machine 
C. an Azure function 
D. a Log Analytics workspace 
E. a storage account 

Show Answer

---

Question # 22

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 

Show Answer

---

Question # 23

You have an Azure subscription. You plan to deploy an instance of SQL Sevier on Azure Virtual Machines that supports Write Accelerator. Which virtual machine series should you use?

A. H-series 
B. G -series 
C. M-series 
D. E-series 

Show Answer

---

Question # 24

You have an Azure subscription that contains an Azure SQL database named DB1. You need to host elastic jobs by using DB1. DB1 will also be configured as a job target. The solution must support the use of location-based Conditional Access policies. What should the elastic jobs use to access DB1?

A. a system-assigned managed identity 
B. Azure SQL sign-in credentials 
C. database-scoped credentials 
D. a user-assigned managed identity 

Show Answer

---

Question # 25

You have an Azure virtual machine named VM1 that runs Windows Server 2022 and hosts a Microsoft SQL Server 2019 instance named SQL1. You need to configure SQL! to use mixed mode authentication. Which procedure should you run?

A. sp_addremoteIogin 
B. xp_instance_regwrite 
C. sp_cnarge_users_login 
D. xp_grant_login 

Show Answer

---

Question # 26

You have an Azure virtual machine named VM1 that runs Windows Server 2022 and hosts a Microsoft SQL Server 2019 instance named SQL1. You need to configure SQL1 to use mixed mode authentication. Which procedure should you run?

A. sp_eddremotelogin 
B. xp_grant_login 
C. sp_change_users_login 
D. xp_instance_regwrite 

Show Answer

---

Question # 27

You have an Azure subscription that contains a logical SQL server named Serverl. The master database of Serverl contains a user named Userl. You need to ensure that Userl can create databases on Serverl. Which database role should you assign to Userl?

A. db_owner 
B. dbmanager 
C. dbo 
D. db_ddladmin

Show Answer

---

Question # 28

You need to recommend a disaster recovery solution for an on-premises Microsoft SQL Server database. The solution must meet the following requirements: • Support real-time data replication to a different geographic region. • Use Azure as a disaster recovery target. • Minimize costs and administrative effort. What should you include in the recommendation

A. database mirroring on an instance of SQL Server on Azure Virtual Machines 
B. availability groups for SQL Server on Azure Virtual Machines 
C. an Azure SQL Managed Instance link 
D. transactional replication to an Azure SQL Managed Instance 

Show Answer

---

Question # 29

You have an on-premises datacenter that contains a 14-TB Microsoft SQL Server database. You plan to create an Azure SQL managed instance and migrate the on-premises database to the new instance. Which three service tiers support the SQL managed instance? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

A. General Purpose Standard 
B. Business Critical Premium 
C. Business Critical Memory Optimized Premium 
D. General Purpose Premium 
E. Business Critical Standard 

Show Answer

---

Question # 30

You have an Azure subscription. You create a logical SQL server that hosts four databases Each database will be used by a separate customer. You need to ensure that each customer can access only its own database. The solution must minimize administrative effort Which two actions should you perform? Each correct answer presents part of the solution NOTE: Each correct selection is worth one point. 

A. Create a network security group (NSG) 
B. Create a server-level firewall rule 
C. Create a private endpoint 
D. Create a database-level firewall rule. 
E. Deny public access. 

Show Answer

---

Question # 31

You have an Azure SQL database named DB1. You need to encrypt DB1. The solution must meet the following requirements; • Encrypt data in motion. • Support comparison operators. • Provide randomized encryption. What should you include in the solution?

A. Always Encrypted 
B. column-level encryption 
C. Transparent Data Encryption (TDE) 
D. Always Encrypted with secure enclaves 

Show Answer

---

Question # 32

You have an on-premises datacenter that contains a 2-TB Microsoft SQL Server 2019 database named DB1. You need to recommend a solution to migrate DB1 to an Azure SQL managed instance. The solution must minimize downtime and administrative effort. What should you include in the recommendation?

A. Log Replay Service (LRS) 
B. log shipping 
C. transactional replication 
D. SQL Data Sync 

Show Answer

---

Question # 33

You have an instance of SQL Server on Azure Virtual Machines named VM1. You need to implement a disaster recovery solution that meets the following requirements: • Returns the solution to an operational state within 15 minutes of a failure • Can perform disaster recovery testing in an isolated environment • Minimizes administrative effort What should you include in the solution? 

A. Azure Site Recovery 
B. a failover cluster instance (FCI) 
C. auto-failover groups 
D. active geo-replication 

Show Answer

---

Question # 34

You have an on-premises Microsoft SQL Server 2022 instance that hosts a 60-TB production database named DB1. You plan to migrate DB1 to Azure. You need to recommend a hosting solution for DB1. Which Azure SQL Database service tier should you use to host DB1?

 A. Hyperscale 
B. Business Critical 
C. General Purpose 

Show Answer

---

Question # 35

You have an Azure subscription. Vou need to deploy two instances of SQL Server on Azure virtual machines in a highly available configuration that will use an Always On availability group. The solution must meet the following requirements: • Minimize how long it takes to fail over. • Maintain existing connections to the primary replica during a failover. What should you do?

A. Connect each virtual machine to a single subnet on a single virtual network. 
B. Connect each virtual machine to a single subnet on a virtual network. Deploy a standard Azure load balancer. 
C. Connect each virtual machine to a different subnet on a single virtual network. 
D. Connect each virtual machine to a different subnet on a virtual network. Deploy a basic Azure load balancer. 

Show Answer

---

Question # 36

You have two Azure virtual machines named Server 1 and Server2 that run Windows Server 2022 and are joined to an Active Directory Domain Services (AD DS) domain named contoso.com. Both virtual machines have a default instance of Microsoft SQL Server 2019 installed. Server1 is configured as a master server, and Server2 is configured as a target server. On Server1, you create a proxy account named contoso\sqlproxy. You need to ensure that the SQL Server Agent job steps can be downloaded from Server1 and run on Server2. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

A. On Server2, grant the contoso\sqlproxy account the Impersonate a client after authentication user right. 
B. On Server2, grant the contoso\sqlproxy account the Access this computer from the network user right. 
C. On Server2. create a proxy account. 
D. On Server1. set the AllowDownloadedDobsTonatehProxyName registry entry to 1. 
E. On Server2. set the AllowDownloadedJobsToNatchProxyName registry entry to 1. 

Show Answer

---

Question # 37

You have an Azure subscription that contains a SQL Server on Azure Virtual Machines instance named SQLVM1. SQLVM1 has the following configurations: • Automated patching is enabled. • The SQL Server laaS Agent extension is installed. • The Microsoft SQL Server instance on SQLVM1 is managed by using the Azuie portal. You need to automate the deployment of cumulative updates to SQLVM1 by using Azure Update Manager. The solution must ensure that the SQL Server instance on SQLVM1 can be managed by using the Azure portal. What should you do first on SQLVM1?

A. Install the Azure Monitor Agent. 
B. Uninstall the SQL Server laaS Agent extension. 
C. Install the Log Analytics agent. 
D. Set Automated patching to Disable 

Show Answer

---

Question # 38

You have an instance of SQL Server on Azure Virtual Machines named SQL1. SQL1 contains an Extended Events session named session! that captures Microsoft SQL Server events. You need to correlate the session events with events captured by Event Tracing for Windows (ETW). What should you do for session1?

A. Modify the Set Session Event Filters settings. 
B. Add a target. 
C. Add an action. 
D. Modify the Specify Session Data Storage settings. 

Show Answer

---

Question # 39

You have an Azure AD tenant and a logical Microsoft SQL server named SQL1 that hosts several Azure SQL databases. You plan to assign Azure AD users permissions to the databases automatically by using Azure Automation. You need to create the required Automation accounts. Which two accounts should you create? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

A. From the Azure Active Directory admin center, create a service principal. 
B. From the Azure Active Directory admin center, create a user-assigned managed identity for SQL1. 
C. On SQL1. create a SQL user in the databases. 
D. On SQL1, create a SQL login. 
E. From the Azure Active Directory admin center, create an external identity. 

Show Answer

---

Question # 40

You have an on-premises Microsoft SQL Server 2019 instance named SQL1 that hosts a database named db1. You have an Azure subscription that contains an Azure SQL managed instance named MI1 and an Azure Storage account named storage1. You need to ensure that you can back up db1 to storage1. The solution must meet the following requirements: * Use block blob storage. * Maximize security.

A. Generate a shared access signature (SAS) 
B. Enable infrastructure encryption. 
C. Create an access policy. 
D. Rotate the storage keys 

Show Answer

---

Question # 41

You have an Azure subscription that contains two Azure SQL managed instances named SQLMI1 and SQLMI2 . SQLM2 contains a database named DB1 and a user named User1. User1 drops DB1. You need to perform a point-in-time restore of DB1 to SQLMI2.

A. Azure CLI 
B. Transact-SQL 
C. The Azure portal 
D. Azure PowerShell 

Show Answer

---

Question # 42

You have SQL Server 2019 or an Azure virtual machine that runs Windows Server 2019. The virtual machine has 4 vCPUs and 28 GB of memory. Vou scale up the virtual machine to 8 vCPUs and 64 GB of memory. You need to reduce tempdb contention without regatively affecting server performance. What is the number of secondary data files that you should configure for tempdb?

A. 2 
B. 4 
C. 8 
D. 64 

Show Answer

---

Question # 43

You have an Azure subscription. You plan to deploy an instance of SQL Server on Azure Virtual Machines by using an Azure Marketplace image You need to register the SQL Server laaS Agent extension (SqllaasExtension). The solution must meet the following requirements: • Install critical updates for SQL Server automatically. • Minimize performance impact on the virtual machine. Which management mode should you select?

A. full 
B. lightweight 
C. NoAgent 

Show Answer

---

Question # 44

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 

Show Answer

---

Question # 45

You have an Azure SQL database named DB1. A user named User 1 has an Azure AD account. You need to provide User1 with the ability to add and remove columns from the tables inDBV The solution must use the principle of least privilege. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point

A. Assign the database user the db.ddladmm role. 
B. Assign the database user the db.owner role. 
C. Create a contained database user. 
D. Create a login and an associated database user. 

Show Answer

---

Question # 46

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). 

Show Answer

---

Question # 47

Task 4You need to enable change data capture (CDC) for db1.

Show Answer

---

Question # 48

Task 10You need to protect all the databases on sql37006S95 from SQL injection attacks.

Show Answer

---

Question # 49

Task 5You need to configure a disaster recovery solution for db1. When a failover occurs, the connection strings to the database must remain the same. The secondary server must be in the West US 3 Azure region.

Show Answer

---

Testimonials