BONUS！！！ Topexam DP-300ダンプの一部を無料でダウンロード：https://drive.google.com/open?id=1yRyIJOKXLNx-gs27niZwyR4LqbsHktWA
安全かつ最も信頼性の高いMicrosoft DP-300問題集販売サイトとして、我々はお客様の個人情報を内緒し、支払いの安全性を保証しています。だから、我々社のMicrosoft DP-300問題集のさまざまなバージョンを安心に購買できます。弊社は量豊かのIT試験資料を所有するから、あなたは別のMicrosoft DP-300試験に関心を寄せるなら、Topexamでは需要したい資料を尋ねたり、弊社の職員に問い合わせたりしています。
DP-300 認定試験は、Microsoft Azure 上の関係データベースを管理する能力を検証するために設計されています。この認定を取得することで、個人は Azure SQL データベースの設計、実装、およびメンテナンスにおける熟練度を示すことができ、今日のビジネス界においてデータプロフェッショナルにとって必要不可欠なスキルを持っていることを証明することができます。クラウドベースのソリューションの需要が高まる中、DP-300 認定試験は、自身のスキルを活用し、IT 業界におけるキャリア成長を促進するための優れた方法です。
DP-300の認定試験は、データベース管理者がキャリアアップするための優れた方法です。この認定試験は、候補者がMicrosoft Azure上の関係データベースを管理するために必要なスキルと知識を持っていることを潜在雇用主に証明します。DP-300の認定を取得した専門家は、業界で非常に需要が高く、より高い給与やより良い求人機会が期待できます。
調査によると、当社の高く評価されているDP-300テスト問題の成功は、簡単に操作できる練習システムへの尽力によるものです。候補者から寄せられたフィードバックのほとんどは、DP-300ガイド急流が優れたプラクティスとシステムを実装し、より競争力のある新しい製品を発売する能力を強化していることを物語っています。 DP-300試験ダンプに伴い、Q＆Aはそれほど複雑ではありませんが、より重要な情報で受験者を教育します。これにより、DP-300試験に合格するための知識を深め、自己啓発を強化できます。
Microsoft DP-300認定試験は、データベース管理者、データベース開発者、およびMicrosoft Azureと協力するIT専門家に最適です。認定試験は、あなたのキャリアの見通しを強化し、潜在的な雇用主に専門知識を実証する素晴らしい方法です。 DP-300試験に合格すると、Microsoft認定を受けたAzure Database Administrator Associateになります。これは、業界で非常に尊敬される認定です。
質問 # 110
You have an Azure SQL Database managed instance named SQLMI1. A Microsoft SQL Server Agent job runs
on SQLMI1.
You need to ensure that an automatic email notification is sent once the job completes.
What should you include in the solution?
正解：D
解説：
Section: [none]
Explanation:
To send a notification in response to an alert, you must first configure SQL Server Agent to send mail.
Using SQL Server Management Studio; to configure SQL Server Agent to use Database Mail:
1. In Object Explorer, expand a SQL Server instance.
2. Right-click SQL Server Agent, and then click Properties.
3. Click Alert System.
4. Select Enable Mail Profile.
5. In the Mail system list, select Database Mail.
6. In the Mail profile list, select a mail profile for Database Mail.
7. Restart SQL Server Agent.
Note: Prerequisites include:
* Enable Database Mail.
* Create a Database Mail account for the SQL Server Agent service account to use.
* Create a Database Mail profile for the SQL Server Agent service account to use and add the user to the
DatabaseMailUserRole in the msdb database.
* Set the profile as the default profile for the msdb database.
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/database-mail/configure-sql-server-agent-mail-to-
use-database-mail
Testlet 1
This is a case study. Case studies are not timed separately. You can use as much exam time as you
would like to complete each case. However, there may be additional case studies and sections on this exam.
You must manage your time to ensure that you are able to complete all questions included on this exam in the
time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the
case study. Case studies might contain exhibits and other resources that provide more information about the
scenario that is described in the case study. Each question is independent of the other questions in this case
study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to
make changes before you move to the next section of the exam. After you begin a new section, you cannot
return to this section.
To start the case study
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore
the content of the case study before you answer the questions. Clicking these buttons displays information such
as business requirements, existing environment, and problem statements. If the case study has an All
Information tab, note that the information displayed is identical to the information displayed on the subsequent
tabs. When you are ready to answer a question, click the Question button to return to the question.
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.
質問 # 111
You have an Azure subscription that contains the resources shown in the following table.
App1 experiences transient connection errors and timeouts when it attempts to access db1 after extended periods of inactivity.
You need to modify db1 to resolve the issues experienced by Appl as soon as possible, without considering immediate costs What you do?
正解：A
質問 # 112
You have an Azure SQL database named db1 on a server named server1.
You use Query Performance Insight to monitor db1.
You need to modify the Query Store configuration to ensure that performance monitoring data is available as soon as possible.
Which configuration setting should you modify and which value should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
正解：
解説：
Explanation:
質問 # 113
You have an on-premises multi-tier application named App1 that includes a web tier, an application tier, and a Microsoft SQL Server tier. All the tiers run on Hyper-V virtual machines.
Your new disaster recovery plan requires that all business-critical applications can be recovered to Azure.
You need to recommend a solution to fail over the database tier of App1 to Azure. The solution must provide the ability to test failover to Azure without affecting the current environment.
What should you include in the recommendation?
正解：C
解説：
Reference:
https://docs.microsoft.com/en-us/azure/site-recovery/site-recovery-test-failover-to-azure
質問 # 114
You have an instance of SQL Server on Azure Virtual Machines named SQL1. SQL1 contains a database named DB1.
You need to enable Transparent Data Encryption (TDE) for DB1.
Which three objects should you create in sequence? To answer, move the appropriate objects from the list of objects to the answer area and arrange them in the correct order.
正解：
解説：
Explanation:
質問 # 115
......
DP-300参考書: https://www.topexam.jp/DP-300_shiken.html
さらに、Topexam DP-300ダンプの一部が現在無料で提供されています：https://drive.google.com/open?id=1yRyIJOKXLNx-gs27niZwyR4LqbsHktWA