BONUS!!! Download part of TrainingQuiz DP-300 dumps for free: https://drive.google.com/open?id=1n_rs_w7uqt2iW9uw8o1L6x564EP1iYdU
As a responsible company with great reputation among the market, we trained our staff and employees with strict beliefs to help you with any problems about our DP-300 Learning materials 24/7. Even you have finished buying activity with us, we still be around you with considerate services on the DP-300 Exam Questions. And we will update our DP-300 training guide from time to time, once we update our DP-300 study guide, we will auto send it to our customers. And you can enjoy our updates of DP-300 learning prep for one year after your payment.
| Section | Weight | Objectives |
|---|---|---|
| Implement a secure environment | 20–25% | - Implement compliance and security controls
|
| Monitor and optimize operational resources | 15–20% | - Automate maintenance and operations
|
| Plan and implement data platform resources | 15–20% | - Implement migration strategies
|
| Plan and configure high availability and disaster recovery | 20–25% | - Design HA/DR strategy
|
| Optimize query performance | 15–20% | - Improve query performance
|
Even in a globalized market, the learning material of similar DP-300 doesn't have much of a share, nor does it have a high reputation or popularity. In this dynamic and competitive market, the DP-300 learning questions can be said to be leading and have absolute advantages. In order to facilitate the user real-time detection of the learning process, we DP-300 Exam Material provideds by the questions and answers are all in the past.it is closely associated, as our experts in constantly update products every day to ensure the accuracy of the problem, so all DP-300 practice materials are high accuracy.
NEW QUESTION # 175
Case Study 1 - Litware, Inc
Overview
Litware, Inc. is a renewable energy company that has a main office in Boston. The main office hosts a sales department and the primary datacenter for the company.
Physical Locations
Existing Environment
Litware has a manufacturing office and a research office is separate locations near Boston. Each office has its own datacenter and internet connection.
The manufacturing and research datacenters connect to the primary datacenter by using a VPN.
Network Environment
The primary datacenter has an ExpressRoute connection that uses both Microsoft peering and private peering. The private peering connects to an Azure virtual network named HubVNet.
Identity Environment
Litware has a hybrid Azure Active Directory (Azure AD) deployment that uses a domain named litwareinc.com. All Azure subscriptions are associated to the litwareinc.com Azure AD tenant.
Database Environment
The sales department has the following database workload:
An on-premises named SERVER1 hosts an instance of Microsoft SQL Server 2012 and two 1- TB databases.
A logical server named SalesSrv01A contains a geo-replicated Azure SQL database named SalesSQLDb1. SalesSQLDb1 is in an elastic pool named SalesSQLDb1Pool. SalesSQLDb1 uses database firewall rules and contained database users.
An application named SalesSQLDb1App1 uses SalesSQLDb1.
The manufacturing office contains two on-premises SQL Server 2016 servers named SERVER2 and SERVER3. The servers are nodes in the same Always On availability group. The availability group contains a database named ManufacturingSQLDb1 Database administrators have two Azure virtual machines in HubVnet named VM1 and VM2 that run Windows Server 2019 and are used to manage all the Azure databases.
Licensing Agreement
Litware is a Microsoft Volume Licensing customer that has License Mobility through Software Assurance.
Current Problems
SalesSQLDb1 experiences performance issues that are likely due to out-of-date statistics and frequent blocking queries.
Requirements
Planned Changes
Litware plans to implement the following changes:
Implement 30 new databases in Azure, which will be used by time-sensitive manufacturing apps that have varying usage patterns. Each database will be approximately 20 GB.
Create a new Azure SQL database named ResearchDB1 on a logical server named ResearchSrv01. ResearchDB1 will contain Personally Identifiable Information (PII) data.
Develop an app named ResearchApp1 that will be used by the research department to populate and access ResearchDB1.
Migrate ManufacturingSQLDb1 to the Azure virtual machine platform.
Migrate the SERVER1 databases to the Azure SQL Database platform.
Technical Requirements
Litware identifies the following technical requirements:
Maintenance tasks must be automated.
The 30 new databases must scale automatically.
The use of an on-premises infrastructure must be minimized.
Azure Hybrid Use Benefits must be leveraged for Azure SQL Database deployments.
All SQL Server and Azure SQL Database metrics related to CPU and storage usage and limits must be analyzed by using Azure built-in functionality.
Security and Compliance Requirements
Litware identifies the following security and compliance requirements:
Store encryption keys in Azure Key Vault.
Retain backups of the PII data for two months.
Encrypt the PII data at rest, in transit, and in use.
Use the principle of least privilege whenever possible.
Authenticate database users by using Active Directory credentials.
Protect Azure SQL Database instances by using database-level firewall rules.
Ensure that all databases hosted in Azure are accessible from VM1 and VM2 without relying on public endpoints.
Business Requirements
Litware identifies the following business requirements:
Meet an SLA of 99.99% availability for all Azure deployments.
Minimize downtime during the migration of the SERVER1 databases.
Use the Azure Hybrid Use Benefits when migrating workloads to Azure.
Once all requirements are met, minimize costs whenever possible.
Drag and Drop Question
You need to configure user authentication for the SERVER1 databases. The solution must meet the security and compliance requirements.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Answer:
Explanation:
Explanation:
Scenario: Authenticate database users by using Active Directory credentials.
The configuration steps include the following procedures to configure and use Azure Active Directory authentication.
1. Create and populate Azure AD.
2. Optional: Associate or change the active directory that is currently associated with your Azure Subscription.
3. Create an Azure Active Directory administrator. (Step 1)
4. Configure your client computers.
5. Create contained database users in your database mapped to Azure AD identities. (Step 2)
6. Connect to your database by using Azure AD identities. (Step 3)
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-overview
NEW QUESTION # 176
You have an Azure subscription that contains two Azure SQL managed instances named SQLMI1 and SQLMI2. SQLMI1 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.
What should you use to perform the restore?
Answer: B
Explanation:
https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/point-in-time-restore?view=azuresql-mi&tabs=azure-portal
You can use point-in-time restore to restore a database in these scenarios:
From an existing database
From a deleted database
To the same managed instance or to a different managed instance
To a managed instance in the same subscription or to a managed instance in a different subscription
NEW QUESTION # 177
You have an Azure subscription that contains an Azure SQL managed instance named SQLMl1.
You need to configure SQLMl1 to use the Business Critical service tier.
Which PowerShell cmdlet should you run?
Answer: B
Explanation:
To configure an Azure SQL Managed Instance to use the Business Critical service tier with PowerShell, you'll use the Set-AzSqlInstance cmdlet. This cmdlet allows you to modify various properties of an existing managed instance, including its service tier. You'll need to specify the resource group, instance name, and the desired service tier as "BusinessCritical".
Example:
$resourceGroupName = "YourResourceGroupName"
$managedInstanceName = "YourManagedInstanceName"
$serviceTier = "BusinessCritical"
Set-AzSqlInstance -ResourceGroupName $resourceGroupName -Name
$managedInstanceName -ServiceTier $serviceTier
Reference:
https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/scripts/create-configure-managed-instance-powershell
NEW QUESTION # 178
You create all of the tables and views for ResearchDB1.
You need to implement security for ResearchDB1. The solution must meet the security and compliance requirements.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Answer:
Explanation:
Explanation:
Graphical user interface, text, application Description automatically generated
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/always-encrypted-azure-key-vault-configure?tabs=azu
NEW QUESTION # 179
You have a new Azure SQL database named DB1 on an Azure SQL server named AzSQL1.
The only user who was created is the server administrator.
You need to create a contained database user in DB1 who will use Azure Active Directory (Azure AD) for authentication.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Answer:
Explanation:
1 - Set up the Active Directory Admin for AzSQL1.
2 - Connect to DB1 by using the server administrator.
3 - Create a user by using the FROM EXTERNAL PROVIDER clause.
Reference:
https://docs.microsoft.com/en-us/sql/t-sql/statements/create-user-transact-sql
NEW QUESTION # 180
......
Confronting a tie-up during your review of the exam? Feeling anxious and confused to choose the perfect DP-300 latest dumps to pass it smoothly? We understand your situation of susceptibility about the exam, and our DP-300 test guide can offer timely help on your issues right here right now. Without tawdry points of knowledge to remember, our experts systematize all knowledge for your reference. You can download our free demos and get to know synoptic outline before buying. Just hold the supposition that you may fail the exam even by the help of our DP-300 Study Tool, we can give full refund back or switch other versions for you to relieve you of any kind of losses. What is more, we offer supplementary content like updates for one year after your purchase.
DP-300 Examcollection Free Dumps: https://www.trainingquiz.com/DP-300-practice-quiz.html
P.S. Free & New DP-300 dumps are available on Google Drive shared by TrainingQuiz: https://drive.google.com/open?id=1n_rs_w7uqt2iW9uw8o1L6x564EP1iYdU